Table Detail Report

RULE_DEFINITION



Column Section Top of Page


Table-level Detail

Description: Rule Definition
Definition: Rule Definition
Table Type: ACTIVITY





Column Detail - RULE_DEFINITION


Column Name Type Null? Definition
LOCATION_CD DOUBLE N The field identifies the current permanent location of the patient. The location for an inpatient will be valued with the lowest level location type in the hierarchy of facility, building, nurse unit, room, bed.
LOC_FACILITY_CD DOUBLE N Facility code set.
MERGE_ID DOUBLE N Code set or id
MERGE_NAME VARCHAR(250) N Merge_name & Merge_id are used only for values that come from code_values or other tables.
PARAM_NAME VARCHAR(250) N Nameof the parameter type.
PARAM_VALUE VARCHAR(250) N Parameter value.e.g.:If the Param Name is 'Age of Request', the parameter value could be 1.
PARENT_ENTITY_ID DOUBLE N It would be the Expire_Rule_Id in Expire_Rule table.
PARENT_ENTITY_NAME VARCHAR(30) N It would be "Expire_Rule" table name.
RULE_DEFINITION_ID DOUBLE N Primary key of Rule_Definition table.
RULE_TYPE_CD DOUBLE N Rule Type Code
SEQ_NUM DOUBLE N Sequence Number
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_DOCUMENT_IDENT_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Document Identifier Relation
Definition: This table relates a document to its history (as known by Millennium) of document identifiers.
Table Type: ACTIVITY





Column Detail - SI_DOCUMENT_IDENT_RELTN


Column Name Type Null? Definition
DOCUMENT_IDENT VARCHAR(100) N The identifier of the document which is unique within the context of the system.
SI_DOCUMENT_IDENT_RELTN_ID DOUBLE N PRIMARY KEY
SI_DOCUMENT_METADATA_ID DOUBLE N The document metadata on the SI_DOCUMENT_METADATA table.
SYSTEM_TXT VARCHAR(100) Y The URI namespace for the identifier value.
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_DOCUMENT_IDENT_RELTN


Child Column in SI_DOCUMENT_IDENT_RELTN(FK) Parent Table Name Parent Column Name
Parents: SI_DOCUMENT_METADATA_ID SI_DOCUMENT_METADATA SI_DOCUMENT_METADATA_ID


SI_DOCUMENT_METADATA



Column Section Relationship Section Top of Page


Table-level Detail

Description: System Integration Document Metadata
Definition: This table keeps track of the most recent version of documents, with keys to more specific document tables, and can be used for filtering documents.
Table Type: ACTIVITY





Column Detail - SI_DOCUMENT_METADATA


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 Y 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.
BEG_EFFECTIVE_DT_TM DATETIME Y 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.
CLIENT_IDENT VARCHAR(100) N The identifier of the client who last updated the document.
CUR_DOC_ENTITY_ID DOUBLE N The CURRENT OR NEWEST tracked version of a document's metadata from table identified in DOC_ENTITY_NAME
DOC_ACTION_STATUS_CD DOUBLE N CODE SET:4002659; Status of the importing and staging of the document.
DOC_ENTITY_NAME VARCHAR(30) Y Parent Entity Name of the table from which the ID vaues come from for ROOT_DOC_ENTITY_ID and CUR_DOC_ENTITY_ID
DOC_FORMAT_CD DOUBLE N CODE SET:23; Allows a potential consumer to know how to render the specific media file format of the document and corresponds to the equivalent MIME type of the document as it was stored in CAMM
DOC_REFERENCE_STATUS_CD DOUBLE N CODE SET:8; Status of the document in the clinical workflow.
ENCNTR_ID DOUBLE N SEQUENCE NAME:ENCOUNTER_ONLY_SEQ; The primary encounter for the document.
END_EFFECTIVE_DT_TM DATETIME Y 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.
EVENT_CD DOUBLE N CODE SET:72; Specifies the precise kind of document (e.g. Pulmonary History and Physical, Discharge Summary, Ultrasound Report).
MDOC_EVENT_ID DOUBLE N SEQUENCE NAME:CLINICAL_EVENT_SEQ; The Event ID of the Parent document that this record is related to.this value is from EVENT_ID in CLINICAL_EVENT.
PERSON_ID DOUBLE N SEQUENCE NAME:PERSON_ONLY_SEQ; The person related to the document.
ROOT_DOC_ENTITY_ID DOUBLE N The ROOT or ORIGINAL tracked version of a document's metadata from table identified in DOC_ENTITY_NAME
SERVICE_STOP_DT_TM DATETIME Y Represents the start time the service being document took place (clinically significant).
SI_DOCUMENT_METADATA_ID DOUBLE N PRIMARY KEY
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_DOCUMENT_METADATA


