| # |
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
Prompt Table:
SP_BU_WM_NONVW
|
| 2 |
WO_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Work Order Identification
|
| 3 |
WO_TASK_ID |
Number(5,0) |
INTEGER NOT NULL |
Task Number
Default Value: 1
|
| 4 |
SEQ_NBR_5 |
Number(5,0) |
INTEGER NOT NULL |
Sequence number five digits long
|
| 5 |
BUSINESS_UNIT_PC |
Character(5) |
VARCHAR2(5) NOT NULL |
PC Business Unit
Default Value: BUS_UNIT_TBL_WM.BUSINESS_UNIT_PC
|
| 6 |
BUSINESS_UNIT_AM |
Character(5) |
VARCHAR2(5) NOT NULL |
AM Business Unit
Prompt Table:
BUS_UNIT_AM_VW
|
| 7 |
ASSET_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Asset Identification
Prompt Table:
WM_ASSET_VWA
|
| 8 |
DEPEND_TASK_ID |
Number(8,0) |
INTEGER NOT NULL |
Dependent Task
Prompt Table:
WM_TSKDEP_VW
|
| 9 |
TASK_ID_ASSOC |
Character(18) |
VARCHAR2(18) NOT NULL |
Dependent Removal Task
|
| 10 |
WO_TASK_ID_TO |
Number(5,0) |
INTEGER NOT NULL |
To Task ID
Prompt Table:
WM_WO_TSK
|
| 11 |
OVERLAP_PERCENT |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Overlap Percentage
|
| 12 |
WO_DURATION |
Number(8,2) |
DECIMAL(7,2) NOT NULL |
Estimated Work Order Duration
Default Value: 1
|
| 13 |
ASSET_UP_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Asset in Production Flag
|
| 14 |
ASSET_LOCATION |
Character(10) |
VARCHAR2(10) NOT NULL |
Asset Location
Prompt Table:
LOCATION_VW
|
| 15 |
LOCATION |
Character(10) |
VARCHAR2(10) NOT NULL |
Location Code
Prompt Table:
LOCATION_TBL
|
| 16 |
DESCR254 |
Character(254) |
VARCHAR2(254) NOT NULL |
Description of length 254
Default Value: WM_WO_HDR.DESCR254
|
| 17 |
STATUS_CD |
Character(4) |
VARCHAR2(4) NOT NULL |
User defined Status Code
Prompt Table:
WM_STATUS_TSK
|
| 18 |
INTERNAL_STATUS |
Character(2) |
VARCHAR2(2) NOT NULL |
Internal Status
01=Open
02=Awaiting Schedule
03=Scheduled
04=Work In Progress
05=Complete
06=Closed
07=Canceled
08=On Hold
09=Work Order Created
|
| 19 |
STATUS_DTTM |
DateTime(26) |
TIMESTAMP |
05/13/02 EGS (CN#PL900-1): Added
|
| 20 |
REQ_START_DT |
Date(10) |
DATE |
Required Start
Default Value: WM_WO_HDR.REQ_START_DT
|
| 21 |
REQ_START_TIME |
Time(15) |
TIMESTAMP |
Required Start Time
|
| 22 |
SCHED_START_DT |
Date(10) |
DATE |
Scheduled Start Date
|
| 23 |
SCHED_START_TIME |
Time(15) |
TIMESTAMP |
Schedule Start Time
|
| 24 |
SCHED_END_DT |
Date(10) |
DATE |
Scheduled End Date
|
| 25 |
SCHED_END_TIME |
Time(15) |
TIMESTAMP |
Schedule End Time
|
| 26 |
REQ_END_DT |
Date(10) |
DATE |
Required End
Default Value: WM_WO_HDR.REQ_END_DT
|
| 27 |
REQ_END_TIME |
Time(15) |
TIMESTAMP |
Required End Time
|
| 28 |
ACTL_END_DTTM |
DateTime(26) |
TIMESTAMP |
Actual End Date/Time
|
| 29 |
ACTL_START_DT |
Date(10) |
DATE |
Actual Start Date
|
| 30 |
ACTL_START_TIME |
Time(15) |
TIMESTAMP |
Actual Start Time
|
| 31 |
ACTL_END_DT |
Date(10) |
DATE |
Actual End Date
|
| 32 |
ACTL_END_TIME |
Time(15) |
TIMESTAMP |
Actual End Time
|
| 33 |
ACTL_START_DTTM |
DateTime(26) |
TIMESTAMP |
Actual Start Date/Time
|
| 34 |
IS_PASSIVE_PROJECT |
Character(1) |
VARCHAR2(1) NOT NULL |
Passive Project Indicator
Y/N Table Edit
|
| 35 |
PROJECT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Project Id ChartField
Default Value: WM_WO_HDR.PROJECT_ID
Prompt Table:
WM_PC_PRJ_VW
|
| 36 |
ACTIVITY_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Activity ID
Prompt Table:
PROJ_ACT_FS
|
| 37 |
SCHEDULER_CODE |
Character(10) |
VARCHAR2(10) NOT NULL |
Scheduler Code
Prompt Table:
WM_SCHEDULER_VW
|
| 38 |
LEAD_PERSON |
Character(30) |
VARCHAR2(30) NOT NULL |
Lead Person
Prompt Table:
%EDITTABLE10
|
| 39 |
CLOSED_DT |
Date(10) |
DATE |
Date Closed
|
| 40 |
COMPLTED_DT |
Date(10) |
DATE |
Completed Date
|
| 41 |
EST_COST_LBR |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Estimated Labor Cost
|
| 42 |
EST_COST_MAT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Estimated Material Cost
|
| 43 |
EST_COST_TLS |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Estimated Tools Cost
|
| 44 |
EST_COST_PO |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Estimated Procurement costs for a work order
|
| 45 |
SCHED_COST_LBR |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
This field will be used by WOM to store Scheduled Labor Cost
|
| 46 |
SCHED_COST_MAT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Cost of Scheduled Materials
|
| 47 |
SCHED_COST_TLS |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Schedule Tools Cost
|
| 48 |
SCHED_COST_PO |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
This field will be used to store the Scheduled cost of Procurement
|
| 49 |
ACTL_COST_LBR |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Actual Labor Cost
|
| 50 |
ACTL_COST_MAT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Actual Cost
|
| 51 |
ACTL_COST_TLS |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Actual Tools Cost
|
| 52 |
ACTL_COST_PO |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Actual procurement costs for a work order
|
| 53 |
ASSET_DOWNTIME_HRS |
Number(32,3) |
DECIMAL(31,3) NOT NULL |
Asset Downtime
|
| 54 |
FAILURE_DT |
Date(10) |
DATE |
Failure date
|
| 55 |
DOWNTIME_RATE |
Number(32,3) |
DECIMAL(31,3) NOT NULL |
Downtime rate
|
| 56 |
RECOVER_COST_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Attempt to Recover Cost flag
Y/N Table Edit
Default Value: N
|
| 57 |
WARRANTY_NAME |
Character(40) |
VARCHAR2(40) NOT NULL |
This field is used to store the name of the warranty.
Prompt Table:
WM_ASSET_WRTYVW
|
| 58 |
VENDOR_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Identifier
Prompt Table:
VNDR_FS
|
| 59 |
CNTCT_SEQ_NUM |
Number(5,0) |
INTEGER NOT NULL |
Contact Sequence Number
Prompt Table:
VENDOR_CNTCT
|
| 60 |
CLAIM_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Claim ID
|
| 61 |
PROBLEM_GROUP |
Character(15) |
VARCHAR2(15) NOT NULL |
Problem Group
Prompt Table:
WM_PCR_CLSF_DVW
|
| 62 |
PROBLEM_CD |
Character(15) |
VARCHAR2(15) NOT NULL |
Problem code
Prompt Table:
WM_PCR_PRBAC_VW
|
| 63 |
CAUSE_CD |
Character(15) |
VARCHAR2(15) NOT NULL |
Cause Code
Prompt Table:
WM_PCR_CSEAC_VW
|
| 64 |
RESOLUTION_CD |
Character(15) |
VARCHAR2(15) NOT NULL |
Resolution code
Prompt Table:
WM_PCR_RESAC_VW
|
| 65 |
TASK_ACTION |
Character(1) |
VARCHAR2(1) NOT NULL |
The purpose of this field is to identify the kind of action that may be done for a task.
1=No Change
2=Install Component
3=Repair
4=Remove
5=Retire
6=Remove and Sell
7=Replacement asset
8=Ownership Change
Default Value: 1
|
| 66 |
NEEDS_REPAIR_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Needs Repair Indicator
Y/N Table Edit
Default Value: N
|
| 67 |
SUPERVISOR |
Character(30) |
VARCHAR2(30) NOT NULL |
Supervisor
Prompt Table:
WM_SHOP_RES_VW2
|
| 68 |
RES_LBR_EXIST |
Character(1) |
VARCHAR2(1) NOT NULL |
Labor exists flag - used on WO
Y/N Table Edit
Default Value: N
|
| 69 |
RES_TLS_EXIST |
Character(1) |
VARCHAR2(1) NOT NULL |
Tools exists flag - indicates if Tools exists on a WO
Y/N Table Edit
Default Value: N
|
| 70 |
RES_MAT_EXIST |
Character(1) |
VARCHAR2(1) NOT NULL |
Inventory exists flag - indicates if inventory exists on WO
Y/N Table Edit
Default Value: N
|
| 71 |
RES_PO_EXIST |
Character(1) |
VARCHAR2(1) NOT NULL |
Procurement exists flag - indicates if Procurement exists in WO
Y/N Table Edit
Default Value: N
|
| 72 |
LAST_RQMTLN_TLS |
Number(8,0) |
INTEGER NOT NULL |
Requirement Line Number
Default Value: 1
|
| 73 |
LAST_RQMTLN_LBR |
Number(8,0) |
INTEGER NOT NULL |
Requirement Line Number
Default Value: 1
|
| 74 |
LAST_SCHEDLN_LBR |
Number(8,0) |
INTEGER NOT NULL |
Requirement Line Number
Default Value: 1
|
| 75 |
LAST_SCHEDLN_TLS |
Number(8,0) |
INTEGER NOT NULL |
Requirement Line Number
Default Value: 1
|
| 76 |
LAST_RQMTLN_MAT |
Number(8,0) |
INTEGER NOT NULL |
Last requirement resource number for Material resource row(s)
Default Value: 1
|
| 77 |
LAST_RQMTLN_PO |
Number(8,0) |
INTEGER NOT NULL |
Last requirement resource number for procured resource row(s)
Default Value: 1
|
| 78 |
LAST_SCHEDLN_MAT |
Number(8,0) |
INTEGER NOT NULL |
Last Schedule resource number for Material resource row(s)
Default Value: 1
|
| 79 |
LAST_SCHEDLN_PO |
Number(8,0) |
INTEGER NOT NULL |
Last Schedule resource number for procured resource row(s)
Default Value: 1
|
| 80 |
ALERT_INDICATOR |
Character(3) |
VARCHAR2(3) NOT NULL |
Note alert indicator
000=None
001=Outstanding Request
002=Reply Received
|
| 81 |
GEN_CHARGEBACK |
Character(1) |
VARCHAR2(1) NOT NULL |
Generate Chargeback field, used in Maintenance Management
Default Value: N
|
| 82 |
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
|
| 83 |
PC_TEMPLATE_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Rate Template ID
Prompt Table:
%EDITTABLE15
|
| 84 |
DISPOSAL_CODE |
Character(1) |
VARCHAR2(1) NOT NULL |
Retirement Type
A=Abandonment
C=Cannibalize for Other Assets
D=Disappeared Assets
E=Expensed
F=Disposal Due to Theft
I=Returned to Inventory
L=Like Kind Exchange
M=Missing Asset
N=Donated to External Group
O=ARO Settlement
R=Scrapped Assets
S=Retirement by Sale
T=Traded In for another Asset
V=Auto-Retire Fully Depr Assets
Y=Casualty Loss
|
| 85 |
CAPITALIZATION_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Work Management user preferences option to override capitalization limit
|
| 86 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Default Value: WM_WO_HDR.CURRENCY_CD
Prompt Table:
CURR_CD_EFF_VW
|
| 87 |
FILTER_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Filter criteria identification
Prompt Table:
WM_PC_AMFLTR_VW
|
| 88 |
CAPITALIZATION_MIN |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Capitalization Minimum
|
| 89 |
CAPITALIZE_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amount to be Capitalized
|
| 90 |
PROCESS_MAN_CLOSE |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Manual Close
N=No
P=Processed
Y=Yes
Default Value: N
|
| 91 |
CUSTODIAN |
Character(30) |
VARCHAR2(30) NOT NULL |
Custodian
|
| 92 |
COMPONENT_OF_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Component of Asset
Prompt Table:
WM_AM_COMPONENT
|
| 93 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table:
PERSONAL_DATA
|
| 94 |
DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Department
Prompt Table:
DEPT_TBL
|
| 95 |
WO_TEMPLATE_ID |
Character(25) |
VARCHAR2(25) NOT NULL |
Work Order Task/Job Template ID
|
| 96 |
WO_TASK_TMPLT_ID |
Character(25) |
VARCHAR2(25) NOT NULL |
WO Task Template ID (specific field)
|
| 97 |
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
|
| 98 |
INTERNAL_STAT_COMM |
Character(2) |
VARCHAR2(2) NOT NULL |
Work Order commit rule internal status.
02=Awaiting Schedule
03=Scheduled
04=Work In Progress
|
| 99 |
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
Default Value: 2
|
| 100 |
INTERNAL_STAT_RSRV |
Character(2) |
VARCHAR2(2) NOT NULL |
Work Order Reservation rule internal status.
02=Awaiting Schedule
03=Scheduled
04=Work In Progress
|
| 101 |
PRIORITY_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Priority
Default Value: 999
|
| 102 |
CREW_BU |
Character(5) |
VARCHAR2(5) NOT NULL |
Crew Business Unit
Prompt Table:
SP_BU_WM_NONVW
|
| 103 |
CREW_SHOP |
Character(10) |
VARCHAR2(10) NOT NULL |
Crew Shop ID
Prompt Table:
WM_CREWSHOP_VW
|
| 104 |
CREW_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Crew Name
Prompt Table:
WM_PREFCREW_VW
|
| 105 |
AREA_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Area ID
Prompt Table:
WM_AREA_PMT_VW
|
| 106 |
MAINT_TYPE |
Character(10) |
VARCHAR2(10) NOT NULL |
This field is used for maintenance type
|
| 107 |
WM_EIP_SNT_DTTM |
DateTime(26) |
TIMESTAMP |
Date/Time Last Sent
|
| 108 |
WM_EIP_UPD_DTTM |
DateTime(26) |
TIMESTAMP |
Date/Time Last Updated
|
| 109 |
LAST_UPDATED_BY |
Character(30) |
VARCHAR2(30) NOT NULL |
LastUpdatedUser
|
| 110 |
LAST_UPDATE_DTTM |
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
|