EX_TIME_DTL_VW

(SQL View)
 Index Back

Time Report Detail View

View contains all of the detail information for a Time Card for regular time (not policy related, see EX_TIME_POL)

SELECT A.TIME_SHEET_ID , A.LINE_NBR , A.VERSION_NUM , A.EX_LINE_STATUS , A.BUSINESS_UNIT_GL , A.COUNTRY , A.STATE , A.LOCALITY , A.TRC , A.BILLING_ACTION , A.PROJECT_ID , %subrec(EX_PROJFLDS_01, A) , A.BI_DISTRIB_STATUS , A.DESCR60 , B.DATE_UNDER_RPT , B.TIME_QUANTITY , B.UNIT_OF_MEASURE , A.LASTUPDDTTM , A.COMMENTS FROM PS_EX_TIME_DTL A ,PS_EX_TIME_DTL_DLY B WHERE A.TIME_SHEET_ID = B.TIME_SHEET_ID AND A.VERSION_NUM = B.VERSION_NUM AND A.LINE_NBR = B.LINE_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 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]

Default Value: 1

3 VERSION_NUM Number(3,0) SMALLINT NOT NULL Version Number

Default Value: 1

4 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

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

Default Value: EX_TIME_HDR.BUSINESS_UNIT_GL

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

Default Value: EX_TIME_HDR.COUNTRY

Prompt Table: COUNTRY_TBL

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

Default Value: EX_TIME_HDR.STATE

Prompt Table: STATE_TBL

8 LOCALITY Character(10) VARCHAR2(10) NOT NULL Locality
9 TRC Character(5) VARCHAR2(5) NOT NULL Time Reporting Code

Prompt Table: TL_TRC_TBL

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

Default Value: B

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

Prompt Table: PROJID_BUGL_VW

12 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit
13 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID
14 RESOURCE_CATEGORY Character(5) VARCHAR2(5) NOT NULL Category
15 RESOURCE_TYPE Character(5) VARCHAR2(5) NOT NULL Source Type
16 RESOURCE_SUB_CAT Character(5) VARCHAR2(5) NOT NULL Subcategory
17 ANALYSIS_TYPE Character(3) VARCHAR2(3) NOT NULL Analysis Type
18 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

Default Value: N

19 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
20 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description
21 DATE_UNDER_RPT Date(10) DATE Date Under Report
22 TIME_QUANTITY Signed Number(16,2) DECIMAL(14,2) NOT NULL Time Quantity
23 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage

Prompt Table: UNITS_TBL

24 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.
25 COMMENTS Long Character CLOB Comment