EX_TIME_POL2_VW(SQL View) |
Index Back |
|---|---|
Time Report Policy ViewView 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 FROM PS_EX_TIME_POL 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 | 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 |