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 |