| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Prompt Table:
PSOPRDEFN
|
| 2 |
TSK_SRCH_VIEW |
Character(30) |
VARCHAR2(30) NOT NULL |
Task Search View name
Prompt Table:
%EDITTABLE
|
| 3 |
TSK_SRCH_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
Task Search code. The Task Search page is utilized by several components. This indicator to provide some categorization for between views stored in the WM_TSK_SRCH table.
CS=Crew Scheduling Workbench
LA=Labor Assignment Workbench
MI=Mobile Inspections
RP=Report
SW=Scheduler Workbench
TW=Technician Workbench
WP=Track Work Progress
|
| 4 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table:
WM_ELGBL_WRKR
|
| 5 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_WM.BUSINESS_UNIT
Prompt Table:
SP_BU_WM_NONVW
|
| 6 |
WO_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Work Order Identification
Prompt Table:
%EDITTABLE2
|
| 7 |
WO_TASK_ID |
Number(5,0) |
INTEGER NOT NULL |
Task Number
Prompt Table:
%EDITTABLE3
|
| 8 |
BUSINESS_UNIT_WR |
Character(5) |
VARCHAR2(5) NOT NULL |
Work Request Business Unit
Prompt Table:
SP_BU_WR_NONVW
|
| 9 |
WR_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Work Request ID
Prompt Table:
WM_WOE_WRPMT_VW
|
| 10 |
WO_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Work Order Type
Prompt Table:
WM_WO_TYPE
|
| 11 |
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
|
| 12 |
ACTL_START_DT |
Date(10) |
DATE |
Actual Start Date
|
| 13 |
ACTL_END_DT |
Date(10) |
DATE |
Actual End Date
|
| 14 |
ACTL_SRCH_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
Task Search Date Start or End indicator.
1=Actual Start
2=Actual End
Default Value: 1
|
| 15 |
ACTL_DT_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Actual date
1=Exists
2=Not Exists
3=Today
4=Date Range
Default Value: 4
|
| 16 |
SCHED_START_DT |
Date(10) |
DATE |
Scheduled Start Date
|
| 17 |
SCHED_END_DT |
Date(10) |
DATE |
Scheduled End Date
|
| 18 |
SCHED_SRCH_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
Task Search Date Start or End indicator.
1=Scheduled Start
2=Scheduled End
Default Value: 1
|
| 19 |
SCHED_DT_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Schedule date
1=Exists
2=Not Exists
3=Today
4=Date Range
Default Value: 4
|
| 20 |
REQ_START_DT |
Date(10) |
DATE |
Required Start
|
| 21 |
REQ_END_DT |
Date(10) |
DATE |
Required End
|
| 22 |
REQ_SRCH_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
Task Search Date Start or End indicator.
1=Required Start
2=Required End
Default Value: 1
|
| 23 |
REQ_DT_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Required date
1=Exists
2=Not Exists
3=Today
4=Date Range
Default Value: 4
|
| 24 |
LOCATION |
Character(10) |
VARCHAR2(10) NOT NULL |
Location Code
Prompt Table:
LOCATION_TBL
|
| 25 |
LOCATION_IN_LIST |
Character(254) |
VARCHAR2(254) NOT NULL |
Location In List
|
| 26 |
ENTERED_DT_FROM |
Date(10) |
DATE |
Field used in Voucher Maintenance Search component
|
| 27 |
ENTERED_DT_TO |
Date(10) |
DATE |
Field used in Voucher Maintenance Search component
|
| 28 |
SHOP_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Shop Identification
Prompt Table:
%EDITTABLE4
|
| 29 |
ENTERED_BY |
Character(30) |
VARCHAR2(30) NOT NULL |
Entered by
Prompt Table:
WM_OPR_NAME_VW
|
| 30 |
BUSINESS_UNIT_PC |
Character(5) |
VARCHAR2(5) NOT NULL |
PC Business Unit
Prompt Table:
SP_BU_PC_NONVW
|
| 31 |
PROJECT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Project Id ChartField
Prompt Table:
%EDITTABLE5
|
| 32 |
ACTIVITY_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Activity ID
Prompt Table:
%EDITTABLE6
|
| 33 |
BUSINESS_UNIT_AM |
Character(5) |
VARCHAR2(5) NOT NULL |
AM Business Unit
Prompt Table:
SP_BU_AM_NONVW
|
| 34 |
ASSET_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Asset Identification
Prompt Table:
WM_WOE_AMPMT_VW
Set Control Field: BUSINESS_UNIT_AM
|
| 35 |
PROBLEM_GROUP |
Character(15) |
VARCHAR2(15) NOT NULL |
Problem Group
Prompt Table:
WM_PCR_GROUP
|
| 36 |
PROBLEM_CD |
Character(15) |
VARCHAR2(15) NOT NULL |
Problem code
Prompt Table:
WM_PCR_PROB_VW
|
| 37 |
CAUSE_CD |
Character(15) |
VARCHAR2(15) NOT NULL |
Cause Code
Prompt Table:
WM_PCR_CAUSE_VW
|
| 38 |
RESOLUTION_CD |
Character(15) |
VARCHAR2(15) NOT NULL |
Resolution code
Prompt Table:
WM_PCR_RES_VW
|
| 39 |
SRVC_GRP_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Service Group
Prompt Table:
WM_SRVC_GRP
|
| 40 |
WO_APPROVAL_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
work order approval status
A=Approved
C=Cancelled
E=Denied
I=Initial
P=Pending Approval
|
| 41 |
BASIS_DT_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
Track WO progress Basis Date indicator.
1=Scheduled Start date
2=Scheduled End date
3=Scheduled Start or End
Default Value: 2
|
| 42 |
STANDING_WO_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Standing Work Order indicator
N=Non-Standing
Y=Standing
|
| 43 |
PM_SCHD_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Preventive Maintenance Schedule ID
Prompt Table:
WM_TSKSRC_PM_VW
|
| 44 |
PM_SRCH_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
PM Search Code
1=PM Work Orders only
2=Non-PM Work Orders only
3=PM Schedule ID
Default Value: 3
|
| 45 |
AREA_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Area ID
Prompt Table:
WM_AREA_PMT_VW
Set Control Field: BUSINESS_UNIT_AM
|
| 46 |
ASSET_CRITICALITY |
Character(2) |
VARCHAR2(2) NOT NULL |
Asset Criticality
Prompt Table:
AM_CRIT_LVL
|
| 47 |
ASSET_LOCATION |
Character(10) |
VARCHAR2(10) NOT NULL |
Asset Location
Prompt Table:
LOCATION_TBL
Set Control Field: BUSINESS_UNIT_AM
|
| 48 |
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
|
| 49 |
ASSET_SUBTYPE |
Character(15) |
VARCHAR2(15) NOT NULL |
Asset Subtype
Prompt Table:
AM_SUBTYPE
Set Control Field: BUSINESS_UNIT_AM
|
| 50 |
MFG_ID |
Character(50) |
VARCHAR2(50) NOT NULL |
Manufacturer ID
Prompt Table:
MANUFACTURER
Set Control Field: BUSINESS_UNIT_AM
|
| 51 |
MODEL |
Character(30) |
VARCHAR2(30) NOT NULL |
Model
Prompt Table:
MFG_MODEL
Set Control Field: BUSINESS_UNIT_AM
|
| 52 |
CRAFT_ID |
Character(16) |
VARCHAR2(16) NOT NULL |
Craft Identification
Prompt Table:
RS_CRAFT_DETAIL
|
| 53 |
CREW_BU |
Character(5) |
VARCHAR2(5) NOT NULL |
Crew Business Unit
Prompt Table:
WM_CREW_DEFN
|
| 54 |
CREW_SHOP |
Character(10) |
VARCHAR2(10) NOT NULL |
Crew Shop ID
Prompt Table:
WM_CREW_PMT_VW
|
| 55 |
CREW_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Crew Name
Prompt Table:
WM_CREW_PMT2_VW
|
| 56 |
CREW_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
View Tasks without Crew
Y/N Table Edit
Default Value: N
|
| 57 |
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
|
| 58 |
TOOLS_REQ_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Tool Required
Y/N Table Edit
Default Value: N
|
| 59 |
TOOLS_ASSET_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Tools Asset Type
010=IT Hardware
020=IT Software
040=Equipment
050=Property
060=Fleet
070=Furniture
080=Facility
100=Intangible
999=Other
|
| 60 |
TOOLS_ASSET_SUBTYP |
Character(15) |
VARCHAR2(15) NOT NULL |
Tools Asset Subtype
Prompt Table:
WM_TLS_SUBTY_VW
Set Control Field: BUSINESS_UNIT_AM
|
| 61 |
SCHEDULING_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Scheduling Status
1=Unscheduled
2=Scheduled
3=Carryover Work
4=Review Entire Crew Schedule
|
| 62 |
SCHED_PERIOD |
Character(1) |
VARCHAR2(1) NOT NULL |
Schedule Period
1=Previous Period
2=Current Period
3=Next Period
4=Following Period
5=Specific Period
|
| 63 |
PERIOD_START_DT |
Date(10) |
DATE |
Represents the date commencement point for a given time set utilized in cash worksheet processing.
Prompt Table:
WM_CREWSCHD_DVW
|
| 64 |
SRCH_OPR_1 |
Character(2) |
VARCHAR2(2) NOT NULL |
Field search operator
<=Less than
<==Less than or equals
==Equals
>=Greater than
>==Greater than or equals
Default Value: =
|
| 65 |
SRCH_OPR_2 |
Character(2) |
VARCHAR2(2) NOT NULL |
Field search operator
<=Less than
<==Less than or equals
==Equals
>=Greater than
>==Greater than or equals
Default Value: =
|
| 66 |
SRCH_OPR_3 |
Character(2) |
VARCHAR2(2) NOT NULL |
Field search operator
<=Less than
<==Less than or equals
==Equals
>=Greater than
>==Greater than or equals
Default Value: =
|
| 67 |
SRCH_OPR_4 |
Character(2) |
VARCHAR2(2) NOT NULL |
Field search operator
<=Less than
<==Less than or equals
==Equals
>=Greater than
>==Greater than or equals
Default Value: =
|
| 68 |
LAST_VIEW_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Last View used flag.
Y/N Table Edit
Default Value: N
|
| 69 |
PUBLIC_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Public
Y/N Table Edit
Default Value: N
|
| 70 |
VIEW_MODE |
Character(1) |
VARCHAR2(1) NOT NULL |
View Mode
1=Crew Scheduled
2=Non-Crew Scheduled
|
| 71 |
WM_CUR_EMPLID_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Assigned to current Technician
Default Value: N
|
| 72 |
TASK_DESCR |
Character(254) |
VARCHAR2(254) NOT NULL |
Task Description
|
| 73 |
ASSET_DESCR |
Character(254) |
VARCHAR2(254) NOT NULL |
Asset Description
|
| 74 |
UNASSIGNED |
Character(1) |
VARCHAR2(1) NOT NULL |
Field used to indicate an unassigned pool
N=No
Y=Yes
Default Value: N
|
| 75 |
WO_INSPECT_STATUS |
Character(2) |
VARCHAR2(2) NOT NULL |
Inspection Status
01=Created
02=Assigned
03=In Progress
09=Completed
99=Terminated
|
| 76 |
WM_SCHED_FROM |
Character(2) |
VARCHAR2(2) NOT NULL |
Scheduled Start Relative Date Range
01=Last Week
02=Last Month
03=This Week
04=This Month
05=Next Week
06=Next Month
|
| 77 |
WM_SCHED_TO |
Character(2) |
VARCHAR2(2) NOT NULL |
Scheduled Start Relative Date Range
01=Last Week
02=Last Month
03=This Week
04=This Month
05=Next Week
06=Next Month
|