| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table:
SP_BUMGOP_NONVW
|
| 3 |
PRODUCTION_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Production ID
|
| 4 |
OP_SEQUENCE |
Number(4,0) |
SMALLINT NOT NULL |
Operation Sequence
|
| 5 |
INV_ITEM_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Item ID
Prompt Table:
SF_PA_IT_ID_VW
|
| 6 |
REF_ROUTING_ITEM |
Character(18) |
VARCHAR2(18) NOT NULL |
Reference Routing Item
|
| 7 |
PRODUCTION_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
JNW 11/1/98 (CN#SF800-13) activated teardown xlat
PR=Production
RW=Rework
SV=Service
TD=Teardown
|
| 8 |
RTG_CODE |
Number(2,0) |
SMALLINT NOT NULL |
Routing Code
Default Value: 1
|
| 9 |
TASK_INTENSITY |
Character(1) |
VARCHAR2(1) NOT NULL |
Intensity
0=Labor Time
1=Mach Time
2=Longest
3=Cumulative
Default Value: 2
|
| 10 |
SF_RESRC_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Resource Type
10=Crew
30=Machine
50=Tool
|
| 11 |
NEW_PRDN_QTY |
Number(12,4) |
DECIMAL(11,4) NOT NULL |
Production Start Qty
|
| 12 |
ASSY_STARTS_QTY |
Number(12,4) |
DECIMAL(11,4) NOT NULL |
Assembly Starts Qty
|
| 13 |
EXPECTED_PRDN_QTY |
Number(12,4) |
DECIMAL(11,4) NOT NULL |
Production End Qty
|
| 14 |
OPERATION_YIELD |
Number(8,4) |
DECIMAL(7,4) NOT NULL |
Operation Yield
|
| 15 |
CUM_YIELD |
Number(8,4) |
DECIMAL(7,4) NOT NULL |
Expected Yield %
|
| 16 |
QTY_COMP_AND_THRU |
Number(12,4) |
DECIMAL(11,4) NOT NULL |
Qty Completed and Thru Oper
|
| 17 |
QTY_SCRAPPED |
Number(12,4) |
DECIMAL(11,4) NOT NULL |
Assembly Qty Scrapped at Op
|
| 18 |
CREW_CODE |
Character(10) |
VARCHAR2(10) NOT NULL |
Crew Name
Prompt Table:
EN_WC_CREW_VW
|
| 19 |
MACHINE_CODE |
Character(10) |
VARCHAR2(10) NOT NULL |
Machine Code
Prompt Table:
EN_WC_MACH_VW
|
| 20 |
WORK_CENTER_CODE |
Character(10) |
VARCHAR2(10) NOT NULL |
Work Center
|
| 21 |
IGNORE_CAPACITY |
Character(1) |
VARCHAR2(1) NOT NULL |
08/29/01 EGS (CN#PL900-1): Added.
Y/N Table Edit
Default Value: N
|
| 22 |
OP_COMPLETED |
Character(1) |
VARCHAR2(1) NOT NULL |
Operation Completed
Y/N Table Edit
Default Value: N
|
| 23 |
TIME_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Time / Resource Type
0100=Planning Labor Setup
0200=Planning Labor Fixed Run
0300=Planning Labor Run
0400=Planning Labor Post Prod
0500=Planning Machine Setup
0600=Planning Machine Fixed Run
0700=Planning Machine Run
0800=Planning Machine Post Prod
1100=Costing Labor Setup
1200=Costing Labor Fixed Run
1300=Costing Labor Run
1400=Costing Labor Post Prod
1500=Costing Machine Setup
1600=Costing Machine Fixed Run
1700=Costing Machine Run
1800=Costing Machine Post Prod
2000=Queue Time
3000=Intransit Time
|
| 24 |
OP_TIME |
Number(9,2) |
DECIMAL(8,2) NOT NULL |
Op Time
|
| 25 |
OP_RATE |
Number(9,2) |
DECIMAL(8,2) NOT NULL |
Op Rate
|
| 26 |
OP_TIME_UNIT |
Character(2) |
VARCHAR2(2) NOT NULL |
Time Unit
DY=Days
HR=Hours
MN=Minutes
|
| 27 |
OP_RATE_UNIT |
Character(2) |
VARCHAR2(2) NOT NULL |
Op Rate Unit
UD=Units/Day
UH=Units/Hour
UM=Units/Min
|
| 28 |
MACH_SETUP |
Signed Number(10,2) |
DECIMAL(8,2) NOT NULL |
Machine Setup
|
| 29 |
MACH_FIXED_RUN |
Signed Number(10,2) |
DECIMAL(8,2) NOT NULL |
Machine Fixed Run
|
| 30 |
MACH_RUN |
Signed Number(10,2) |
DECIMAL(8,2) NOT NULL |
Machine Run
|
| 31 |
MACH_TOTAL |
Signed Number(11,2) |
DECIMAL(9,2) NOT NULL |
Machine Total
|
| 32 |
LAB_SETUP |
Signed Number(10,2) |
DECIMAL(8,2) NOT NULL |
Labor Setup
|
| 33 |
LAB_FIXED_RUN |
Signed Number(10,2) |
DECIMAL(8,2) NOT NULL |
Labor Fixed Run
|
| 34 |
LAB_RUN |
Signed Number(10,2) |
DECIMAL(8,2) NOT NULL |
Labor Run
|
| 35 |
LAB_TOTAL |
Signed Number(11,2) |
DECIMAL(9,2) NOT NULL |
Labor Total
|
| 36 |
TOTAL_RUN |
Signed Number(10,2) |
DECIMAL(8,2) NOT NULL |
Total Run Time
|
| 37 |
TIME_REMAINING |
Signed Number(16,5) |
DECIMAL(14,5) NOT NULL |
Time Remaining
|
| 38 |
SETUP_TIME |
Signed Number(10,2) |
DECIMAL(8,2) NOT NULL |
Setup
|
| 39 |
INCLUDE_SETUP |
Character(1) |
VARCHAR2(1) NOT NULL |
Include Setup in Lead Time
N=No
Y=Yes
Y/N Table Edit
Default Value: Y
|
| 40 |
QUEUE_TIME |
Number(9,2) |
DECIMAL(8,2) NOT NULL |
Default Queue Time
|
| 41 |
MOVE_TIME |
Number(9,2) |
DECIMAL(8,2) NOT NULL |
Move Time
|
| 42 |
PARM |
Character(1) |
VARCHAR2(1) NOT NULL |
Parameters
|
| 43 |
LEVEL_CNT |
Number(3,0) |
SMALLINT NOT NULL |
Level Count
|
| 44 |
AE_SECTION |
Character(8) |
VARCHAR2(8) NOT NULL |
Section
|
| 45 |
SCHEDULING_METHOD |
Character(3) |
VARCHAR2(3) NOT NULL |
Scheduling Method
BWD=Backward
FWD=Forward
|
| 46 |
NEW_START_DATE |
Date(10) |
DATE |
Start Date
|
| 47 |
NEW_START_TIME |
Time(15) |
TIMESTAMP |
Start Time
|
| 48 |
NEW_START_SHIFT |
Signed Number(2,0) |
DECIMAL(1) NOT NULL |
Start Shift
|
| 49 |
PRDN_START_DATE |
Date(10) |
DATE |
Prdn Start Date
|
| 50 |
PRDN_START_SHIFT |
Signed Number(2,0) |
DECIMAL(1) NOT NULL |
Prdn Start Shift
|
| 51 |
NEW_END_DATE |
Date(10) |
DATE |
Due Date
|
| 52 |
NEW_END_TIME |
Time(15) |
TIMESTAMP |
Due Time
|
| 53 |
NEW_END_SHIFT |
Signed Number(2,0) |
DECIMAL(1) NOT NULL |
Due Shift
|
| 54 |
PRDN_DUE_DATE |
Date(10) |
DATE |
Prdn Due Date
|
| 55 |
PRDN_DUE_SHIFT |
Signed Number(2,0) |
DECIMAL(1) NOT NULL |
Prdn Due Shift
|