EX_TIME_POL_VW (SQL View)	Index Back
Time Report Policy View View contains all of the detail information for a Time Card for policy time

EX_TIME_POL_VW

(SQL View)

Time Report Policy View

View contains all of the detail information for a Time Card for policy time

SELECT A.TIME_SHEET_ID , 'B' , A.LINE_NBR , A.VERSION_NUM , A.EX_LINE_STATUS , A.TRC , A.DESCR60 , B.DATE_UNDER_RPT , B.TIME_QUANTITY , B.UNIT_OF_MEASURE FROM PS_EX_TIME_POL A ,PS_EX_TIME_POL_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 SORTBY Character(1) VARCHAR2(1) NOT NULL Sort By

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

4 VERSION_NUM Number(3,0) SMALLINT NOT NULL Version Number
Default Value: 1

5 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

6 TRC Character(5) VARCHAR2(5) NOT NULL Time Reporting Code
Prompt Table: EX_TRC_MAP_VW

7 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description

8 DATE_UNDER_RPT Date(10) DATE Date Under Report

9 TIME_QUANTITY Signed Number(16,2) DECIMAL(14,2) NOT NULL Time Quantity

10 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage

#	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	SORTBY	Character(1)	VARCHAR2(1) NOT NULL	Sort By
3	LINE_NBR	Number(5,0)	INTEGER NOT NULL	Line Number: 11/24/08 - Added TARGET label [PC product] Default Value: 1
4	VERSION_NUM	Number(3,0)	SMALLINT NOT NULL	Version Number Default Value: 1
5	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
6	TRC	Character(5)	VARCHAR2(5) NOT NULL	Time Reporting Code Prompt Table: EX_TRC_MAP_VW
7	DESCR60	Character(60)	VARCHAR2(60) NOT NULL	Description
8	DATE_UNDER_RPT	Date(10)	DATE	Date Under Report
9	TIME_QUANTITY	Signed Number(16,2)	DECIMAL(14,2) NOT NULL	Time Quantity
10	UNIT_OF_MEASURE	Character(3)	VARCHAR2(3) NOT NULL	Used on an approval rule set. MHR=Muti Hourly PER=Percentage SQF=Square Footage