| # |
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_AM |
Character(5) |
VARCHAR2(5) NOT NULL |
AM Business Unit
|
| 3 |
ASSET_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Asset Identification
|
| 4 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 5 |
MAINT_LOOP_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Maintenance Loop ID
|
| 6 |
MAINT_TYPE |
Character(10) |
VARCHAR2(10) NOT NULL |
This field is used for maintenance type
|
| 7 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 8 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 9 |
REQUEST_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Request ID
|
| 10 |
REQUEST_DT |
Date(10) |
DATE |
Request Date
|
| 11 |
WHERE_CLAUSE |
Character(254) |
VARCHAR2(254) NOT NULL |
Where Clause
|
| 12 |
WHERE_CLAUSE1 |
Character(254) |
VARCHAR2(254) NOT NULL |
Where Clause
|
| 13 |
WHERE_CLAUSE2 |
Character(254) |
VARCHAR2(254) NOT NULL |
Where Clause
|
| 14 |
PROCESS_FREQUENCY |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Frequency
A=Always Process
N=Don't Run
O=Process Once
|
| 15 |
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
|
| 16 |
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
|
| 17 |
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).
|
| 18 |
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
|
| 19 |
CREATE_WO_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Create Work Order
|
| 20 |
PM_PROC_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Options
1=Preventive
2=Projection
|
| 21 |
FROM_DATE |
Date(10) |
DATE |
From Date
|
| 22 |
TO_DATE |
Date(10) |
DATE |
To Date
|
| 23 |
AE_SECTION |
Character(8) |
VARCHAR2(8) NOT NULL |
Section
|
| 24 |
TEMP_FLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Temporary Field for App Engine
|
| 25 |
NEXT_DUE_DT |
Date(10) |
DATE |
Preventive Maintenance due date
|
| 26 |
CALC_DT |
Date(10) |
DATE |
The calculation date for a given data set within the Position tools.
|
| 27 |
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.
|
| 28 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 29 |
PM_SCHD_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Preventive Maintenance Schedule ID
|
| 30 |
WO_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Work Order Identification
|
| 31 |
RECNAME |
Character(15) |
VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
|
| 32 |
RECNAME_0 |
Character(15) |
VARCHAR2(15) NOT NULL |
Level 0 Record
|
| 33 |
RECNAME_1 |
Character(15) |
VARCHAR2(15) NOT NULL |
Record 1 Name
|
| 34 |
RECNAME_2 |
Character(15) |
VARCHAR2(15) NOT NULL |
Record 2 Name
|
| 35 |
RECNAME_3 |
Character(15) |
VARCHAR2(15) NOT NULL |
Rename
|
| 36 |
RECNAME_4 |
Character(15) |
VARCHAR2(15) NOT NULL |
Rename
|
| 37 |
RECNAME_18 |
Character(18) |
VARCHAR2(18) NOT NULL |
used in table CFOBJECT_TMP for App Engine FS_CFUPDATE.ViewSrch to look for view/table dependencies.
|
| 38 |
INSERT_CLAUSE |
Character(254) |
VARCHAR2(254) NOT NULL |
Insert Clause used for Inheritance.
|
| 39 |
LAST_TASK_ID |
Number(8,0) |
INTEGER NOT NULL |
Last Task ID
|
| 40 |
MAX_TASK_ID |
Number(5,0) |
INTEGER NOT NULL |
Last Task ID
|
| 41 |
SEQ_NBR |
Number(15,0) |
DECIMAL(15) NOT NULL |
Sequence Number
|
| 42 |
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
|
| 43 |
DAY_OF_WEEK |
Character(16) |
VARCHAR2(16) NOT NULL |
Day of Week
|
| 44 |
SEQ_NBR_5 |
Number(5,0) |
INTEGER NOT NULL |
Sequence number five digits long
|
| 45 |
LANGUAGE_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Language Code
|
| 46 |
MAX_NBR |
Number(5,0) |
INTEGER NOT NULL |
Max Number
|
| 47 |
DATE_OF_MONTH |
Character(2) |
VARCHAR2(2) NOT NULL |
Date of the Month
|
| 48 |
WEEK_OF_MONTH |
Character(1) |
VARCHAR2(1) NOT NULL |
Week of the month
1=1st
2=2nd
3=3rd
4=4th
5=Last
|
| 49 |
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
|
| 50 |
INTERVAL_VAL |
Number(9,0) |
DECIMAL(9) NOT NULL |
Interval
|
| 51 |
PM_OCCURRENCES |
Number(3,0) |
SMALLINT NOT NULL |
Occurrences
|
| 52 |
COUNTER |
Number(10,0) |
DECIMAL(10) NOT NULL |
Counter
|
| 53 |
COUNTER1 |
Number(16,2) |
DECIMAL(15,2) NOT NULL |
Counter 1
|
| 54 |
COMMITMENT_CNTL_IN |
Character(1) |
VARCHAR2(1) NOT NULL |
Commitment Control on IN
|
| 55 |
WHERE_CLAUSE3 |
Character(254) |
VARCHAR2(254) NOT NULL |
Where Clause
|
| 56 |
WO_TEMPLATE_ID |
Character(25) |
VARCHAR2(25) NOT NULL |
Work Order Task/Job Template ID
|
| 57 |
WO_TASK_ID |
Number(5,0) |
INTEGER NOT NULL |
Task Number
|
| 58 |
RES_LN_NBR |
Number(5,0) |
INTEGER NOT NULL |
Resource Line No.
|
| 59 |
RQMT_LN_NBR |
Number(5,0) |
INTEGER NOT NULL |
Requirement Line Number
|
| 60 |
PROJECT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Project Id ChartField
|
| 61 |
ACTIVITY_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Activity ID
|
| 62 |
BUSINESS_UNIT_PC |
Character(5) |
VARCHAR2(5) NOT NULL |
PC Business Unit
|
| 63 |
WM_PM_RUN_DTTM |
DateTime(26) |
TIMESTAMP |
Process Run Date Time
|
| 64 |
FIRST_CYCLE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
First Maintenance Cycle
|
| 65 |
LOOP_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Looping
|
| 66 |
MTR_CALC_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Calculate Meter
|
| 67 |
PERIOD_SELECTION |
Character(1) |
VARCHAR2(1) NOT NULL |
10/03/02 JC (CN#PL880-1): Added
1=Weekly
2=Monthly
|
| 68 |
WO_LAST_NUM |
Number(10,0) |
DECIMAL(10) NOT NULL |
Work Order id last number used
|
| 69 |
INV |
Character(1) |
VARCHAR2(1) NOT NULL |
Inventory
|
| 70 |
INTFC_ID |
Number(8,0) |
INTEGER NOT NULL |
Interface ID
|
| 71 |
TO_INTFC_ID |
Number(8,0) |
INTEGER NOT NULL |
To Interface ID
|
| 72 |
TRANSACTION_NBR |
Number(15,0) |
DECIMAL(15) NOT NULL |
08/02/99 NAS: Changed the size of this field from 10 to 15. Based on Jim Hillman's decision to make the field at a standard size.
|
| 73 |
RQMT_QTY |
Signed Number(12,0) |
DECIMAL(11) NOT NULL |
Required Quantity
|
| 74 |
ACT_SEQ_NBR |
Number(15,0) |
DECIMAL(15) NOT NULL |
Sequence Number
|
| 75 |
WHERE_CLAUSE4 |
Character(254) |
VARCHAR2(254) NOT NULL |
Where Clause
|
| 76 |
EFFDT |
Date(10) |
DATE |
Effective Date
Default Value: %date
|
| 77 |
WO_TASK_TMPLT_ID |
Character(25) |
VARCHAR2(25) NOT NULL |
WO Task Template ID (specific field)
|
| 78 |
DESCRLONG |
Long Character |
CLOB |
Long Description
|
| 79 |
TMPL_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Template type
|
| 80 |
TO_VALUE_DATE |
Date(10) |
DATE |
To Date
|
| 81 |
LAST_PJC_DT |
Date(10) |
DATE |
Preventive Maintenance due date
|
| 82 |
GEN_WO_FROM_PJC |
Character(1) |
VARCHAR2(1) NOT NULL |
Generate Work Order from Projection List flag
|
| 83 |
CREW_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Crew Name
|
| 84 |
SHOP_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Shop Identification
|
| 85 |
FROM_DUE_DT |
Date(10) |
DATE |
From Due Date
|
| 86 |
TO_DUE_DT |
Date(10) |
DATE |
To Due Date
|
| 87 |
GEN_PROCESS_INST |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 88 |
SEQ_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Sequence
|
| 89 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 90 |
INSERT_CLAUSE1 |
Character(254) |
VARCHAR2(254) NOT NULL |
Insert Clause used for Inheritance (where Inh GLBU <> Dist Line GLBU).
|
| 91 |
RECNAME_MTR |
Character(18) |
VARCHAR2(18) NOT NULL |
Meter Record
|
| 92 |
RECNAME_BKP |
Character(18) |
VARCHAR2(18) NOT NULL |
Blackout Record
|
| 93 |
REPORT_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Recreate Unshipped Report
|
| 94 |
INSERT_CLAUSE2 |
Character(254) |
VARCHAR2(254) NOT NULL |
Insert Clause used for Draft Inheritance (where Inh GLBU = Dist Line GLBU and No Payment Method setup).
|
| 95 |
INSERT_CLAUSE3 |
Character(254) |
VARCHAR2(254) NOT NULL |
Insert Clause used for Draft Inheritance (where Inh GLBU <> Dist Line GLBU and No Payment Method setup).
|
| 96 |
DATENULL |
Date(10) |
DATE |
Date
|
| 97 |
PJC_LIST_DT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Projection List Flag
|
| 98 |
PM_SEQ_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Sequence Number
|
| 99 |
PM_SEQ_NBR_PRIM |
Number(3,0) |
SMALLINT NOT NULL |
Sequence Number
|
| 100 |
PM_SCHD_ID_TO |
Character(10) |
VARCHAR2(10) NOT NULL |
Preventive Maintenance Schedule ID
|
| 101 |
PM_SCHD_ID_TO2 |
Character(10) |
VARCHAR2(10) NOT NULL |
Preventive Maintenance Schedule ID
|
| 102 |
RECNAME_LNK |
Character(18) |
VARCHAR2(18) NOT NULL |
Meter Record
|
| 103 |
RECNAME_LNK1 |
Character(18) |
VARCHAR2(18) NOT NULL |
Meter Record
|
| 104 |
INSERT_CLAUSE4 |
Character(254) |
VARCHAR2(254) NOT NULL |
Insert Clause used for Draft Inheritance (where Inh GLBU <> Dist Line GLBU and No Payment Method setup).
|
| 105 |
SCHEDULER_CODE |
Character(10) |
VARCHAR2(10) NOT NULL |
Scheduler Code
|
| 106 |
WM_PM_CURR_CYCLE |
Number(3,0) |
SMALLINT NOT NULL |
Current Cycle
|
| 107 |
ASSET_SEQ_NBR |
Number(5,0) |
INTEGER NOT NULL |
Asset Sequence Number
|
| 108 |
HOLIDAY_DT |
Date(10) |
DATE |
The date associated with a defined business holiday.
|
| 109 |
WM_HOL_PROC_DAYS |
Number(3,0) |
SMALLINT NOT NULL |
Processing days
|
| 110 |
WM_HOL_PROC_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Holiday Processing Option
A=Due After Holiday
B=Due Before Holiday
N=Not applicable
|
| 111 |
WM_GO_NXT_PRV_DAY |
Character(1) |
VARCHAR2(1) NOT NULL |
Go next or prior business day
N=Next Business Day
P=Prior Business Day
|
| 112 |
WM_PM_USE_BUS_DAY |
Character(1) |
VARCHAR2(1) NOT NULL |
Use business day
|
| 113 |
NUM_WEEKS |
Number(10,0) |
DECIMAL(10) NOT NULL |
Weeks Past Due
|
| 114 |
WM_PM_LOOP_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Loop Option
1=Default asset meter reading
2=Individual asset meter reading
|
| 115 |
WM_PM_LOOP_GEN |
Character(1) |
VARCHAR2(1) NOT NULL |
WO Generation
1=Single Work Order
2=Multiple Work Orders
|
| 116 |
WM_NUM_WEEKS |
Number(13,2) |
DECIMAL(12,2) NOT NULL |
Number of Weeks
|
| 117 |
WM_RECNAME_WO_HDR |
Character(15) |
VARCHAR2(15) NOT NULL |
Record (Table) Name
|
| 118 |
WM_RECNAME_WO_LBR |
Character(15) |
VARCHAR2(15) NOT NULL |
Record (Table) Name
|
| 119 |
WM_RECNAME_WO_PO |
Character(15) |
VARCHAR2(15) NOT NULL |
Record (Table) Name
|
| 120 |
WM_RECNAME_WO_TSK |
Character(15) |
VARCHAR2(15) NOT NULL |
Record (Table) Name
|
| 121 |
MESSAGE_SET_NBR |
Number(5,0) |
INTEGER NOT NULL |
Message Set Number. This field refers to the Message Set Number in the Message Catalog.
|
| 122 |
MESSAGE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Message Number. This field refers to the Message Number in the Message Catalog.
|
| 123 |
PROBLEM_GROUP |
Character(15) |
VARCHAR2(15) NOT NULL |
Problem Group
|
| 124 |
PROBLEM_CD |
Character(15) |
VARCHAR2(15) NOT NULL |
Problem code
|
| 125 |
PRIORITY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Priority Code
|
| 126 |
RECNAME_BASE |
Character(15) |
VARCHAR2(15) NOT NULL |
Base record name
|
| 127 |
WM_ASSET_INSP_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Asset Inspections
Y/N Table Edit
Default Value: N
|
| 128 |
COUNT1 |
Number(10,0) |
DECIMAL(10) NOT NULL |
Counter
|
| 129 |
WHERE_CLAUSE5 |
Character(254) |
VARCHAR2(254) NOT NULL |
Where Clause
|
| 130 |
WM_COUNT_DUPS |
Number(10,0) |
DECIMAL(10) NOT NULL |
Duplicates Count
|
| 131 |
WHERE_CLAUSE6 |
Character(254) |
VARCHAR2(254) NOT NULL |
Where Clause
|