WM_PM_PJC

(SQL Table)
 Index Back

Projection Record

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
3 PM_SCHD_ID Character(10) VARCHAR2(10) NOT NULL Preventive Maintenance Schedule ID
4 BUSINESS_UNIT_AM Character(5) VARCHAR2(5) NOT NULL AM Business Unit
5 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification
6 NEXT_DUE_DT Date(10) DATE Preventive Maintenance due date
7 NEXT_RDG Signed Number(21,4) DECIMAL(19,4) NOT NULL Next preventive maintenance due reading
8 MAINT_TYPE Character(10) VARCHAR2(10) NOT NULL This field is used for maintenance type
9 PERCENT_DUE Signed Number(16,0) DECIMAL(15) NOT NULL Preventive Maintenance percent due
10 SETID Character(5) VARCHAR2(5) NOT NULL SetID
11 MAINT_LOOP_ID Character(15) VARCHAR2(15) NOT NULL Maintenance Loop ID
12 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
13 PJC_ID Character(10) VARCHAR2(10) NOT NULL Projection ID
14 CREATE_WO_FLG Character(1) VARCHAR2(1) NOT NULL Create Work Order

Y/N Table Edit

15 COMPLTED_DT Date(10) DATE Completed Date
16 DATE_OF_MONTH Character(2) VARCHAR2(2) NOT NULL Date of the Month
17 THRESHOLD_PCT Number(3,0) SMALLINT NOT NULL Confidence %
18 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
19 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
20 INTERVAL_VAL Number(9,0) DECIMAL(9) NOT NULL Interval
21 INTERVAL_START_FRM Character(1) VARCHAR2(1) NOT NULL From the last PM completion
N=No
Y=Yes

Default Value: N

22 DAY_OFWEEK Character(1) VARCHAR2(1) NOT NULL Day
0=0: Sunday
1=1: Monday
2=2: Tuesday
3=3 :Wednesday
4=4: Thursday
5=5: Friday
6=6: Saturday
23 WEEK_OF_MONTH Character(1) VARCHAR2(1) NOT NULL Week of the month
1=1st
2=2nd
3=3rd
4=4th
5=Last
24 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.
25 LAST_WO_ID Character(10) VARCHAR2(10) NOT NULL Last Preventive Maintenance Work Order ID
26 LAST_WO_RDG Signed Number(21,4) DECIMAL(19,4) NOT NULL Last reading
27 LAST_PJC_DT Date(10) DATE Preventive Maintenance due date
28 METER_TYPE Character(30) VARCHAR2(30) NOT NULL Meter Type
29 PM_CALC_TYPE Character(3) VARCHAR2(3) NOT NULL Preventive Maintenance Calculation type
100=Sampling days
101=Sampling Readings
102=Cycle
103=Average from Asset
2=Specific Date
200=Meter Reading
3=Day Interval
300=CBM Alert
4=Week interval
5=Month Interval by day
6=Month interval by date
30 REQ_START_DT Date(10) DATE Required Start
31 PM_PROC_OPT Character(1) VARCHAR2(1) NOT NULL Process Options
1=Preventive
2=Projection
32 BUS_UNIT_AM Character(5) VARCHAR2(5) NOT NULL Business Unit
33 ASSET_ID2 Character(12) VARCHAR2(12) NOT NULL Asset Identification
34 SHOP_ID Character(10) VARCHAR2(10) NOT NULL Shop Identification
35 CREW_ID Character(10) VARCHAR2(10) NOT NULL Crew Name
36 LAST_SCHD_DT Date(10) DATE Last Preventive maintenance schedule date
37 TAG_NUMBER Character(12) VARCHAR2(12) NOT NULL Tag Number
38 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL Serial ID
39 DESCR Character(30) VARCHAR2(30) NOT NULL Description
40 DESCR_LONG Character(254) VARCHAR2(254) NOT NULL Long Description
41 VIN Character(18) VARCHAR2(18) NOT NULL VIN
42 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
43 ASSET_SUBTYPE Character(15) VARCHAR2(15) NOT NULL Asset Subtype
44 MFG_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer ID
45 MODEL Character(30) VARCHAR2(30) NOT NULL Model
46 MANUFACTURER Character(60) VARCHAR2(60) NOT NULL Manufacturer Name
47 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description
48 WM_PM_LINK_FLAG Character(1) VARCHAR2(1) NOT NULL Linked

Y/N Table Edit