USERIDBUSINESS_UNITDefault Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
TIME_SHEET_IDSPA_E_TIMAPR_VW(SQL View) |
Index Back |
|---|
| SELECT O.ROLEUSER ,W.BUSINESS_UNIT ,T.TIME_SHEET_ID ,P.NAME ,T.PERIOD_END_DT ,SUM(L.SP_TIME_QTY) ,D.CURRENCY_CD FROM PS_SPF_WORDERREC W , PS_SPA_TIME_HDR T , PS_SPA_TIME_DTL D , PS_SPA_TIM_DTL_DLY L , PS_SPB_PERSON_TBL P , PS_ROLEXLATOPR O WHERE W.BUSINESS_UNIT = T.BUSINESS_UNIT AND D.BUSINESS_UNIT = T.BUSINESS_UNIT AND W.WORK_ORDER_ID = D.WORK_ORDER_ID AND T.TIME_SHEET_ID = D.TIME_SHEET_ID AND D.TIME_SHEET_ID = L.TIME_SHEET_ID AND D.LINE_NBR = L.LINE_NBR AND T.PERSON_ID = P.PERSON_ID AND D.TIME_LINE_STATUS = 'SUB' AND (O.ROLEUSER IN ( SELECT C.OPRID FROM PS_SPA_TS_APR_XREF A , PS_EOAW_STEPINST B , PS_EOAW_USERINST C WHERE A.EOAWDEFN_ID = B.EOAWDEFN_ID AND A.EOAWPRCS_ID = B.EOAWPRCS_ID AND A.EOAWTHREAD_ID = B.EOAWTHREAD_ID AND B.EOAWSTEP_INSTANCE = C.EOAWSTEP_INSTANCE AND A.BUSINESS_UNIT = T.BUSINESS_UNIT AND A.TIME_SHEET_ID = T.TIME_SHEET_ID AND B.EOAWSTEP_STATUS <> 'A')) GROUP BY O.ROLEUSER ,W.BUSINESS_UNIT ,T.TIME_SHEET_ID ,P.NAME ,T.PERIOD_END_DT ,D.CURRENCY_CD |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | USERID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID |
| 2 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT |
| 3 | TIME_SHEET_ID |
Character(10) | VARCHAR2(10) NOT NULL | Time Sheet Unique Identifier (System Generated) |
| 4 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
| 5 | PERIOD_END_DT | Date(10) | DATE NOT NULL | Represents the date termination point for a given time set utilized in cash worksheet processing. |
| 6 | SP_TIME_QTY | Signed Number(18,4) | DECIMAL(16,4) NOT NULL | Time Quantity |
| 7 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |