TL_DSH_SUM_TMP

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
3	PERIOD_START_DT	Date(10)	DATE	Period Start Date
4	PERIOD_END_DT	Date(10)	DATE	Period End Date
5	TRC_SUM_CATEGORY	Character(6)	VARCHAR2(6) NOT NULL	TRC Category
6	TRC	Character(5)	VARCHAR2(5) NOT NULL	Time Reporting Code used to report time in Time and Labor
7	TL_CHT_GROUP_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Group
8	NAME_DISPLAY	Character(50)	VARCHAR2(50) NOT NULL	Display Name - name formatted for Display based on the Country
9	LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Last Name
10	FIRST_NAME	Character(30)	VARCHAR2(30) NOT NULL	First Name
11	JOB_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Job Description
12	TL_QUANTITY	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	This field represents the measure of Work in hrs,amount etc.,
13	TL_QUANTITY1	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Quantity
14	TL_QUANTITY2	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Quantity
15	TL_QUANTITY3	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Prior Quantity
16	TL_QUANTITY4	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	TL_QUANTITY4
17	TL_HOURS_DEVIATION	Signed Number(16,2)	DECIMAL(14,2) NOT NULL	Deviation
18	EST_GROSS	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Estimated Gross
19	TL_AMOUNT1	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Estimated Gross
20	TL_AMOUNT2	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Estimated Gross
21	TL_AMOUNT3	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Estimated Gross
22	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Prompt Table: CURRENCY_CD_TBL
23	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
24	DEPT_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Department Description
25	LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Location Code
26	LOC_DESCR_SS	Character(30)	VARCHAR2(30) NOT NULL	Location Description