| # |
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.
|
| 5 |
BUSINESS_UNIT_AM |
Character(5) |
VARCHAR2(5) NOT NULL |
AM Business Unit
|
| 6 |
ASSET_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Asset Identification
|
| 7 |
TAG_NUMBER |
Character(12) |
VARCHAR2(12) NOT NULL |
Tag Number
|
| 8 |
SERIAL_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
Serial ID
|
| 9 |
VIN |
Character(18) |
VARCHAR2(18) NOT NULL |
VIN
|
| 10 |
SHOP_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Shop Identification
|
| 11 |
LOCATION |
Character(10) |
VARCHAR2(10) NOT NULL |
Location Code
|
| 12 |
RS_CALENDAR |
Character(1) |
VARCHAR2(1) NOT NULL |
Calendar field.
|
| 13 |
FIT_SCORE_QUA |
Signed Number(7,4) |
DECIMAL(5,4) NOT NULL |
Qualifications Fit Score
|
| 14 |
FIT_SCORE_AVA |
Signed Number(7,4) |
DECIMAL(5,4) NOT NULL |
Availability Fit Score
|
| 15 |
FIT_DISPLAY_QUA |
Character(15) |
VARCHAR2(15) NOT NULL |
Display qualification fitness score.
|
| 16 |
FIT_DISPLAY_AVA |
Character(15) |
VARCHAR2(15) NOT NULL |
Display availability fitness score.
|
| 17 |
SELECT_PB |
Character(1) |
VARCHAR2(1) NOT NULL |
Refresh
|
| 18 |
WO_TASK_ROW_NBR |
Number(5,0) |
INTEGER NOT NULL |
Task Row Number
|
| 19 |
WO_SCHED_ROW_NBR |
Number(5,0) |
INTEGER NOT NULL |
Schedule Row Number
|