Child Column in SI_DOCUMENT_METADATA(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
PERSON_ID PERSON PERSON_ID




Parent Column in SI_DOCUMENT_METADATA (PK) Child Table Name Child Column Name
Children: SI_DOCUMENT_METADATA_ID SI_DOCUMENT_IDENT_RELTN SI_DOCUMENT_METADATA_ID


SI_INTEROP_AUTHOR



Column Section Relationship Section Top of Page


Table-level Detail

Description: System Integration Advanced Interoperability Author
Definition: This table holds information about authors of documents that have metadata in the SI_INTEROP_METADATA table
Table Type: ACTIVITY





Column Detail - SI_INTEROP_AUTHOR


Column Name Type Null? Definition
AUTHOR_SEQUENCE DOUBLE N Sequence of the author in the metadata author list.
FULL_NAME_FRMT VARCHAR(255) Y The authors full formatted name.
PRSNL_ID DOUBLE N The identifier of the personnel if this author has been added to Millennium.
SI_INTEROP_AUTHOR_ID DOUBLE N PRIMARY KEY
SI_INTEROP_METADATA_ID DOUBLE N The SI_INTEROP_METADATA with this author.
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_INTEROP_AUTHOR


Child Column in SI_INTEROP_AUTHOR(FK) Parent Table Name Parent Column Name
Parents: PRSNL_ID PRSNL PERSON_ID
SI_INTEROP_METADATA_ID SI_INTEROP_METADATA SI_INTEROP_METADATA_ID


SI_INTEROP_METADATA



Column Section Relationship Section Top of Page


Table-level Detail

Description: SI INTEROP METADATA
Definition: System Integration Advanced Interop Metadata
Table Type: ACTIVITY





Column Detail - SI_INTEROP_METADATA


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.
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.
CATEGORY_TXT VARCHAR(100) Y The category that the document belongs to.
CLIENT_IDENT VARCHAR(100) N The identifier of the client who last updated the document.
CONFIDENTIALITY_TXT VARCHAR(100) N The value which indicates the confidentiality of the document.
DOC_ACTION_STATUS_CD DOUBLE N CODE SET:4002659; Status of the document in terms of the relationship with the database. Values include New or Processed.
DOC_EVENT_ID DOUBLE N SEQUENCE NAME:CLINICAL_EVENT_SEQ; The Event ID of the child document that this record is related to. - this value is from EVENT_ID in CLINICAL_EVENT.
DOC_FORMAT_CD DOUBLE N CODE SET:23; Allows a potential consumer to know how to render the specific media file format of the document and corresponds to the equivalent MIME type of the document as it was stored in CAMM.
DOC_REF_STATUS_CD DOUBLE N document reference status code value
DOC_TITLE VARCHAR(100) Y Title of the document.
ENCNTR_ID DOUBLE N SEQUENCE NAME:ENCOUNTER_ONLY_SEQ; The primary encounter for the document.
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.
EVENT_CD DOUBLE N CODE SET:72; Specifies the precise kind of document (e.g. Pulmonary History and Physical, Discharge Summary, Ultrasound Report).
FORMAT_CD DOUBLE N CODE SET:4002390; Along with typeCode, should provide sufficient information to allow potential consumer to know if it will be able to process the document. Shall be sufficiently specific to ensure processing/display by identifying a document encoding, structure and template (e.g. for HITSP CCD, the fact that it complies with a CDA schema, a template, and choice of content-specific style sheet.
INSTANCE_IND DOUBLE Y Indicates whether the record is a document instance.
LGL_AUTHENT_NAME_FULL_FRMT VARCHAR(255) Y legal authenticator full name formatted
LGL_AUTHENT_PRSNL_ID DOUBLE N PRSNL ID of the authenticator
MEDIA_OBJECT_IDENTIFIER VARCHAR(100) Y Identifier of the document object if stored in the multimedia storage.
MEDIA_OBJECT_VERSION_NBR DOUBLE Y Version of the identified document object in the multimedia storage.
PERSON_ID DOUBLE N SEQUENCE NAME:PERSON_ONLY_SEQ; The person related to the document.
ROOT_METADATA_ID DOUBLE N SEQUENCE NAME:SI_DOCUMENT_SEQ; The ID of the oldest version of the document in this table.
SERVICE_START_DT_TM DATETIME Y Represents the start time the service being documented took place (clinically significant).
SERVICE_START_TZ DOUBLE N The time zone in which the service start date time was captured.
SERVICE_STOP_DT_TM DATETIME Y date and time service was stopped
SERVICE_STOP_TZ DOUBLE N The time zone in which the service stop date time was captured.
SI_INTEROP_METADATA_ID DOUBLE N PRIMARY KEY
UPDATE_DT_TM DATETIME Y Date and time when the attachment (document) has been updated.
UPDATE_TZ DOUBLE N The time zone in which the update date time was captured.
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.
VERIFIED_DT_TM DATETIME Y Date and time the document was verified.
VERIFIED_TZ DOUBLE N The time zone in which the verified date time was captured.



Relationship Detail - SI_INTEROP_METADATA


Child Column in SI_INTEROP_METADATA(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
PERSON_ID PERSON PERSON_ID
LGL_AUTHENT_PRSNL_ID PRSNL PERSON_ID
ROOT_METADATA_ID SI_INTEROP_METADATA SI_INTEROP_METADATA_ID




Parent Column in SI_INTEROP_METADATA (PK) Child Table Name Child Column Name
Children: SI_INTEROP_METADATA_ID SI_INTEROP_AUTHOR SI_INTEROP_METADATA_ID
SI_INTEROP_METADATA ROOT_METADATA_ID