BUSINESS_UNITWO_IDWO_TASK_IDSEQ_NBR_5Y/N Table Edit
Default Value: N
1=Before task
2=After task
N=Not Completed
Y=Complete
Y/N Table Edit
Default Value: N
Prompt Table: WM_OPR_NAME_VW
WM_EIP_CHK_VW(SQL View) |
Index Back |
|---|---|
Work Order Task Check listWork Order Task Check list |
| SELECT BUSINESS_UNIT , WO_ID , WO_TASK_ID , SEQ_NBR_5 , STEP , REQUIRED_FLG , CHECKLIST_TYPE , DESCR254 , COMPLETED_FLG , COMPLETED_BY_OPRID , COMPLETED_DTTM FROM PS_WM_TSK_CHK_LST |
| # | 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 | SEQ_NBR_5 |
Number(5,0) | INTEGER NOT NULL | Sequence number five digits long |
| 5 | STEP | Number(2,0) | SMALLINT NOT NULL | Step |
| 6 | REQUIRED_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Required Flag
Y/N Table Edit Default Value: N |
| 7 | CHECKLIST_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Checklist type
1=Before task 2=After task |
| 8 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |
| 9 | COMPLETED_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Completed
N=Not Completed Y=Complete Y/N Table Edit Default Value: N |
| 10 | COMPLETED_BY_OPRID | Character(30) | VARCHAR2(30) NOT NULL |
Completed By
Prompt Table: WM_OPR_NAME_VW |
| 11 | COMPLETED_DTTM | DateTime(26) | TIMESTAMP | Completed Datetime |