Holiday Calendar Team field specifications
This table lists the field-column specifications in the Holiday Calendar Team import interface. Fields with the asterisk (*) symbol are required.
Col. | Field Name | Type | Size/Format | Description |
---|---|---|---|---|
1 | WBT_ID* | Varchar2 | 10 | The team ID number from the WORKBRAIN_TEAM table. |
2 | HCAL_ID* | Number | 10 | The holiday calendar ID number from the HOLIDAY_CALENDAR table. |
3 | HCALWBT_FLAG1 | Varchar2 | 1 | One-character flag for general use. A {space} in one of the flag positions indicates no processing is to be done for that flag. An ampersand (&) in one of the flag positions indicates the flag is to be blanked. |
4 | HCALWBT_FLAG2 | Varchar2 | 1 | One-character flag for general use. |
5 | HCALWBT_FLAG3 | Varchar2 | 1 | One-character flag for general use. |
6 | HCALWBT_FLAG4 | Varchar2 | 1 | One-character flag for general use. |
7 | HCALWBT_FLAG5 | Varchar2 | 1 | One-character flag for general use. |
8 | HCALWBT_UDF1 | Varchar2 | 40 | User defined field. |
9 | HCALWBT_UDF2 | Varchar2 | 40 | User defined field. |
10 | HCALWBT_UDF3 | Varchar2 | 40 | User defined field. |
11 | HCALWBT_UDF4 | Varchar2 | 40 | User defined field. |
12 | HCALWBT_UDF5 | Varchar2 | 40 | User defined field. |