Table Detail Report
SI_FLAGS
Column Section | Top of Page |
Table-level Detail
Description: | System Integration Flags |
Definition: | This table defines the flags to be utilized by SI_Manager. |
Table Type: | REFERENCE |
Column Detail - SI_FLAGS
Column Name | Type | Null? | Definition |
---|---|---|---|
CODIFIED_IND | DOUBLE | N | Set on if the code is a codified or Bit mapped value. |
COLUMN_NAME | VARCHAR(30) | N | Name of the column related to a flag |
DEFINITION | VARCHAR(500) | N | Long definition of the flag value |
DISPLAY_TXT | VARCHAR(80) | N | Short description to be used in display drop-down |
FLAG_VALUE | DOUBLE | N | The value of the flag |
SI_FLAGS_ID | DOUBLE | N | Flag Identifier. Primary key for this table. |
TABLE_NAME | VARCHAR(30) | N | Name of the Table related to a flag |
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. |
SI_HAAD_FILE_DOWNLOAD
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | SI HAAD File Download |
Definition: | Table to keep track of downloaded files from HAAD |
Table Type: | ACTIVITY |
Column Detail - SI_HAAD_FILE_DOWNLOAD
Column Name | Type | Null? | Definition |
---|---|---|---|
FILE_CONTENT_ID | DOUBLE | N | Identifier on the long_blob table for the row containing the contents of the file. |
FILE_IDENT | VARCHAR(50) | N | HAAD-assigned file identifier |
FILE_NAME | VARCHAR(255) | N | Name of the file as identified by the uploading system |
PROCESSED_FLAG | DOUBLE | N | Whether or not the downloaded file was processed by Millennium. 0 = Not processed, 1 = Processed |
SI_HAAD_FILE_DOWNLOAD_ID | DOUBLE | N | PRIMARY KEY |
SI_HAAD_FILE_POLL_ID | DOUBLE | N | Identifier on the SI_HAAD_FILE_POLL table |
TRANSACTION_IDENT | VARCHAR(25) | N | Transaction identifier |
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. |
ZIP_IND | DOUBLE | N | Indicates whether the file content is a zip file |
Relationship Detail - SI_HAAD_FILE_DOWNLOAD
Child Column in SI_HAAD_FILE_DOWNLOAD(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | FILE_CONTENT_ID | LONG_BLOB | LONG_BLOB_ID |
SI_HAAD_FILE_POLL_ID | SI_HAAD_FILE_POLL | SI_HAAD_FILE_POLL_ID |
Parent Column in SI_HAAD_FILE_DOWNLOAD (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | SI_HAAD_FILE_DOWNLOAD_ID | SI_HAAD_TRANSACTION | SI_HAAD_FILE_DOWNLOAD_ID |
SI_HAAD_FILE_POLL
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | SI HAAD File Poll |
Definition: | HAAD Search Transaction Poll Log |
Table Type: | ACTIVITY |
Column Detail - SI_HAAD_FILE_POLL
Column Name | Type | Null? | Definition |
---|---|---|---|
END_DT_TM | DATETIME | Y | Time at which polling ended |
POLL_COUNT | DOUBLE | N | Number of the times the search transaction was called for a given poll |
POLL_TYPE_BIT | DOUBLE | N | This field will contain a bit map value to correspond to various options/combinations |
SENDING_FACILITY_IDENT | VARCHAR(75) | N | HAAD license number of sending facility |
SI_HAAD_FILE_POLL_ID | DOUBLE | N | PRIMARY KEY |
START_DT_TM | DATETIME | N | Time at which polling began |
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 - SI_HAAD_FILE_POLL
Parent Column in SI_HAAD_FILE_POLL (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | SI_HAAD_FILE_POLL_ID | SI_HAAD_FILE_DOWNLOAD | SI_HAAD_FILE_POLL_ID |
SI_HAAD_TRANSACTION
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | SI HAAD TRANSACTIONS |
Definition: | Table to keep track of the current status of HAAD transactions ( Health Authority - Abu Dhabi ) |
Table Type: | ACTIVITY |
Column Detail - SI_HAAD_TRANSACTION
Column Name | Type | Null? | Definition |
---|---|---|---|
COMPLETED_DT_TM | DATETIME | Y | The date and time the transaction completed processing. |
CREATE_DT_TM | DATETIME | N | The date and time the row was originally created. |
RETRIEVE_QUEUE_ID | DOUBLE | N | Link to the CQM queue_id of the retrieve |
SENDING_FACILITY_IDENT | VARCHAR(75) | Y | HAAD license number of sending facility |
SENDING_LOCATION_CD | DOUBLE | N | Code value denoting the sending facility |
SI_HAAD_FILE_DOWNLOAD_ID | DOUBLE | N | Link to the SI_HAAD_FILE_DOWNLOAD row of the downloaded response |
SI_HAAD_TRANSACTION_ID | DOUBLE | N | PRIMARY KEY |
STATUS_CD | DOUBLE | N | Code value denoting the current state of the transaction. |
STATUS_TEXT | VARCHAR(50) | Y | Textual detail about the current status |
SUBMIT_MSGLOG_ID | DOUBLE | Y | Link to the si_message_log row of the upload request |
SUBMIT_RESP_MSGLOG_ID | DOUBLE | Y | Link to the si_message_log row of the uploaded request Response |
TRANSACTION_IDENT | VARCHAR(25) | N | Identifier assigned by the health provider to identify the transaction. |
TRANSACTION_NBR | DOUBLE | N | TRANSACTION_NBR from the RX_CLAIMS table. |
TRANSACTION_SUBTYPE | VARCHAR(25) | Y | Subtype of transaction being sent outbound |
TRANSACTION_TYPE_FLAG | DOUBLE | N | Type of transaction being sent outbound |
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. |
UPLOAD_DT_TM | DATETIME | Y | Date and time of the upload |
UPLOAD_QUEUE_ID | DOUBLE | N | Link to the CQM queue_id of the upload |
Relationship Detail - SI_HAAD_TRANSACTION
Child Column in SI_HAAD_TRANSACTION(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | RETRIEVE_QUEUE_ID | CQM_OENINTERFACE_QUE | QUEUE_ID |
UPLOAD_QUEUE_ID | CQM_OENINTERFACE_QUE | QUEUE_ID | |
SI_HAAD_FILE_DOWNLOAD_ID | SI_HAAD_FILE_DOWNLOAD | SI_HAAD_FILE_DOWNLOAD_ID | |
SUBMIT_MSGLOG_ID | SI_MESSAGE_LOG | SI_MESSAGE_LOG_ID | |
SUBMIT_RESP_MSGLOG_ID | SI_MESSAGE_LOG | SI_MESSAGE_LOG_ID |
SI_HIST_ALIAS_FLD_CONTR_SRC_R
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | System Integration Alias Field Contributor Source Relation History |
Definition: | This table stores historical information for the si_alias_field_contr_src_r_hist table |
Table Type: | REFERENCE |
Column Detail - SI_HIST_ALIAS_FLD_CONTR_SRC_R
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. |
ACTIVE_STATUS_CD | DOUBLE | N | Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc. |
ACTIVE_STATUS_DT_TM | DATETIME | N | The date and time that the active_status_cd was set. |
ACTIVE_STATUS_PRSNL_ID | DOUBLE | N | The person who caused the active_status_cd to be set or change. |
ALIAS_FLD_CONTR_SRC_R_ID | DOUBLE | N | Copy of the Alias_field_contr_src_id from the si_alias_field_contr_src_r table |
CONTRIBUTOR_SOURCE_CD | DOUBLE | N | Copy of the Contributor_source_cd from the si_alias_field_contr_src_r table |
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. |
FIELD_CD | DOUBLE | N | Copy of the Field_cd from the si_alias_field_contr_src_r table |
FIELD_NAME | VARCHAR(256) | Y | Copy of the Field_name from the si_alias_field_contr_src_r table |
HIST_ALIAS_FLD_CONTR_SRC_R_ID | DOUBLE | N | Alias Field Contributor Source Relation History ID |
MODIFY_PRSNL_ID | DOUBLE | N | Prsnl ID of the user who made new modification on the si_alias_field_contr_src_r table |
ORIG_PRSNL_ID | DOUBLE | N | Prsnl ID of the user who made original modification on the si_alias_field_contr_src_r table |
REC_BEG_EFF_DT_TM | DATETIME | N | Copy of the Beg_Eff_Dt_TM from the si_alias_field_contr_src_r table |
SEGMENT_NAME | VARCHAR(256) | Y | Copy of the Segment_name from the si_alias_field_contr_src_r table |
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 - SI_HIST_ALIAS_FLD_CONTR_SRC_R
Child Column in SI_HIST_ALIAS_FLD_CONTR_SRC_R(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | MODIFY_PRSNL_ID | PRSNL | PERSON_ID |
ORIG_PRSNL_ID | PRSNL | PERSON_ID | |
ALIAS_FLD_CONTR_SRC_R_ID | SI_ALIAS_FLD_CONTR_SRC_R | ALIAS_FLD_CONTR_SRC_R_ID |