...
INTR_RQST_ID | Required | NOT NULL | VARCHAR2(13) |
SEQ_NUM | Required | NOT NULL | NUMBER(10) |
EMP_ID | Required | NOT NULL | NUMBER(3) |
ACTIVITY_CD | Required | NOT NULL | VARCHAR2(1) |
TIMECLK_EMP_ID_TYPE_CD | Required | NOT NULL | VARCHAR2(3) |
LONG_KEY | Required - must be Unique | NOT NULL | VARCHAR2(2000) |
DESCR_2000 | Optional | VARCHAR2(2000) |
...
123|TIMECLKID|U|PIN|123456|PIN Code for Emp 123|
NOTE: With the requirement that the PIN and QRC being unique, do not include the record in the file unless loading a unique code. Including the record with a blank or null code will cause an error in the interface because blank or null is not unique.