CP_CPPIRULE_TM

(SQL Table)
Index Back

CP Operation Times Work

CP 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