| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 2 |
WO_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Work Order Identification
|
| 3 |
WO_TASK_ID |
Number(5,0) |
INTEGER NOT NULL |
Task Number
|
| 4 |
RES_LN_NBR |
Number(5,0) |
INTEGER NOT NULL |
Resource Line No.
Default Value: WM_WO_TSK.LAST_SCHEDLN_LBR
|
| 5 |
RQMT_LN_NBR |
Number(5,0) |
INTEGER NOT NULL |
Requirement Line Number
|
| 6 |
CRAFT_ID |
Character(16) |
VARCHAR2(16) NOT NULL |
Craft Identification
Prompt Table:
RS_CRAFT_DETAIL
|
| 7 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table:
WM_ELGBL_WRKR
|
| 8 |
SCHED_START_DT |
Date(10) |
DATE |
Scheduled Start Date
Default Value: WM_WO_TSK.SCHED_START_DT
|
| 9 |
SCHED_START_TIME |
Time(15) |
TIMESTAMP |
Schedule Start Time
Default Value: WM_WO_TSK.SCHED_START_TIME
|
| 10 |
SCHED_END_DT |
Date(10) |
DATE |
Scheduled End Date
Default Value: WM_WO_TSK.SCHED_END_DT
|
| 11 |
SCHED_END_TIME |
Time(15) |
TIMESTAMP |
Schedule End Time
Default Value: WM_WO_TSK.SCHED_END_TIME
|
| 12 |
SCHED_DURATION |
Signed Number(9,2) |
DECIMAL(7,2) NOT NULL |
Scheduled Duration
|
| 13 |
SCHED_COST_LBR |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
This field will be used by WOM to store Scheduled Labor Cost
|
| 14 |
ACTL_START_DT |
Date(10) |
DATE |
Actual Start Date
|
| 15 |
ACTL_START_TIME |
Time(15) |
TIMESTAMP |
Actual Start Time
|
| 16 |
ACTL_END_DT |
Date(10) |
DATE |
Actual End Date
|
| 17 |
ACTL_END_TIME |
Time(15) |
TIMESTAMP |
Actual End Time
|
| 18 |
ACTL_DURATION |
Signed Number(9,2) |
DECIMAL(7,2) NOT NULL |
Actual Duration
|
| 19 |
ACTL_COST_LBR |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Actual Labor Cost
|
| 20 |
LABOR_COST_RATE |
Number(27,3) |
DECIMAL(26,3) NOT NULL |
Cost Rate
|
| 21 |
LABOR_BILL_RATE |
Number(27,3) |
DECIMAL(26,3) NOT NULL |
Billing Rate
|
| 22 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Default Value: BUS_UNIT_TBL_WM.BASE_CURRENCY
|
| 23 |
ASSIGNMENT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Work Assignment ID
|
| 24 |
PROCURE_STATUS |
Character(2) |
VARCHAR2(2) NOT NULL |
Indicates whether or not a Labor or a Tools resource in Maintenance Management is being procured.
1=No Procurement
2=Being Procured
Default Value: 1
|
| 25 |
MAX_DISTRIB_LINE |
Number(5,0) |
INTEGER NOT NULL |
Highest Distribution Line
|
| 26 |
SHOP_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Shop Identification
|
| 27 |
SHIFT_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Shift ID
|
| 28 |
CREW_BU |
Character(5) |
VARCHAR2(5) NOT NULL |
Crew Business Unit
Prompt Table:
SP_BU_WM_NONVW
|
| 29 |
CREW_SHOP |
Character(10) |
VARCHAR2(10) NOT NULL |
Crew Shop ID
Prompt Table:
WM_CREWSHOP_VW
|
| 30 |
CREW_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Crew Name
Prompt Table:
WM_PREFCREW_VW
|
| 31 |
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
|
| 32 |
ACTL_SOURCE_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
Actuals Source Code
2=Multiple Sources
A=Actual Hours
I=Mobile Inspection
M=My Tasks
T=Elapsed Time Entry
W=Work Order Completion
|
| 33 |
TIME_SHEET_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Time Sheet Unique Identifier (System Generated)
|
| 34 |
TIME1 |
Signed Number(6,2) |
DECIMAL(4,2) NOT NULL |
TIME1
|
| 35 |
TIME2 |
Signed Number(6,2) |
DECIMAL(4,2) NOT NULL |
TIME2
|
| 36 |
TIME3 |
Signed Number(6,2) |
DECIMAL(4,2) NOT NULL |
TIME3
|
| 37 |
TIME4 |
Signed Number(6,2) |
DECIMAL(4,2) NOT NULL |
TIME4
|
| 38 |
TIME5 |
Signed Number(6,2) |
DECIMAL(4,2) NOT NULL |
TIME5
|
| 39 |
TIME6 |
Signed Number(6,2) |
DECIMAL(4,2) NOT NULL |
TIME6
|
| 40 |
TIME7 |
Signed Number(6,2) |
DECIMAL(4,2) NOT NULL |
TIME7
|
| 41 |
COMMENT1 |
Character(254) |
VARCHAR2(254) NOT NULL |
Comments
|
| 42 |
LAST_UPDATED_BY |
Character(30) |
VARCHAR2(30) NOT NULL |
LastUpdatedUser
|
| 43 |
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
|