WM_RSCHD_HST_VW(SQL View) |
Index Back |
|---|---|
Crew Rescheduling History |
| SELECT B.BUSINESS_UNIT , B.WO_ID , B.WO_TASK_ID , B.RQMT_LN_NBR , B.SEQ_NBR_5 , %subrec(WM_CREW_SBR, B) , B.SCHED_PATTERN , B.PERIOD_START_DT , B.SCHED_START_DT , B.SCHED_START_TIME , B.SCHED_END_DT , B.SCHED_END_TIME , B.CREW_SCHED_STATUS , B.WO_SCHED_HRS , B.REMAINING_MAN_HRS , B.COMPLETE_HRS , B.REASON_CD , B.DESCRLONG , B.LAST_UPDATE_DT , B.LAST_UPDATED_BY FROM PS_WM_CREW_SCHD_VW A , PS_WM_RESCHED_HST B WHERE %Join(COMMON_KEYS,WM_CREW_SCHD_VW A, WM_RESCHED_HST B ) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | WO_ID |
Character(10) | VARCHAR2(10) NOT NULL | Work Order Identification |
| 3 | WO_TASK_ID |
Number(5,0) | INTEGER NOT NULL | Task Number |
| 4 | RQMT_LN_NBR |
Number(5,0) | INTEGER NOT NULL | Requirement Line Number |
| 5 | SEQ_NBR_5 |
Number(5,0) | INTEGER NOT NULL | Sequence number five digits long |
| 6 | CREW_BU | Character(5) | VARCHAR2(5) NOT NULL |
Crew Business Unit
Prompt Table: SP_BU_WM_NONVW |
| 7 | CREW_SHOP | Character(10) | VARCHAR2(10) NOT NULL |
Crew Shop ID
Prompt Table: WM_CREWSHOP_VW |
| 8 | CREW_ID | Character(10) | VARCHAR2(10) NOT NULL |
Crew Name
Prompt Table: WM_PREFCREW_VW |
| 9 | SCHED_PATTERN | Character(5) | VARCHAR2(5) NOT NULL | Schedule Pattern |
| 10 | PERIOD_START_DT | Date(10) | DATE | Represents the date commencement point for a given time set utilized in cash worksheet processing. |
| 11 | SCHED_START_DT | Date(10) | DATE | Scheduled Start Date |
| 12 | SCHED_START_TIME | Time(15) | TIMESTAMP | Schedule Start Time |
| 13 | SCHED_END_DT | Date(10) | DATE | Scheduled End Date |
| 14 | SCHED_END_TIME | Time(15) | TIMESTAMP | Schedule End Time |
| 15 | CREW_SCHED_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Crew Schedule Status
1=Unscheduled 2=Scheduled 3=Unplanned / Emergency 4=Schedule Confirmed |
| 16 | WO_SCHED_HRS | Number(15,2) | DECIMAL(14,2) NOT NULL | Scheduled Hours |
| 17 | REMAINING_MAN_HRS | Number(15,2) | DECIMAL(14,2) NOT NULL | Carryover Hours |
| 18 | COMPLETE_HRS | Number(15,2) | DECIMAL(14,2) NOT NULL | Completed hours |
| 19 | REASON_CD | Character(10) | VARCHAR2(10) NOT NULL |
Reason Code
Prompt Table: WM_CSREASON_TBL |
| 20 | DESCRLONG | Long Character | CLOB | Long Description |
| 21 | LAST_UPDATE_DT | Date(10) | DATE | Last Updated |
| 22 | LAST_UPDATED_BY | Character(30) | VARCHAR2(30) NOT NULL |
LastUpdatedUser
Prompt Table: PSOPRDEFN_VW |