Table Detail Report

SI_TEMPLATE



Column Section Relationship Section Top of Page


Table-level Detail

Description: System Integration Template
Definition: Stores template information by Contributor System code
Table Type: REFERENCE





Column Detail - SI_TEMPLATE


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 This indicator will be set to 1 for the templates that are defined by Cerner. These templates a can't be modified
CONTRIBUTOR_SOURCE_CD DOUBLE N Used to define the Contributor Source for the template when not HITSP or CCD. If this isn't valued, then the Contributor Source of the Contributor System will be used.
DEFAULT_SECTION_TITLE VARCHAR(100) Y Default Title to appear for the section built by this template.
DESCRIPTION VARCHAR(255) Y TEMPLATE DESCRIPTION
DESCRIPTION_KEY VARCHAR(255) Y _KEY version of the DESCRIPTION assigned by the user. This data is stripped of spaces and special characters and converted to upper case.
DISCRETE_LONG_BLOB_ID DOUBLE N Foreign Key Identifier to the LONG_BLOB_REFERENCE table that stores the style sheet to be used for the discrete section.
DISCRETE_SS_NAME VARCHAR(50) N Name of the Style Sheet used to detail discrete data for the selected section type.
DISCRETE_STYLE_SHEET_ID DOUBLE N Foreign key to the SI_TEMPLATE_STYLE_SHEET table for the discrete style sheet.
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.
NARRATIVE_LONG_BLOB_ID DOUBLE N Foreign Key Identifier to the LONG_BLOB_REFERENCE table that stores the style sheet to be used for the narrative section.
NARRATIVE_SS_NAME VARCHAR(50) N Name of the Style Sheet used to detail narrative data for the selected section type.
NARRATIVE_STYLE_SHEET_ID DOUBLE N Foreign key to the SI_TEMPLATE_STYLE_SHEET table for the narrative style sheet.
OUTPUT_CONTENT_CLASS_CD DOUBLE N Output Content Class Code used to define the standard that the stylesheet was built to represent.
OUTPUT_CONTENT_TYPE_CD DOUBLE N This column will become logicall OBSOLETE with the introduction of new column OUTPUT_CONTENT_CLASS_CD and new code changes.The output content type that this template is based off of.
PREV_SI_TEMPLATE_ID DOUBLE N Previous (original) ID of the versioned set of rows. Used for type-2 versioning
SECTION_CD DOUBLE N The section that this template is used to detail
SI_TEMPLATE_ID DOUBLE N The primary Identifier
TEMPLATE_TYPE_CD DOUBLE N When valued, this field will combine with output content type to specify which si_templates can be used.
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_TEMPLATE


Child Column in SI_TEMPLATE(FK) Parent Table Name Parent Column Name
Parents: PREV_SI_TEMPLATE_ID SI_TEMPLATE SI_TEMPLATE_ID
DISCRETE_STYLE_SHEET_ID SI_TEMPLATE_STYLE_SHEET SI_TEMPLATE_STYLE_SHEET_ID
NARRATIVE_STYLE_SHEET_ID SI_TEMPLATE_STYLE_SHEET SI_TEMPLATE_STYLE_SHEET_ID




Parent Column in SI_TEMPLATE (PK) Child Table Name Child Column Name
Children: SI_TEMPLATE_ID SI_TEMPLATE PREV_SI_TEMPLATE_ID
SI_TEMPLATE_GROUP_RELTN SI_TEMPLATE_ID


SI_TEMPLATE_GROUP



Column Section Relationship Section Top of Page


Table-level Detail

Description: System Integration Template Group Relation
Definition: Stores template group relationships along with output content type and default information.
Table Type: REFERENCE





Column Detail - SI_TEMPLATE_GROUP


Column Name Type Null? Definition
CERNER_DEFINED_IND DOUBLE Y When set, this template group has been defined by Cerner and templates can't be added or removed from the group.
DEFAULT_IND DOUBLE N This indicates the default template group for a given output_content_type_cd, only one template group per output_content_type_cd can have this set at a time.
GROUP_DESCRIPTION VARCHAR(250) N This field describes the group of templates.
OUTPUT_CONTENT_TYPE_CD DOUBLE N The output type of this set of templates.
RENDERING_URL VARCHAR(256) Y The URL of the rendering style sheet for all documents generated using this Template Group
SI_TEMPLATE_GROUP_ID DOUBLE N The primary Identifier
SUMMARY_CARE_TYPE_CD DOUBLE N If selected, then this document must meet all required specifications for the selected type.
SYSTEM_DEFAULT_IND DOUBLE N This indicates the default template group for the system, only one template group can have this set at a time.
TEMPLATE_TYPE_CD DOUBLE N When valued, this field will combine with output content type to specify which si_templates can be used.
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_TEMPLATE_GROUP




Parent Column in SI_TEMPLATE_GROUP (PK) Child Table Name Child Column Name
Children: SI_TEMPLATE_GROUP_ID SI_DOCUMENT_INFO SI_TEMPLATE_GROUP_ID
SI_ENTITY_TEMPLATE_GROUP_R SI_TEMPLATE_GROUP_ID
SI_TEMPLATE_GROUP_RELTN SI_TEMPLATE_GROUP_ID


