CE_HR_CONV(SQL Table) |
Index Back |
|---|---|
Costing Hours ConversionsActual Cost Enhancement 10/02 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CE_SOURCE | Character(15) | VARCHAR2(15) NOT NULL | source |
| 2 | OP_TIME_UNIT | Character(2) | VARCHAR2(2) NOT NULL |
Time Unit
DY=Days HR=Hours MN=Minutes |
| 3 | OP_RATE_UNIT | Character(2) | VARCHAR2(2) NOT NULL |
Op Rate Unit
UD=Units/Day UH=Units/Hour UM=Units/Min |
| 4 | RATE_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Rate Per
HR=Hourly UN=Per Unit |
| 5 | CONVERSION_CODE | Character(4) | VARCHAR2(4) NOT NULL | Conversion Code |
| 6 | OH_RATE_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Conversion Ovhd Rate Type
%L=% of Labor Amt %M=% of Mach Amt PL=Amt Per Labor Hr PM=Amt Per Mach Hr PU=Per Unit Amt |
| 7 | QTY_CODE | Character(3) | VARCHAR2(3) NOT NULL |
Per
ASY=Assembly ORD=Order |
| 8 | CE_PERASSY_FLG | Number(1,0) | SMALLINT NOT NULL | min |
| 9 | CE_PERORD_FLG | Number(1,0) | SMALLINT NOT NULL | Min |
| 10 | CE_MIN | Number(1,0) | SMALLINT NOT NULL | min |
| 11 | CE_HR | Number(1,0) | SMALLINT NOT NULL | hour |
| 12 | CE_DAY | Signed Number(2,0) | DECIMAL(1) NOT NULL | day |
| 13 | CE_INV_MIN | Number(1,0) | SMALLINT NOT NULL | inv min |
| 14 | CE_INV_HR | Number(1,0) | SMALLINT NOT NULL | 1/hr |
| 15 | CE_INV_DY | Number(1,0) | SMALLINT NOT NULL | 1/day |
| 16 | CE_RATE_HR | Number(1,0) | SMALLINT NOT NULL | hrs |
| 17 | CE_RATE_UN | Number(1,0) | SMALLINT NOT NULL | unit |
| 18 | CE_NOCALC_CREWMACH | Number(1,0) | SMALLINT NOT NULL | no calc |
| 19 | CE_CREW | Number(1,0) | SMALLINT NOT NULL | crew |
| 20 | CE_MACH | Number(1,0) | SMALLINT NOT NULL | mach |
| 21 | CE_OVHD_LAB | Number(1,0) | SMALLINT NOT NULL | lab |
| 22 | CE_OVHD_MACH | Number(1,0) | SMALLINT NOT NULL | mach |
| 23 | CE_LAB_OH | Number(1,0) | SMALLINT NOT NULL | Lab |
| 24 | CE_MACH_OH | Number(1,0) | SMALLINT NOT NULL | mach |
| 25 | CE_PID_QTY | Number(1,0) | SMALLINT NOT NULL | pid |
| 26 | CE_PID_QTY_NO | Number(1,0) | SMALLINT NOT NULL | no |
| 27 | CE_AOQ_YES | Number(1,0) | SMALLINT NOT NULL | aoq |
| 28 | CE_AOQ_NO | Number(1,0) | SMALLINT NOT NULL | no aoq |