EMPLIDTIME_SHEET_IDVERSION_NUMO=Original Version
P=Partial Submit
R=Revision
A=Asset Lifecycle Management
H=Mobile Hand Held Device
M=Mobile Time and Expense
N=NUI
P=Primavera P6
W=Web
EX_DEL_TIME_VW(SQL View) |
Index Back |
|---|---|
Delete Time Report DailyDelete Time Report Daily |
| SELECT A.EMPLID , A.TIME_SHEET_ID , A.VERSION_NUM , A.VERSION_LBL , A.PERIOD_END_DT , (A.DTL_TOTAL + A.POL_TOTAL) , A.CREATION_DT , A.BUSINESS_UNIT_GL , A.EX_ORIGIN FROM PS_EX_TIME_HDR A WHERE A.TIME_SHEET_STATUS IN ('PND','DEN','DNA','DNU') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | TIME_SHEET_ID |
Character(10) | VARCHAR2(10) NOT NULL | Time Sheet Unique Identifier (System Generated) |
| 3 | VERSION_NUM |
Number(3,0) | SMALLINT NOT NULL | Version Number |
| 4 | VERSION_LBL | Character(1) | VARCHAR2(1) NOT NULL |
Used to show version in search pages
O=Original Version P=Partial Submit R=Revision |
| 5 | PERIOD_END_DT | Date(10) | DATE | Represents the date termination point for a given time set utilized in cash worksheet processing. |
| 6 | GRAND_TOTAL | Signed Number(7,2) | DECIMAL(5,2) NOT NULL | Grand Total |
| 7 | CREATION_DT | Date(10) | DATE | Creation Date |
| 8 | BUSINESS_UNIT_GL | Character(5) | VARCHAR2(5) NOT NULL | GL Business Unit |
| 9 | EX_ORIGIN | Character(1) | VARCHAR2(1) NOT NULL |
Origin of Entry (Expenses)
A=Asset Lifecycle Management H=Mobile Hand Held Device M=Mobile Time and Expense N=NUI P=Primavera P6 W=Web |