SI_TEMPLATE_GROUP_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: System Integration Template Group Relation
Definition: Stores template group relationships along with output content type and default information.
Table Type: REFERENCE





Column Detail - SI_TEMPLATE_GROUP_RELTN


Column Name Type Null? Definition
SECTION_SIGNIFICANCE_FLAG DOUBLE Y This value dictates the significance of the given section during the document creation process.
SECTION_TITLE VARCHAR(100) Y The Title that will appear for when this template and group combination is used.
SEQUENCE DOUBLE N Sequence number used to order and group sets of templates
SI_TEMPLATE_GROUP_ID DOUBLE N Foreign Key to the SI_TEMPLATE_GROUP table
SI_TEMPLATE_GROUP_RELTN_ID DOUBLE N The primary Identifier
SI_TEMPLATE_ID DOUBLE N The template ID that is grouped with other similar template IDs .
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_TEMPLATE_GROUP_RELTN


Child Column in SI_TEMPLATE_GROUP_RELTN(FK) Parent Table Name Parent Column Name
Parents: SI_TEMPLATE_ID SI_TEMPLATE SI_TEMPLATE_ID
SI_TEMPLATE_GROUP_ID SI_TEMPLATE_GROUP SI_TEMPLATE_GROUP_ID


SI_TEMPLATE_STYLE_SHEET



Column Section Relationship Section Top of Page


Table-level Detail

Description: System Integration Template Style Sheet
Definition: All Style Sheets utilized by the SI Document Generation process are stored here for location purposes.
Table Type: REFERENCE





Column Detail - SI_TEMPLATE_STYLE_SHEET


Column Name Type Null? Definition
CERNER_DEFINED_IND DOUBLE N This record is defined by Cerner and not allowed to be changed in any way.
FILE_NAME_TXT VARCHAR(50) N The name of the text file created when this record is extracted to the file system for processing. This muct be unique for all records.
LONG_BLOB_REFERENCE_ID DOUBLE N Foreign key to the long blob reference table where the style sheet is stored.
OUTPUT_CONTENT_CLASS_CD DOUBLE N All style sheets are required to have an output content class code to define where they are allowed to be executed.
OUTPUT_CONTENT_TYPE_CD DOUBLE N All style sheets are required to have an output content type code to define where they are allowed to be executed.
REFERENCE_IND DOUBLE N This file created by this record can only be referenced by other files and isn't used as a primary file for procesing purposes.
SECTION_CD DOUBLE N Primary Style Sheets are associated to the section code that they are built to create.
SI_TEMPLATE_STYLE_SHEET_ID DOUBLE N PRIMARY KEY
TEMPLATE_TYPE_CD DOUBLE N Depending upon the need, Template Type is only required in specialty cases, such as Dynamic Documentation.`
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.
VERSION_TXT VARCHAR(32) N The version of the Style Sheet that has been stored in the database that can be compared to the style sheet in the service jar



Relationship Detail - SI_TEMPLATE_STYLE_SHEET


Child Column in SI_TEMPLATE_STYLE_SHEET(FK) Parent Table Name Parent Column Name
Parents: LONG_BLOB_REFERENCE_ID LONG_BLOB_REFERENCE LONG_BLOB_ID




Parent Column in SI_TEMPLATE_STYLE_SHEET (PK) Child Table Name Child Column Name
Children: SI_TEMPLATE_STYLE_SHEET_ID SI_TEMPLATE DISCRETE_STYLE_SHEET_ID
SI_TEMPLATE NARRATIVE_STYLE_SHEET_ID


SI_TRANSACTION



Column Section Relationship Section Top of Page


Table-level Detail

Description: System Integration Transaction
Definition: Details and processing status about inbound or outbound interface transactionS
Table Type: ACTIVITY





Column Detail - SI_TRANSACTION


Column Name Type Null? Definition
ACKNOWLEDGEMENT_FLAG DOUBLE N State of acknowledgement of the transaction by the user 0 = Not Acknowledged, 1 = Acknowledged
ENCNTR_ID DOUBLE N Associated encntr_id of the transaction (if applicable)
END_DT_TM DATETIME Y Completion time of the transaction
PERSON_ID DOUBLE N Associated person_id of the transaction (if applicable)
SI_TRANSACTION_ID DOUBLE N PRIMARY KEY
SI_TRANSACTION_SET_ID DOUBLE N The optional parent set of the transaction
START_DT_TM DATETIME N Creation time of the transaction
TXN_STATUS_DETAIL_TXT VARCHAR(500) N Detailed status of the transaction
TXN_STATUS_TXT VARCHAR(12) N Status of the transaction
TXN_TYPE_TXT VARCHAR(12) N Type of transaction
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.



Relationship Detail - SI_TRANSACTION


Child Column in SI_TRANSACTION(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
PERSON_ID PERSON PERSON_ID
SI_TRANSACTION_SET_ID SI_TRANSACTION_SET SI_TRANSACTION_SET_ID




Parent Column in SI_TRANSACTION (PK) Child Table Name Child Column Name
Children: SI_TRANSACTION_ID SI_TRANSACTION_DETAIL SI_TRANSACTION_ID
SI_UNMTCHD_PRSN_QUE_RELTN SI_TRANSACTION_ID