WM_PTIME_DTLHRS

(SQL View)
Index Back

SELECT D.TIME_SHEET_ID , D.VERSION_NUM , D.LINE_NBR , H.DATE_UNDER_RPT , H.START_TIME , D.EX_LINE_STATUS , D.BUSINESS_UNIT_GL , D.COUNTRY , D.STATE , D.LOCALITY , D.TRC , D.BILLING_ACTION , D.BI_DISTRIB_STATUS , %subrec(CF16_AN_SBR, D) , %subrec(PC_CF1_N_SBR, D) , D.PC_DISTRIB_STATUS , D.DEPTID , D.DESCR60 , D.COMMENTS , D.RESOURCE_ETC , D.CHANGE_REQ_FLAG , %subrec(WM_WO_SBR, D) , L.CRAFT_ID , H.END_TIME , H.TOTAL_HOURS FROM PS_EX_TIME_DTL D , PS_EX_TIME_DTL_HRS H , PS_WM_WO_SCHED_LBR L WHERE %Join(COMMON_KEYS, EX_TIME_DTL D, EX_TIME_DTL_HRS H) AND D.BUSINESS_UNIT_WO = L.BUSINESS_UNIT AND D.WO_ID = L.WO_ID AND D.WO_TASK_ID = L.WO_TASK_ID AND D.RES_LN_NBR = L.RES_LN_NBR

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 TIME_SHEET_ID Character(10) VARCHAR2(10) NOT NULL Time Sheet Unique Identifier (System Generated)
2 VERSION_NUM Number(3,0) SMALLINT NOT NULL Version Number

Default Value: 1

3 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]

Default Value: 1

4 DATE_UNDER_RPT Date(10) DATE Date Under Report
5 START_TIME Time(15) TIMESTAMP Start of Shift
6 EX_LINE_STATUS Character(3) VARCHAR2(3) NOT NULL The Line Status of an Expenses transaction (i.e. Expense Report, Cash Advance, Travel Authorization, Time Report)
ADJ=Adjusted
APR=Approved
APY=Approved for Payment
CLS=Closed
DEN=Denied
DNA=Denied by Approver
DNC=Denied
DNU=Denied by Auditor
ESC=Escheated Payment
HDA=Hold by Approver
HDU=Hold by Auditor
HLD=Hold
MFS=Marked For Submit
OPN=Open
PAR=Approvals in Process
PD=Paid
PND=Pending
PRO=In Process
RAP=Approved
STG=Staged
SUB=Submitted
XML=Submitted, Pending Validation

Default Value: PND

7 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit

Default Value: EX_TIME_HDR.BUSINESS_UNIT_GL

8 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

Prompt Table: COUNTRY_TBL

9 STATE Character(6) VARCHAR2(6) NOT NULL State

Prompt Table: STATE_TBL

10 LOCALITY Character(10) VARCHAR2(10) NOT NULL Locality

Prompt Table: LOCAL_TAX_VW

11 TRC Character(5) VARCHAR2(5) NOT NULL Time Reporting Code

Prompt Table: TL_TRC_TBL

12 BILLING_ACTION Character(1) VARCHAR2(1) NOT NULL Billing Action
B=Billable
I=Internal
P=Personal
U=Nonbillable

Default Value: EX_TIME_HDR.BILLING_ACTION

13 BI_DISTRIB_STATUS Character(1) VARCHAR2(1) NOT NULL Billing Distribution Status
D=Distributed
I=Ignore
N=Not Distributed
P=Priced
U=Unbillable/Non-billable
W=Billing Worksheet

Default Value: N

14 OPERATING_UNIT Character(8) VARCHAR2(8) NOT NULL Operating Unit ChartField

Prompt Table: OPERUNT_BUGL_VW

15 PRODUCT Character(6) VARCHAR2(6) NOT NULL Product ChartField

Prompt Table: PRODUCT_BUGL_VW

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

Prompt Table: FUND_BUGL_VW

17 CLASS_FLD Character(5) VARCHAR2(5) NOT NULL Class Field

Prompt Table: CLASSCF_BUGL_VW

18 PROGRAM_CODE Character(5) VARCHAR2(5) NOT NULL Program Code ChartField

Prompt Table: PROGRAM_BUGL_VW

19 BUDGET_REF Character(8) VARCHAR2(8) NOT NULL Budget Reference

Prompt Table: BUD_REF_BUGL_VW

20 AFFILIATE Character(5) VARCHAR2(5) NOT NULL Affiliate

Prompt Table: AFFILIATE_VW

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

Prompt Table: %EDIT_INTRA01

22 AFFILIATE_INTRA2 Character(10) VARCHAR2(10) NOT NULL Operating Unit Affiliate

Prompt Table: %EDIT_INTRA02

23 CHARTFIELD1 Character(10) VARCHAR2(10) NOT NULL Expansion chartfield 1

Prompt Table: CF1_BUGL_VW

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

Prompt Table: CF2_BUGL_VW

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

Prompt Table: CF3_BUGL_VW

26 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit

Prompt Table: %EDIT_BU_PC

27 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField

Prompt Table: %EDIT_PROJECT

28 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID

Prompt Table: %EDIT_ACTIVITY

29 RESOURCE_TYPE Character(5) VARCHAR2(5) NOT NULL Source Type

Prompt Table: PROJ_RESTYPE_FS
Set Control Field: BUSINESS_UNIT_PC

30 RESOURCE_CATEGORY Character(5) VARCHAR2(5) NOT NULL Category

Prompt Table: %EDIT_RES_CAT
Set Control Field: BUSINESS_UNIT_PC

31 RESOURCE_SUB_CAT Character(5) VARCHAR2(5) NOT NULL Subcategory

Prompt Table: %EDIT_RES_SUB
Set Control Field: BUSINESS_UNIT_PC

32 ANALYSIS_TYPE Character(3) VARCHAR2(3) NOT NULL Analysis Type

Prompt Table: %EDIT_ANALYSIS
Set Control Field: BUSINESS_UNIT_PC

33 PC_DISTRIB_STATUS Character(1) VARCHAR2(1) NOT NULL PC Distribution Status
B=Budget Check
D=Distributed
G=Generated
H=Hold
I=Ignore
M=Modified
N=Not Distributed
S=Staged
34 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

Prompt Table: DEPTID_BUGL_VW

35 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description
36 COMMENTS Long Character CLOB Comment
37 RESOURCE_ETC Signed Number(16,2) DECIMAL(14,2) NOT NULL Estimate to Complete
38 CHANGE_REQ_FLAG Character(1) VARCHAR2(1) NOT NULL Change Request Flag

Y/N Table Edit

Default Value: N

39 BUSINESS_UNIT_WO Character(5) VARCHAR2(5) NOT NULL Business Unit Work Order

Prompt Table: SP_BU_WM_NONVW

40 WO_ID Character(10) VARCHAR2(10) NOT NULL Work Order Identification

Prompt Table: %EDIT_WO_ID

41 WO_TASK_ID Number(5,0) INTEGER NOT NULL Task Number

Prompt Table: %EDIT_WO_TASK

42 RSRC_TYPE Character(1) VARCHAR2(1) NOT NULL Work Order Management Resource Types
1=Labor
2=Tools
3=Material
43 RES_LN_NBR Number(5,0) INTEGER NOT NULL Resource Line No.

Prompt Table: %EDIT_RES_LINE

44 CRAFT_ID Character(16) VARCHAR2(16) NOT NULL Craft Identification
45 END_TIME Time(15) TIMESTAMP End of Shift
46 TOTAL_HOURS Number(7,2) DECIMAL(6,2) NOT NULL Total Hours