| # |
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_WM.OPRID
Prompt Table:
OPR_DEF_TBL_WM
Set Control Field: OPRID
|
| 2 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 3 |
REQUEST_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Request ID
Default Value: 1
|
| 4 |
PROCESS_FREQUENCY |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Frequency
A=Always Process
N=Don't Run
O=Process Once
Default Value: A
|
| 5 |
PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 6 |
PROCESS_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Status
A=Active
C=Successfully Completed
E=Completed With Errors
N=Not Yet Processed
P=Processing Now
X=No Success
|
| 7 |
DTTM_STAMP_SEC |
DateTime(26) |
TIMESTAMP |
Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
Default Value: %Datetime
|
| 8 |
WM_MTRDY_REPT_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Analyze Material Readiness for
1=Inventory Items Only
2=Procured Items Only
3=Inventory and Procured Items
Default Value: 3
|
| 9 |
WM_MTRDY_EXCPT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Include Exception Detail
Y/N Table Edit
Default Value: Y
|
| 10 |
WO_BAR_CODE |
Character(1) |
VARCHAR2(1) NOT NULL |
Produce Bar Codes, yes or no
Y/N Table Edit
Default Value: N
|
| 11 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_WM.BUSINESS_UNIT
Prompt Table:
SP_BU_WM_NONVW
|
| 12 |
SRVC_GRP_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Service Group
Prompt Table:
WM_SRVC_GRP
|
| 13 |
WO_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Work Order Type
Prompt Table:
WM_WO_TYPE
|
| 14 |
WO_ID_FROM |
Character(10) |
VARCHAR2(10) NOT NULL |
Work Order ID From
Prompt Table:
WM_WO_HDR
|
| 15 |
WO_ID_TO |
Character(10) |
VARCHAR2(10) NOT NULL |
Work Order ID To
Prompt Table:
WM_WO_HDR
|
| 16 |
SHOP_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Shop Identification
Prompt Table:
WM_SHOP_DEFN
|
| 17 |
SCHEDULER_CODE |
Character(10) |
VARCHAR2(10) NOT NULL |
Scheduler Code
Prompt Table:
WM_SCHEDULER_VW
|
| 18 |
CREW_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Crew Name
Prompt Table:
WM_CREW_DEFN
|
| 19 |
CRAFT_ID |
Character(16) |
VARCHAR2(16) NOT NULL |
Craft Identification
Prompt Table:
RS_CRAFT_DETAIL
|
| 20 |
BUSINESS_UNIT_PC |
Character(5) |
VARCHAR2(5) NOT NULL |
PC Business Unit
Prompt Table:
SP_BU_PC_NONVW
|
| 21 |
PROJECT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Project Id ChartField
Prompt Table:
WM_WOE_PCPMT_VW
|
| 22 |
ACTIVITY_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Activity ID
Prompt Table:
WM_WOE_ACPMT_VW
|
| 23 |
BUSINESS_UNIT_AM |
Character(5) |
VARCHAR2(5) NOT NULL |
AM Business Unit
Prompt Table:
SP_BU_AM_NONVW
|
| 24 |
ASSET_LOCATION |
Character(10) |
VARCHAR2(10) NOT NULL |
Asset Location
Prompt Table:
LOCATION_VW
Set Control Field: BUSINESS_UNIT_AM
|
| 25 |
AREA_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Area ID
Prompt Table:
WM_AREA_PMT_VW
Set Control Field: BUSINESS_UNIT_AM
|
| 26 |
ASSET_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Asset Identification
Prompt Table:
WM_WOE_AMPMT_VW
|
| 27 |
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
|
| 28 |
ASSET_SUBTYPE |
Character(15) |
VARCHAR2(15) NOT NULL |
Asset Subtype
Prompt Table:
AM_SUBTYPE
Set Control Field: BUSINESS_UNIT_AM
|
| 29 |
INV_ITEM_GROUP |
Character(15) |
VARCHAR2(15) NOT NULL |
Item Group
Prompt Table:
INV_ITEM_GROUP
|
| 30 |
WM_MTRDY_DTSEL_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Date Selection Options
1=Required Start
2=Required End
3=Scheduled Start
4=Scheduled End
5=Item Need/Due
Default Value: 1
|
| 31 |
WM_MTRDY_DTRNG_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Date Range Options
1=less than or equal to
2=date range from
Default Value: 1
|
| 32 |
DAYS_INTERVAL |
Number(2,0) |
SMALLINT NOT NULL |
Today's Date plus
|
| 33 |
DATE_FROM |
Date(10) |
DATE |
Date From
|
| 34 |
DATE_TO |
Date(10) |
DATE |
Date To
|