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