WM_WO_TYPE_SD(SQL View) |
Index Back |
|---|---|
Work Order Type Definitionsame as WM_WO_TYPE_SD except SETID is not required |
| SELECT A.SETID , A.WO_TYPE , A.DESCR , A.DESCRSHORT , A.CLOSE_DAYS_TSK , A.WO_APPRVL_FLG , A.WO_APPRVL_DEF , A.GEN_CHARGEBACK_DEF , A.GEN_CHARGEBACK , A.CLOSE_DAYS_TSK_DEF FROM PS_WM_WO_TYPE A |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW |
| 2 | WO_TYPE |
Character(5) | VARCHAR2(5) NOT NULL | Work Order Type |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 5 | CLOSE_DAYS_TSK | Signed Number(6,0) | DECIMAL(5) NOT NULL |
Number of close days for WO Task
Default Value: 0 |
| 6 | WO_APPRVL_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Work Management Approval
1=Pre-Approved 3=Workflow Approval |
| 7 | WO_APPRVL_DEF | Character(1) | VARCHAR2(1) NOT NULL |
Approval Default
D=Default S=Specify Default Value: D |
| 8 | GEN_CHARGEBACK_DEF | Character(1) | VARCHAR2(1) NOT NULL |
Bank Flag
D=Default S=Specify Default Value: D |
| 9 | GEN_CHARGEBACK | Character(1) | VARCHAR2(1) NOT NULL |
Generate Chargeback field, used in Maintenance Management
Y/N Table Edit Default Value: N |
| 10 | CLOSE_DAYS_TSK_DEF | Character(1) | VARCHAR2(1) NOT NULL |
Task Close Days Default
D=Default From Higher Level S=Specify Default Value: D |