WM_TSK_CHK_LST

(SQL Table)
Index Back

Work Order Task Check list

Work Order Task Check list

# 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
12 LAST_UPDATED_BY Character(30) VARCHAR2(30) NOT NULL LastUpdatedUser
13 LAST_UPDATE_DTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

Default Value: %Datetime