TL_DSH_TRC_TMP

(SQL Table)
Index Back

TL Dashbd Empl Time Summary

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PERIOD_START_DT Date(10) DATE Period Start Date
2 PERIOD_END_DT Date(10) DATE Period End Date
3 TRC_SUM_CATEGORY Character(6) VARCHAR2(6) NOT NULL TRC Category
4 TRC Character(5) VARCHAR2(5) NOT NULL Time Reporting Code used to report time in Time and Labor
5 TL_CHT_GROUP_DESCR Character(30) VARCHAR2(30) NOT NULL Group
6 TL_QUANTITY Signed Number(20,6) DECIMAL(18,6) NOT NULL This field represents the measure of Work in hrs,amount etc.,
7 TL_QUANTITY1 Signed Number(20,6) DECIMAL(18,6) NOT NULL Quantity
8 TL_QUANTITY2 Signed Number(20,6) DECIMAL(18,6) NOT NULL Quantity
9 TL_QUANTITY3 Signed Number(20,6) DECIMAL(18,6) NOT NULL Prior Quantity
10 TL_QUANTITY4 Signed Number(20,6) DECIMAL(18,6) NOT NULL TL_QUANTITY4
11 EST_GROSS Signed Number(20,6) DECIMAL(18,6) NOT NULL Estimated Gross
12 TL_AMOUNT1 Signed Number(20,6) DECIMAL(18,6) NOT NULL Estimated Gross
13 TL_AMOUNT2 Signed Number(20,6) DECIMAL(18,6) NOT NULL Estimated Gross
14 TL_AMOUNT3 Signed Number(20,6) DECIMAL(18,6) NOT NULL Estimated Gross
15 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Prompt Table: CURRENCY_CD_TBL

16 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
17 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code