| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
|
| 2 |
LOCATION |
Character(10) |
VARCHAR2(10) NOT NULL |
Location Code
Prompt Table:
LOCATION_TBL
|
| 3 |
BUSINESS_UNIT_GL |
Character(5) |
VARCHAR2(5) NOT NULL |
GL Business Unit
Prompt Table:
SP_BU_GL_NONVW
|
| 4 |
BASE_CURRENCY |
Character(3) |
VARCHAR2(3) NOT NULL |
"Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. "
Prompt Table:
CURRENCY_CD_TBL
|
| 5 |
RT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
Prompt Table:
RT_TYPE_TBL
|
| 6 |
BUSINESS_UNIT_PC |
Character(5) |
VARCHAR2(5) NOT NULL |
PC Business Unit
Prompt Table:
SP_BU_PC_NONVW
|
| 7 |
WO_MULT_ASSETS |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow multiple assets per Work Order
Y/N Table Edit
Default Value: N
|
| 8 |
GEN_CHARGEBACK |
Character(1) |
VARCHAR2(1) NOT NULL |
Generate Chargeback field, used in Maintenance Management
Y/N Table Edit
Default Value: N
|
| 9 |
ANALYSIS_GROUP |
Character(5) |
VARCHAR2(5) NOT NULL |
Analysis Group
Prompt Table:
PROJ_AN_GRP_TBL
|
| 10 |
WO_APPRVL_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Work Management Approval
1=Pre-Approved
3=Workflow Approval
Default Value: 1
|
| 11 |
EDIT_CHARTFIELDS |
Character(1) |
VARCHAR2(1) NOT NULL |
Edit Chartfields
Y/N Table Edit
Default Value: N
|
| 12 |
WO_EST_LABOR |
Character(1) |
VARCHAR2(1) NOT NULL |
Record Estimated Labor
Y/N Table Edit
Default Value: Y
|
| 13 |
WO_EST_MATERIAL |
Character(1) |
VARCHAR2(1) NOT NULL |
Record Estimated Material
Y/N Table Edit
Default Value: Y
|
| 14 |
WO_EST_TOOLS |
Character(1) |
VARCHAR2(1) NOT NULL |
Record estimated Tools usage
Y/N Table Edit
Default Value: Y
|
| 15 |
WO_SCHED_LABOR |
Character(1) |
VARCHAR2(1) NOT NULL |
Work Management Schedule labor
Y/N Table Edit
Default Value: Y
|
| 16 |
WO_SCHED_MATERIAL |
Character(1) |
VARCHAR2(1) NOT NULL |
Work Management Schedule materials
Y/N Table Edit
Default Value: Y
|
| 17 |
WO_SCHED_TOOLS |
Character(1) |
VARCHAR2(1) NOT NULL |
Work Management Schedule Tools
Y/N Table Edit
Default Value: Y
|
| 18 |
WO_ACTUAL_TOOLS |
Character(1) |
VARCHAR2(1) NOT NULL |
Report actual tools usage for WO
Y/N Table Edit
Default Value: N
|
| 19 |
SRVC_GRP_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Service Group
Prompt Table:
WM_SRVC_GRP
|
| 20 |
SHOP_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Shop Identification
Prompt Table:
WM_SHOP_BU_VW
|
| 21 |
CLOSE_DAYS_TSK |
Signed Number(6,0) |
DECIMAL(5) NOT NULL |
Number of close days for WO Task
Default Value: 0
|
| 22 |
COST_SUMM_DAYS_TSK |
Signed Number(6,0) |
DECIMAL(5) NOT NULL |
Number of days for Cost Summarization to Collect Cost
Default Value: 0
|
| 23 |
WO_NUM_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow work order auto numbering
Y/N Table Edit
|
| 24 |
RATE_SELECT |
Character(1) |
VARCHAR2(1) NOT NULL |
This will determine selection of 1) Rate Set and 2) Rate Plan in Project Type, Project and Activity.
1=Rate Set
2=Rate Plan
Default Value: 1
|
| 25 |
PC_TEMPLATE_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Rate Template ID
Prompt Table:
%EDITTABLE15
|
| 26 |
BUSINESS_UNIT_IN |
Character(5) |
VARCHAR2(5) NOT NULL |
Inventory Unit
Prompt Table:
WM_WO_IN_BU_VW
|
| 27 |
WO_INV_COMMIT_RULE |
Character(1) |
VARCHAR2(1) NOT NULL |
Inventory commit rule, when to commit inventory for Work Management
1=Parts List Creation
2=Pick Plan Creation
3=Work Order Status Change
4=Commit at Reserve
|
| 28 |
INTERNAL_STAT_COMM |
Character(2) |
VARCHAR2(2) NOT NULL |
Work Order commit rule internal status.
02=Awaiting Schedule
03=Scheduled
04=Work In Progress
|
| 29 |
WO_PM_DAYS |
Signed Number(6,0) |
DECIMAL(5) NOT NULL |
Preventive maintenance days to consider
|
| 30 |
WO_PROCURE_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Work Management procurement option, create requisitions or purchase orders, or none
1=Create Requisition
2=Create Purchase Order
3=None
4=Create ePro Requisition
Default Value: 3
|
| 31 |
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
|
| 32 |
UPDATE_RS_CALENDAR |
Character(1) |
VARCHAR2(1) NOT NULL |
Update Resource Calendar
Y/N Table Edit
Default Value: N
|
| 33 |
CONTACT_NAME |
Character(50) |
VARCHAR2(50) NOT NULL |
The individual contact name associated with a given bank/counterparty.
|
| 34 |
COMPANY_NAME1 |
Character(40) |
VARCHAR2(40) NOT NULL |
Company Name 1
|
| 35 |
COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
Prompt Table:
COUNTRY_TBL
|
| 36 |
ADDRESS1 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 1
|
| 37 |
ADDRESS2 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 2
|
| 38 |
ADDRESS3 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 3
|
| 39 |
ADDRESS4 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 4
|
| 40 |
CITY |
Character(30) |
VARCHAR2(30) NOT NULL |
City
|
| 41 |
NUM1 |
Character(6) |
VARCHAR2(6) NOT NULL |
Number 1
|
| 42 |
NUM2 |
Character(6) |
VARCHAR2(6) NOT NULL |
Number 2
|
| 43 |
HOUSE_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
House Type
AB=House Boat
WW=Trailer
|
| 44 |
ADDR_FIELD1 |
Character(2) |
VARCHAR2(2) NOT NULL |
Address Field 1
|
| 45 |
ADDR_FIELD2 |
Character(4) |
VARCHAR2(4) NOT NULL |
Address Field 2
|
| 46 |
ADDR_FIELD3 |
Character(4) |
VARCHAR2(4) NOT NULL |
Address Field 3
|
| 47 |
COUNTY |
Character(30) |
VARCHAR2(30) NOT NULL |
County
|
| 48 |
STATE |
Character(6) |
VARCHAR2(6) NOT NULL |
State
Prompt Table:
%EDIT_STATE
|
| 49 |
POSTAL |
Character(12) |
VARCHAR2(12) NOT NULL |
Postal
|
| 50 |
GEO_CODE |
Character(11) |
VARCHAR2(11) NOT NULL |
Geo Code
|
| 51 |
IN_CITY_LIMIT |
Character(1) |
VARCHAR2(1) NOT NULL |
In City Limit
Y/N Table Edit
|
| 52 |
PHONE |
Character(24) |
VARCHAR2(24) NOT NULL |
Telephone
|
| 53 |
EXTENSION |
Character(6) |
VARCHAR2(6) NOT NULL |
Phone Extension
|
| 54 |
COUNTRY_CODE |
Character(3) |
VARCHAR2(3) NOT NULL |
Int'l Prefix
|
| 55 |
PRIORITY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Priority Code
Prompt Table:
WM_PRIORITY
|
| 56 |
WO_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Work Order Type
Prompt Table:
WM_WO_TYPE
|
| 57 |
STATUS_CD |
Character(4) |
VARCHAR2(4) NOT NULL |
User defined Status Code
Prompt Table:
WM_STATUS_TSK_O
|
| 58 |
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
|
| 59 |
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).
|
| 60 |
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
|
| 61 |
ASSET_FIELD |
Character(1) |
VARCHAR2(1) NOT NULL |
Field to use for Asset lookup on Work Request
1=Tag Number
2=Serial ID
3=Vehicle ID Number
4=Asset ID
5=Do not display asset fields
Default Value: 4
|
| 62 |
WO_ACCTG_SRVC_GRP |
Character(1) |
VARCHAR2(1) NOT NULL |
Work Order Service Group default
1=1
2=2
3=3
4=4
5=5
6=6
7=7
Default Value: 1
|
| 63 |
WO_ACCTG_WO_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Work Order Type default
1=1
2=2
3=3
4=4
5=5
6=6
7=7
Default Value: 2
|
| 64 |
WO_ACCTG_ASSET_TYP |
Character(1) |
VARCHAR2(1) NOT NULL |
Work Order Accounting default for Asset Type
1=1
2=2
3=3
4=4
5=5
6=6
7=7
Default Value: 3
|
| 65 |
WO_ACCTG_ASSET_SUB |
Character(1) |
VARCHAR2(1) NOT NULL |
Work Order Accounting asset subtype default
1=1
2=2
3=3
4=4
5=5
6=6
7=7
Default Value: 4
|
| 66 |
WO_ACCTG_ASSET_LOC |
Character(1) |
VARCHAR2(1) NOT NULL |
Work Order Accounting asset location default
1=1
2=2
3=3
4=4
5=5
6=6
7=7
Default Value: 5
|
| 67 |
WO_ACCTG_ASSET_ID |
Character(1) |
VARCHAR2(1) NOT NULL |
Work Order Accounting asset id defaul
1=1
2=2
3=3
4=4
5=5
6=6
7=7
Default Value: 6
|
| 68 |
WO_ACCTG_ASSET_BU |
Character(1) |
VARCHAR2(1) NOT NULL |
Work Order Accounting default asset business unit
1=1
2=2
3=3
4=4
5=5
6=6
7=7
Default Value: 7
|
| 69 |
WO_PROJ_DFLT_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Project Default Order option on the Work Management Business Unit setup
1=Bus Unit - Srvc Grp - WO Type
2=Bus Unit - WO Type - Srvc Grp
Default Value: 1
|
| 70 |
WO_CNTRL_DFLT_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Control default order option for Work Management Business Unit setup
1=Bus Unit - WO Type - Shop
2=Bus Unit - Shop - WO Type
Default Value: 1
|
| 71 |
WM_WO_ACCESS |
Character(1) |
VARCHAR2(1) NOT NULL |
Technician WO Security
B=Shop and Resource Pool
N=Full Access
R=Resource Pool
S=Shop
Default Value: N
|
| 72 |
WO_RESERVE_RULE |
Character(1) |
VARCHAR2(1) NOT NULL |
Work Order Reservation rule
1=Parts List Creation
2=Pick Plan Creation
3=Work Order Status Change
4=Batch Reserve Only
|
| 73 |
INTERNAL_STAT_RSRV |
Character(2) |
VARCHAR2(2) NOT NULL |
Work Order Reservation rule internal status.
02=Awaiting Schedule
03=Scheduled
04=Work In Progress
|
| 74 |
PRIORITY_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Priority
|
| 75 |
MAINT_TYPE |
Character(10) |
VARCHAR2(10) NOT NULL |
This field is used for maintenance type
Prompt Table:
MAINT_TYPE_TBL
Set Control Field: BUSINESS_UNIT
|
| 76 |
GIS_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
GIS Integration
Y/N Table Edit
Default Value: N
|
| 77 |
WM_EIP_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Mobile Integration Enabled
Y/N Table Edit
Default Value: N
|
| 78 |
ASSET_REQD |
Character(1) |
VARCHAR2(1) NOT NULL |
Header Asset Required
Y/N Table Edit
Default Value: N
|
| 79 |
TASK_ASSET_REQD |
Character(1) |
VARCHAR2(1) NOT NULL |
Task Asset Required
Y/N Table Edit
Default Value: N
|
| 80 |
WM_PM_APPRVL_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Work Management Approval
1=Pre-Approved
3=Workflow Approval
Default Value: 1
|
| 81 |
WM_PM_DAY_DURATION |
Number(5,2) |
DECIMAL(4,2) NOT NULL |
Estimated Work Order Duration
Default Value: 24
|
| 82 |
WM_PM_USE_BUS_DAY |
Character(1) |
VARCHAR2(1) NOT NULL |
Use business day
Y/N Table Edit
|
| 83 |
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
Default Value: N
|
| 84 |
WM_HOL_PROC_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Holiday Processing Option
A=Due After Holiday
B=Due Before Holiday
N=Not applicable
|
| 85 |
WM_HOL_PROC_DAYS |
Number(3,0) |
SMALLINT NOT NULL |
Processing days
Default Value: 1
|
| 86 |
WM_AUTOASSIG_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Auto Assignment & Dispatch
Y/N Table Edit
Default Value: N
|
| 87 |
WM_AUTOASSIG1_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Auto Resource Replacement
Y/N Table Edit
Default Value: N
|
| 88 |
WM_ASSET_INSP_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Asset Inspections
Y/N Table Edit
Default Value: N
|
| 89 |
WM_GEN_PM_INSP_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Generate PM Inspections
Y/N Table Edit
Default Value: N
|