BUS_UNIT_OPT_WM

(SQL Table)
Index Back

WorkMgmt Business Unit Options

Work Management Business unit options to support integration with Resource Management.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 SO_WORKLIST_FLG Character(1) VARCHAR2(1) NOT NULL Send Service Order to Worklist

Y/N Table Edit

Default Value: N

3 SO_WF_INTPARTY Character(1) VARCHAR2(1) NOT NULL E-mail Interested Parties

Y/N Table Edit

Default Value: N

4 ASSGN_APPR_EXT_FLG Character(1) VARCHAR2(1) NOT NULL Assignment Approval Required

Y/N Table Edit

Default Value: N

5 ASSGN_APPR_INT_FLG Character(1) VARCHAR2(1) NOT NULL Assignment Approval Required

Y/N Table Edit

Default Value: N

6 ASSGN_APPR_DTCHG Character(1) VARCHAR2(1) NOT NULL Date Change Approval Required

Y/N Table Edit

7 ASSGN_NOTFYMGR_FLG Character(1) VARCHAR2(1) NOT NULL Assignment Status Notification

Y/N Table Edit

Default Value: N

8 ASSGN_NOTFYRES_FLG Character(1) VARCHAR2(1) NOT NULL Assignment Status Notification

Y/N Table Edit

Default Value: N

9 ASSGN_NOTFYPRJ_FLG Character(1) VARCHAR2(1) NOT NULL Assignment Status Notification

Y/N Table Edit

Default Value: N

10 ASSGN_DTNTF_MGR Character(1) VARCHAR2(1) NOT NULL Date Change Notification

Y/N Table Edit

Default Value: N

11 ASSGN_DTNTF_PRJ Character(1) VARCHAR2(1) NOT NULL Date Change Notification

Y/N Table Edit

Default Value: N

12 ASSGN_DTNTF_RES Character(1) VARCHAR2(1) NOT NULL Date Change Notification

Y/N Table Edit

Default Value: N

13 ASSGN_RESRV_FLEX Number(4,2) DECIMAL(3,2) NOT NULL Reservation Flexibility

Default Value: 1