SPA_SUP_RH_VW(SQL View) |
Index Back |
|---|
| SELECT O.ROLEUSER ,T.BUSINESS_UNIT ,T.TIME_SHEET_ID ,P.NAME , T.PERSON_ID ,T.SPA_TIMESHEET_NAME , W.WORK_ORDER_ID , W.WO_NAME ,T.PERIOD_START_DT ,T.PERIOD_END_DT , ' ' , T.TIME_HDR_STATUS ,TW.SP_TIME_QTY , TW.TIME_AMOUNT ,TW.CURRENCY_CD FROM PS_SPF_WORDERREC W , PS_SPA_TIME_HDR T , PS_SPA_TIME_WO TW , PS_SPB_PERSON_TBL P , PS_ROLEXLATOPR O , PSOPRALIAS A WHERE W.BUSINESS_UNIT = T.BUSINESS_UNIT AND T.BUSINESS_UNIT = TW.BUSINESS_UNIT AND W.WORK_ORDER_ID = TW.WORK_ORDER_ID AND T.TIME_SHEET_ID = TW.TIME_SHEET_ID AND T.PERSON_ID = P.PERSON_ID AND A.PERSON_ID IN (W.PROVIDER_CONTACT) AND A.OPRID = O.ROLEUSER |
| # | 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 | PERSON_ID | Character(15) | VARCHAR2(15) NOT NULL | Person ID |
| 6 | SPA_TIMESHEET_NAME | Character(30) | VARCHAR2(30) NOT NULL | Time Sheet Name |
| 7 | WORK_ORDER_ID | Character(15) | VARCHAR2(15) NOT NULL |
Work Order ID
Prompt Table: SPA_TIME_WO2_VW |
| 8 | WO_NAME | Character(30) | VARCHAR2(30) NOT NULL | Work Order Name |
| 9 | PERIOD_START_DT | Date(10) | DATE | Represents the date commencement point for a given time set utilized in cash worksheet processing. |
| 10 | PERIOD_END_DT | Date(10) | DATE | Represents the date termination point for a given time set utilized in cash worksheet processing. |
| 11 | SPA_DATE_RANGE | Character(23) | VARCHAR2(23) NOT NULL | Date Range |
| 12 | TIME_HDR_STATUS | Character(3) | VARCHAR2(3) NOT NULL |
Time Line Status
ADJ=Adjusted APR=Approved DEN=Denied LAJ=Line Adjusted LDN=Line Denied LPD=Line Pending OPN=Open PND=Pending SUB=Submitted Default Value: OPN |
| 13 | SP_TIME_QTY | Signed Number(18,4) | DECIMAL(16,4) NOT NULL | Time Quantity |
| 14 | TIME_AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Time Amount |
| 15 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |