WM_PM_SCHD_DTL(SQL Table) |
Index Back |
---|---|
PM Schedule DetailPreventive Maintenance Schedule Detail |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: BUS_UNIT_TBL_WM |
2 | PM_SCHD_ID | Character(10) | VARCHAR2(10) NOT NULL | Preventive Maintenance Schedule ID |
3 | EFFDT | Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
4 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
5 | WO_TEMPLATE_ID | Character(25) | VARCHAR2(25) NOT NULL |
Work Order Task/Job Template ID
Prompt Table:
%EDITTABLE
|
6 | THRESHOLD_PCT | Number(3,0) | SMALLINT NOT NULL |
Confidence %
Default Value: 100 |
7 | 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 Default Value: 1 |
8 | 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 |
9 | SCHED_DATE | Date(10) | DATE | Schedule Date |
10 | INTERVAL_VAL | Number(9,0) | DECIMAL(9) NOT NULL | Interval |
11 | INTERVAL_START_FRM | Character(1) | VARCHAR2(1) NOT NULL |
From the last PM completion
N=No Y=Yes Default Value: Y |
12 | 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 |
13 | DATE_OF_MONTH | Character(2) | VARCHAR2(2) NOT NULL | Date of the Month |
14 | WEEK_OF_MONTH | Character(1) | VARCHAR2(1) NOT NULL |
Week of the month
1=1st 2=2nd 3=3rd 4=4th 5=Last |
15 | START_FR_END_MONTH | Character(1) | VARCHAR2(1) NOT NULL |
From the end of the month
N=No Y=Yes Default Value: N |
16 | DURATION_MLTP | Number(6,2) | DECIMAL(5,2) NOT NULL |
Duration Multiple
Default Value: 1 |
17 | SRVC_GRP_ID | Character(10) | VARCHAR2(10) NOT NULL |
Service Group
Prompt Table: WM_SRVC_GRP_BU |
18 | WO_TYPE | Character(5) | VARCHAR2(5) NOT NULL |
Work Order Type
Prompt Table: WM_WO_TYPE |
19 | BUSINESS_UNIT_PC | Character(5) | VARCHAR2(5) NOT NULL | PC Business Unit |
20 | PROJECT_ID | Character(15) | VARCHAR2(15) NOT NULL |
Project Id ChartField
Prompt Table: WM_PC_PRJ_DVW2 |
21 | ACTIVITY_ID | Character(15) | VARCHAR2(15) NOT NULL |
Activity ID
Prompt Table: PROJ_ACT_FS |
22 | SHOP_ID | Character(10) | VARCHAR2(10) NOT NULL |
Shop Identification
Prompt Table: WM_SRVC_SHOP_VW |
23 | PRIORITY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Priority Code
Prompt Table: WM_PRIORITY |
24 | STATUS_CD | Character(4) | VARCHAR2(4) NOT NULL |
User defined Status Code
Prompt Table:
WM_STATUS_TSK_O
|
25 | 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 Default Value: 01 |
26 | STATUS_CD_HDR | Character(4) | VARCHAR2(4) NOT NULL |
Header Status
Prompt Table: WM_STATUS_HDR |
27 | WO_APPROVAL_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
work order approval status
A=Approved C=Cancelled E=Denied I=Initial P=Pending Approval Default Value: A |
28 | WO_APPRVL_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Work Management Approval
1=Pre-Approved 3=Workflow Approval |
29 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |
30 | ANNUAL_OCCURANCE | Character(1) | VARCHAR2(1) NOT NULL | Annual Occurance |
31 | CBM_ALERT | Character(1) | VARCHAR2(1) NOT NULL |
Force WO. Disregard options.
1=On 2=Off Default Value: 2 |
32 | CBM_SOURCE | Character(1) | VARCHAR2(1) NOT NULL |
CBM Alert source
1=AM Reading Tolerance 2=MM Alert 3=Alert set manually |
33 | PM_LEAD_DAYS | Number(3,0) | SMALLINT NOT NULL | LEAD DAYS |
34 | WM_PM_LINK_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Linked
Default Value: N |
35 | 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 Default Value: I |
36 | WM_PM_APPRVL_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Work Management Approval
1=Pre-Approved 3=Workflow Approval |
37 | 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 |
38 | SUBMIT_DTTM | DateTime(26) | TIMESTAMP | Report Submitted On - DateTime |
39 | OPRID | Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Default Value: OPR_DEF_TBL_FS.OPRID |
40 | WM_PARENTCHILD_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Parent/Child
Y/N Table Edit Default Value: N |
41 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: WM_ELGBL_WRKR |
42 | CREW_ID | Character(10) | VARCHAR2(10) NOT NULL |
Crew Name
Prompt Table: WM_PREFCREW2_VW |
43 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
44 | IN_PROCESS_FLG | Character(1) | VARCHAR2(1) NOT NULL |
In process flag
Default Value: N |