TL_COMPLEAV_HST

(SQL Table)
Index Back

Archive Rec - TL CompLeav

Archive Record for TL CompLeav

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PSARCH_ID Character(8) VARCHAR2(8) NOT NULL Archive ID (see PSARCHTEMPLATE).
2 PSARCH_BATCHNUM Number(30,0) DECIMAL(30) NOT NULL Archive Batch Number
3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
4 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
5 DUR Date(10) DATE NOT NULL Date Under Report associates time being reported, scheduled or paid, to a specific date.
6 TRC Character(5) VARCHAR2(5) NOT NULL Time Reporting Code used to report time in Time and Labor
7 COMP_LEAV_IND Character(4) VARCHAR2(4) NOT NULL Comp Leave Indiactor indicates whether a TRC has any effect on Leave and Compensatory time Off
CERN=Comp Time Earned
CTKN=Comp Time Taken
LTKN=Leave Taken
NO=No Comp Time Effect
RULE=Avoid Replacing by Rules
8 COMP_TIME_PLAN Character(10) VARCHAR2(10) NOT NULL Compensatory Time Off Plan
9 EXP_DT Date(10) DATE Expected Completion Date
10 TL_QUANTITY Signed Number(20,6) DECIMAL(18,6) NOT NULL This field represents the measure of Work in hrs,amount etc.,
11 END_BAL Signed Number(9,3) DECIMAL(7,3) NOT NULL Ending Balance