| # |
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 |
FAILURE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Failure ID
|
| 5 |
SELECT_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Selection Flag
N=No
Y=Yes
Y/N Table Edit
Default Value: Y
|
| 6 |
WO_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Work Order Type
Prompt Table:
WM_WO_TYPE
|
| 7 |
SRVC_GRP_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Service Group
Prompt Table:
WM_SRVC_GRP_BU
|
| 8 |
PRIORITY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Priority Code
Prompt Table:
WM_PRIORITY
|
| 9 |
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
|
| 10 |
STATUS_CD |
Character(4) |
VARCHAR2(4) NOT NULL |
User defined Status Code
Prompt Table:
WM_STATUS_TSK
|
| 11 |
BUSINESS_UNIT_AM |
Character(5) |
VARCHAR2(5) NOT NULL |
AM Business Unit
Prompt Table:
SP_BU_AM_NONVW
|
| 12 |
ASSET_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Asset Identification
Prompt Table:
WM_ASSET_VWA
|
| 13 |
ASSET_LOCATION |
Character(10) |
VARCHAR2(10) NOT NULL |
Asset Location
Prompt Table:
LOCATION_VW
|
| 14 |
AREA_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Area ID
Prompt Table:
WM_AREA_PMT_VW
|
| 15 |
PROBLEM_GROUP |
Character(15) |
VARCHAR2(15) NOT NULL |
Problem Group
Prompt Table:
WM_PCR_GRP_VW
|
| 16 |
PROBLEM_CD |
Character(15) |
VARCHAR2(15) NOT NULL |
Problem code
Prompt Table:
WM_PCR_PRBAC_VW
|
| 17 |
CAUSE_CD |
Character(15) |
VARCHAR2(15) NOT NULL |
Cause Code
Prompt Table:
WM_PCR_CSEAC_VW
|
| 18 |
RESOLUTION_CD |
Character(15) |
VARCHAR2(15) NOT NULL |
Resolution code
Prompt Table:
WM_PCR_RESAC_VW
|
| 19 |
WARRANTY_NAME |
Character(40) |
VARCHAR2(40) NOT NULL |
This field is used to store the name of the warranty.
Prompt Table:
WM_ASSET_WRTYVW
|
| 20 |
VENDOR_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Identifier
Prompt Table:
VNDR_FS
|
| 21 |
CLAIM_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Claim ID
|
| 22 |
BUSINESS_UNIT_PC |
Character(5) |
VARCHAR2(5) NOT NULL |
PC Business Unit
Prompt Table:
SP_BU_PC_NONVW
|
| 23 |
PROJECT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Project Id ChartField
Prompt Table:
WM_PC_PRJ_VW
|
| 24 |
ACTIVITY_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Activity ID
Prompt Table:
PROJ_ACT_FS
|
| 25 |
CREW_BU |
Character(5) |
VARCHAR2(5) NOT NULL |
Crew Business Unit
Prompt Table:
SP_BU_WM_NONVW
|
| 26 |
CREW_SHOP |
Character(10) |
VARCHAR2(10) NOT NULL |
Crew Shop ID
Prompt Table:
WM_CREWSHOP_VW
|
| 27 |
CREW_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Crew Name
Prompt Table:
WM_PREFCREW_VW
|
| 28 |
SUPERVISOR |
Character(30) |
VARCHAR2(30) NOT NULL |
Supervisor
Prompt Table:
WM_SHOP_RES_VW2
|
| 29 |
ASSET_DESCR30 |
Character(30) |
VARCHAR2(30) NOT NULL |
Asset Description
|
| 30 |
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
|
| 31 |
ASSET_SUBTYPE |
Character(15) |
VARCHAR2(15) NOT NULL |
Asset Subtype
Prompt Table:
AM_SUBTYPE
|
| 32 |
MFG_ID |
Character(50) |
VARCHAR2(50) NOT NULL |
Manufacturer ID
Prompt Table:
MANUFACTURER
|
| 33 |
MODEL |
Character(30) |
VARCHAR2(30) NOT NULL |
Model
Prompt Table:
MFG_MODEL
|
| 34 |
IN_SERVICE_DT |
Date(10) |
DATE |
In Service Date
|
| 35 |
FAILURE_DT |
Date(10) |
DATE |
Failure date
|
| 36 |
PREV_FAILURE_DT |
Date(10) |
DATE |
Previous Failure Date
|
| 37 |
FAIL_DAYS_BASIS_DT |
Date(10) |
DATE |
Days to Failure Basis Date
|
| 38 |
FAILURE_DESCR |
Character(254) |
VARCHAR2(254) NOT NULL |
Failure Description
|
| 39 |
SEVERITY_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Severity Code
Prompt Table:
WM_FAIL_SEVRTY
|
| 40 |
FAILURE_START_DT |
Date(10) |
DATE |
Failure Start Date
|
| 41 |
FAILURE_START_TIME |
Time(15) |
TIMESTAMP |
Failure Start Time
|
| 42 |
FAILURE_END_DT |
Date(10) |
DATE |
Failure End Date
|
| 43 |
FAILURE_END_TIME |
Time(15) |
TIMESTAMP |
Failure End Time
|
| 44 |
WM_FAIL_SUMM_CNT |
Number(8,0) |
INTEGER NOT NULL |
Summary Count
|
| 45 |
WM_FAIL_REC_COUNT |
Number(8,0) |
INTEGER NOT NULL |
Failure Count
|
| 46 |
DAYS_BETW_FAILURE |
Number(8,0) |
INTEGER NOT NULL |
Mean Time Betw Failure (Days)
|
| 47 |
UNITS_BETW_FAILURE |
Signed Number(23,6) |
DECIMAL(21,6) NOT NULL |
Mean Meter Units Betw Failure
|
| 48 |
METER_TYPE |
Character(30) |
VARCHAR2(30) NOT NULL |
Meter Type
Prompt Table:
AM_METER_TYPE
|
| 49 |
TOTAL_REPAIR_HRS |
Number(16,3) |
DECIMAL(15,3) NOT NULL |
Mean Time to Repair (Hrs)
|
| 50 |
TOTAL_REPAIR_COST |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Mean Cost to Repair
|
| 51 |
REPAIR_COST_LBR |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Labor Repair Cost
|
| 52 |
REPAIR_COST_MAT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Material Repair Cost
|
| 53 |
REPAIR_COST_PO |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Procurement Repair Cost
|
| 54 |
REPAIR_COST_TLS |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Tools Repair Cost
|
| 55 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table:
CURR_CD_EFF_VW
|
| 56 |
METER_UOM |
Character(3) |
VARCHAR2(3) NOT NULL |
Meter Unit of Measure
Prompt Table:
UNITS_TBL
|
| 57 |
METER_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Meter Option
D=Decreasing
I=Increasing
R=Tolerance Range
|
| 58 |
READING |
Signed Number(15,6) |
DECIMAL(13,6) NOT NULL |
Reading
|
| 59 |
CUM_READING |
Signed Number(21,4) |
DECIMAL(19,4) NOT NULL |
Cumulative Reading
|
| 60 |
READING_DATE |
Date(10) |
DATE |
Reading Date
|