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.