EX_TJ_HDR_AW_VW(SQL View) |
Index Back |
|---|---|
Time Report Header Adjust ViewUsed by the Approval process |
| SELECT H.TIME_SHEET_ID , H.VERSION_NUM , H.EMPLID , H.PERIOD_END_DT , H.TIME_SHEET_STATUS , H.PROJ_MGR_FLAG , H.CREATION_DT , H.APPROVAL_DT , H.APPROVAL_OPRID , H.SUBMISSION_DATE , H.RESUBMISSION_DT , H.LASTUPDDTTM , H.OPRID_LAST_UPDT , H.SETID , H.BUSINESS_UNIT_GL , H.DEPTID , H.OPRID_ENTERED_BY , H.DTL_TOTAL FROM PS_EX_TIME_HDR H WHERE H.VERSION_NUM = ( SELECT MAX(H2.VERSION_NUM) FROM PS_EX_TIME_HDR H2 WHERE H.TIME_SHEET_ID = H2.TIME_SHEET_ID) |
| # | 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 |
| 3 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 4 | PERIOD_END_DT | Date(10) | DATE | Represents the date termination point for a given time set utilized in cash worksheet processing. |
| 5 | TIME_SHEET_STATUS | Character(3) | VARCHAR2(3) NOT NULL |
Time Sheet Status
ADJ=Adjusted APR=Approved DEN=Denied DNA=Denied by Approver DNU=Denied by Project Manager HDA=Hold by Approver HDU=Hold by Project Manager HLD=Hold MFS=Marked for Submit PAR=Approvals in Process PND=Pending PRO=In Process SFA=Submission in Process SUB=Submitted for Approval XML=Submitted, Pending Validation |
| 6 | PROJ_MGR_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Project Manager Review |
| 7 | CREATION_DT | Date(10) | DATE | Creation Date |
| 8 | APPROVAL_DT | Date(10) | DATE | Date of Approval |
| 9 | APPROVAL_OPRID | Character(30) | VARCHAR2(30) NOT NULL | A system generated value that reflects the operator that approved a given transaction. |
| 10 | SUBMISSION_DATE | Date(10) | DATE | Submission Date |
| 11 | RESUBMISSION_DT | Date(10) | DATE | Resubmission Date |
| 12 | LASTUPDDTTM | DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |
| 13 | OPRID_LAST_UPDT | Character(30) | VARCHAR2(30) NOT NULL | Last User to Update |
| 14 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 15 | BUSINESS_UNIT_GL | Character(5) | VARCHAR2(5) NOT NULL | GL Business Unit |
| 16 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL | Department |
| 17 | OPRID_ENTERED_BY | Character(30) | VARCHAR2(30) NOT NULL | Entered By 07/25/2011 MRAD 12383033 :Ensured that OPRID_ENTERED_BY is set with format type of MixedCase. 03/22/2013 GL 16482301: Switched OPRID_ENTERED_BY back to MixedCase again. Please don't change it to UpperCase!!! FYI - The alternatives to use a User ID as uppercase: 1) Create your own User ID, add comments in the Field Properties, and fill out the Owner ID 2) Use %Upper meta-SQL in SQL statements 3) Use Upper function in peoplecodes |
| 18 | DTL_TOTAL | Signed Number(7,2) | DECIMAL(5,2) NOT NULL | Total |