TL_RTA_DAT_TMP (SQL Table)	Index Back
Rptd Tim Data for time adt rpt This record stores the reported time data to be printed by the Time Audit Report

TL_RTA_DAT_TMP

(SQL Table)

Rptd Tim Data for time adt rpt

This record stores the reported time data to be printed by the Time Audit Report

# 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

7 TL_NAME Character(50) VARCHAR2(50) NOT NULL NAME

8 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code

9 DESCR Character(30) VARCHAR2(30) NOT NULL Description

10 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

11 DESCR1 Character(30) VARCHAR2(30) NOT NULL Descr

12 PUNCH_TYPE Character(2) VARCHAR2(2) NOT NULL Global Punch Types
0=Elapsed
1=In
2=Out
3=Meal
4=Break
5=Transfer

13 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name

14 PUNCH_TIME Time(15) TIMESTAMP punch time

15 TL_QUANTITY Signed Number(20,6) DECIMAL(18,6) NOT NULL This field represents the measure of Work in hrs,amount etc.,

16 TASKGROUP Character(10) VARCHAR2(10) NOT NULL Taskgroup

17 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

18 TRC Character(5) VARCHAR2(5) NOT NULL Time Reporting Code used to report time in Time and Labor

#	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	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
7	TL_NAME	Character(50)	VARCHAR2(50) NOT NULL	NAME
8	JOBCODE	Character(6)	VARCHAR2(6) NOT NULL	Job Code
9	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
10	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
11	DESCR1	Character(30)	VARCHAR2(30) NOT NULL	Descr
12	PUNCH_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Global Punch Types 0=Elapsed 1=In 2=Out 3=Meal 4=Break 5=Transfer
13	XLATLONGNAME	Character(30)	VARCHAR2(30) NOT NULL	Translate Long Name
14	PUNCH_TIME	Time(15)	TIMESTAMP	punch time
15	TL_QUANTITY	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	This field represents the measure of Work in hrs,amount etc.,
16	TASKGROUP	Character(10)	VARCHAR2(10) NOT NULL	Taskgroup
17	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
18	TRC	Character(5)	VARCHAR2(5) NOT NULL	Time Reporting Code used to report time in Time and Labor