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. |