BUSINESS_UNITWO_IDWO_TASK_IDRES_LN_NBRWM_REQ_LBR(SQL Table) |
Index Back |
|---|---|
Labor Requirements Work RecordLabor Requirements Work Record for recommending labor resources |
| # | 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 | RES_LN_NBR |
Number(5,0) | INTEGER NOT NULL | Resource Line No. |
| 5 | RQMT_LN_NBR | Number(5,0) | INTEGER NOT NULL | Requirement Line Number |
| 6 | CRAFT_ID | Character(16) | VARCHAR2(16) NOT NULL | Craft Identification |
| 7 | SCHED_START_DT | Date(10) | DATE | Scheduled Start Date |
| 8 | SCHED_START_TIME | Time(15) | TIMESTAMP | Schedule Start Time |
| 9 | SCHED_END_DT | Date(10) | DATE | Scheduled End Date |
| 10 | SCHED_END_TIME | Time(15) | TIMESTAMP | Schedule End Time |
| 11 | SCHED_DURATION | Signed Number(9,2) | DECIMAL(7,2) NOT NULL | Scheduled Duration |