EX_TJ_LN_AW_VW3 (SQL View)	Index Back
Time Report Detail Adjust View Used for Approval process

EX_TJ_LN_AW_VW3

(SQL View)

Time Report Detail Adjust View

Used for Approval process

SELECT TIME_SHEET_ID , VERSION_NUM , LINE_NBR , EX_LINE_STATUS , BUSINESS_UNIT_GL , PROJECT_ID FROM PS_EX_TIME_DTL WHERE VERSION_NUM > 1 UNION SELECT TIME_SHEET_ID , VERSION_NUM , LINE_NBR , EX_LINE_STATUS , ' ' , ' ' FROM PS_EX_TIME_POL B WHERE VERSION_NUM > 1

# 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 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 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
Prompt Table: PROJID_BUGL_VW

#	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	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	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField Prompt Table: PROJID_BUGL_VW