| Manufacturing Execution System for Process Manufacturing - GMO_BATCH_PROGRESSION | This table maintains Batch Progression |
|---|---|
| Column Name | Descritpion |
| PROGRESSION_ID | Unique Identifier |
| TRANSACTION_ID | Transaction Identifier |
| PARENT_NODE | Parent Node under which current XML or text output need to be placed |
| PARENT_KEY_NODE | Parent XML record Identifier Node |
| PARENT_KEY_VAL | Parent Node Identifier Value |
| CURR_NODE_KEY | Current XML record Identifier Node |
| CURR_KEY_VAL | Current Node Identifier Value |
| USER_KEY_LABEL_PROD | User Key Label Message Token Owner Product Code |
| USER_KEY_LABEL_TOKEN | User Key Label Message Token |
| USER_KEY_LABEL | |
| USER_KEY_VALUE | User Visual record Identifier |
| BATCH_ID | Batch ID |
| EXTERNAL_EVENT | External Event Flag It will contain value of Y or N |
| INCLUDE_IN_CBR | This identifies CLOB Column value is XML or Text |
| EVENT | Event occured in batch progression |
| EVENT_KEY | ERES event Key |
| EVENT_DATE | Event Date |
| PLANED_START_DATE | Planed Start Date of the Event |
| ERECORD_ID | Evidence Store Document ID |
| XML_EREC | CLOB this will hold XML or Text Output |
| STATUS | Evnet Status |
| INCLUDED_IN_CBR | This contains value Y or N. N means not included. Y means included |
| BATCHSTEP_ID | Batch Step Identifier |
| XML_MAP_CODE | If XML need to be transformed further |
| COMPARE_XML | This column holds whether to compare XML or Not |
| MATERIAL_LINE_ID | Material Line Identifier |
| BATCHACTIVITY_ID | Batch Activity Identifier |
| BATCHRSRC_ID | Batch Activity Resource Identifier |
| DISPENSE_ID | Dispense Identifier |
| SAMPLE_ID | Sample Identifier |
| DEVIATION_ID | Deviation Identifier |
| Manufacturing Execution System for Process Manufacturing - GMO_CBR_XML | This table is to store consolidated Control Batch Record XML |
|---|---|
| Column Name | Descritpion |
| BATCH_ID | |
| CBR_XML |
| Manufacturing Execution System for Process Manufacturing - GMO_DEVICE_REQUESTS_T | GMO Device Request |
|---|---|
| Column Name | Descritpion |
| REQUEST_ID | Request Id |
| LAST_UPDATED_BY | Standard who column |
| LAST_UPDATE_LOGIN | Standard who column |
| LAST_UPDATE_DATE | Standard who column |
| DEVICE_ID | Device Id |
| REQUESTER | Requester User Id |
| RESPONSE_STATUS | Response Status |
| DEVICE_STATUS | Device Status |
| REQUEST_DATE | Request Date |
| CREATED_BY | Standard who column |
| CREATION_DATE | Standard who column |
| Manufacturing Execution System for Process Manufacturing - GMO_DEVICE_RESPONSES_T | GMO Device Response |
|---|---|
| Column Name | Descritpion |
| RESPONSE_ID | Response Id |
| REQUEST_ID | Request Id |
| RESP_COMP_CODE | Response Component Code |
| RESP_COMP_CODE_VALUE | Response Value |
| CREATED_BY | Standard who column |
| CREATION_DATE | Standard who column |
| LAST_UPDATED_BY | Standard who column |
| LAST_UPDATE_LOGIN | Standard who column |
| LAST_UPDATE_DATE | Standard who column |
| Manufacturing Execution System for Process Manufacturing - GMO_DISPENSE_CONFIG_INST | Holds the instantiated dispense setup configurations. |
|---|---|
| Column Name | Descritpion |
| INSTANCE_ID | The primary key of the table. |
| DISPENSE_CONFIG_ID | The config ID of the Dispense Setup that has been instantiated. |
| ENTITY_NAME | The entity name. |
| ENTITY_KEY | The entity key. |
| CREATED_BY | Standard who column |
| CREATION_DATE | Standard who column |
| LAST_UPDATED_BY | Standard who column |
| LAST_UPDATE_LOGIN | Standard who column |
| LAST_UPDATE_DATE | Standard who column |
| Manufacturing Execution System for Process Manufacturing - GMO_DISPENSE_CONFIG | GMO Dispense Configuration |
|---|---|
| Column Name | Descritpion |
| CONFIG_ID | Configuration ID |
| ERECORD_ID | E-record ID |
| CREATED_BY | Standard who column |
| CREATION_DATE | Standard who column |
| LAST_UPDATED_BY | Standard who column |
| LAST_UPDATE_LOGIN | Standard who column |
| LAST_UPDATE_DATE | Standard who column |
| END_DATE | 'This is the start date when the dispense setup configuration becomes active.' |
| START_DATE | 'This is the end date when the dispense setup configuration becomes inactive.' |
| SECURECODE_REQUIRED_FLAG | |
| DISPENSE_EXPIRATION_FENCE | |
| INVENTORY_ITEM_ID | Inventory Item ID |
| LEAD_TIME | |
| ORGANIZATION_ID | Organization ID |
| RECIPE_ID | Recipe ID |
| DISPENSE_UOM | Dispense UOM |
| TOLERANCE_TYPE | Tolerance Type |
| HIGH_TOLERANCE | Higher Tolerance |
| LOW_TOLERANCE | Low Tolerance |
| DISPENSE_REQUIRED_FLAG | Dispense Required Flag |
| Manufacturing Execution System for Process Manufacturing - GMO_MATERIAL_DISPENSES | GMO Material Dispenses |
|---|---|
| Column Name | Descritpion |
| DISPENSE_ID | Dispense ID |
| ORGANIZATION_ID | Organization ID |
| SUBINVENTORY_CODE | Sub inventory or booth Code |
| SECURITY_CODE | Security code to be used in label printing |
| DISPENSE_UOM | Dispense UOM |
| SOURCE_CONTAINER_DEVICE_ID | Source Container Item ID |
| TARGET_CONTAINER_DEVICE_ID | Target Container Item ID |
| DISPENSED_DATE | Dispensed Date |
| DISPENSING_MODE | Dispensing Mode |
| REQUIRED_QTY | Pending Dispense Quantity |
| DISPENSED_QTY | Dispensed Quantity |
| DISPENSE_SOURCE | Dispense Source e.g. BATCH |
| GROSS_REQUIRED_WEIGHT | Required Weight of the dispensed container |
| SOURCE_CONTAINER_TARE | Source Container tare |
| SOURCE_CONTAINER_WEIGHT | Source Container weight |
| SOURCE_CONTAINER_REWEIGHT | Source Container Re-weight |
| ACTUAL_GROSS_WEIGHT | Target Container Weight |
| TARGET_CONTAINER_TARE | Target Container Tare |
| SOURCE_CONTAINER_ITEM_ID | Source Container Item ID |
| TARGET_CONTAINER_ITEM_ID | Target Container Item ID |
| RESERVATION_ID | Material Reservation ID |
| MATERIAL_STATUS | Material Status |
| DISPENSE_NUMBER | Dispense Number |
| LOT_NUMBER | Lot Number |
| ERECORD_ID | E-record ID |
| CREATED_BY | Standard who column |
| CREATION_DATE | Standard who column |
| LAST_UPDATED_BY | Standard who column |
| LAST_UPDATE_DATE | Standard who column |
| LAST_UPDATE_LOGIN | Standard who column |
| INCLUDE_TARE_FLAG | |
| DISPENSE_AREA_ID | |
| DISPENSE_BOOTH_ID | |
| DISPENSE_SOURCE_TRANSACTION_ID | ID of the source transaction e.g. Batch ID |
| DISPENSE_TYPE | Dispense Type : Production or Ad hoc |
| MATERIAL_DETAIL_ID | Material detail ID |
| BATCH_ID | Batch ID |
| BATCH_STEP_ID | Batch Step ID |
| INVENTORY_ITEM_ID | Inventory Item ID |
| Manufacturing Execution System for Process Manufacturing - GMO_MATERIAL_UNDISPENSES | GMO Material UNDispenses |
|---|---|
| Column Name | Descritpion |
| UNDISPENSE_ID | Reverse Dispense ID |
| ORGANIZATION_ID | Organization ID |
| SUBINVENTORY_CODE | Sub inventory or booth Code |
| SECURITY_CODE | Security code to be used in label printing |
| DISPENSE_UOM | Dispense UOM |
| SOURCE_CONTAINER_DEVICE_ID | Source Container Item ID |
| TARGET_CONTAINER_DEVICE_ID | Target Container Item ID |
| UNDISPENSED_DATE | Reverse Dispensed Date |
| UNDISPENSING_MODE | Reverse Dispensing Mode |
| DISPENSED_QTY | Pending Reverse Dispense Quantity |
| UNDISPENSED_QTY | Reverse Dispensed Quantity |
| DISPENSE_ID | Dispense ID |
| GROSS_REQUIRED_WEIGHT | Required Weight of the reverse dispensed container |
| SOURCE_CONTAINER_TARE | Source Container tare |
| SOURCE_CONTAINER_WEIGHT | Source Container weight |
| SOURCE_CONTAINER_REWEIGHT | Source Container Re-weight |
| ACTUAL_GROSS_WEIGHT | Target Container Weight |
| TARGET_CONTAINER_TARE | Target Container Tare |
| SOURCE_CONTAINER_ITEM_ID | Source Container Item ID |
| TARGET_CONTAINER_ITEM_ID | Target Container Item ID |
| RESERVATION_ID | Material Reservation ID |
| MATERIAL_STATUS | Material Status |
| UNDISPENSE_NUMBER | Reverse Dispense Number |
| LOT_NUMBER | Lot Number |
| ERECORD_ID | E-record ID |
| MATERIAL_LOSS | Material Loss |
| CREATED_BY | Standard who column |
| CREATION_DATE | Standard who column |
| LAST_UPDATED_BY | Standard who column |
| LAST_UPDATE_DATE | Standard who column |
| LAST_UPDATE_LOGIN | Standard who column |
| INCLUDE_TARE_FLAG | |
| DISPENSE_AREA_ID | |
| SOURCE_TRANSACTION_ID | ID of the source transaction e.g. Batch ID |
| DISPENSE_BOOTH_ID | |
| UNDISPENSE_TYPE | Reverse Dispense Type : Production or Ad hoc |
| MATERIAL_DETAIL_ID | Material detail ID |
| BATCH_ID | Batch ID |
| BATCH_STEP_ID | Batch Step ID |
| INVENTORY_ITEM_ID | Inventory Item ID |
| Manufacturing Execution System for Process Manufacturing - GMO_LABEL_CONTEXT_T | This is a temporary table whihc stores the context of transaction to be used in UI rendering |
|---|---|
| Column Name | Descritpion |
| LABEL_ID | Label identifier refers GMO_LABEL_HISTORY |
| LAST_UPDATE_LOGIN | Standard who column |
| DISPLAY_SEQUENCE | Display sequnece of the context in UI |
| APPLICATION_SHORT_NAME | Application short name to derive the message token |
| CONTEXT_MESSAGE_TOKEN | FND message token to be used as display name |
| CONTEXT_VALUE | Value to be displayed next to the display name |
| CREATED_BY | Standard who column |
| CREATION_DATE | Standard who column |
| LAST_UPDATED_BY | Standard who column |
| LAST_UPDATE_DATE | Standard who column |
| Manufacturing Execution System for Process Manufacturing - GMO_LABEL_HISTORY_DTL | Stores the Label types printed for a transaction |
|---|---|
| Column Name | Descritpion |
| LABEL_DTL_ID | Unique row identifier and Primary Key |
| LAST_UPDATE_LOGIN | Standard who column |
| LABEL_ID | Unique Label identifier and references GMO_LABEL_HISTORY |
| LABEL_TYPE | WMS label type being printed. Derived from WMS_LABEL_TYPE lookups |
| WMS_LABEL_ID | Label ID returned by WMS interface |
| WMS_PRINT_STATUS | Print Status from WMS interface |
| CREATED_BY | Standard who column |
| CREATION_DATE | Standard who column |
| LAST_UPDATED_BY | Standard who column |
| LAST_UPDATE_DATE | Standard who column |
| Manufacturing Execution System for Process Manufacturing - GMO_LABEL_HISTORY | |
|---|---|
| Column Name | Descritpion |
| LABEL_ID | |
| STATUS | |
| CREATED_BY | |
| CREATION_DATE | |
| LAST_UPDATED_BY | |
| LAST_UPDATE_DATE | |
| LAST_UPDATE_LOGIN | |
| ENTITY_NAME | |
| ENTITY_KEY | |
| WMS_BUSINESSFLOW_CODE | |
| WMS_BUSINESSFLOW_TRANS_ID | |
| TRANSACTION_TYPE | |
| REQUESTER | |
| REQUESTED_DATE | |
| ERECORD_ID |
| Manufacturing Execution System for Process Manufacturing - GMO_NONCONFORMANCE | Stores the non conformance logged against Batches |
|---|---|
| Column Name | Descritpion |
| NONCONFORMANCE_ID | Unique nonconformance identifier and primary key |
| LAST_UPDATE_LOGIN | Standard who column |
| ENTITY_NAME | Calling Entity name which has non conformance |
| ENTITY_KEY | Calling Entity key which has non conformance |
| COLLECTION_ID | Collection id returned by Oracle Quality Nonconformacne module |
| COLLECTION_STATUS | STATUS of the Print request NEW,COMPLETE |
| CREATED_BY | Standard who column |
| CREATION_DATE | Standard who column |
| LAST_UPDATED_BY | Standard who column |
| LAST_UPDATE_DATE | Standard who column |
| Manufacturing Execution System for Process Manufacturing - GMO_BATCH_STEP_LOCK_DETAILS | GMO Batch Step Lock Details |
|---|---|
| Column Name | Descritpion |
| BATCH_ID | Batch Id |
| BATCHSTEP_ID | Batchstep Id |
| LOCK_REQUESTER | Lock requester User Id |
| LOCK_DATE | Lock request date |
| CREATED_BY | Standard who column |
| CREATION_DATE | Standard who column |
| LAST_UPDATED_BY | Standard who column |
| LAST_UPDATE_LOGIN | Standard who column |
| LAST_UPDATE_DATE | Standard who column |
| Manufacturing Execution System for Process Manufacturing - GMO_BATCH_STEP_LOCK_HIST | GMO Batch Step Lock History |
|---|---|
| Column Name | Descritpion |
| LOCK_HIST_SEQ | Sequence for Lock History |
| LAST_UPDATED_BY | Standard who column |
| LAST_UPDATE_LOGIN | Standard who column |
| LAST_UPDATE_DATE | Standard who column |
| BATCH_ID | Batch Id |
| BATCHSTEP_ID | Batchstep Id |
| LOCK_REQUESTER | Lock requester User Id |
| LOCK_DATE | Lock request date |
| UNLOCK_REQUESTER | Unlock requester User Id |
| UNLOCK_DATE | Unlock request date |
| CREATED_BY | Standard who column |
| CREATION_DATE | Standard who column |
| Manufacturing Execution System for Process Manufacturing - GMO_INSTR_INSTANCE_TL | Instruction Translation Table for instructions at execution time |
|---|---|
| Column Name | Descritpion |
| INSTRUCTION_ID | Instruction Id, Primary Key |
| LAST_UPDATED_BY | Standard WHO Column |
| LAST_UPDATE_LOGIN | Standard WHO Column |
| INSTRUCTION_TEXT | Instruction Text |
| COMMENTS | Instruction Comments |
| TASK_LABEL | Instruction Task Label |
| SOURCE_LANG | Source Language |
| LANGUAGE | Translated Language |
| CREATION_DATE | Standard WHO Column |
| CREATED_BY | Standard WHO Column |
| LAST_UPDATE_DATE | Standard WHO Column |
| Manufacturing Execution System for Process Manufacturing - GMO_INSTR_SET_INSTANCE_T | Instruction Set Temp Table to maintain Instruction Set Ackn Status |
|---|---|
| Column Name | Descritpion |
| INSTRUCTION_SET_ID | Instruction Set Id , Primary Key |
| INSTRUCTION_PROCESS_ID | Instruction Process Id |
| ACKN_STATUS | Instruction Set Ackn Status |
| CREATION_DATE | Standard WHO Column |
| CREATED_BY | Standard WHO Column |
| LAST_UPDATE_DATE | Standard WHO Column |
| LAST_UPDATED_BY | Standard WHO Column |
| LAST_UPDATE_LOGIN | Standard WHO Column |
| Manufacturing Execution System for Process Manufacturing - GMO_INSTR_EREC_INSTANCE_T | The table stores the relationship between Instruction Id and Instruction E-record Id |
|---|---|
| Column Name | Descritpion |
| INSTRUCTION_ID | Instruction id referenced from GMO_INSTR_INSTANCE_B , part of primary key |
| LAST_UPDATE_LOGIN | Standard WHO Column |
| INSTRUCTION_PROCESS_ID | |
| INSTR_EREC_SEQ | Instruction e-record sequence |
| INSTR_EREC_ID | Instructioon e-record id |
| TASK_EREC_ID | Task E-record Id, if any task is associated |
| CREATION_DATE | Standard WHO Column |
| CREATED_BY | Standard WHO Column |
| LAST_UPDATE_DATE | Standard WHO Column |
| LAST_UPDATED_BY | Standard WHO Column |
| Manufacturing Execution System for Process Manufacturing - GMO_INSTR_TASK_INSTANCE_T | Task (task erecord id, task identifier, task value ) related data for given instruction in given exectution session |
|---|---|
| Column Name | Descritpion |
| INSTRUCTION_ID | Instruction Id, referenced from GMO_INSTR_INSTANCE_B, part of primary key |
| LAST_UPDATE_DATE | Standard WHO Column |
| LAST_UPDATED_BY | Standard WHO Column |
| LAST_UPDATE_LOGIN | Standard WHO Column |
| INSTRUCTION_PROCESS_ID | Instruction Process Id |
| INSTR_TASK_SEQ | Unique task sequence used to form primary key |
| TASK_EREC_ID | Task E-record Id |
| TASK_IDENTIFIER | Task Identifier |
| TASK_VALUE | Task Value |
| MANUAL_ENTRY | Whether task is acknowledged from application or manually entered = Y or N |
| CREATION_DATE | Standard WHO Column |
| CREATED_BY | Standard WHO Column |
| Manufacturing Execution System for Process Manufacturing - GMO_INSTR_EREC_INSTANCE | The table stores the relationship between Instruction Id and Instruction E-record Id |
|---|---|
| Column Name | Descritpion |
| INSTRUCTION_ID | Instruction id referenced from GMO_INSTR_INSTANCE_B , part of primary key |
| INSTR_EREC_SEQ | Instruction e-record sequence |
| INSTR_EREC_ID | Instructioon e-record id |
| TASK_EREC_ID | Task E-record Id, if any task is associated |
| CREATION_DATE | Standard WHO Column |
| CREATED_BY | Standard WHO Column |
| LAST_UPDATE_DATE | Standard WHO Column |
| LAST_UPDATED_BY | Standard WHO Column |
| LAST_UPDATE_LOGIN | Standard WHO Column |
| Manufacturing Execution System for Process Manufacturing - GMO_INSTR_APPR_INSTANCE | Instruction Approvers Table |
|---|---|
| Column Name | Descritpion |
| INSTRUCTION_ID | Instruction Id, referenced from GMO_INSTR_INSTANCE_B, part of primary key |
| APPROVER_SEQ | Approver Sequence, part of primary key |
| ROLE_NAME | WF Internal Role Name of approvers |
| ROLE_COUNT | Number of Signatures for given Role Name |
| CREATION_DATE | Standard WHO Column |
| CREATED_BY | Standard WHO Column |
| LAST_UPDATE_DATE | Standard WHO Column |
| LAST_UPDATED_BY | Standard WHO Column |
| LAST_UPDATE_LOGIN | Standard WHO Column |
| Manufacturing Execution System for Process Manufacturing - GMO_INSTR_TASK_INSTANCE | Task (task erecord id, task identifier, task value ) related data for given instruction |
|---|---|
| Column Name | Descritpion |
| INSTRUCTION_ID | Instruction Id, referenced from GMO_INSTR_INSTANCE_B, part of primary key |
| LAST_UPDATED_BY | Standard WHO Column |
| LAST_UPDATE_LOGIN | Standard WHO Column |
| INSTR_TASK_SEQ | Unique task sequence used to form primary key |
| TASK_EREC_ID | Task E-record Id |
| TASK_IDENTIFIER | Task Identifier |
| TASK_VALUE | Task Value |
| MANUAL_ENTRY | Whether task is acknowledged from application or manually entered = Y or N |
| CREATION_DATE | Standard WHO Column |
| CREATED_BY | Standard WHO Column |
| LAST_UPDATE_DATE | Standard WHO Column |
| Manufacturing Execution System for Process Manufacturing - GMO_INSTR_INSTANCE_B | Instruction base table at execution time |
|---|---|
| Column Name | Descritpion |
| INSTRUCTION_ID | Instruction Id, Primary Key |
| TASK_ATTRIBUTE_ID | Task Attribute Id |
| TASK_ACKN_DATE | Task Acknowledgement Date |
| TASK_ACKN_STATUS | Task Acknowledgement Status |
| CREATION_DATE | Standard WHO Column |
| CREATED_BY | Standard WHO Column |
| LAST_UPDATE_DATE | Standard WHO Column |
| LAST_UPDATED_BY | Standard WHO Column |
| LAST_UPDATE_LOGIN | Standard WHO Column |
| INSTRUCTION_SET_ID | Instruction Set Id, Foriegn Key from GMO_INSTR_SET_INSTANCE_B |
| INSTR_SEQ | Instruction Seq, used to order the instructions in runtime region |
| INSTR_NUMBER | Instruction Number, user entered number to display to the user |
| INSTR_STATUS | Instruction Status - PENDING, WORKING, DONE, COMPLETE, CANCEL |
| INSTR_ACKN_TYPE | Instruction Acknowledgement Type |
| OPERATOR_ACKN | Operator Acknowledgement |
| TASK_ID | Task Id |
| TASK_ATTRIBUTE | Task Attribute |
| Manufacturing Execution System for Process Manufacturing - GMO_INSTR_INSTANCE_T | Functional Temporary table to store the Operator Response and Task Related details at execution time for an Instruction |
|---|---|
| Column Name | Descritpion |
| INSTRUCTION_ID | Instruction Id |
| TASK_ACKN_STATUS | Task Ackn Status |
| TASK_ACKN_DATE | Task Ackn Date |
| DISABLE_TASK | Disable Task Flag for given Instruction Y or N |
| CREATION_DATE | Standard WHO Column |
| CREATED_BY | Standard WHO Column |
| LAST_UPDATE_DATE | Standard WHO Column |
| LAST_UPDATED_BY | Standard WHO Column |
| LAST_UPDATE_LOGIN | Standard WHO Column |
| INSTRUCTION_PROCESS_ID | Instruction Process Id |
| INSTR_STATUS | Instruction Status |
| OPERATOR_ACKN | Operator Acknowledgement |
| COMMENTS | Instruction Comments |
| TASK_LABEL | Task Label |
| TASK_ID | Task Id |
| TASK_ATTRIBUTE | Task Attribute |
| TASK_ATTRIBUTE_ID | Task Attribute Id |
| Manufacturing Execution System for Process Manufacturing - GMO_INSTR_DEFN_B | Instruction definition time base table |
|---|---|
| Column Name | Descritpion |
| INSTRUCTION_ID | Instruction Id, primary key |
| CREATED_BY | Standard WHO Column |
| LAST_UPDATE_DATE | Standard WHO Column |
| LAST_UPDATED_BY | Standard WHO Column |
| LAST_UPDATE_LOGIN | Standard WHO Column |
| INSTRUCTION_SET_ID | Instruction Set Id, Foriegn Key, referenced from GMO_INSTR_SET_DEFN_B |
| INSTR_SEQ | Instruction sequence for ordering instructions in definition and runtime |
| TASK_ID | Task Id referencing GMO_INSTR_TASK_DEFN_B, for task associated with instruction |
| TASK_ATTRIBUTE_ID | Task Attribute Id for task associated |
| TASK_ATTRIBUTE | Task Attribute for task associated |
| INSTR_ACKN_TYPE | Instruction Ackn Type Code reference from GMO_INSTR_ACKN_TYPES lookup |
| INSTR_NUMBER | Instruction Number displayed to user |
| CREATION_DATE | Standard WHO Column |
| Manufacturing Execution System for Process Manufacturing - GMO_INSTR_SET_INSTANCE_TL | |
|---|---|
| Column Name | Descritpion |
| INSTRUCTION_SET_ID | |
| INSTR_SET_DESC | |
| SOURCE_LANG | |
| LANGUAGE | |
| CREATION_DATE | |
| CREATED_BY | |
| LAST_UPDATE_DATE | |
| LAST_UPDATED_BY | |
| LAST_UPDATE_LOGIN |
| Manufacturing Execution System for Process Manufacturing - GMO_INSTR_TASK_ATTR_COLS_B | |
|---|---|
| Column Name | Descritpion |
| ATTR_COL_SEQ | |
| ENTITY_NAME | |
| TASK_NAME | |
| COLUMN_NO | |
| CREATION_DATE | |
| CREATED_BY | |
| LAST_UPDATE_DATE | |
| LAST_UPDATED_BY | |
| LAST_UPDATE_LOGIN |
| Manufacturing Execution System for Process Manufacturing - GMO_INSTR_ATTRIBUTES_T | Functional temporary table to store session related attributes |
|---|---|
| Column Name | Descritpion |
| INSTRUCTION_PROCESS_ID | Instruction Process id for particular user session, part of PK |
| CREATED_BY | Standard WHO Column |
| LAST_UPDATE_DATE | Standard WHO Column |
| LAST_UPDATED_BY | Standard WHO Column |
| LAST_UPDATE_LOGIN | Standard WHO Column |
| ATTRIBUTE_SEQ | Unique attribute sequence for all attributes created, part of PK |
| ATTRIBUTE_NAME | Attribute name |
| ATTRIBUTE_VALUE | Attribute value |
| ENTITY_NAME | Entity Name |
| ENTITY_KEY | Entity Key |
| ENTITY_DISPLAY_NAME | Entity Display Name |
| INSTRUCTION_TYPE | Instruction Type |
| ATTRIBUTE_TYPE | |
| CREATION_DATE | Standard WHO Column |
| Manufacturing Execution System for Process Manufacturing - GMO_INSTR_SET_INSTANCE_B | Instruction Set base table at execution time |
|---|---|
| Column Name | Descritpion |
| INSTRUCTION_SET_ID | Instruction set id, primary key |
| CREATION_DATE | Standard WHO Column |
| CREATED_BY | Standard WHO Column |
| LAST_UPDATE_DATE | Standard WHO Column |
| LAST_UPDATED_BY | Standard WHO Column |
| LAST_UPDATE_LOGIN | Standard WHO Column |
| INSTRUCTION_TYPE | Instruction Type |
| INSTR_SET_NAME | Instruction Set Name used to identify Instruction Set |
| ENTITY_NAME | Entity Name for Instruction Set |
| ENTITY_KEY | Entity Key for Instruction Set |
| ACKN_STATUS | Acknowledgement status used for handshake purposes |
| INSTR_SET_STATUS | Instruction set status used to identify nullified instructions -can be ACTIVE or CANCEL |
| ORIG_SOURCE | ORIG Source = DEFINITION in case of CREATE_INSTANCE_FROM_DEFINITION or INSTANCE in case of CREATE_INSTANCE_FROM_INSTANCE |
| ORIG_SOURCE_ID | Originial Instruction Set Id, if this instruction set is a copy of existing |
| Manufacturing Execution System for Process Manufacturing - GMO_INSTR_TASK_ATTR_COLS_TL | Task Columns Translation Table for Column Heading |
|---|---|
| Column Name | Descritpion |
| ATTR_COL_SEQ | Attribute Column Sequence, Primary Key |
| COLUMN_HEADING | Column Heading Displayed in Task LOV |
| SOURCE_LANG | Source Language |
| LANGUAGE | Translated Language |
| CREATION_DATE | Standard WHO Column |
| CREATED_BY | Standard WHO Column |
| LAST_UPDATE_DATE | Standard WHO Column |
| LAST_UPDATED_BY | Standard WHO Column |
| LAST_UPDATE_LOGIN | Standard WHO Column |
| Manufacturing Execution System for Process Manufacturing - GMO_INSTR_APPR_DEFN_T | |
|---|---|
| Column Name | Descritpion |
| INSTRUCTION_ID | Instruction Id, part of primary key |
| LAST_UPDATE_LOGIN | Standard WHO Column |
| INSTRUCTION_PROCESS_ID | Instruction Process Id for particular user session, part of PK |
| APPROVER_SEQ | Approver Sequence part of PK |
| ROLE_NAME | Approver Role Name , can be null |
| ROLE_COUNT | Number of Signatures for given role |
| CREATION_DATE | Standard WHO Column |
| CREATED_BY | Standard WHO Column |
| LAST_UPDATE_DATE | Standard WHO Column |
| LAST_UPDATED_BY | Standard WHO Column |
| Manufacturing Execution System for Process Manufacturing - GMO_INSTR_TASK_DEFN_B | Task Definition Table to store all possible tasks to be executed using PI Framework |
|---|---|
| Column Name | Descritpion |
| TASK_ID | Task Id, primary key |
| CREATION_DATE | Standard WHO Column |
| CREATED_BY | Standard WHO Column |
| LAST_UPDATE_DATE | Standard WHO Column |
| LAST_UPDATED_BY | Standard WHO Column |
| LAST_UPDATE_LOGIN | Standard WHO Column |
| MAX_ALLOWED_TASK | Maximum number of allowed task for this Entity. |
| ENTITY_NAME | Entity Name for the Task |
| INSTRUCTION_TYPE | Instruction Type for the task |
| TASK_NAME | Internal Name of task |
| TASK_TYPE | Type of Task |
| TARGET | Target URL or OA Function Name for the task |
| ATTRIBUTE_SQL | Attribute SQL for the Task to be used at definition time |
| ATTRIBUTE_DISPLAY_COL_COUNT | Attribute Display Column Count |
| ENTITY_KEY_PATTERN | String pattern used to for entity key |
| Manufacturing Execution System for Process Manufacturing - GMO_INSTR_APPR_DEFN | Instruction Approvers Functional Temp Table |
|---|---|
| Column Name | Descritpion |
| INSTRUCTION_ID | Foriegn Key from GMO_INSTR_DEFN_B Instruction Id |
| APPROVER_SEQ | Unique Approver Seq to identify instruction approver |
| ROLE_NAME | Approver Role Name , can be null |
| ROLE_COUNT | Number of Signatures for given role |
| CREATION_DATE | Standard WHO Column |
| CREATED_BY | Standard WHO Column |
| LAST_UPDATE_DATE | Standard WHO Column |
| LAST_UPDATED_BY | Standard WHO Column |
| LAST_UPDATE_LOGIN | Standard WHO Column |
| Manufacturing Execution System for Process Manufacturing - GMO_INSTR_TASK_DEFN_TL | Task Definition Translation Table |
|---|---|
| Column Name | Descritpion |
| TASK_ID | Task Id, Primary Key |
| DISPLAY_NAME | Task Display Name |
| SOURCE_LANG | Source Language |
| LANGUAGE | Translated Language |
| CREATION_DATE | Standard WHO Column |
| CREATED_BY | Standard WHO Column |
| LAST_UPDATE_DATE | Standard WHO Column |
| LAST_UPDATED_BY | Standard WHO Column |
| LAST_UPDATE_LOGIN | Standard WHO Column |
| Manufacturing Execution System for Process Manufacturing - GMO_INSTR_DEFN_TL | Instruction Definitioin Transalatable Table |
|---|---|
| Column Name | Descritpion |
| INSTRUCTION_ID | Instruction Id, Primary Key |
| LAST_UPDATE_LOGIN | Standard WHO Column |
| INSTRUCTION_TEXT | Instruction Text |
| TASK_LABEL | Task Label |
| SOURCE_LANG | Source Language |
| LANGUAGE | Translated Language |
| CREATION_DATE | Standard WHO Column |
| CREATED_BY | Standard WHO Column |
| LAST_UPDATE_DATE | Standard WHO Column |
| LAST_UPDATED_BY | Standard WHO Column |
| Manufacturing Execution System for Process Manufacturing - GMO_INSTR_DEFN_T | Functional Temporary table for Instructions at Definition Time |
|---|---|
| Column Name | Descritpion |
| INSTRUCTION_PROCESS_ID | The instruction process id for one particular user session, part of PK |
| INSTRUCTION_TEXT | Instruction Text |
| TASK_LABEL | Task Label |
| CREATION_DATE | Standard WHO Column |
| CREATED_BY | Standard WHO Column |
| LAST_UPDATE_DATE | Standard WHO Column |
| LAST_UPDATED_BY | Standard WHO Column |
| LAST_UPDATE_LOGIN | Standard WHO Column |
| INSTRUCTION_ID | The instruction id , Primary Key |
| INSTRUCTION_SET_ID | Instruction Set Id, Foriegn Key, referenced from GMO_INSTR_SET_DEFN_B |
| INSTR_SEQ | Instruction sequence for ordering instructions in definition and runtime |
| TASK_ID | Task Id referencing GMO_INSTR_TASK_DEFN_B, for task associated with instruction |
| TASK_ATTRIBUTE_ID | Task Attribute Id for task associated |
| TASK_ATTRIBUTE | Task Attribute for task associated |
| INSTR_ACKN_TYPE | Instruction Ackn Type Code reference from GMO_INSTR_ACKN_TYPES lookup |
| INSTR_NUMBER | Instruction Number displayed to user |
| Manufacturing Execution System for Process Manufacturing - GMO_INSTR_SET_DEFN_TL | Instruction Set Definition Time Translation Table |
|---|---|
| Column Name | Descritpion |
| INSTRUCTION_SET_ID | Instruction Set Id, Primary Key |
| INSTR_SET_DESC | Instruction Set Description (MLS) |
| SOURCE_LANG | Source Language |
| LANGUAGE | Translated Language |
| CREATION_DATE | Standard WHO Column |
| CREATED_BY | Standard WHO Column |
| LAST_UPDATE_DATE | Standard WHO Column |
| LAST_UPDATED_BY | Standard WHO Column |
| LAST_UPDATE_LOGIN | Standard WHO Column |
| Manufacturing Execution System for Process Manufacturing - GMO_INSTR_SET_DEFN_T | |
|---|---|
| Column Name | Descritpion |
| INSTRUCTION_SET_ID | The instruction set id , Primary Key |
| ORIG_SOURCE_ID | Originial Instruction Set Id, if this instruction set is a copy of existing |
| CREATION_DATE | Standard WHO Column |
| CREATED_BY | Standard WHO Column |
| LAST_UPDATE_DATE | Standard WHO Column |
| LAST_UPDATED_BY | Standard WHO Column |
| LAST_UPDATE_LOGIN | Standard WHO Column |
| INSTRUCTION_PROCESS_ID | The instruction process id for one particular user session, part of PK |
| INSTRUCTION_TYPE | Instruction Set type code eg. PROCESS, DISPENSE, REVERSE_DISPENSE |
| INSTR_SET_NAME | Instruction Set Name used to identify Instruction Set |
| INSTR_SET_DESC | Instruction Set Description (MLS) |
| ENTITY_NAME | Entity Name for Instruction Set |
| ENTITY_KEY | Entity Key for Instruction Set |
| ACKN_STATUS | Acknowledgement status used for handshake purposes |
| ORIG_SOURCE | ORIG Source = DEFINITION |
| Manufacturing Execution System for Process Manufacturing - GMO_INSTR_SET_DEFN_B | Instruction Set Definition Time Base Table |
|---|---|
| Column Name | Descritpion |
| INSTRUCTION_SET_ID | Instruction Set Id, Primary Key |
| CREATED_BY | Standard WHO Column |
| LAST_UPDATE_DATE | Standard WHO Column |
| LAST_UPDATED_BY | Standard WHO Column |
| LAST_UPDATE_LOGIN | Standard WHO Column |
| INSTRUCTION_TYPE | Instruction Set type code eg. PROCESS, DISPENSE, REVERSE_DISPENSE |
| INSTR_SET_NAME | Instruction Set Name used to identify Instruction Set |
| ENTITY_NAME | Entity Name for Instruction Set |
| ENTITY_KEY | Entity Key for Instruction Set |
| ACKN_STATUS | Acknowledgement status used for handshake purposes |
| ORIG_SOURCE | ORIG Source = DEFINITION |
| ORIG_SOURCE_ID | Originial Instruction Set Id, if this instruction set is a copy of existing |
| CREATION_DATE | Standard WHO Column |
| Manufacturing Execution System for Process Manufacturing - GMO_DOCUMENT_NUMBERS | Holds generated document numbers for a given organization and transaction type |
|---|---|
| Column Name | Descritpion |
| DOC_ID | The primary key of the table |
| DOC_INCREMENT | The value by which sequence is to be incremented each time. |
| DOC_CURRENTVAL | The current value of the sequence |
| DOC_ZERO_PAD | Whether zero padding is required |
| CREATED_BY | Standard who column |
| CREATION_DATE | Standard who column |
| LAST_UPDATED_BY | Standard who column |
| LAST_UPDATE_LOGIN | Standard who column |
| LAST_UPDATE_DATE | Standard who column |
| ORGANIZATION_ID | The organization ID |
| TRANSACTION_TYPE | The transaction type |
| DOC_TYPE | The document number type |
| DOC_PREFIX | The document number prefix |
| DOC_SUFFIX | The document number suffix |
| DOC_SEPARATOR | The separator symbol |
| DOC_START | The starting sequence of the document number |
| DOC_LENGTH | The maximum allowed length of the sequence |
| Manufacturing Execution System for Process Manufacturing - GMO_OPERT_CERT_GTMP | |
|---|---|
| Column Name | Descritpion |
| ERECORD_ID | |
| OPERATOR_CERTIFICATE_ID | |
| EVENT_KEY | |
| EVENT_NAME |
| Manufacturing Execution System for Process Manufacturing - GMO_AREA_OPERATOR_MAPPING | Dispense Area Operator Mapping Table |
|---|---|
| Column Name | Descritpion |
| DISPENSE_AREA_ID | Dispense Area ID |
| OPER_ID | HR person ID |
| NUMBER_OF_TASKS_PER_DAY | Max No of tasks operator can handle in a day |
| CREATED_BY | |
| CREATION_DATE | |
| LAST_UPDATED_BY | |
| LAST_UPDATE_DATE | |
| LAST_UPDATE_LOGIN |
| Manufacturing Execution System for Process Manufacturing - GMO_DISPENSE_BOOTH_TL | |
|---|---|
| Column Name | Descritpion |
| DISPENSE_BOOTH_ID | |
| DISPENSE_BOOTH_DESC | |
| SOURCE_LANG | |
| LANGUAGE | |
| CREATED_BY | |
| CREATION_DATE | |
| LAST_UPDATED_BY | |
| LAST_UPDATE_DATE | |
| LAST_UPDATE_LOGIN |
| Manufacturing Execution System for Process Manufacturing - GMO_DISPENSE_AREA_TL | |
|---|---|
| Column Name | Descritpion |
| DISPENSE_AREA_ID | |
| DISPENSE_AREA_DESC | |
| SOURCE_LANG | |
| LANGUAGE | |
| CREATED_BY | |
| CREATION_DATE | |
| LAST_UPDATED_BY | |
| LAST_UPDATE_DATE | |
| LAST_UPDATE_LOGIN |
| Manufacturing Execution System for Process Manufacturing - GMO_DISPENSE_AREA_B | Dispense Area Table |
|---|---|
| Column Name | Descritpion |
| DISPENSE_AREA_ID | Dispense Area Id |
| LAST_UPDATE_DATE | Standard who column |
| LAST_UPDATE_LOGIN | Standard who column |
| ORGANIZATION_ID | Organization Id |
| DISPENSE_AREA_NAME | Name for Dispense Area |
| DEFAULT_AREA_IND | |
| SUBINVENTORY_CODE | Subinventory associated to the dispense area |
| NUMBER_OF_TASKS_PER_DAY | No of Tasks which can be handled by the dispense area |
| CREATED_BY | Standard who column |
| CREATION_DATE | Standard who column |
| LAST_UPDATED_BY | Standard who column |
| Manufacturing Execution System for Process Manufacturing - GMO_DISPENSE_BOOTH_B | |
|---|---|
| Column Name | Descritpion |
| DISPENSE_BOOTH_ID | |
| DISPENSE_BOOTH_NAME | |
| DISPENSE_AREA_ID | |
| LOCATOR_ID | |
| CREATED_BY | |
| CREATION_DATE | |
| LAST_UPDATED_BY | |
| LAST_UPDATE_DATE | |
| LAST_UPDATE_LOGIN |
| Manufacturing Execution System for Process Manufacturing - GMO_DISPENSE_STORAGE_SUBINVS | |
|---|---|
| Column Name | Descritpion |
| DISPENSE_AREA_ID | |
| STORAGE_TYPE | |
| SUBINVENTORY_CODE | |
| CREATED_BY | |
| CREATION_DATE | |
| LAST_UPDATED_BY | |
| LAST_UPDATE_DATE | |
| LAST_UPDATE_LOGIN |
| Manufacturing Execution System for Process Manufacturing - GMO_DISPENSING_PLANNING | Dispense Planning Table |
|---|---|
| Column Name | Descritpion |
| PLANNED_TASK_ID | Primary key storing the planned id |
| CREATED_BY | Standard who column |
| CREATION_DATE | Standard who column |
| LAST_UPDATED_BY | Standard who column |
| LAST_UPDATE_DATE | Standard who column |
| LAST_UPDATE_LOGIN | Standard who column |
| RESERVATION_ID | Reservation id |
| DISPENSE_AREA_ID | Id for Dispense Area |
| PRIORITY | Priority : High,Medium,Low |
| PLANNED_DISPENSING_DATE | Planned Dispense Date |
| STATUS | Status : PLANNED,DISPENSD,REVRDISP |
| DISPENSE_ID | Dispensing id if dispensed |
| DISPENSED_DATE | Dispensed_date if dispensed |
| OPER_ID |
| Manufacturing Execution System for Process Manufacturing - GMO_KIOSK_PREFERENCES | Main Preferences Table |
|---|---|
| Column Name | Descritpion |
| PREFERENCES_ID | Unique Preference ID |
| LAST_UPDATE_DATE | Standard who column |
| ORGANIZATION_ID | Unique Organization ID |
| LEVEL_CODE | Indicates Preferences Level SITE,USER,RESPONSIBILITY for a given ORGANIZATION |
| LEVEL_VALUE | Value Applicable to the Preference Level |
| ENFORCE_CERTIFICATE_FLAG | Enforce Operator Certification Flag |
| CREATED_BY | Standard who column |
| CREATION_DATE | Standard who column |
| LAST_UPDATED_BY | Standard who column |
| LAST_UPDATE_LOGIN | Standard who column |
| Manufacturing Execution System for Process Manufacturing - GMO_KIOSK_LOV_T | |
|---|---|
| Column Name | Descritpion |
| PROCESS_ID | |
| ATTRIBUTE_ID | |
| ATTRIBUTE_TYPE | |
| ATTRIBUTE_NAME | |
| ATTRIBUTE_VALUE |
| Manufacturing Execution System for Process Manufacturing - GMO_KIOSK_DISP_PREFERENCES | Dispensing Preferences Table |
|---|---|
| Column Name | Descritpion |
| PREFERENCES_ID | Unique Preference ID |
| DEFAULT_DEVICE_ID | ID for Default Device |
| DEFAULT_SOURCE_DEVICE_ID | Default Source Device ID |
| DEFAULT_TARGET_DEVICE_ID | Default Target Device ID |
| OPERATOR_CERTIFICATE_FLAG | Flag To Enforce Operator Certification |
| DISPENSE_BOOTH | Dispensing Booth |
| DISPENSE_ORGANIZATION | Dispensing Organization |
| CREATED_BY | Standard who column |
| CREATION_DATE | Standard who column |
| LAST_UPDATED_BY | Standard who column |
| LAST_UPDATE_LOGIN | Standard who column |
| DISPENSE_AREA | Dispense Area ID |
| LAST_UPDATE_DATE | Standard who column |
| TIME_RANGE | Dispense Time Range |
| NO_OF_DAYS | Number Of Days Setting |
| ROLLING_FLAG | Flag Indicating Whether Rolling is enabled |
| DISPENSE_MODE | Dispense Mode |
| PALLET_LABEL_FLAG | Cage Label Flag |
| DISPENSE_LABEL_FLAG | Dispense Label Flag |
| MATERIAL_LABEL_FLAG | Material Label Flag |
| Manufacturing Execution System for Process Manufacturing - GMO_KIOSK_REV_DISP_PREFERENCES | Reverse Dispense Preferences |
|---|---|
| Column Name | Descritpion |
| PREFERENCES_ID | Unique Preference ID |
| DEFAULT_SOURCE_DEVICE_ID | |
| DEFAULT_TARGET_DEVICE_ID | |
| OPERATOR_CERTIFICATE_FLAG | |
| DISPENSE_BOOTH | |
| DISPENSE_ORGANIZATION | |
| CREATED_BY | |
| CREATION_DATE | |
| LAST_UPDATED_BY | |
| LAST_UPDATE_LOGIN | |
| LAST_UPDATE_DATE | |
| DISPENSE_AREA | Dispense Area ID |
| TIME_RANGE | Dispense Time Range |
| NO_OF_DAYS | Number Of Days Setting |
| ROLLING_FLAG | Flag Indicating Whether Rolling is enabled |
| DISPENSE_MODE | Dispense Mode |
| DISPENSE_LABEL_FLAG | Dispense Label Flag |
| MATERIAL_LABEL_FLAG | Material Label Flag |
| DEFAULT_DEVICE_ID | ID for Default Device |
| Manufacturing Execution System for Process Manufacturing - GMO_KIOSK_OWB_PREFERENCES | Operator Workbench Preferences |
|---|---|
| Column Name | Descritpion |
| PREFERENCES_ID | Unique Preference ID |
| LAST_UPDATE_LOGIN | Standard who column |
| LAST_UPDATE_DATE | Standard who column |
| TIME_RANGE | Time Range |
| NO_OF_DAYS | Number Of Days |
| ROLLING_FLAG | Flag Indicating Rolling |
| DEFAULT_RESOURCE | Default Resource |
| OPERATOR_CERTIFICATE_FLAG | Flag to Enforce Operator Certification |
| CREATED_BY | Standard who column |
| CREATION_DATE | Standard who column |
| LAST_UPDATED_BY | Standard who column |
| Manufacturing Execution System for Process Manufacturing - GMO_OPERT_CERT_HEADER | GMO Operator cert header |
|---|---|
| Column Name | Descritpion |
| HEADER_ID | header_id |
| LAST_UPDATE_LOGIN | Standard who column |
| ORGANIZATION_ID | Organization_id is organization which it is applicable |
| OBJECT_ID | Object_id is the Id for which it is applicable |
| OBJECT_TYPE | Name of the Object_type |
| OVERRIDE | Override is allowed for this object |
| CREATION_DATE | Standard who column |
| CREATED_BY | Standard who column |
| LAST_UPDATE_DATE | Standard who column |
| LAST_UPDATED_BY | Standard who column |
| Manufacturing Execution System for Process Manufacturing - GMO_OPERT_CERT_DETAIL | GMO_OPERT_CERT_DETAIL |
|---|---|
| Column Name | Descritpion |
| DETAIL_ID | detail_id |
| LAST_UPDATE_DATE | Standard who column |
| LAST_UPDATED_BY | Standard who column |
| LAST_UPDATE_LOGIN | Standard who column |
| HEADER_ID | header_id from GMO_OPERT_CERT_HEADER |
| QUALIFICATION_ID | Qualifiaction_id is Qualifiaction which it is applicable |
| QUALIFICATION_TYPE | |
| PROFICIENCY_LEVEL_ID | PROFICIENCY_LEVEL for this Qualification |
| FROM_DATE | From date for this qualification |
| TO_DATE | To date for this qualification |
| CREATION_DATE | Standard who column |
| CREATED_BY | Standard who column |
| Manufacturing Execution System for Process Manufacturing - GMO_OPERATOR_TRANS_DETAIL | GMO_OPERATOR_TRANS_DETAIL |
|---|---|
| Column Name | Descritpion |
| OPERATOR_CERTIFICATE_ID | OPERATOR_CERTIFICATE_ID |
| TRANS_DETAIL_ID | |
| HEADER_ID | |
| QUALIFICATION_ID | |
| QUALIFICATION_TYPE | |
| PROFICIENCY_LEVEL_ID | PROFICIENCY_LEVEL for this Qualification |
| Manufacturing Execution System for Process Manufacturing - GMO_OPERATOR_CERT_TRANS | GMO_OPERATOR_CERT_TRANS |
|---|---|
| Column Name | Descritpion |
| OPERATOR_CERTIFICATE_ID | OPERATOR_CERTIFICATE_ID |
| ERECORD_ID | ERECORD_ID for this transaction |
| TRANS_OBJECT_ID | Object for this transaction |
| STATUS | STATUS for this transaction |
| EVENT_KEY | EVENT_KEY for this transaction |
| EVENT_NAME | EVENT_NAME for this transaction |
| CREATION_DATE | Standard who column |
| CREATED_BY | Standard who column |
| LAST_UPDATE_DATE | Standard who column |
| LAST_UPDATED_BY | Standard who column |
| LAST_UPDATE_LOGIN | Standard who column |
| HEADER_ID | header_id from GMO_OPERT_CERT_HEADER |
| TRANSACTION_ID | TRANSACTION_ID is TRANSACTION which it is applicable |
| USER_ID | User_id of the Operator |
| COMMENTS | COMMENTS for this override |
| OVERRIDER_ID | OVERRIDER_ID for this qualification |
| USER_KEY_LABEL_PRODUCT | PRODUCT for this transaction |
| USER_KEY_LABEL_TOKEN | TOKEN for this transaction |
| USER_KEY_VALUE | Value for this transaction |
