TL_PAYABLE_HST (SQL Table)	Index Back
Payable Time Archive record Payable Time

TL_PAYABLE_HST

(SQL Table)

Payable Time Archive record

Payable 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 Record

5 DUR Date(10) DATE 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 TASKGROUP Character(10) VARCHAR2(10) NOT NULL Taskgroup
Prompt Table: TL_TASKGRP_TBL

8 SHIFT_ID Character(10) VARCHAR2(10) NOT NULL Shift ID

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

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

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

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

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

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

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

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

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

18 EST_GROSS Signed Number(20,6) DECIMAL(18,6) NOT NULL Estimated Gross

19 LBR_DIST_AMT Signed Number(20,6) DECIMAL(18,6) NOT NULL Labor Distribution Amount

20 DILUTED_GROSS Signed Number(20,6) DECIMAL(18,6) NOT NULL Diluted Labor Distribution Amt

21 CURRENCY_CD2 Character(3) VARCHAR2(3) NOT NULL Currency Code

22 PAYABLE_STATUS Character(2) VARCHAR2(2) NOT NULL Payable Status
AP=Approved
CL=Closed
DL=Diluted
DN=Denied
ES=Estimated
IG=Ignore
NA=Needs Approval
NP=No Pay
OE=Online Estimate
PB=Pushed Back
PD=Distributed
RP=Rejected by Payroll
RV=Reversed Check
SP=Sent to Payroll
TP=Taken by Payroll

23 PAY_SYSTEM Character(4) VARCHAR2(4) NOT NULL Payroll System
GP=Global Payroll
NA=Payroll for North America

24 PAYROLL_REQ_NUM Number(6,0) INTEGER NOT NULL Last payroll request number.

25 FROZEN_SW Character(1) VARCHAR2(1) NOT NULL Frozen
N=Not Frozen
Y=Frozen

26 FROZEN_DATE Date(10) DATE Frozen Date

27 RECORD_ONLY_ADJ Character(1) VARCHAR2(1) NOT NULL Record Only Adjustment

28 PUBLISH_SW Character(1) VARCHAR2(1) NOT NULL If Data was published
I=Ignore
N=Not Publish
Y=Published

29 ACTUAL_PUB_DATE Date(10) DATE Publish Date

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

31 APPRV_PRCS_DTTM DateTime(26) TIMESTAMP Approval Process Time

32 SOURCE_IND Character(1) VARCHAR2(1) NOT NULL Indicates the source of payable time. S - system generated U - User entered O - Offset
O=Offset
S=System Generated
U=User Reported

33 ORIG_SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Original Sequence Number

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

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

36 SETID_LOCATION Character(5) VARCHAR2(5) NOT NULL Location Set ID

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

38 SETID_DEPT Character(5) VARCHAR2(5) NOT NULL Department Set ID

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

40 SETID_JOBCODE Character(5) VARCHAR2(5) NOT NULL Job Code Set ID

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

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

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

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

45 ACCT_CD Character(25) VARCHAR2(25) NOT NULL Combination Code
Prompt Table: TL_ACCTCD_BU_VW

46 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL Project Costing Business Unit
Prompt Table: BUS_UNIT_PRJ_VW

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

48 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project/Grant
Prompt Table: %EDIT_PROJECT

49 SETID_ACTIVITY Character(5) VARCHAR2(5) NOT NULL Activity Set ID

50 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID
Prompt Table: %EDIT_ACTIVITY

51 RESOURCE_TYPE Character(5) VARCHAR2(5) NOT NULL Project Costing Resource Type
Prompt Table: TL_PROJ_RTYPE_V

52 SETID_RESOURCE Character(5) VARCHAR2(5) NOT NULL Resource Set ID

53 RESOURCE_CATEGORY Character(5) VARCHAR2(5) NOT NULL Project Costing Resource Category
Prompt Table: %EDIT_RES_CAT

54 RESOURCE_SUB_CAT Character(5) VARCHAR2(5) NOT NULL Project Costing Resource Sub Category
Prompt Table: %EDIT_RES_SUB

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

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

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

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

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

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

61 DEPTID_CF Character(10) VARCHAR2(10) NOT NULL Department

62 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account

63 FUND_CODE Character(5) VARCHAR2(5) NOT NULL Fund Code

64 PROGRAM_CODE Character(5) VARCHAR2(5) NOT NULL Program Code

65 CLASS_FLD Character(5) VARCHAR2(5) NOT NULL Public Sector Financials Chart Field.

66 AFFILIATE Character(5) VARCHAR2(5) NOT NULL Public Sector Financials Chart Field

67 OPERATING_UNIT Character(8) VARCHAR2(8) NOT NULL Operating Unit

68 ALTACCT Character(10) VARCHAR2(10) NOT NULL Alternate Account

