TL_RTA_ADAT_TMP

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
3	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
4	DUR	Date(10)	DATE	Date Under Report associates time being reported, scheduled or paid, to a specific date.
5	SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Number
6	AUDIT_ACTN	Character(1)	VARCHAR2(1) NOT NULL	Audit Action Code for Application Messages. This tells the subscriber whether the row has been added, changed, or deleted. A=Add C=Change Old (PPR Only) D=Delete K=Change - Old Values N=Change - New Values O=Change - Original Values
7	XLATSHORTNAME	Character(10)	VARCHAR2(10) NOT NULL	Translate Value Short Name
8	TL_QUANTITY	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	This field represents the measure of Work in hrs,amount etc.,
9	PUNCH_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Global Punch Types 0=Elapsed 1=In 2=Out 3=Meal 4=Break 5=Transfer
10	XLATLONGNAME	Character(30)	VARCHAR2(30) NOT NULL	Translate Long Name
11	PUNCH_TIME	Time(15)	TIMESTAMP	punch time
12	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD).
13	ORIGINAL_VAL	Character(2)	VARCHAR2(2) NOT NULL	Reported Status
14	CURRENT_VAL	Character(2)	VARCHAR2(2) NOT NULL	Reported Status
15	AUDIT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	The OPRID of the user who made the changes audited on an audit record.
16	AUDIT_STAMP	DateTime(26)	TIMESTAMP	Date and Time Stamp
17	TASKGROUP	Character(10)	VARCHAR2(10) NOT NULL	Taskgroup
18	REPORTED_STATUS	Character(2)	VARCHAR2(2) NOT NULL	Reported Status AP=Approved DN=Denied IP=Approval In Process NA=Needs Approval NW=New PB=Pushed Back PR=Processed SB=Submitted SV=Saved
19	TRC	Character(5)	VARCHAR2(5) NOT NULL	Time Reporting Code used to report time in Time and Labor
20	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code