In this step, you will create an employee holiday table which will contain the details of the employees' holidays.

1.  Create a LANSA table Name iiiEmpHolidays, Description Employee Holidays. Make it RDMLX enabled.

2.  Using the Multi-Add Columns option in the table, add these real columns to the table:

     Don't forget to define the table keys.

iiiEmpHolidays

Employee Holiday Table

Type

Length

Key

iiiEmployNumber

Employee number

Alpha

2

1

iiiHolCode

Holiday Code

Alpha

3

2

iiiHolStartDate

Holiday Start Date

DateTime

26


iiiHolEndDate

Holiday End Date

DateTime

26


iiiHolComments

Holiday Comments

String

512


  • No labels