WM_AUTOASSIG

(SQL Table)
 Index Back

Auto Assignment Setup

Auto Assignment Setup

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: SP_BU_WM_NONVW

2 ASSET_TYPE Character(3) VARCHAR2(3) NOT NULL Asset Type
010=IT Hardware
020=IT Software
040=Equipment
050=Property
060=Fleet
070=Machinery
080=Furniture
090=Facility
100=Intangible
200=Asset Retirement Obligations
999=Other
3 ASSET_SUBTYPE Character(15) VARCHAR2(15) NOT NULL Asset Subtype

Prompt Table: AM_SUBTYPE

4 BUSINESS_UNIT_AM Character(5) VARCHAR2(5) NOT NULL AM Business Unit

Prompt Table: SP_BUS_AM_NONVW

5 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification

Prompt Table: WM_ASSET_VW

6 ASSET_LOCATION Character(10) VARCHAR2(10) NOT NULL Asset Location

Prompt Table: LOCATION_TBL

7 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

Prompt Table: LOCATION_TBL

8 AREA_ID Character(10) VARCHAR2(10) NOT NULL Area ID

Prompt Table: AM_AREA_TBL

9 PROBLEM_GROUP Character(15) VARCHAR2(15) NOT NULL Problem Group

Prompt Table: WM_PCR_CLSF_VW

10 PROBLEM_CD Character(15) VARCHAR2(15) NOT NULL Problem code

Prompt Table: WM_PCR_PRBAC_VW

11 PRIORITY_CD Character(3) VARCHAR2(3) NOT NULL Priority Code

Prompt Table: WM_PRIORITY

12 SHOP_ID Character(10) VARCHAR2(10) NOT NULL Shop Identification

Prompt Table: WM_SHOP_BU4_VW

13 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

Prompt Table: WM_DEPT_VW

14 WO_SOURCE_CD Character(4) VARCHAR2(4) NOT NULL Work order source code
1=Third Party
2=CRM Help Desk
3=Work Order
4=Service Request
5=Preventive Maintenance
6=Project Costing
7=Express Work Order
8=Condition-based Maintenance
9=WO Inspection
15 WO_TYPE Character(5) VARCHAR2(5) NOT NULL Work Order Type

Prompt Table: WM_WO_TYPE
Set Control Field: BUSINESS_UNIT

16 SRVC_GRP_ID Character(10) VARCHAR2(10) NOT NULL Service Group

Prompt Table: WM_SRVC_GRP
Set Control Field: BUSINESS_UNIT

17 WO_TEMPLATE_ID Character(25) VARCHAR2(25) NOT NULL Work Order Task/Job Template ID

Prompt Table: WM_WO_JTMPL_VW
Set Control Field: BUSINESS_UNIT

18 WO_TASK_TMPLT_ID Character(25) VARCHAR2(25) NOT NULL WO Task Template ID (specific field)

Prompt Table: WM_WO_TTMPL_VW
Set Control Field: BUSINESS_UNIT

19 SHOP_ID2 Character(10) VARCHAR2(10) NOT NULL Shop Identification

Prompt Table: WM_SHOP_BU_VW

20 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: WM_ELGBL_WRKR

21 WM_EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: WM_ELGBL_WRKR

22 WM_EMPLID2 Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: WM_ELGBL_WRKR

23 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
24 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

Prompt Table: WM_WO_VNDR_VW

25 WM_VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

Prompt Table: WM_WO_VNDR_VW

26 WM_VENDOR_ID2 Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

Prompt Table: WM_WO_VNDR_VW

27 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location

Prompt Table: VNDR_LOC_VW1

28 WM_VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location

Prompt Table: WM_VNDR_LOC_VW1

29 WM_VNDR_LOC2 Character(10) VARCHAR2(10) NOT NULL Vendor Location

Prompt Table: WM_VNDR2LOC_VW1

30 SHIPTO_ID Character(10) VARCHAR2(10) NOT NULL Ship To Location

Prompt Table: SHIPTO_TBL

31 CATEGORY_CD Character(18) VARCHAR2(18) NOT NULL Category Code

Prompt Table: WM_ITM_CAT_VW
Set Control Field: VENDOR_SETID

32 MAINT_TYPE Character(10) VARCHAR2(10) NOT NULL This field is used for maintenance type

Prompt Table: MAINT_TYPE_TBL

33 WM_SHOP_SCHDLER Character(1) VARCHAR2(1) NOT NULL Shop Primary Scheduler

Y/N Table Edit

34 WM_CREW_LEADER Character(1) VARCHAR2(1) NOT NULL Crew Leader

Y/N Table Edit

35 WEIGHT Number(15,0) DECIMAL(15) NOT NULL Field used to store Weight Points.