EX_DCAA_ACKN_VW(SQL View) |
Index Back |
|---|---|
DCAA AcknowledgmentThis record returns time reports awaiting acknowledgement. |
| SELECT A.TIME_SHEET_ID , A.VERSION_NUM , A.EMPLID , A.PERIOD_END_DT , A.SUBMISSION_DATE , A.RESUBMISSION_DT , A.OPRID_SUBMITTED_BY , A.BUSINESS_UNIT_GL FROM PS_EX_TIME_HDR A WHERE EXISTS ( SELECT 'X' FROM PS_INSTALLATION_EX B WHERE B.DCAA_APPL_FLG = 'Y') AND EXISTS ( SELECT 'X' FROM PS_EX_EE_ORG_DTL C WHERE A.EMPLID = C.EMPLID AND C.OVERRIDE_DCAA_FLG = 'N') AND A.OPRID_SUBMITTED_BY <> ' ' AND ACKNOWLEDGE_DTTM IS NULL AND A.OPRID_SUBMITTED_BY NOT IN ( SELECT X.OPRID FROM PSOPRDEFN X WHERE X.EMPLID = A.EMPLID) |
| # | 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 | SUBMISSION_DATE | Date(10) | DATE | Submission Date |
| 6 | RESUBMISSION_DT | Date(10) | DATE | Resubmission Date |
| 7 | OPRID_SUBMITTED_BY | Character(30) | VARCHAR2(30) NOT NULL | Operator Id of user submitting the transaction |
| 8 | BUSINESS_UNIT_GL | Character(5) | VARCHAR2(5) NOT NULL | GL Business Unit |