TL_DSH_CHT_TMP

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	TRC	Character(5)	VARCHAR2(5) NOT NULL	Time Reporting Code used to report time in Time and Labor
2	TRC_SUM_CATEGORY	Character(6)	VARCHAR2(6) NOT NULL	TRC Category
3	START_DT	Date(10)	DATE	Start Date
4	END_DT	Date(10)	DATE	end date
5	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
6	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
7	LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Last Name
8	FIRST_NAME	Character(30)	VARCHAR2(30) NOT NULL	First Name
9	NAME_DISPLAY	Character(50)	VARCHAR2(50) NOT NULL	Display Name - name formatted for Display based on the Country
10	TL_QUANTITY	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	This field represents the measure of Work in hrs,amount etc.,
11	TL_QUANTITY1	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Quantity
12	TL_QUANTITY2	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Quantity
13	TL_QUANTITY3	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Prior Quantity
14	TL_QUANTITY4	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	TL_QUANTITY4
15	TL_AMOUNT	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Estimated Gross
16	TL_AMOUNT1	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Estimated Gross
17	TL_AMOUNT2	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Estimated Gross
18	TL_AMOUNT3	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Estimated Gross
19	TL_HOURS_DEVIATION	Signed Number(16,2)	DECIMAL(14,2) NOT NULL	Deviation
20	TL_CHT_GROUP_VAL	Character(20)	VARCHAR2(20) NOT NULL	Group By
21	TL_CHT_GROUP_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Group
22	TL_CHT_SERIES_VAL	Character(60)	VARCHAR2(60) NOT NULL	Chart Series Value
23	TL_CHT_SERIES_DESC	Character(30)	VARCHAR2(30) NOT NULL	Series Description
24	TL_RECORD_SRC	Character(2)	VARCHAR2(2) NOT NULL	Record Source A=All Sources AP=Approved Time D=Scheduled to Date P=Payable Time R=Reported Time S=Scheduled Time SD=Scheduled to Date ST=Scheduled Time
25	TL_CHAR_VALUE	Character(30)	VARCHAR2(30) NOT NULL	Character Value