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
|
30 | RESOURCE_CATEGORY | Character(5) | VARCHAR2(5) NOT NULL |
Category
Prompt Table:
%EDIT_RES_CAT
|
31 | RESOURCE_SUB_CAT | Character(5) | VARCHAR2(5) NOT NULL |
Subcategory
Prompt Table:
%EDIT_RES_SUB
|
32 | ANALYSIS_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Analysis Type
Prompt Table:
%EDIT_ANALYSIS
|
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 |