TL_PAYBTIME_LNG (SQL View)	Index Back
Payable Time View Payable Time

TL_PAYBTIME_LNG

(SQL View)

Payable Time View

Payable Time

SELECT PT.EMPLID ,PT.EMPL_RCD ,PT.DUR ,PT.SEQ_NBR ,PT.TASKGROUP ,PT.SHIFT_ID ,PT.TRC ,PT.TL_QUANTITY ,PT.CURRENCY_CD ,PT.COUNTRY ,PT.STATE ,PT.LOCALITY ,PT.COMP_RATECD ,PT.BILLABLE_IND ,PT.OVERRIDE_RATE ,PT.EST_GROSS ,PT.LBR_DIST_AMT ,PT.DILUTED_GROSS ,PT.CURRENCY_CD2 ,PT.PAYABLE_STATUS ,PT.PAY_SYSTEM ,PT.PAYROLL_REQ_NUM ,PT.FROZEN_SW ,PT.FROZEN_DATE ,PT.RECORD_ONLY_ADJ ,PT.PUBLISH_SW ,PT.ACTUAL_PUB_DATE ,PT.OPRID ,PT.APPRV_PRCS_DTTM ,PT.SOURCE_IND ,PT.ORIG_SEQ_NBR ,PT.COMPANY ,PT.BUSINESS_UNIT ,PT.SETID_LOCATION ,PT.LOCATION ,PT.SETID_DEPT ,PT.DEPTID ,PT.SETID_JOBCODE ,PT.JOBCODE ,PT.POSITION_NBR ,PT.PRODUCT ,PT.CUSTOMER ,PT.ACCT_CD ,PT.BUSINESS_UNIT_PC ,PT.BUSINESS_UNIT_PF ,PT.PROJECT_ID ,PT.SETID_ACTIVITY ,PT.ACTIVITY_ID ,PT.RESOURCE_TYPE ,PT.SETID_RESOURCE ,PT.RESOURCE_CATEGORY ,PT.RESOURCE_SUB_CAT ,PT.TASK ,PT.USER_FIELD_1 ,PT.USER_FIELD_2 ,PT.USER_FIELD_3 ,PT.USER_FIELD_4 ,PT.USER_FIELD_5 ,PT.DEPTID_CF ,PT.ACCOUNT ,PT.FUND_CODE ,PT.PROGRAM_CODE ,PT.CLASS_FLD ,PT.AFFILIATE ,PT.OPERATING_UNIT ,PT.ALTACCT ,PT.BUDGET_REF ,PT.CHARTFIELD1 ,PT.CHARTFIELD2 ,PT.CHARTFIELD3 ,PT.AFFILIATE_INTRA1 ,PT.AFFILIATE_INTRA2 ,PT.TL_RULE_ID ,PT.RT_SOURCE ,PT.TL_PYBL_REASON_CD ,PT.INITIAL_SEQ_NBR ,B.LANGUAGE_CD ,B.DESCR FROM PS_TL_PAYABLE_TIME PT , PS_TL_TRC_LANG B , PS_TL_TRC_TBL A WHERE A.TRC = PT.TRC AND A.EFF_STATUS = 'A' AND A.TRC = B.TRC AND B.EFFDT = A.EFFDT AND A.EFFDT = ( SELECT MAX(A1.EFFDT) FROM PS_TL_TRC_TBL A1 WHERE A1.TRC = A.TRC AND A1.EFFDT <= %CurrentDateIn)

Related Language Record for TL_PAYB_TIME_VW

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

20 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

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

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

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

24 FROZEN_DATE Date(10) DATE Frozen Date

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

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

27 ACTUAL_PUB_DATE Date(10) DATE Publish Date

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

29 APPRV_PRCS_DTTM DateTime(26) TIMESTAMP Approval Process Time

30 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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

74 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

75 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

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

77 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

78 TRC_DESCR Character(30) VARCHAR2(30) NOT NULL Time Reporting Code Descriptio

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