My Manufacturing Execution System for Process Manufacturing Table Descriptions hand book (I have big hands)

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