WM_PM_PJC_RUN(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 3 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 4 | REQUEST_ID | Character(10) | VARCHAR2(10) NOT NULL | Request ID |
| 5 | REQUEST_DT | Date(10) | DATE | Request Date |
| 6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 7 | PM_SELCT_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Selection Type
1=All business units 2=AM business unit list 3=Location list 4=Asset classification 5=Maintenance type list 6=PM schedule selection 7=WO business unit list 8=Projection List 9=Shop List |
| 8 | 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 |
| 9 | 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). |
| 10 | 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 |
| 11 | FROM_DATE | Date(10) | DATE | From Date |
| 12 | TO_DATE | Date(10) | DATE | To Date |
| 13 | PM_OCCURRENCES | Number(3,0) | SMALLINT NOT NULL | Occurrences |
| 14 | WM_PM_RUN_DTTM | DateTime(26) | TIMESTAMP | Process Run Date Time |
| 15 | CREATE_WO_FLG | Character(1) | VARCHAR2(1) NOT NULL | Create Work Order |