69 BUDGET_REF Character(8) VARCHAR2(8) NOT NULL Budget Reference Chartfield

70 CHARTFIELD1 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield number 1

71 CHARTFIELD2 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 2

72 CHARTFIELD3 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 3

73 AFFILIATE_INTRA1 Character(10) VARCHAR2(10) NOT NULL IntraUnit Affiliate1

74 AFFILIATE_INTRA2 Character(10) VARCHAR2(10) NOT NULL IntraUnit Affiliate2

75 TL_RULE_ID Character(12) VARCHAR2(12) NOT NULL Rule ID

76 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
SYS=Time and Labor System
TCD=Time Collection Device

77 TL_PYBL_REASON_CD Character(3) VARCHAR2(3) NOT NULL Payable Reason Code
CAN=Cancelled
CRV=Reversed
MRJ=Manual Reject
NDS=Not Distributed
NOP=Not OK to Pay
NSP=Not Sent to Payroll
NUS=Not Used
PNP=Not Processed in Payroll
PPS=Prior Period Adjustment
RAJ=Record Adjustment

78 INITIAL_SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Original sequence number of payable time row.

79 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 Record
5	DUR	Date(10)	DATE	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	TASKGROUP	Character(10)	VARCHAR2(10) NOT NULL	Taskgroup Prompt Table: TL_TASKGRP_TBL
8	SHIFT_ID	Character(10)	VARCHAR2(10) NOT NULL	Shift ID
9	TRC	Character(5)	VARCHAR2(5) NOT NULL	Time Reporting Code used to report time in Time and Labor Prompt Table: TL_TRC_TBL
10	TL_QUANTITY	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	This field represents the measure of Work in hrs,amount etc.,
11	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Prompt Table: CURRENCY_CD_TBL
12	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country Prompt Table: COUNTRY_TBL
13	STATE	Character(6)	VARCHAR2(6) NOT NULL	State Prompt Table: STATE_TBL
14	LOCALITY	Character(10)	VARCHAR2(10) NOT NULL	Locality Prompt Table: LOCAL_TAX_TBL
15	COMP_RATECD	Character(6)	VARCHAR2(6) NOT NULL	Comp Rate Code Prompt Table: COMP_RT_REG_VW
16	BILLABLE_IND	Character(1)	VARCHAR2(1) NOT NULL	Billable Indicator N=No Y=Yes Y/N Table Edit Default Value: N
17	OVERRIDE_RATE	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Override Rate.
18	EST_GROSS	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Estimated Gross
19	LBR_DIST_AMT	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Labor Distribution Amount
20	DILUTED_GROSS	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Diluted Labor Distribution Amt
21	CURRENCY_CD2	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
22	PAYABLE_STATUS	Character(2)	VARCHAR2(2) NOT NULL	Payable Status AP=Approved CL=Closed DL=Diluted DN=Denied ES=Estimated IG=Ignore NA=Needs Approval NP=No Pay OE=Online Estimate PB=Pushed Back PD=Distributed RP=Rejected by Payroll RV=Reversed Check SP=Sent to Payroll TP=Taken by Payroll
23	PAY_SYSTEM	Character(4)	VARCHAR2(4) NOT NULL	Payroll System GP=Global Payroll NA=Payroll for North America
24	PAYROLL_REQ_NUM	Number(6,0)	INTEGER NOT NULL	Last payroll request number.
25	FROZEN_SW	Character(1)	VARCHAR2(1) NOT NULL	Frozen N=Not Frozen Y=Frozen
26	FROZEN_DATE	Date(10)	DATE	Frozen Date
27	RECORD_ONLY_ADJ	Character(1)	VARCHAR2(1) NOT NULL	Record Only Adjustment
28	PUBLISH_SW	Character(1)	VARCHAR2(1) NOT NULL	If Data was published I=Ignore N=Not Publish Y=Published
29	ACTUAL_PUB_DATE	Date(10)	DATE	Publish Date
30	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
31	APPRV_PRCS_DTTM	DateTime(26)	TIMESTAMP	Approval Process Time
32	SOURCE_IND	Character(1)	VARCHAR2(1) NOT NULL	Indicates the source of payable time. S - system generated U - User entered O - Offset O=Offset S=System Generated U=User Reported
33	ORIG_SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Original Sequence Number
34	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company Prompt Table: COMPANY_TBL
35	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: TL_BUS_UNIT_VW
36	SETID_LOCATION	Character(5)	VARCHAR2(5) NOT NULL	Location Set ID
37	LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Location Code Prompt Table: TL_LOCATION_VW
38	SETID_DEPT	Character(5)	VARCHAR2(5) NOT NULL	Department Set ID
39	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department Prompt Table: TL_DEPT_TBL_VW
40	SETID_JOBCODE	Character(5)	VARCHAR2(5) NOT NULL	Job Code Set ID
41	JOBCODE	Character(6)	VARCHAR2(6) NOT NULL	Job Code Prompt Table: TL_JOBCODE_VW
42	POSITION_NBR	Character(8)	VARCHAR2(8) NOT NULL	Position Number Prompt Table: POSITION_DATA
43	PRODUCT	Character(6)	VARCHAR2(6) NOT NULL	Product Prompt Table: TL_PRODUCT_TBL
44	CUSTOMER	Character(10)	VARCHAR2(10) NOT NULL	Customer Prompt Table: TL_CUSTOMER
45	ACCT_CD	Character(25)	VARCHAR2(25) NOT NULL	Combination Code Prompt Table: TL_ACCTCD_BU_VW
46	BUSINESS_UNIT_PC	Character(5)	VARCHAR2(5) NOT NULL	Project Costing Business Unit Prompt Table: BUS_UNIT_PRJ_VW
47	BUSINESS_UNIT_PF	Character(5)	VARCHAR2(5) NOT NULL	Perf Meas Business Unit Prompt Table: BUS_UNIT_TBL_PF
48	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project/Grant Prompt Table: %EDIT_PROJECT
49	SETID_ACTIVITY	Character(5)	VARCHAR2(5) NOT NULL	Activity Set ID
50	ACTIVITY_ID	Character(15)	VARCHAR2(15) NOT NULL	Activity ID Prompt Table: %EDIT_ACTIVITY
51	RESOURCE_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Project Costing Resource Type Prompt Table: TL_PROJ_RTYPE_V
52	SETID_RESOURCE	Character(5)	VARCHAR2(5) NOT NULL	Resource Set ID
53	RESOURCE_CATEGORY	Character(5)	VARCHAR2(5) NOT NULL	Project Costing Resource Category Prompt Table: %EDIT_RES_CAT
54	RESOURCE_SUB_CAT	Character(5)	VARCHAR2(5) NOT NULL	Project Costing Resource Sub Category Prompt Table: %EDIT_RES_SUB
55	TASK	Character(5)	VARCHAR2(5) NOT NULL	Task Prompt Table: TL_TASK
56	USER_FIELD_1	Character(10)	VARCHAR2(10) NOT NULL	User Field 1 Prompt Table: TL_USER_FIELD_1
57	USER_FIELD_2	Character(10)	VARCHAR2(10) NOT NULL	User Field 2 Prompt Table: TL_USER_FIELD_2
58	USER_FIELD_3	Character(15)	VARCHAR2(15) NOT NULL	User Field 3 Prompt Table: TL_USER_FIELD_3
59	USER_FIELD_4	Character(20)	VARCHAR2(20) NOT NULL	User Field 4 Prompt Table: TL_USER_FIELD_4
60	USER_FIELD_5	Character(20)	VARCHAR2(20) NOT NULL	User Field 5 Prompt Table: TL_USER_FIELD_5
61	DEPTID_CF	Character(10)	VARCHAR2(10) NOT NULL	Department
62	ACCOUNT	Character(10)	VARCHAR2(10) NOT NULL	Account
63	FUND_CODE	Character(5)	VARCHAR2(5) NOT NULL	Fund Code
64	PROGRAM_CODE	Character(5)	VARCHAR2(5) NOT NULL	Program Code
65	CLASS_FLD	Character(5)	VARCHAR2(5) NOT NULL	Public Sector Financials Chart Field.
66	AFFILIATE	Character(5)	VARCHAR2(5) NOT NULL	Public Sector Financials Chart Field
67	OPERATING_UNIT	Character(8)	VARCHAR2(8) NOT NULL	Operating Unit
68	ALTACCT	Character(10)	VARCHAR2(10) NOT NULL	Alternate Account
69	BUDGET_REF	Character(8)	VARCHAR2(8) NOT NULL	Budget Reference Chartfield
70	CHARTFIELD1	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield number 1
71	CHARTFIELD2	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 2
72	CHARTFIELD3	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 3
73	AFFILIATE_INTRA1	Character(10)	VARCHAR2(10) NOT NULL	IntraUnit Affiliate1
74	AFFILIATE_INTRA2	Character(10)	VARCHAR2(10) NOT NULL	IntraUnit Affiliate2
75	TL_RULE_ID	Character(12)	VARCHAR2(12) NOT NULL	Rule ID
76	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 SYS=Time and Labor System TCD=Time Collection Device
77	TL_PYBL_REASON_CD	Character(3)	VARCHAR2(3) NOT NULL	Payable Reason Code CAN=Cancelled CRV=Reversed MRJ=Manual Reject NDS=Not Distributed NOP=Not OK to Pay NSP=Not Sent to Payroll NUS=Not Used PNP=Not Processed in Payroll PPS=Prior Period Adjustment RAJ=Record Adjustment
78	INITIAL_SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Original sequence number of payable time row.
79	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.