| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Default Value: OPR_DEF_TBL_FS.OPRID
Prompt Table:
OPRID_VW
|
| 2 |
WR_LOCATION |
Character(10) |
VARCHAR2(10) NOT NULL |
Service Location
Prompt Table:
WM_WR_LOCATION
|
| 3 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table:
SP_BU_WM_NONVW
|
| 4 |
BUSINESS_UNIT_AM |
Character(5) |
VARCHAR2(5) NOT NULL |
AM Business Unit
Prompt Table:
SP_BU_AM_NONVW
|
| 5 |
BUSINESS_UNIT_WR |
Character(5) |
VARCHAR2(5) NOT NULL |
Work Request Business Unit
Prompt Table:
SP_BU_WR_NONVW
|
| 6 |
WO_ALLOW_INV |
Character(1) |
VARCHAR2(1) NOT NULL |
Work Management field on the User Preference record/page to authorize access and entry of Inventory parts on a Work Order
Y/N Table Edit
Default Value: N
|
| 7 |
WO_ALLOW_PROCURE |
Character(1) |
VARCHAR2(1) NOT NULL |
Y/N field used for Work Management User Preference option to Allow Procurement
Y/N Table Edit
Default Value: N
|
| 8 |
WO_ALLW_PLND_DWNTM |
Character(1) |
VARCHAR2(1) NOT NULL |
Y/N field used for Work Management User Preference option to Allow Downtime Entry.
Y/N Table Edit
Default Value: Y
|
| 9 |
WO_VIEW_REQTS |
Character(1) |
VARCHAR2(1) NOT NULL |
Work Management authorized to view requirements
Y/N Table Edit
Default Value: N
|
| 10 |
WO_VIEW_SCHED |
Character(1) |
VARCHAR2(1) NOT NULL |
Work Management authorized to view schedules
Y/N Table Edit
Default Value: N
|
| 11 |
WO_UPD_ACCTG |
Character(1) |
VARCHAR2(1) NOT NULL |
Work Management authorized to create/update accounting information
Y/N Table Edit
Default Value: N
|
| 12 |
WO_SCHED_RSRCS |
Character(1) |
VARCHAR2(1) NOT NULL |
Work Management Schedule resources
Y/N Table Edit
Default Value: N
|
| 13 |
WO_SCHED_RSRCS_TLS |
Character(1) |
VARCHAR2(1) NOT NULL |
Schedule Tools
Y/N Table Edit
Default Value: N
|
| 14 |
CLOSE_WO |
Character(1) |
VARCHAR2(1) NOT NULL |
Number of days before closing a WO
Y/N Table Edit
Default Value: N
|
| 15 |
COMPLETE_WO |
Character(1) |
VARCHAR2(1) NOT NULL |
Authorized to Complete WO Task
Y/N Table Edit
Default Value: N
|
| 16 |
UNDO_COMPLETE_WO |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow reset of Complete status to a prior open status
Y/N Table Edit
Default Value: N
|
| 17 |
CANCEL_WO |
Character(1) |
VARCHAR2(1) NOT NULL |
Authorized to Cancel WO Task
Y/N Table Edit
Default Value: N
|
| 18 |
CREATE_WO_TMPL |
Character(1) |
VARCHAR2(1) NOT NULL |
Authorized to create WO templates
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_VW3
|
| 21 |
ASSET_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Asset Type
010=IT Hardware
020=IT Software
040=Equipment
050=Property
060=Fleet
070=Machinery
080=Furniture
090=Facility
100=Intangible
200=Asset Retirement Obligations
999=Other
|
| 22 |
WO_TRANS_TMPL |
Character(1) |
VARCHAR2(1) NOT NULL |
User preferences option for "Authorized to create WO Transaction Template"
|
| 23 |
WO_VIEW_TASK |
Character(1) |
VARCHAR2(1) NOT NULL |
This flag dicatates if a Work Managment Technician has access to view another technicians task(s)
Y/N Table Edit
Default Value: N
|
| 24 |
COPY_WO |
Character(1) |
VARCHAR2(1) NOT NULL |
Copy To New Work Order
Y/N Table Edit
Default Value: N
|
| 25 |
VIEW_LABOR |
Character(1) |
VARCHAR2(1) NOT NULL |
This is a user preferences option for Work Management. It allows authorized people to view labor rates.
Y/N Table Edit
Default Value: N
|
| 26 |
VIEW_TOOLS |
Character(1) |
VARCHAR2(1) NOT NULL |
This is a user preferences option for Work Management. It allows authorized people to view tools rates.
Y/N Table Edit
Default Value: N
|
| 27 |
RS_RSRCGRP_NAME |
Character(15) |
VARCHAR2(15) NOT NULL |
Resource Group ID
Prompt Table:
WM_RSRCGRP
|
| 28 |
RUN_PICK_PLAN |
Character(1) |
VARCHAR2(1) NOT NULL |
This is a user preferences option for Work Management. This flag allows the person to run the Pick Plan to Pick parts for a work order.
Y/N Table Edit
Default Value: N
|
| 29 |
COST_RECOVERY_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Work Mangement user preferences to authorize cost recovery claim
Y/N Table Edit
Default Value: N
|
| 30 |
CAPITALIZATION_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Work Management user preferences option to override capitalization limit
Y/N Table Edit
Default Value: N
|
| 31 |
CAL_ITEM_LINK_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Calendar Item Link Option
1=Technician Workbench
3=Work Order
Default Value: 3
|
| 32 |
WO_ALLOW_ASSETACT |
Character(1) |
VARCHAR2(1) NOT NULL |
Authorized to set asset action is a field used in Work Management user preferences
Y/N Table Edit
Default Value: N
|
| 33 |
TIME_RPTR_METH |
Character(1) |
VARCHAR2(1) NOT NULL |
Time Report Method
E=Elapsed Time
P=Punch Time
Default Value: E
|
| 34 |
WM_TIME_SUBMIT |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Submit Time for Posting
Y/N Table Edit
Default Value: Y
|
| 35 |
WM_VIEW_ACCESS |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Access to Search Views
Y/N Table Edit
Default Value: Y
|
| 36 |
WO_ALLOW_RESERVE |
Character(1) |
VARCHAR2(1) NOT NULL |
Maintenance Mangement Allow on-line reserve of inventory items
Y/N Table Edit
Default Value: N
|
| 37 |
WM_WO_ACCESS_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Access to WO Security
Y/N Table Edit
Default Value: Y
|
| 38 |
UPDATE_METRICS_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Update Crew Schedule Metrics
Y/N Table Edit
Default Value: N
|
| 39 |
APPLY_WOA_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Apply WO Access Security
Y/N Table Edit
Default Value: Y
|
| 40 |
OVERRIDE_MT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag to signal whether a user is authorized to Complete Work Order Tasks
Y/N Table Edit
Default Value: N
|
| 41 |
REP_COMPLETION_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag to signal whether a user is authorized to report Crew Assignment Completion
Y/N Table Edit
Default Value: N
|
| 42 |
REP_REM_HRS_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag to authorize user to report carryover man hours
Y/N Table Edit
Default Value: N
|
| 43 |
WO_DFLT_EPL_UPDT |
Character(1) |
VARCHAR2(1) NOT NULL |
Y/N option field for MM User Preferences, authorizes update of asset-default EPL templates
Y/N Table Edit
Default Value: N
|
| 44 |
WO_GENL_EPL_UPDT |
Character(1) |
VARCHAR2(1) NOT NULL |
Y/N option field for MM User Preferences, authorizes update of non-specific ("non asset-default") EPL templates
Y/N Table Edit
Default Value: N
|
| 45 |
WM_ACTL_HRS_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Enable Actual Hours
Y/N Table Edit
Default Value: N
|
| 46 |
WM_MASSCHG_HRS_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Mass Change Hours
Y/N Table Edit
Default Value: N
|
| 47 |
WM_DISPLAY_ROWS |
Signed Number(7,0) |
DECIMAL(6) NOT NULL |
Determine number of rows to display in the grid
Default Value: 300
|
| 48 |
WM_DISPLAY_ROWS2 |
Signed Number(7,0) |
DECIMAL(6) NOT NULL |
Determine number of rows to display in the grid
Default Value: 300
|