TL_RPT_TIME_HST (SQL Table)	Index Back
Archive Rec - Reported Time Archive Record for Reported Time

TL_RPT_TIME_HST

(SQL Table)

Archive Rec - Reported Time

Archive Record for Reported Time

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PSARCH_ID Character(8) VARCHAR2(8) NOT NULL Archive ID (see PSARCHTEMPLATE).

2 PSARCH_BATCHNUM Number(30,0) DECIMAL(30) NOT NULL Archive Batch Number

3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

4 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr

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

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

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

8 PUNCH_TIME Time(15) TIMESTAMP Punch Time

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

10 PUNCH_END DateTime(26) TIMESTAMP Punch out

11 TIMEZONE Character(9) VARCHAR2(9) NOT NULL Time Zone
Default Value: TL_EMPL_DATA.TIMEZONE

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

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

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

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

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

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

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

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

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

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

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

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

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

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

26 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

27 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

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

29 DTTM_MODIFIED DateTime(26) TIMESTAMP Datetime modified

30 DTTM_CREATED DateTime(26) TIMESTAMP Datetime Created

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

67 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.

68 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	PSARCH_ID	Character(8)	VARCHAR2(8) NOT NULL	Archive ID (see PSARCHTEMPLATE).
2	PSARCH_BATCHNUM	Number(30,0)	DECIMAL(30) NOT NULL	Archive Batch Number
3	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
4	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
5	DUR	Date(10)	DATE NOT NULL	Date Under Report associates time being reported, scheduled or paid, to a specific date.
6	SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Number
7	PUNCH_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Global Punch Types 0=Elapsed 1=In 2=Out 3=Meal 4=Break 5=Transfer
8	PUNCH_TIME	Time(15)	TIMESTAMP	Punch Time
9	PUNCH_DTTM	DateTime(26)	TIMESTAMP	Date and time when the punch occurred.
10	PUNCH_END	DateTime(26)	TIMESTAMP	Punch out
11	TIMEZONE	Character(9)	VARCHAR2(9) NOT NULL	Time Zone Default Value: TL_EMPL_DATA.TIMEZONE
12	TIMEZONE2	Character(9)	VARCHAR2(9) NOT NULL	Time Zone
13	ST_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Session Number
14	BADGE_ID	Character(20)	VARCHAR2(20) NOT NULL	Badge ID
15	TCD_ID	Character(10)	VARCHAR2(10) NOT NULL	Time Collection Device Identification.
16	RULE_ELEMENT_1	Character(10)	VARCHAR2(10) NOT NULL	Rule Element 1 Prompt Table: TL_RULE_ELEMNT1
17	RULE_ELEMENT_2	Character(10)	VARCHAR2(10) NOT NULL	Rule Element 2 Prompt Table: TL_RULE_ELEMNT2
18	RULE_ELEMENT_3	Character(10)	VARCHAR2(10) NOT NULL	Rule Element 3 Prompt Table: TL_RULE_ELEMNT3
19	RULE_ELEMENT_4	Character(10)	VARCHAR2(10) NOT NULL	Rule Element 4 Prompt Table: TL_RULE_ELEMNT4
20	RULE_ELEMENT_5	Character(10)	VARCHAR2(10) NOT NULL	Rule Element 5 Prompt Table: TL_RULE_ELEMNT5
21	TASKGROUP	Character(10)	VARCHAR2(10) NOT NULL	Taskgroup Prompt Table: TL_TASKGRP_TBL
22	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
23	TASK_PROFILE_ID	Character(10)	VARCHAR2(10) NOT NULL	Task Profile ID Prompt Table: TL_TASKGRP_PRFL
24	TCD_SUPERVISR_ID	Character(20)	VARCHAR2(20) NOT NULL	TCD Supervisor ID
25	OVERRIDE_RSN_CD	Character(5)	VARCHAR2(5) NOT NULL	Override Reason Code Prompt Table: TL_OVRD_RSN_TBL
26	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
27	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
28	OPRID_LAST_UPDT	Character(30)	VARCHAR2(30) NOT NULL	Last Operator to Update
29	DTTM_MODIFIED	DateTime(26)	TIMESTAMP	Datetime modified
30	DTTM_CREATED	DateTime(26)	TIMESTAMP	Datetime Created
31	TRC	Character(5)	VARCHAR2(5) NOT NULL	Time Reporting Code used to report time in Time and Labor Prompt Table: TL_TRC_TBL
32	TL_QUANTITY	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	This field represents the measure of Work in hrs,amount etc.,
33	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Prompt Table: CURRENCY_CD_TBL
34	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country Prompt Table: COUNTRY_TBL
35	STATE	Character(6)	VARCHAR2(6) NOT NULL	State Prompt Table: STATE_TBL
36	LOCALITY	Character(10)	VARCHAR2(10) NOT NULL	Locality Prompt Table: LOCAL_TAX_TBL
37	COMP_RATECD	Character(6)	VARCHAR2(6) NOT NULL	Comp Rate Code Prompt Table: COMP_RT_REG_VW
38	BILLABLE_IND	Character(1)	VARCHAR2(1) NOT NULL	Billable Indicator N=No Y=Yes Y/N Table Edit Default Value: N
39	OVERRIDE_RATE	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Override Rate.
40	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company Prompt Table: COMPANY_TBL
41	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: TL_BUS_UNIT_VW
42	SETID_LOCATION	Character(5)	VARCHAR2(5) NOT NULL	Location SetID
43	LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Location Code Prompt Table: TL_LOCATION_VW
44	SETID_DEPT	Character(5)	VARCHAR2(5) NOT NULL	Department SetID
45	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department Prompt Table: TL_DEPT_TBL_VW
46	SETID_JOBCODE	Character(5)	VARCHAR2(5) NOT NULL	Job Code SetID
47	JOBCODE	Character(6)	VARCHAR2(6) NOT NULL	Job Code Prompt Table: TL_JOBCODE_VW
48	POSITION_NBR	Character(8)	VARCHAR2(8) NOT NULL	Position Number Prompt Table: POSITION_DATA
49	PRODUCT	Character(6)	VARCHAR2(6) NOT NULL	Product Prompt Table: TL_PRODUCT_TBL
50	CUSTOMER	Character(10)	VARCHAR2(10) NOT NULL	Customer Prompt Table: TL_CUSTOMER
51	ACCT_CD	Character(25)	VARCHAR2(25) NOT NULL	Combination Code Prompt Table: %EDITTABLE6
52	BUSINESS_UNIT_PC	Character(5)	VARCHAR2(5) NOT NULL	PC Business Unit Prompt Table: %EDITTABLE3
53	BUSINESS_UNIT_PF	Character(5)	VARCHAR2(5) NOT NULL	Perf Meas Business Unit Prompt Table: BUS_UNIT_TBL_PF
54	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project/Grant Prompt Table: %EDITTABLE
55	SETID_ACTIVITY	Character(5)	VARCHAR2(5) NOT NULL	Activity SetID
56	ACTIVITY_ID	Character(15)	VARCHAR2(15) NOT NULL	Activity ID Prompt Table: %EDITTABLE2
57	RESOURCE_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Resource Type Prompt Table: TL_PROJ_RTYPE_V
58	SETID_RESOURCE	Character(5)	VARCHAR2(5) NOT NULL	Resource SetID
59	RESOURCE_CATEGORY	Character(5)	VARCHAR2(5) NOT NULL	Resource Category Prompt Table: %EDITTABLE4
60	RESOURCE_SUB_CAT	Character(5)	VARCHAR2(5) NOT NULL	Resource Sub Category Prompt Table: %EDITTABLE5
61	TASK	Character(5)	VARCHAR2(5) NOT NULL	Task Prompt Table: TL_TASK
62	USER_FIELD_1	Character(10)	VARCHAR2(10) NOT NULL	User Field 1 Prompt Table: TL_USER_FIELD_1
63	USER_FIELD_2	Character(10)	VARCHAR2(10) NOT NULL	User Field 2 Prompt Table: TL_USER_FIELD_2
64	USER_FIELD_3	Character(15)	VARCHAR2(15) NOT NULL	User Field 3 Prompt Table: TL_USER_FIELD_3
65	USER_FIELD_4	Character(20)	VARCHAR2(20) NOT NULL	User Field 4 Prompt Table: TL_USER_FIELD_4
66	USER_FIELD_5	Character(20)	VARCHAR2(20) NOT NULL	User Field 5 Prompt Table: TL_USER_FIELD_5
67	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.
68	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.