Table Detail Report

SI_MATCH_TAG_PARMS_HIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: System Integration Match Tag Parms History
Definition: This table stores historical information for the match_tag_parms table.
Table Type: REFERENCE





Column Detail - SI_MATCH_TAG_PARMS_HIST


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_ENTITY_ALIAS_TYPE_CD DOUBLE N Copy of the Alias_Entity_Alias_Type_cd field from the match_tag_parms table.
ALIAS_ENTITY_NAME VARCHAR(32) Y Copy of the Alias_entity_Name field from the match_tag_parms table.
ALIAS_POOL_CD DOUBLE N Copy of the Alias_Pool_Cd field from the match_tag_parms table.
BILLING_IND DOUBLE Y Copy of the Billing_ind field from the match_tag_parms 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.
MATCH_FIELD_CD DOUBLE N Copy of the Match_Field_cd field from the match_tag_parms table.
MATCH_FUNCTION_CD DOUBLE N Copy of the Match_Function_cd field from the match_tag_parms table.
MATCH_SEQ DOUBLE Y Copy of the Match_Seq field from the match_tag_parms table.
MATCH_TAG_PARMS_ID DOUBLE N Copy of the Match_Tag_Parms_id field from the match_tag_parms table.
MATCH_VALIDATION_CD DOUBLE N Copy of the Match_validation_cd field from the match_tag_parms table.
MODIFY_PRSNL_ID DOUBLE N Prsnl ID of the user who made new modification on the match_tag_parms table
OPF_IND DOUBLE Y Copy of the Opf_ind field from the match_tag_parms table.
ORDER_CONTROL_CD DOUBLE N Copy of the Order_Control_cd field from the match_tag_parms table.
ORIG_PRSNL_ID DOUBLE N Prsnl ID of the user who made original modification on the match_tag_parms table
PRIM_ALIAS_IND DOUBLE Y Copy of the Prim_Alias_Ind field from the match_tag_parms table.
REC_BEG_EFF_DT_TM DATETIME Y Copy of the Rec_Beg_Eff_Dt_TM field from the match_tag_parms table.
SI_MATCH_TAG_PARMS_HIST_ID DOUBLE N SI_match_tag_parms_Hist_id Primary Key
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.
WEIGHT DOUBLE Y Copy of the Weight field from the match_tag_parms table.



Relationship Detail - SI_MATCH_TAG_PARMS_HIST


Child Column in SI_MATCH_TAG_PARMS_HIST(FK) Parent Table Name Parent Column Name
Parents: MODIFY_PRSNL_ID PRSNL PERSON_ID
ORIG_PRSNL_ID PRSNL PERSON_ID


SI_OID



Column Section Top of Page


Table-level Detail

Description: System Integration Object Identifier
Definition: This table will store OID information for use in determining code systems for outbound aliases and identifiers.
Table Type: REFERENCE





Column Detail - SI_OID


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.
BEG_EFFECTIVE_DT_TM DATETIME N The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
CERNER_DEFINED_IND DOUBLE N If this field is set to 1 then this is a pre-populated OID that has been certified by Cerner and shouldn't be modified by the client.
CONTRIBUTOR_SOURCE_CD DOUBLE N This is a contributor_source_cd that is related to the OID, it is not required. In some cases it is used as part of the select, in others it is sent back to the calling object for additional functionality. This is based on the type of OID selected.
END_EFFECTIVE_DT_TM DATETIME N The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
ENTITY_ID DOUBLE N A numeric identifier that is related to the Parent Entity Name to define the OID. This field can store values form Code Set 400 or 263. It isn't required depending upon the type of OID.
ENTITY_NAME VARCHAR(30) N Parent Table Name related to the ENTITY_ID value if ENTITY_ID is not zero.
ENTITY_TYPE VARCHAR(40) N A String description of the type of OID being stored, possible options are ALIASPOOL, ALLERGYID, NOMENCLATURE, ADMINISTRATIVEGENDER. This field is required with ENTITY_ID is zero.
OID_DISPLAY VARCHAR(100) Y Human readable display of the oid text
OID_TXT VARCHAR(200) N The OID for the Code System related to the given Parent Entity Name/ID. This should be in for of an OID #.#.#
SI_OID_ID DOUBLE N Unique Identifier for the SI_OID 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.


SI_RESULT_SET_ORDER_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: RESULT_SET_ORDER_RELTN
Definition: Stores information that links a result_set_id (from the ce_result_set_link table) to an order_id (on the orders table)
Table Type: ACTIVITY





Column Detail - SI_RESULT_SET_ORDER_RELTN


Column Name Type Null? Definition
CLINSIG_DT_TM DATETIME Y Clinically significant date time for result_set
ENTRY_MODE_CD DOUBLE N ENTRY MODE - From codeset 29520
ORDER_ID DOUBLE N Order_id tied to result_set_id
RESULT_SET_ID DOUBLE N Value from column result_set_id on ce_result_set_link table. This column is used to find rowI(s) that relate to an ORDER.
RESULT_SET_ORDER_RELTN_ID DOUBLE N PRIMARY KEY
RESULT_SET_STATUS_CD DOUBLE N Status of result_set
TASK_COMPLETION_DT_TM DATETIME Y Date/time when task was completed by Task Completion Server or Interactive View
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_RESULT_SET_ORDER_RELTN


Child Column in SI_RESULT_SET_ORDER_RELTN(FK) Parent Table Name Parent Column Name
Parents: ORDER_ID ORDERS ORDER_ID


SI_SERVICE_ACTION



Column Section Top of Page


Table-level Detail

Description: SI_SERVICE_ACTION
Definition: This table will store service actions for XDS services
Table Type: REFERENCE





Column Detail - SI_SERVICE_ACTION


Column Name Type Null? Definition
ACTION_SEQUENCE DOUBLE N The sequence of the action associated to the entity, if multiple SI_SERVICE_ACTION rows are associated
ACTION_TYPE VARCHAR(255) N Identifies the type of action associated to the entity. Action types will vary depending on the related entity
PARENT_ENTITY_ID DOUBLE N Entity the property is associated with. ID value from the table name identified in PARENT_ENTITY_NAME.
PARENT_ENTITY_NAME VARCHAR(30) N Contains the table name related to the PARENT_ENTITY_ID value.
SI_SERVICE_ACTION_ID DOUBLE N PRIMARY KEY
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_SPINE_AUDIT



Column Section Top of Page


Table-level Detail

Description: SI_SPINE_AUDIT
Definition: This table will store all Spine SOAP messages from si.soap_audit queue
Table Type: ACTIVITY





Column Detail - SI_SPINE_AUDIT


Column Name Type Null? Definition
MESSAGE_SIZE DOUBLE Y size of message as stored on this table
MESSAGE_TEXT LONGTEXT Y message that was sent/received
MSG_IDENT VARCHAR(100) Y message identifier from message body
MSG_TRIG_ACTION_TEXT VARCHAR(100) Y this is the message trigger
SI_SPINE_AUDIT_ID DOUBLE N Unique generated number that identifies a single row on the SI_SPINE_AUDIT table
TRN_CONV_IDENT VARCHAR(100) Y this is a unique identifier for conversation between two parties. the party initiating a conversation determines the value of the conversationid element that shall be reflected in all messages pertaining to that conversation.
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.