BUSINESS_UNITTIME_SHEET_IDN=No
Y=Yes
SPA_TIME_HDR_VW(SQL View) |
Index Back |
|---|---|
Timesheet viewTimesheet view |
| SELECT DISTINCT A.BUSINESS_UNIT , A.TIME_SHEET_ID , A.PERSON_ID , A.SPA_TIMESHEET_NAME , A.PERIOD_START_DT , B.WORK_ORDER_ID , W.MRSC_PARENT_WOID , W.SUB_LINE FROM PS_SPA_TIME_HDR A , PS_SPA_TIME_WO B , PS_SPF_WORDERREC W WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.TIME_SHEET_ID = B.TIME_SHEET_ID AND W.BUSINESS_UNIT = B.BUSINESS_UNIT AND W.WORK_ORDER_ID = B.WORK_ORDER_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | TIME_SHEET_ID |
Character(10) | VARCHAR2(10) NOT NULL | Time Sheet Unique Identifier (System Generated) |
| 3 | PERSON_ID | Character(15) | VARCHAR2(15) NOT NULL | Person ID |
| 4 | SPA_TIMESHEET_NAME | Character(30) | VARCHAR2(30) NOT NULL | Time Sheet Name |
| 5 | PERIOD_START_DT | Date(10) | DATE | Represents the date commencement point for a given time set utilized in cash worksheet processing. |
| 6 | WORK_ORDER_ID | Character(15) | VARCHAR2(15) NOT NULL | Work Order ID |
| 7 | MRSC_PARENT_WOID | Character(15) | VARCHAR2(15) NOT NULL | Multi Resource Parent WOID |
| 8 | SUB_LINE | Character(1) | VARCHAR2(1) NOT NULL |
Sub Line
N=No Y=Yes |