EX_TIME_DTL2_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)

EX_TIME_DTL2_VW

(SQL View)

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 , A.COMMENTS FROM PS_EX_TIME_DTL A

# 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 COMMENTS Long Character CLOB Comment

#	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	COMMENTS	Long Character	CLOB	Comment