WM_PM_SCH_SRH(SQL Table) |
Index Back |
---|---|
PM Schedule Mass UpdatePM Schedule Mass Update Search Criteria |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
2 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
3 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_WM_NONVW |
4 | MAINT_TYPE | Character(10) | VARCHAR2(10) NOT NULL |
This field is used for maintenance type
Prompt Table: MAINT_TYPE_TBL |
5 | BUSINESS_UNIT_AM | Character(5) | VARCHAR2(5) NOT NULL |
AM Business Unit
Prompt Table: SP_BU_AM_NONVW |
6 | 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 |
7 | ASSET_SUBTYPE | Character(15) | VARCHAR2(15) NOT NULL |
Asset Subtype
Prompt Table:
AM_SUBTYPE
|
8 | PM_SCHD_SRCH_FLD | Character(1) | VARCHAR2(1) NOT NULL |
Search Field
1=Asset ID 2=Tag # 3=Serial ID 4=VIN 5=Location 6=Loop ID 7=Schedule |
9 | PM_SCHD_ID | Character(10) | VARCHAR2(10) NOT NULL |
Preventive Maintenance Schedule ID
Prompt Table: WM_PM_SCHD |
10 | PM_SCHD_ID_TO | Character(10) | VARCHAR2(10) NOT NULL |
Preventive Maintenance Schedule ID
Prompt Table: WM_PM_SCHD |
11 | ASSET_ID | Character(12) | VARCHAR2(12) NOT NULL |
Asset Identification
Prompt Table: WM_ASSET_VWA |
12 | ASSET_ID_TO | Character(12) | VARCHAR2(12) NOT NULL |
Asset ID to
Prompt Table: WM_ASSET_VWA |
13 | TAG_NUMBER | Character(12) | VARCHAR2(12) NOT NULL |
Tag Number
Prompt Table: WM_ASSET_VW9T |
14 | TAG_NUMBER_TO | Character(12) | VARCHAR2(12) NOT NULL |
Tag Number To
Prompt Table: WM_ASSET_VW9T |
15 | SERIAL_ID | Character(20) | VARCHAR2(20) NOT NULL |
Serial ID
Prompt Table: WM_ASSET_VW9S |
16 | SERIAL_ID_TO | Character(20) | VARCHAR2(20) NOT NULL |
To Serial ID
Prompt Table: WM_ASSET_VW9S |
17 | VIN | Character(18) | VARCHAR2(18) NOT NULL |
VIN
Prompt Table: WM_ASSET_VIN |
18 | VIN_TO | Character(18) | VARCHAR2(18) NOT NULL |
VIN to
Prompt Table: WM_ASSET_VIN |
19 | MAINT_LOOP_ID | Character(15) | VARCHAR2(15) NOT NULL |
Maintenance Loop ID
Prompt Table: WM_PM_LOOP_VW |
20 | MAINT_LOOP_TO_15 | Character(15) | VARCHAR2(15) NOT NULL |
Loop To
Prompt Table: WM_PM_LOOP_VW |
21 | LOCATION | Character(10) | VARCHAR2(10) NOT NULL |
Location Code
Prompt Table: LOCATION_VW |
22 | LOCATION_TO | Character(10) | VARCHAR2(10) NOT NULL |
Location Code
Prompt Table: LOCATION_VW |
23 | EFFDT | Date(10) | DATE | Effective Date |
24 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |
25 | WO_TEMPLATE_ID | Character(25) | VARCHAR2(25) NOT NULL |
Work Order Task/Job Template ID
Prompt Table:
WM_WO_JTMPL_VW2
|
26 | THRESHOLD_PCT | Number(3,0) | SMALLINT NOT NULL | Confidence % |
27 | 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 |
28 | 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 |
29 | SCHED_DATE | Date(10) | DATE | Schedule Date |
30 | INTERVAL_VAL | Number(9,0) | DECIMAL(9) NOT NULL | Interval |
31 | INTERVAL_START_FRM | Character(1) | VARCHAR2(1) NOT NULL |
From the last PM completion
N=No Y=Yes |
32 | 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 |
33 | DATE_OF_MONTH | Character(2) | VARCHAR2(2) NOT NULL | Date of the Month |
34 | WEEK_OF_MONTH | Character(1) | VARCHAR2(1) NOT NULL |
Week of the month
1=1st 2=2nd 3=3rd 4=4th 5=Last |
35 | START_FR_END_MONTH | Character(1) | VARCHAR2(1) NOT NULL |
From the end of the month
N=No Y=Yes |
36 | DURATION_MLTP | Number(6,2) | DECIMAL(5,2) NOT NULL | Duration Multiple |
37 | SRVC_GRP_ID | Character(10) | VARCHAR2(10) NOT NULL |
Service Group
Prompt Table: WM_SRVC_GRP_BU |
38 | WO_TYPE | Character(5) | VARCHAR2(5) NOT NULL |
Work Order Type
Prompt Table: WM_WO_TYPE |
39 | BUSINESS_UNIT_PC | Character(5) | VARCHAR2(5) NOT NULL | PC Business Unit |
40 | PROJECT_ID | Character(15) | VARCHAR2(15) NOT NULL |
Project Id ChartField
Prompt Table: WM_PC_PRJ_VW3 |
41 | ACTIVITY_ID | Character(15) | VARCHAR2(15) NOT NULL |
Activity ID
Prompt Table: PROJ_ACT_FS |
42 | SHOP_ID | Character(10) | VARCHAR2(10) NOT NULL |
Shop Identification
Prompt Table: WM_SRVC_SHOP_VW |
43 | PRIORITY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Priority Code
Prompt Table: WM_PRIORITY |
44 | STATUS_CD | Character(4) | VARCHAR2(4) NOT NULL |
User defined Status Code
Prompt Table:
WM_STATUS_TSK_O
|
45 | 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 |
46 | STATUS_CD_HDR | Character(4) | VARCHAR2(4) NOT NULL |
Header Status
Prompt Table: WM_STATUS_HDR |
47 | WO_APPROVAL_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
work order approval status
A=Approved C=Cancelled E=Denied I=Initial P=Pending Approval |
48 | WO_APPRVL_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Work Management Approval
1=Pre-Approved 3=Workflow Approval |
49 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |
50 | ANNUAL_OCCURANCE | Character(1) | VARCHAR2(1) NOT NULL | Annual Occurance |
51 | CBM_ALERT | Character(1) | VARCHAR2(1) NOT NULL |
Force WO. Disregard options.
1=On 2=Off |
52 | CBM_SOURCE | Character(1) | VARCHAR2(1) NOT NULL |
CBM Alert source
1=AM Reading Tolerance 2=MM Alert 3=Alert set manually |
53 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
54 | START_DATE | Date(10) | DATE | Start Date for Gen Standing PO |
55 | END_DATE | Date(10) | DATE | End Date |
56 | METER_TYPE | Character(30) | VARCHAR2(30) NOT NULL |
Meter Type
Prompt Table: AM_METER_TYPE |
57 | INTERVAL_MTR | Signed Number(21,4) | DECIMAL(19,4) NOT NULL | Meter Reading Interval |
58 | PROJ_MTR_USAGE | Character(1) | VARCHAR2(1) NOT NULL |
Project Meter Usage
1=None 2=Average from Asset 3=Sampling |
59 | SAMPLING_METHOD | Character(4) | VARCHAR2(4) NOT NULL |
Used in Preventive Maintenance to allow the system to project the meter usage based on historic data (the sample).
CYCL=Cycles DAYS=Days READ=Readings |
60 | SAMPLING_SIZE | Number(5,0) | INTEGER NOT NULL | Used in Preventive Maintenance to allow the system to project the meter usage based on historic data (the sample). |
61 | PROJECTED_FROM | Character(4) | VARCHAR2(4) NOT NULL |
Used in Preventive Maintenance to calculate PM's start date based on projection of meter usage.
LAST=Last PM Completion Date THRU=Current System Date |
62 | WM_PM_LINK_METHOD | Character(1) | VARCHAR2(1) NOT NULL |
PM Linking Method
1=Linking by Cycle 3=Days Tolerance |
63 | MAINT_TYPE_LNK | Character(10) | VARCHAR2(10) NOT NULL |
This field is used for maintenance type
Prompt Table: MAINT_TYPE_TBL |
64 | WM_PM_LINK_ACTION | Character(1) | VARCHAR2(1) NOT NULL |
PM Linking Action
1=Suppress Secondary Tasks 2=Merge All Tasks 3=Separate Work Orders |
65 | WM_PM_DAYS_TOLER | Number(2,0) | SMALLINT NOT NULL | PM Linking Days Tolerance |
66 | WM_PM_INTERVAL_TYP | Character(1) | VARCHAR2(1) NOT NULL |
PM linking interval type
1=Day Interval 2=Meter Interval |
67 | METER_TYPE_LNK | Character(30) | VARCHAR2(30) NOT NULL |
Meter Type
Prompt Table: AM_METER_TYPE |
68 | PM_LEAD_DAYS | Number(3,0) | SMALLINT NOT NULL | LEAD DAYS |
69 | DESCR100 | Character(100) | VARCHAR2(100) NOT NULL | Length 100 Description |
70 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: WM_ELGBL_WRKR |
71 | CREW_ID | Character(10) | VARCHAR2(10) NOT NULL |
Crew Name
Prompt Table: WM_PREFCREW2_VW |