PGM_TIME_DETAIL(SQL View) |
Index Back |
|---|---|
Timesheet DetailThis view returns approved timesheet lines where a change request is required to update to the employee's estimate to complete hours. |
| SELECT B.TIME_SHEET_ID , B.BUSINESS_UNIT_PC , B.PROJECT_ID , B.ACTIVITY_ID , SUM(C.TIME_QUANTITY) , B.RESOURCE_ETC , ' ' , D.EMPLID , D.OPRID , D.SEQ_NUM FROM PS_EX_TIME_DTL B , PS_EX_TIME_DTL_DLY C , PS_EX_APRVL_HIST D WHERE B.TIME_SHEET_ID = C.TIME_SHEET_ID AND B.TIME_SHEET_ID = D.EX_DOC_ID AND B.VERSION_NUM = C.VERSION_NUM AND B.VERSION_NUM = D.VERSION_NUM AND B.LINE_NBR = C.LINE_NBR AND D.EX_DOC_TYPE = 'C' AND B.CHANGE_REQ_FLAG = 'Y' AND B.VERSION_NUM = 1 GROUP BY B.TIME_SHEET_ID, B.VERSION_NUM, B.BUSINESS_UNIT_PC, B.PROJECT_ID, B.ACTIVITY_ID, B.RESOURCE_ETC, D.EMPLID, D.OPRID, D.SEQ_NUM |
| # | 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 | BUSINESS_UNIT_PC | Character(5) | VARCHAR2(5) NOT NULL | PC Business Unit |
| 3 | PROJECT_ID | Character(15) | VARCHAR2(15) NOT NULL | Project Id ChartField |
| 4 | ACTIVITY_ID | Character(15) | VARCHAR2(15) NOT NULL | Activity ID |
| 5 | TIME_QUANTITY | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | Time Quantity |
| 6 | NEW_ETC | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | The new number of hours estimated to complete a task (activity). |
| 7 | COMMENTS_DETAIL | Character(254) | VARCHAR2(254) NOT NULL | Comments |
| 8 | APPROVER_ID | Character(11) | VARCHAR2(11) NOT NULL | Approver ID |
| 9 | APPROVER_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Approver Oprid |
| 10 | SEQ_NUM | Number(3,0) | SMALLINT NOT NULL | Sequence |