CODE_SET_INTERFACE
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Code Set Interface Table |
Definition: | This table is used by ESI and ESO to define code value alias processing rules. |
Table Type: | REFERENCE |
Column Detail - CODE_SET_INTERFACE
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVE_IND | DOUBLE | Y | The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc. |
ALIAS_TYPE_MEANING | VARCHAR(12) | Y | The meaning of the alias. Used when alias is not unique enough within a code_set. |
CODE_SET | DOUBLE | N | The number of the code set header record (determined by following the procedure for creating a new code set). |
CONTRIBUTOR_SYSTEM_CD | DOUBLE | N | Contributor system identifies the source feed of data from which a row was populated. This is mainly used to determine how to update a set of data that may have originated from more than one source feed. |
DEFAULT_ALIAS | VARCHAR(255) | Y | This may define the default alias string to use (maining for ESO) when an outbound alias can not be found for a code value. |
DEFAULT_CD | DOUBLE | N | This may define the default code value to use when an inbound alias is not found for a particular code set. |
PROCESS_CD | DOUBLE | N | The field defines the processing meaning/function when the alias for code value by either the ESI or ESO servers. |
SYS_DIRECTION_CD | DOUBLE | N | This define the direction of the interface either TO_HNA or FROM_HNA. |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. |
UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. |
Relationship Detail - CODE_SET_INTERFACE
Child Column in CODE_SET_INTERFACE(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | CODE_SET | CODE_VALUE_SET | CODE_SET |
CQM_CONTRIBUTOR_CONFIG
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | CQM Contributor Configuration |
Definition: | The CQM contributor configuration table identifies the verifiable alias of contributor applications that are permitted to add transactions to an associated CQM queue table. Each alias is associated with a CQM application in this table. |
Table Type: | REFERENCE |
Column Detail - CQM_CONTRIBUTOR_CONFIG
Column Name | Type | Null? | Definition |
---|---|---|---|
APPLICATION_NAME | VARCHAR(12) | N | The application name denotes a specific usage of CQM. This string is limited to twelve characters as it concatenated into DB table names to isolate the physical storage space of transaction by application. |
CONTRIBUTOR_ALIAS | VARCHAR(48) | N | The verifiable alias, by application name, which denotes a contributor application that act as the originators of CQM transactions. |
CONTRIBUTOR_ID | DOUBLE | N | This is the value of the unique primary identifier of the CQM contributor configuration table. It is an internal system assigned number. |
CREATE_DT_TM | DATETIME | N | The date and time the row was inserted. |
DEBUG_IND | DOUBLE | Y | Defines whether debugging is active or inactive for the contributor alias and application |
TARGET_PRIORITY | DOUBLE | Y | Identifies the priority of a target transaction row in the queue table for the contributor alias and application. The value range for priority is 1 through 99, highest to lowest, respectively. |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. |
UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. |
VERBOSITY_FLAG | DOUBLE | Y | Defines the verbosity level during debugging for the contributor alias and application. |
Relationship Detail - CQM_CONTRIBUTOR_CONFIG
Parent Column in CQM_CONTRIBUTOR_CONFIG (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | CONTRIBUTOR_ID | CQM_BMDI_RESULTS_QUE | CONTRIBUTOR_ID |
CQM_FSIESO_QUE | CONTRIBUTOR_ID | ||
CQM_FSIOCC_QUE | CONTRIBUTOR_ID | ||
CQM_MDRESULTS_QUE | CONTRIBUTOR_ID | ||
CQM_MICRESULTS_QUE | CONTRIBUTOR_ID |
CQM_FSIESO_QUE
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | FSI ESO CQM Queue |
Definition: | This CQM queue table is the primary storage locations of the transaction message for the FSI ESO application. This table contains the administrative and routing data used for controlling the transaction. |
Table Type: | ACTIVITY |
Column Detail - CQM_FSIESO_QUE
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVE_IND | DOUBLE | N | The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc. |
CLASS | VARCHAR(15) | Y | Identifies the trigger explosion class of the transaction. |
CONTRIBUTOR_EVENT_DT_TM | DATETIME | Y | Significant date and time associated with the transaction row as supplied by the contributor application. |
CONTRIBUTOR_ID | DOUBLE | N | This is the value of the unique primary identifier of the CQM contributor configuration table. It is an internal system assigned number. |
CONTRIBUTOR_REFNUM | VARCHAR(48) | N | A reference or key assigned to the transaction row by the contributor application. It recommended that this identifier be unique although it is not required. |
CREATE_DT_TM | DATETIME | N | The date and time the row was inserted. |
CREATE_RETURN_FLAG | DOUBLE | Y | The current trigger explosion state for this transaction row. |
CREATE_RETURN_TEXT | VARCHAR(132) | Y | Return text string from the trigger explosion process of this transaction row. |
DEBUG_IND | DOUBLE | Y | Defines whether debugging is active or inactive for the queue transaction unidentified in this row. |
MESSAGE | LONGBLOB | Y | This is the binary longraw field which contains the contents of the original message. |
MESSAGE_LEN | DOUBLE | N | The length of the textual or binary object placed in the message field. |
MESSAGE_SEQUENCE | DOUBLE | N | This is a numeric value that determines the order in which the messages will be processed. It is based on the date and time that the row was inserted. |
PARAM_LIST_IND | DOUBLE | Y | Identifies whether there are row in the queue parameters table associated with this transaction row. |
PRIORITY | DOUBLE | N | Identifies the priority of this transaction row that may or may not be used to process in a prioritized method. The value range for priority is 1 through 99, highest to lowest, respectively. |
PROCESS_STATUS_FLAG | DOUBLE | N | The current trigger explosion state for this transaction row. |
QUEUE_ID | DOUBLE | N | This is the value of the unique primary identifier of the CQM queue table. It is an internal system assigned number. |
SUBTYPE | VARCHAR(15) | Y | Identifies the trigger explosion subtype of the transaction. |
SUBTYPE_DETAIL | VARCHAR(15) | Y | Identifies the trigger explosion subtype detail of the transaction. |
TRIG_CREATE_END_DT_TM | DATETIME | Y | The date and time the trigger explosion completed on this transaction row. |
TRIG_CREATE_START_DT_TM | DATETIME | Y | The date and time the trigger explosion began on this transaction row. |
TRIG_MODULE_IDENTIFIER | VARCHAR(16) | Y | Future. Identifies the process/module which performs the trigger explosion on this transaction row. |
TYPE | VARCHAR(15) | Y | Identifies the trigger explosion type of the transaction. |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. |
UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. |
VERBOSITY_FLAG | DOUBLE | Y | Defines the verbosity level during debugging for the processing of the transaction. |
Relationship Detail - CQM_FSIESO_QUE
Child Column in CQM_FSIESO_QUE(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | CONTRIBUTOR_ID | CQM_CONTRIBUTOR_CONFIG | CONTRIBUTOR_ID |
Parent Column in CQM_FSIESO_QUE (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | QUEUE_ID | DQR_DOCUMENT_ACTION | ESO_QUEUE_ID |
FSIESO_QUE_DETAILS | QUEUE_ID | ||
HOLD_QUEUE | QUEUE_ID | ||
SI_AUDIT | QUEUE_ID | ||
WF_STFG_HDR | QUEUE_ID |
CQM_FSIESO_TR_1
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | FSI ESO Listener Trigger #1 |
Definition: | The CQM listener trigger table contains the administrative data for the processing of a trigger exploded CQM transaction by a listener application. This table contains data for the FSI ESO application. |
Table Type: | ACTIVITY |
Column Detail - CQM_FSIESO_TR_1
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVE_IND | DOUBLE | N | The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc. |
COMPLETION_SEQUENCE_ID | DOUBLE | N | This is the value that unique identifies the transaction completion order by the listener application. It is an internal system assigned number. |
CREATE_DT_TM | DATETIME | N | The date and time the row was inserted. |
DEBUG_IND | DOUBLE | Y | Defines whether debugging is active or inactive for the listener trigger explosion event unidentifie in this row. |
ESO_TRIGGER_ID | DOUBLE | N | This is the value of the unique primary identifier of the eso_trigger table. It is an internal system assigned number. |
LAST_RETRY_DT_TM | DATETIME | Y | The date and time of the last retry to process this trigger exploded transaction row. This field may or may not be used by the listener application. |
LISTENER_ID | DOUBLE | N | This is the value of the unique primary identifier of the CQM listener configuration table. It is an internal system assigned number. |
L_R_PROCESS_STATUS_FLAG | DOUBLE | Y | The last retry processing state for this trigger exploded transaction row. This field may or may not be used by the listener application. |
L_R_TRIGGER_STATUS_TEXT | VARCHAR(132) | Y | The last retry processing text for this trigger exploded transaction row. This field may or may not be used by the listener application. |
MESSAGE_SEQUENCE | DOUBLE | N | This is a numeric value that determines the order in which the messages will be processed. It is based on the date and time that the row was inserted. |
NUMBER_OF_RETRIES | DOUBLE | Y | Set to 0 on insert. Optionally incremented by 1 by the listener application to specify the number of times the listener attempted to process the trigger exploded transaction. |
PRIORITY | DOUBLE | Y | Identifies the priority of this transaction row that may or may not be used to process in a prioritized method. The value range for priority is 1 throug 99, highest to lowest, respectively. |
PROCESS_START_DT_TM | DATETIME | Y | The date and time the listener application started processing on this exploded transaction. |
PROCESS_STATUS_FLAG | DOUBLE | N | The current processing state for this trigger exploded transaction row. |
PROCESS_STOP_DT_TM | DATETIME | Y | The date and time the listener application completed processing on this exploded transaction. |
QUEUE_ID | DOUBLE | N | This is the value of the unique primary identifier of the CQM queue table. It is an internal system assigned number. |
SCHEDULE_DT_TM | DATETIME | N | The date and time this exploded transaction row is scheduled for processing. |
TRANSACTION_TIME_IN_SECONDS | DOUBLE | Y | Stores the elapsed time in seconds for an entire transaction in ESO |
TRIGGER_ID | DOUBLE | N | This is the value of the unique primary identifier of the CQM listener trigger table. It is an internal system assigned number. |
TRIGGER_STATUS_TEXT | VARCHAR(132) | Y | The status text associated with the processing status flag. |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
VERBOSITY_FLAG | DOUBLE | Y | Defines the verbosity level during debugging for the processing of the transaction. |
Relationship Detail - CQM_FSIESO_TR_1
Child Column in CQM_FSIESO_TR_1(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ESO_TRIGGER_ID | ESO_TRIGGER | TRIGGER_ID |
Parent Column in CQM_FSIESO_TR_1 (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | TRIGGER_ID | CR_REPORT_REQUEST | TRIGGER_ID |
HOLD_QUEUE | TRIGGER_ID | ||
SI_ALERT_EVENT | FSIESO_TRIGGER_ID | ||
SI_DOCUMENT_TRANSACTION_LOG | ESO_TRIGGER_ID |
CQM_FSIOCC_QUE
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | FSI Outbound ComClient CQM Queue |
Definition: | This CQM queue table is the primary storage locations of the transaction message for the FSI Outbound ComClient application. This table contains the administrative and routing data used for controlling the transaction. |
Table Type: | ACTIVITY |
Column Detail - CQM_FSIOCC_QUE
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVE_IND | DOUBLE | N | The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc. |
CLASS | VARCHAR(15) | Y | Identifies the trigger explosion class of the transaction. |
CONTRIBUTOR_EVENT_DT_TM | DATETIME | Y | Significant date and time associated with the transaction row as supplied by the contributor application. |
CONTRIBUTOR_ID | DOUBLE | N | This is the value of the unique primary identifier of the CQM contributor configuration table. It is an internal system assigned number. |
CONTRIBUTOR_REFNUM | VARCHAR(48) | N | A reference or key assigned to the transaction row by the contributor applicatio. It recommended that this identifier be unique although it is not required. |
CREATE_DT_TM | DATETIME | N | The date and time the row was inserted. |
CREATE_RETURN_FLAG | DOUBLE | Y | The current trigger explosion state for this transaction row. |
CREATE_RETURN_TEXT | VARCHAR(132) | Y | Return text string from the trigger explosion process of this transaction row. |
DEBUG_IND | DOUBLE | Y | Defines whether debugging is active or inactive for the queue transaction unidentifie in this row. |
MESSAGE | LONGBLOB | Y | This is the binary longraw field which contains the contents of the original message. |
MESSAGE_LEN | DOUBLE | N | The length of the textual or binary object placed in the message field. |
PARAM_LIST_IND | DOUBLE | Y | Identifies whether there are row in the queue parameters table associated with this transaction row. |
PRIORITY | DOUBLE | N | Identifies the priority of this transaction row that may or may not be used to process in a prioritized method. The value range for priority is 1 throug 99, highest to lowest, respectively. |
PROCESS_STATUS_FLAG | DOUBLE | N | The current trigger explosion state for this transaction row. |
QUEUE_ID | DOUBLE | N | This is the value of the unique primary identifier of the CQM queue table. It is an internal system assigned number. |
SUBTYPE | VARCHAR(15) | Y | Identifies the trigger explosion subtype of the transaction. |
SUBTYPE_DETAIL | VARCHAR(15) | Y | Identifies the trigger explosion subtype detail of the transaction. |
TRIG_CREATE_END_DT_TM | DATETIME | Y | The date and time the trigger explosion completed on this transaction row. |
TRIG_CREATE_START_DT_TM | DATETIME | Y | The date and time the trigger explosion began on this transaction row. |
TRIG_MODULE_IDENTIFIER | VARCHAR(16) | Y | Future. Identifies the process/module which performs the trigger explosion on this transaction row. |
TYPE | VARCHAR(15) | Y | Identifies the trigger explosion type of the transaction. |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. |
UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. |
VERBOSITY_FLAG | DOUBLE | Y | Defines the verbosity level during debugging for the processing of the transaction. |
Relationship Detail - CQM_FSIOCC_QUE
Child Column in CQM_FSIOCC_QUE(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | CONTRIBUTOR_ID | CQM_CONTRIBUTOR_CONFIG | CONTRIBUTOR_ID |