TL_RPTD_TIME (SQL Table)	Index Back
Reported Time Reported Elapsed and Reported Punch time storage. Punch Time Storage Punch Type = '0' for elapsed Dur = Local time zone Date for Punch time Time = Local time zone Time for Punch time Punch Dttm = Base time zone Punch Date time for Punch time

TL_RPTD_TIME

(SQL Table)

Reported Time

Reported Elapsed and Reported Punch time storage. Punch Time Storage Punch Type = '0' for elapsed Dur = Local time zone Date for Punch time Time = Local time zone Time for Punch time Punch Dttm = Base time zone Punch Date time for Punch time

Audit Record: AUDIT_TLRPTTIME

# 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 Rcd Nbr

3 DUR Date(10) DATE NOT NULL Date Under Report associates time being reported, scheduled or paid, to a specific date.

4 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number

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

6 PUNCH_TIME Time(15) TIMESTAMP Punch Time

7 PUNCH_DTTM DateTime(26) TIMESTAMP Date and time when the punch occurred.

8 PUNCH_END DateTime(26) TIMESTAMP Punch out

9 TIMEZONE Character(9) VARCHAR2(9) NOT NULL Time Zone
Default Value: TL_EMPL_DATA.TIMEZONE
Prompt Table: PSTIMEZONE

10 TIMEZONE2 Character(9) VARCHAR2(9) NOT NULL Time Zone

11 ST_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Session Number

12 BADGE_ID Character(20) VARCHAR2(20) NOT NULL Badge ID

13 TCD_ID Character(10) VARCHAR2(10) NOT NULL Time Collection Device Identification.

14 RULE_ELEMENT_1 Character(10) VARCHAR2(10) NOT NULL Rule Element 1
Prompt Table: TL_RULE_ELEMNT1

15 RULE_ELEMENT_2 Character(10) VARCHAR2(10) NOT NULL Rule Element 2
Prompt Table: TL_RULE_ELEMNT2

16 RULE_ELEMENT_3 Character(10) VARCHAR2(10) NOT NULL Rule Element 3
Prompt Table: TL_RULE_ELEMNT3

17 RULE_ELEMENT_4 Character(10) VARCHAR2(10) NOT NULL Rule Element 4
Prompt Table: TL_RULE_ELEMNT4

18 RULE_ELEMENT_5 Character(10) VARCHAR2(10) NOT NULL Rule Element 5
Prompt Table: TL_RULE_ELEMNT5

19 TASKGROUP Character(10) VARCHAR2(10) NOT NULL Taskgroup
Prompt Table: TL_TASKGRP_TBL

20 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

21 TASK_PROFILE_ID Character(10) VARCHAR2(10) NOT NULL Task Profile ID
Prompt Table: TL_TASKGRP_PRFL

22 TCD_SUPERVISR_ID Character(20) VARCHAR2(20) NOT NULL TCD Supervisor ID

23 OVERRIDE_RSN_CD Character(5) VARCHAR2(5) NOT NULL Override Reason Code
Prompt Table: TL_OVRD_RSN_TBL

24 RT_SOURCE Character(3) VARCHAR2(3) NOT NULL Reported Time Source. the originator of Reported Time
AM=Absence Management
MD=Mobile Device
ONL=Online
SCH=Schedule Source
SYS=Time and Labor System
TCD=Time Collection Device

25 REPORTED_STATUS Character(2) VARCHAR2(2) NOT NULL Reported Status
AP=Approved
CN=Cancelled
DN=Denied
IE=In Error
NA=Needs Approval
NW=New
PB=Pushed Back
PR=Processed
SB=Submitted
SV=Saved
VD=Voided

26 OPRID_LAST_UPDT Character(30) VARCHAR2(30) NOT NULL Last Operator to Update

27 DTTM_MODIFIED DateTime(26) TIMESTAMP Datetime modified

28 DTTM_CREATED DateTime(26) TIMESTAMP Datetime Created

