TIME_SHEET_IDVERSION_NUMLINE_NBREX_TJ_DTL_HVW(SQL View) |
Index Back |
|---|---|
Time Adjustment Detail ViewUsed for Fluid Approvals |
| SELECT A.TIME_SHEET_ID ,A.VERSION_NUM ,A.LINE_NBR ,A.DATE_UNDER_RPT , B.BUSINESS_UNIT_GL ,E.BUSINESS_UNIT_PC , B.PROJECT_ID , E.ACTIVITY_ID , ' ' ,A.TIME_QUANTITY FROM PS_EX_TIME_DTL_DLY A , PS_EX_TJ_LN_AW_VW B , PS_EX_TIME_DTL E WHERE A.TIME_SHEET_ID = B.TIME_SHEET_ID AND A.VERSION_NUM = B.VERSION_NUM AND A.LINE_NBR = B.LINE_NBR AND A.TIME_SHEET_ID = E.TIME_SHEET_ID AND A.VERSION_NUM = E.VERSION_NUM AND A.LINE_NBR = E.LINE_NBR UNION ALL SELECT C.TIME_SHEET_ID ,C.VERSION_NUM ,C.LINE_NBR ,C.DATE_UNDER_RPT , ' ' , ' ' ,' ' ,' ' ,D.DESCR60 ,C.TIME_QUANTITY FROM PS_EX_TIME_POL_DLY C , PS_EX_TIME_POL D WHERE C.TIME_SHEET_ID = D.TIME_SHEET_ID AND C.VERSION_NUM = D.VERSION_NUM AND C.LINE_NBR = D.LINE_NBR |
| # | 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 | LINE_NBR |
Number(5,0) | INTEGER NOT NULL | Line Number: 11/24/08 - Added TARGET label [PC product] |
| 4 | DATE_UNDER_RPT | Date(10) | DATE | Date Under Report |
| 5 | BUSINESS_UNIT_GL | Character(5) | VARCHAR2(5) NOT NULL | GL Business Unit |
| 6 | BUSINESS_UNIT_PC | Character(5) | VARCHAR2(5) NOT NULL | PC Business Unit |
| 7 | DESCR100 | Character(100) | VARCHAR2(100) NOT NULL | Length 100 Description |
| 8 | DESCR100A | Character(100) | VARCHAR2(100) NOT NULL | Description |
| 9 | TYPE_RTB | Character(20) | VARCHAR2(20) NOT NULL | Type |
| 10 | TIME_QUANTITY | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | Time Quantity |