WM_PM_PJC_LINK(SQL Table) |
Index Back |
|---|---|
PM Meter Based Schedule |
| # | 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 | PM_SCHD_ID_TO |
Character(10) | VARCHAR2(10) NOT NULL |
Preventive Maintenance Schedule ID
Prompt Table: WM_PM_SCHD |
| 9 | PJC_ID |
Character(10) | VARCHAR2(10) NOT NULL | Projection ID |
| 10 | METER_TYPE | Character(30) | VARCHAR2(30) NOT NULL |
Meter Type
Prompt Table: WM_ASSET_MTR_VW |
| 11 | WM_PM_DAYS_TOLER | Number(2,0) | SMALLINT NOT NULL | PM Linking Days Tolerance |
| 12 | WM_PM_LINK_METHOD | Character(1) | VARCHAR2(1) NOT NULL |
PM Linking Method
1=Linking by Cycle 3=Days Tolerance |
| 13 | 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 |
| 14 | WM_PM_OCCURRENCES | Number(2,0) | SMALLINT NOT NULL | PM Linking Occurrences per Cycle |
| 15 | WM_PM_CUR_OCCUR | Number(2,0) | SMALLINT NOT NULL | PM Linking Current Occurrence |
| 16 | WM_PM_CURR_CYCLE | Number(3,0) | SMALLINT NOT NULL | Current Cycle |
| 17 | WM_PM_INTERVAL_TYP | Character(1) | VARCHAR2(1) NOT NULL |
PM linking interval type
1=Day Interval 2=Meter Interval |
| 18 | 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 |
| 19 | WM_PM_SEC_DUE_DATE | Date(10) | DATE | Secondary Schedule's Due Date |
| 20 | WM_PM_LINK_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Linked |
| 21 | DUE_DT | Date(10) | DATE | Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received. |
| 22 | PM_SEQ_NBR | Number(3,0) | SMALLINT NOT NULL | Sequence Number |
| 23 | PM_SEQ_NBR_PRIM | Number(3,0) | SMALLINT NOT NULL | Sequence Number |
| 24 | IN_PROCESS_FLG | Character(1) | VARCHAR2(1) NOT NULL |
In process flag
Default Value: N |