CP_CPPIRULE_TM(SQL Table) |
Index Back |
---|---|
CP Operation Times WorkCP Operation Times Work |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
2 | OP_SEQUENCE | Number(4,0) | SMALLINT NOT NULL | Operation Sequence |
3 | CP_TIME_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Time/Resource Type Field
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 |
4 | CP_TIME_RATE_UNIT | Character(2) | VARCHAR2(2) NOT NULL |
Time/Rate Unit Field
DY=Days HR=Hours MN=Minutes UD=Units Per Day UH=Units Per Hour UM=Units Per Minute |
5 | CP_INCLUDE_SETUP | Character(1) | VARCHAR2(1) NOT NULL |
Include Setup Field
Y/N Table Edit Default Value: N |
6 | CP_TIME_RATE | Number(9,2) | DECIMAL(8,2) NOT NULL | Operation Time/Rate Field |