Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

INTR_RQST_IDRequiredNOT NULLVARCHAR2(13)
SEQ_NUMRequiredNOT NULLNUMBER(10)
EMP_ID

Required

NOT NULLNUMBER(3)
ACTIVITY_CDRequiredNOT NULLVARCHAR2(1)
TIMECLK_EMP_ID_TYPE_CDRequiredNOT NULLVARCHAR2(3)
LONG_KEYRequired - must be UniqueNOT NULLVARCHAR2(2000)
DESCR_2000Optional
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.