| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Default Value: OPR_DEF_TBL_FS.OPRID
|
| 2 |
WM_FLEXSRCH_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Search Criteria
|
| 3 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_WM.BUSINESS_UNIT
Prompt Table:
SP_BU_WM_NONVW
|
| 4 |
PM_SCHD_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Preventive Maintenance Schedule ID
Prompt Table:
WM_PM_SCHDT2_VW
Set Control Field: BUSINESS_UNIT
|
| 5 |
BUSINESS_UNIT_AM |
Character(5) |
VARCHAR2(5) NOT NULL |
AM Business Unit
Prompt Table:
SP_BU_AM_NONVW
|
| 6 |
ASSET_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Asset Identification
Prompt Table:
WM_ASSET_VW
|
| 7 |
ASSET_LOCATION |
Character(10) |
VARCHAR2(10) NOT NULL |
Asset Location
Prompt Table:
LOCATION_VW
Set Control Field: BUSINESS_UNIT_AM
|
| 8 |
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
|
| 9 |
TAG_NUMBER |
Character(12) |
VARCHAR2(12) NOT NULL |
Tag Number
Prompt Table:
WM_TAG_DVW
|
| 10 |
ASSET_SUBTYPE |
Character(15) |
VARCHAR2(15) NOT NULL |
Subtype
Prompt Table:
AM_SUBTYPE
Set Control Field: BUSINESS_UNIT_AM
|
| 11 |
MAINT_LOOP_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Loop ID
Prompt Table:
WM_PM_LOOP_VW
Set Control Field: BUSINESS_UNIT
|
| 12 |
MFG_ID |
Character(50) |
VARCHAR2(50) NOT NULL |
Manufacturer ID
Prompt Table:
WM_MANUFACTURER
Set Control Field: BUSINESS_UNIT_AM
|
| 13 |
MODEL |
Character(30) |
VARCHAR2(30) NOT NULL |
Model
Prompt Table:
MFG_MODEL
Set Control Field: BUSINESS_UNIT_AM
|
| 14 |
SERIAL_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
Serial ID
Prompt Table:
WM_SERIAL_DVW
|
| 15 |
PM_TM_SCHD_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Schedule Type
1=None
2=Specific Date
3=Daily
4=Weekly by Day
5=Monthly by Day
6=Monthly by Date
7=On Demand
|
| 16 |
STATUS_CD |
Character(4) |
VARCHAR2(4) NOT NULL |
User defined Status Code
Prompt Table:
WM_STATUS_TSK_O
Set Control Field: BUSINESS_UNIT
|
| 17 |
WM_PM_APPR_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
work order approval status
A=Approved
C=Cancelled
E=Denied
I=Initial
P=Pending Approval
|
| 18 |
AREA_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Area ID
Prompt Table:
WM_AREA_PMT_VW
Set Control Field: BUSINESS_UNIT_AM
|
| 19 |
ASSET_CRITICALITY |
Character(2) |
VARCHAR2(2) NOT NULL |
Asset Criticality
Prompt Table:
AM_CRIT_LVL
|
| 20 |
LOCATION |
Character(10) |
VARCHAR2(10) NOT NULL |
Location Code
Prompt Table:
LOCATION_VW
Set Control Field: BUSINESS_UNIT
|
| 21 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 22 |
DESCR100 |
Character(100) |
VARCHAR2(100) NOT NULL |
Length 100 Description
|
| 23 |
MAINT_TYPE |
Character(10) |
VARCHAR2(10) NOT NULL |
This field is used for maintenance type
Prompt Table:
WM_MAINT_DVW
Set Control Field: BUSINESS_UNIT
|
| 24 |
WO_TEMPLATE_ID |
Character(25) |
VARCHAR2(25) NOT NULL |
Work Order Task/Job Template ID
Prompt Table:
%EDITTABLE
Set Control Field: BUSINESS_UNIT
|
| 25 |
PM_SCHD_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Scheduling Option
1=One Cycle
2=Multiple Cycles Multiple WO
3=Multiple Cycles One WO
4=Non-recurring
|
| 26 |
SRVC_GRP_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Service Group
Prompt Table:
WM_SRVC_GRP_BU
|
| 27 |
WO_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Work Order Type
Prompt Table:
WM_WO_TYPE
|
| 28 |
BUSINESS_UNIT_PC |
Character(5) |
VARCHAR2(5) NOT NULL |
PC Business Unit
|
| 29 |
PROJECT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Project Id ChartField
Prompt Table:
WM_PC_PRJ_DVW2
|
| 30 |
ACTIVITY_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Activity ID
Prompt Table:
PROJ_ACT_FS
|
| 31 |
SHOP_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Shop Identification
Prompt Table:
WM_SHOP_BU_VW
|
| 32 |
PRIORITY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Priority Code
Prompt Table:
WM_PRIORITY
|
| 33 |
INTERNAL_STATUS |
Character(2) |
VARCHAR2(2) NOT NULL |
Internal Status
01=Open
02=Awaiting Schedule
03=Scheduled
04=Work In Progress
05=Complete
06=Closed
07=Canceled
08=On Hold
09=Work Order Created
|
| 34 |
STATUS_CD_HDR |
Character(4) |
VARCHAR2(4) NOT NULL |
Header Status
Prompt Table:
WM_STATUS_HDR
|
| 35 |
CBM_ALERT |
Character(1) |
VARCHAR2(1) NOT NULL |
Force WO. Disregard options.
1=On
2=Off
|
| 36 |
CBM_SOURCE |
Character(1) |
VARCHAR2(1) NOT NULL |
CBM Alert source
1=AM Reading Tolerance
2=MM Alert
3=Alert set manually
|
| 37 |
WM_PM_APPRVL_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Work Management Approval
1=Pre-Approved
3=Workflow Approval
|
| 38 |
HOLIDAY_LIST_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
This is used to identify what holiday calendar to use. This is the access
field for all financials groups.
Prompt Table:
BUS_CAL_HOL_DFN
|
| 39 |
ASSET_DESCR30 |
Character(30) |
VARCHAR2(30) NOT NULL |
Asset Description
|