29 TRC Character(5) VARCHAR2(5) NOT NULL Time Reporting Code used to report time in Time and Labor
Prompt Table: TL_TRC_TBL

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

31 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
Prompt Table: CURRENCY_CD_TBL

32 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
Prompt Table: COUNTRY_TBL

33 STATE Character(6) VARCHAR2(6) NOT NULL State
Prompt Table: STATE_TBL

34 LOCALITY Character(10) VARCHAR2(10) NOT NULL Locality
Prompt Table: LOCAL_TAX_TBL

35 COMP_RATECD Character(6) VARCHAR2(6) NOT NULL Comp Rate Code
Prompt Table: COMP_RT_REG_VW

36 BILLABLE_IND Character(1) VARCHAR2(1) NOT NULL Billable Indicator
N=No
Y=Yes
Y/N Table Edit
Default Value: N

37 OVERRIDE_RATE Signed Number(20,6) DECIMAL(18,6) NOT NULL Override Rate.

38 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
Prompt Table: COMPANY_TBL

39 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Prompt Table: TL_BUS_UNIT_VW

40 SETID_LOCATION Character(5) VARCHAR2(5) NOT NULL Location SetID

41 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
Prompt Table: TL_LOCATION_VW

42 SETID_DEPT Character(5) VARCHAR2(5) NOT NULL Department SetID

43 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
Prompt Table: TL_DEPT_TBL_VW

44 SETID_JOBCODE Character(5) VARCHAR2(5) NOT NULL Job Code SetID

45 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code
Prompt Table: TL_JOBCODE_VW

46 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number
Prompt Table: POSITION_DATA

47 PRODUCT Character(6) VARCHAR2(6) NOT NULL Product
Prompt Table: TL_PRODUCT_TBL

48 CUSTOMER Character(10) VARCHAR2(10) NOT NULL Customer
Prompt Table: TL_CUSTOMER

49 ACCT_CD Character(25) VARCHAR2(25) NOT NULL Combination Code
Prompt Table: %EDITTABLE6

50 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit
Prompt Table: %EDITTABLE3

51 BUSINESS_UNIT_PF Character(5) VARCHAR2(5) NOT NULL Perf Meas Business Unit
Prompt Table: BUS_UNIT_TBL_PF

52 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project/Grant
Prompt Table: %EDITTABLE

53 SETID_ACTIVITY Character(5) VARCHAR2(5) NOT NULL Activity SetID

54 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID
Prompt Table: %EDITTABLE2

55 RESOURCE_TYPE Character(5) VARCHAR2(5) NOT NULL Resource Type
Prompt Table: TL_PROJ_RTYPE_V

56 SETID_RESOURCE Character(5) VARCHAR2(5) NOT NULL Resource SetID

57 RESOURCE_CATEGORY Character(5) VARCHAR2(5) NOT NULL Resource Category
Prompt Table: %EDITTABLE4

58 RESOURCE_SUB_CAT Character(5) VARCHAR2(5) NOT NULL Resource Sub Category
Prompt Table: %EDITTABLE5

59 TASK Character(5) VARCHAR2(5) NOT NULL Task
Prompt Table: TL_TASK

60 USER_FIELD_1 Character(10) VARCHAR2(10) NOT NULL User Field 1
Prompt Table: TL_USER_FIELD_1

61 USER_FIELD_2 Character(10) VARCHAR2(10) NOT NULL User Field 2
Prompt Table: TL_USER_FIELD_2

62 USER_FIELD_3 Character(15) VARCHAR2(15) NOT NULL User Field 3
Prompt Table: TL_USER_FIELD_3

63 USER_FIELD_4 Character(20) VARCHAR2(20) NOT NULL User Field 4
Prompt Table: TL_USER_FIELD_4

64 USER_FIELD_5 Character(20) VARCHAR2(20) NOT NULL User Field 5
Prompt Table: TL_USER_FIELD_5

65 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.

66 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

