RTSS Group Employee field specifications
This table lists the field-column specifications in the RTSS Group Employee import interface. Fields with the asterisk (*) symbol are required.
| Col. | Field Name | Type | Size/Format | Description |
|---|---|---|---|---|
| 1 | RTSSG_ID* | Number | 22 | The RTSS Group ID number. |
| 2 | EMP_ID* | Number | 22 | The Employee ID from the EMPLOYEE table. |
| 3 | RTSSGE_EFF_START_DATE | Date | yyyy-MM-dd HH:mm:ss | The effective start date. Note: The default for a blank
value is the current date.
|
| 4 | RTSSGE_EFF_END_DATE | Date | yyyy-MM-dd HH:mm:ss | The effective end date. Note: The default for a blank value
is 01/01/3000.
|
| 5 | RTSSGE_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. |
| 6 | RTSSGE_FLAG2 | Varchar2 | 1 | One-character flag for general use. |
| 7 | RTSSGE_FLAG3 | Varchar2 | 1 | One-character flag for general use. |
| 8 | RTSSGE_FLAG4 | Varchar2 | 1 | One-character flag for general use. |
| 9 | RTSSGE_FLAG5 | Varchar2 | 1 | One-character flag for general use. |
| 10 | RTSSGE_UDF1 | Varchar2 | 40 | User defined field. |
| 11 | RTSSGE_UDF2 | Varchar2 | 40 | User defined field. |
| 12 | RTSSGE_UDF3 | Varchar2 | 40 | User defined field. |
| 13 | RTSSGE_UDF4 | Varchar2 | 40 | User defined field. |
| 14 | RTSSGE_UDF5 | Varchar2 | 40 | User defined field. |