QS_UPG_HIER_KY(SQL Table) |
Index Back |
|---|---|
MAP: Fixed Hierarchy to QCPLANDuring the upgrade from Release 7.5 to Release 8.0, this record was populated with the keys from the release 7.5 record/s AND the corresponding NEW keys in the 8.0 record/s. Though this record was used as a component of the upgrade, it van be used by the customer as a resource for identifying their changed data. RRE 1/18/2000 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 3 | MACHINE_CODE | Character(10) | VARCHAR2(10) NOT NULL | Machine Code |
| 4 | STATION_CODE | Character(10) | VARCHAR2(10) NOT NULL | Station Code |
| 5 | WORK_CENTER_CODE | Character(10) | VARCHAR2(10) NOT NULL | Work Center |
| 6 | QC_STEP_ID | Character(18) | VARCHAR2(18) NOT NULL | QC Step Id |
| 7 | STREAM_ROOT_ID | Number(8,0) | INTEGER NOT NULL | Stream Root ID - hierarchal structure |