#	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 Rcd Nbr
3	DUR	Date(10)	DATE NOT NULL	Date Under Report associates time being reported, scheduled or paid, to a specific date.
4	SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Number
5	PUNCH_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Global Punch Types 0=Elapsed 1=In 2=Out 3=Meal 4=Break 5=Transfer
6	PUNCH_TIME	Time(15)	TIMESTAMP	Punch Time
7	PUNCH_DTTM	DateTime(26)	TIMESTAMP	Date and time when the punch occurred.
8	PUNCH_END	DateTime(26)	TIMESTAMP	Punch out
9	TIMEZONE	Character(9)	VARCHAR2(9) NOT NULL	Time Zone Default Value: TL_EMPL_DATA.TIMEZONE Prompt Table: PSTIMEZONE
10	TIMEZONE2	Character(9)	VARCHAR2(9) NOT NULL	Time Zone
11	ST_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Session Number
12	BADGE_ID	Character(20)	VARCHAR2(20) NOT NULL	Badge ID
13	TCD_ID	Character(10)	VARCHAR2(10) NOT NULL	Time Collection Device Identification.
14	RULE_ELEMENT_1	Character(10)	VARCHAR2(10) NOT NULL	Rule Element 1 Prompt Table: TL_RULE_ELEMNT1
15	RULE_ELEMENT_2	Character(10)	VARCHAR2(10) NOT NULL	Rule Element 2 Prompt Table: TL_RULE_ELEMNT2
16	RULE_ELEMENT_3	Character(10)	VARCHAR2(10) NOT NULL	Rule Element 3 Prompt Table: TL_RULE_ELEMNT3
17	RULE_ELEMENT_4	Character(10)	VARCHAR2(10) NOT NULL	Rule Element 4 Prompt Table: TL_RULE_ELEMNT4
18	RULE_ELEMENT_5	Character(10)	VARCHAR2(10) NOT NULL	Rule Element 5 Prompt Table: TL_RULE_ELEMNT5
19	TASKGROUP	Character(10)	VARCHAR2(10) NOT NULL	Taskgroup Prompt Table: TL_TASKGRP_TBL
20	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
21	TASK_PROFILE_ID	Character(10)	VARCHAR2(10) NOT NULL	Task Profile ID Prompt Table: TL_TASKGRP_PRFL
22	TCD_SUPERVISR_ID	Character(20)	VARCHAR2(20) NOT NULL	TCD Supervisor ID
23	OVERRIDE_RSN_CD	Character(5)	VARCHAR2(5) NOT NULL	Override Reason Code Prompt Table: TL_OVRD_RSN_TBL
24	RT_SOURCE	Character(3)	VARCHAR2(3) NOT NULL	Reported Time Source. the originator of Reported Time AM=Absence Management MD=Mobile Device ONL=Online SCH=Schedule Source SYS=Time and Labor System TCD=Time Collection Device
25	REPORTED_STATUS	Character(2)	VARCHAR2(2) NOT NULL	Reported Status AP=Approved CN=Cancelled DN=Denied IE=In Error NA=Needs Approval NW=New PB=Pushed Back PR=Processed SB=Submitted SV=Saved VD=Voided
26	OPRID_LAST_UPDT	Character(30)	VARCHAR2(30) NOT NULL	Last Operator to Update
27	DTTM_MODIFIED	DateTime(26)	TIMESTAMP	Datetime modified
28	DTTM_CREATED	DateTime(26)	TIMESTAMP	Datetime Created
29	TRC	Character(5)	VARCHAR2(5) NOT NULL	Time Reporting Code used to report time in Time and Labor Prompt Table: TL_TRC_TBL
30	TL_QUANTITY	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	This field represents the measure of Work in hrs,amount etc.,
31	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Prompt Table: CURRENCY_CD_TBL
32	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country Prompt Table: COUNTRY_TBL
33	STATE	Character(6)	VARCHAR2(6) NOT NULL	State Prompt Table: STATE_TBL
34	LOCALITY	Character(10)	VARCHAR2(10) NOT NULL	Locality Prompt Table: LOCAL_TAX_TBL
35	COMP_RATECD	Character(6)	VARCHAR2(6) NOT NULL	Comp Rate Code Prompt Table: COMP_RT_REG_VW
36	BILLABLE_IND	Character(1)	VARCHAR2(1) NOT NULL	Billable Indicator N=No Y=Yes Y/N Table Edit Default Value: N
37	OVERRIDE_RATE	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Override Rate.
38	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company Prompt Table: COMPANY_TBL
39	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: TL_BUS_UNIT_VW
40	SETID_LOCATION	Character(5)	VARCHAR2(5) NOT NULL	Location SetID
41	LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Location Code Prompt Table: TL_LOCATION_VW
42	SETID_DEPT	Character(5)	VARCHAR2(5) NOT NULL	Department SetID
43	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department Prompt Table: TL_DEPT_TBL_VW
44	SETID_JOBCODE	Character(5)	VARCHAR2(5) NOT NULL	Job Code SetID
45	JOBCODE	Character(6)	VARCHAR2(6) NOT NULL	Job Code Prompt Table: TL_JOBCODE_VW
46	POSITION_NBR	Character(8)	VARCHAR2(8) NOT NULL	Position Number Prompt Table: POSITION_DATA
47	PRODUCT	Character(6)	VARCHAR2(6) NOT NULL	Product Prompt Table: TL_PRODUCT_TBL
48	CUSTOMER	Character(10)	VARCHAR2(10) NOT NULL	Customer Prompt Table: TL_CUSTOMER
49	ACCT_CD	Character(25)	VARCHAR2(25) NOT NULL	Combination Code Prompt Table: %EDITTABLE6
50	BUSINESS_UNIT_PC	Character(5)	VARCHAR2(5) NOT NULL	PC Business Unit Prompt Table: %EDITTABLE3
51	BUSINESS_UNIT_PF	Character(5)	VARCHAR2(5) NOT NULL	Perf Meas Business Unit Prompt Table: BUS_UNIT_TBL_PF
52	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project/Grant Prompt Table: %EDITTABLE
53	SETID_ACTIVITY	Character(5)	VARCHAR2(5) NOT NULL	Activity SetID
54	ACTIVITY_ID	Character(15)	VARCHAR2(15) NOT NULL	Activity ID Prompt Table: %EDITTABLE2
55	RESOURCE_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Resource Type Prompt Table: TL_PROJ_RTYPE_V
56	SETID_RESOURCE	Character(5)	VARCHAR2(5) NOT NULL	Resource SetID
57	RESOURCE_CATEGORY	Character(5)	VARCHAR2(5) NOT NULL	Resource Category Prompt Table: %EDITTABLE4
58	RESOURCE_SUB_CAT	Character(5)	VARCHAR2(5) NOT NULL	Resource Sub Category Prompt Table: %EDITTABLE5
59	TASK	Character(5)	VARCHAR2(5) NOT NULL	Task Prompt Table: TL_TASK
60	USER_FIELD_1	Character(10)	VARCHAR2(10) NOT NULL	User Field 1 Prompt Table: TL_USER_FIELD_1
61	USER_FIELD_2	Character(10)	VARCHAR2(10) NOT NULL	User Field 2 Prompt Table: TL_USER_FIELD_2
62	USER_FIELD_3	Character(15)	VARCHAR2(15) NOT NULL	User Field 3 Prompt Table: TL_USER_FIELD_3
63	USER_FIELD_4	Character(20)	VARCHAR2(20) NOT NULL	User Field 4 Prompt Table: TL_USER_FIELD_4
64	USER_FIELD_5	Character(20)	VARCHAR2(20) NOT NULL	User Field 5 Prompt Table: TL_USER_FIELD_5
65	SYNCID	Number(10,0)	DECIMAL(10) NOT NULL	The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
66	LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.