GP_TLPTM_WRK

(SQL Table)
Index Back

T&L Interface work table

T&L Interface work table

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SRC_CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Source Calendar Run ID
2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
3 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
4 PRC_ORD_TS DateTime(26) TIMESTAMP Process Order Timestamp
5 TRC Character(5) VARCHAR2(5) NOT NULL Time Reporting Code used to report time in Time and Labor
6 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group
7 CAL_ID Character(18) VARCHAR2(18) NOT NULL calendar id
8 PRD_TYPE Character(1) VARCHAR2(1) NOT NULL Period Type
C=Current
R=Retro
9 SEL_ACTION Character(1) VARCHAR2(1) NOT NULL Select Action
A=Retro Add
C=Current Calculation
R=Retro Recalc
V=Retro Reversal
Z=Retro Rvr & Recalc
10 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number
11 TRC_TYPE Character(1) VARCHAR2(1) NOT NULL This defines TRC Type of Hours,Amounts ,Units
A=Amount
H=Hours
U=Units
12 RATE Signed Number(20,6) DECIMAL(18,6) NOT NULL Rate
13 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
14 TL_PRD_BGN_DT Date(10) DATE Time && Labor Period Bgn Dt
15 TL_PRD_END_DT Date(10) DATE Time && Labaor Period End Dt
16 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
17 SEG_BGN_DT Date(10) DATE Payee Process Segment's Begin Date
18 FRST_SEG_IND Character(1) VARCHAR2(1) NOT NULL First Segment Ind