TL_ELP_ERR

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SUBSCRIBE_DTTM	DateTime(26)	TIMESTAMP	Subscription Date Time
2	TRANSACTIONID	Number(10,0)	DECIMAL(10) NOT NULL	Transaction Identifier
3	BADGE_ID	Character(20)	VARCHAR2(20) NOT NULL	Badge ID
4	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: TL_ADM_NAME_VW
5	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr Prompt Table: TL_ADM_EERCD_VW
6	DUR	Date(10)	DATE	Date Under Report associates time being reported, scheduled or paid, to a specific date.
7	SEQNUM	Number(3,0)	SMALLINT NOT NULL	Sequence Number
8	DELETE_DATE	Date(10)	DATE	Date for deletion in TCD Interface
9	ADD_DELETE_IND	Character(1)	VARCHAR2(1) NOT NULL	Add / Delete Indicator A=Add D=Delete
10	TCD_ID	Character(10)	VARCHAR2(10) NOT NULL	Time Collection Device Identification.
11	TRC	Character(5)	VARCHAR2(5) NOT NULL	Time Reporting Code used to report time in Time and Labor
12	TL_QUANTITY	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	This field represents the measure of Work in hrs,amount etc.,
13	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
14	OVERRIDE_RATE	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Override Rate.
15	COMP_RATECD	Character(6)	VARCHAR2(6) NOT NULL	Comp Rate Code
16	BILLABLE_IND	Character(1)	VARCHAR2(1) NOT NULL	Billable Indicator N=No Y=Yes
17	TCD_SUPERVISR_ID	Character(20)	VARCHAR2(20) NOT NULL	TCD Supervisor ID
18	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
19	OVERRIDE_RSN_CD	Character(5)	VARCHAR2(5) NOT NULL	Override Reason Code
20	ACTION_DTTM	DateTime(26)	TIMESTAMP	Override Date Time
21	TASK_PROFILE_ID	Character(10)	VARCHAR2(10) NOT NULL	Task Profile ID
22	TASK_PRFL_TMPLT_ID	Character(10)	VARCHAR2(10) NOT NULL	Task Template ID
23	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country
24	STATE	Character(6)	VARCHAR2(6) NOT NULL	State
25	LOCALITY	Character(10)	VARCHAR2(10) NOT NULL	Locality
26	TL_COMMENTS	Character(254)	VARCHAR2(254) NOT NULL	Comments