Table Detail Report
ABST_CODING_RELTN
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | ABSTRACTING CODING RELATION |
Definition: | Relationship between code and abstracting field |
Table Type: | ACTIVITY |
Column Detail - ABST_CODING_RELTN
Column Name | Type | Null? | Definition |
---|---|---|---|
ABSTRACT_FIELD_DEF_CD | DOUBLE | N | this is the unique identifier to the abstract field def table |
ABST_CODING_RELTN_ID | DOUBLE | N | This is the value of the unique primary identifier of the abst_coding_reltn table. It is an internal system assigned number. It is filled out if the media was moved from another media. |
ACTIVE_IND | DOUBLE | Y | 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. |
ENCNTR_ID | DOUBLE | N | This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number. |
ENCNTR_SLICE_ID | DOUBLE | N | Identifies an Encounter as it relates to a time slice. |
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. |
PARENT_ENTITY_ID | DOUBLE | N | This is the value of the unique primary identifier of the parent table. It is an internal system assigned number. It is filled out if the media was moved from another media. |
PARENT_ENTITY_NAME | VARCHAR(255) | Y | This is the name of the parent table |
PERSON_ID | DOUBLE | N | This is the value of the unique primary identifier of the person table. It is an internal system assigned number. |
SVC_CAT_HIST_ID | DOUBLE | N | This is the unique identifier for the service category history 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. |
Relationship Detail - ABST_CODING_RELTN
Child Column in ABST_CODING_RELTN(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ENCNTR_SLICE_ID | ENCNTR_SLICE | ENCNTR_SLICE_ID |
ENCNTR_ID | ENCOUNTER | ENCNTR_ID | |
PERSON_ID | PERSON | PERSON_ID | |
SVC_CAT_HIST_ID | SERVICE_CATEGORY_HIST | SVC_CAT_HIST_ID |
ABST_FORM_SECURITY
Column Section | Top of Page |
Table-level Detail
Description: | Abstract form security |
Definition: | Abstract form security |
Table Type: | REFERENCE |
Column Detail - ABST_FORM_SECURITY
Column Name | Type | Null? | Definition |
---|---|---|---|
ABST_FORM_SECURITY_ID | DOUBLE | N | This is the unique identifier to the abs_form_security able. It is a system assigned number. |
ACTIVE_IND | DOUBLE | Y | 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 | Y | 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 | Y | The person who caused the active_status_cd to be set or change. |
APP_GROUP_CD | DOUBLE | Y | This is used to identify if a user has privilege to view/edit a form based on their application security group. |
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. |
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. |
FLEX_FORM_ID | DOUBLE | Y | This is the unique identifier to the flex form table. It is a system assigned number |
FULL_ACCESS_IND | DOUBLE | Y | This indicator is checked to see if a user should be granted full access to this form. |
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. |
BATCH_LABEL
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | This table is used to store the list of media that needed to be printed in batch |
Definition: | Media that need to be printed in a batch run |
Table Type: | ACTIVITY |
Column Detail - BATCH_LABEL
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVE_IND | DOUBLE | Y | 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. |
ALIAS_SORT_STRING | VARCHAR(40) | Y | This field will hold the sort value based on settings in the him_label_format table (MRN or FIN in TDO or Serial) |
BATCH_LABEL_ID | DOUBLE | N | This is the value of the unique primary identifier of the batch_label master table. It is an internal system assigned number |
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. |
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_DT_TM | DATETIME | Y | The date and time that autocreated media was created |
HIM_PRINTER_FORMATS_ID | DOUBLE | N | Unique key from the HIM_PRINTER_FORMATS table. This determines where we are printing to and what script to call when creating label. |
MEDIA_MASTER_ID | DOUBLE | N | This is the value of the unique primary identifier of the media master table. It is an internal system assigned 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. |
Relationship Detail - BATCH_LABEL
Child Column in BATCH_LABEL(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | MEDIA_MASTER_ID | MEDIA_MASTER | MEDIA_MASTER_ID |
CAC_DOCUMENT
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Computer Assisted Coding Documents |
Definition: | Stores information on documents that have been parsed for computer assisted coding |
Table Type: | ACTIVITY |
Column Detail - CAC_DOCUMENT
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 | 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. |
BLOB_HANDLE | VARCHAR(255) | Y | Handle to remote blob. |
CAC_DOCUMENT_ID | DOUBLE | N | Unique identifier number for this row |
CLINICAL_EVENT_ID | DOUBLE | N | Clinical Event ID this document belongs to |
ENCNTR_ID | DOUBLE | N | Encounter ID this document belongs to |
ENCNTR_SLICE_ID | DOUBLE | N | Encounter Slice ID this document belongs to |
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_ID | DOUBLE | N | Event ID for the original version of the document |
FURTHER_REVIEW_REQUIRED_IND | DOUBLE | N | Indicates whether this document requires further review or not. 1 indicates that this document requires further review and 0 indicates that this document doesn't require further review |
LONG_TEXT_ID | DOUBLE | N | Unique identifier for the row on the long_text table where the plain-text version of the document is stored |
PERSON_ID | DOUBLE | N | Person ID this document belongs to |
PROCESS_STATUS_CD | DOUBLE | N | A code indicating the CAC document process status. |
REVIEWED_IND | DOUBLE | N | Indicates that this document has been reviewed |
SVC_CAT_HIST_ID | DOUBLE | N | Service Category History ID this document belongs to |
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 - CAC_DOCUMENT
Child Column in CAC_DOCUMENT(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | CLINICAL_EVENT_ID | CLINICAL_EVENT | CLINICAL_EVENT_ID |
ENCNTR_SLICE_ID | ENCNTR_SLICE | ENCNTR_SLICE_ID | |
ENCNTR_ID | ENCOUNTER | ENCNTR_ID | |
LONG_TEXT_ID | LONG_TEXT | LONG_TEXT_ID | |
PERSON_ID | PERSON | PERSON_ID | |
SVC_CAT_HIST_ID | SERVICE_CATEGORY_HIST | SVC_CAT_HIST_ID |
Parent Column in CAC_DOCUMENT (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | CAC_DOCUMENT_ID | CAC_NOMENCLATURE | CAC_DOCUMENT_ID |
CAC_NOMENCLATURE
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Computer Assisted Coding Nomenclature |
Definition: | Stores nomenclatures and related information found during document parsing |
Table Type: | ACTIVITY |
Column Detail - CAC_NOMENCLATURE
Column Name | Type | Null? | Definition |
---|---|---|---|
ACCEPTED_FLAG | DOUBLE | N | Indicates whether this nomenclature record was accepted into the coding encounter or not. 0 indicated that this was legacy, 1 indicates that this was not accepted and 2 indicates that this was accepted. |
CAC_DOCUMENT_ID | DOUBLE | N | Identifies the document this nomenclature was found in. |
CAC_NOMENCLATURE_ID | DOUBLE | N | Unique identifier number for this row. |
CAC_RULE_ID | DOUBLE | N | This is the value of the unique primary identifier of the CAC_RULE table. This will be set if a rule was applied to the row. |
CERTAINTY_FLAG | DOUBLE | N | The indicator for the level of certainty for the nomenclature.0 - NOT DETERMINED1 - POSITIVE2 - NEGATIVE3 - UNCERTAIN |
DEFAULT_PRESENT_ON_ADMIT_CD | DOUBLE | N | This is the POA value that will be defaulted if this Nomenclature is accepted in the CAC Document. This field will be set via a CAC rule. |
END_POS | DOUBLE | N | The character end position this nomenclature was found at. |
HIDDEN_IND | DOUBLE | N | Indicates whether the nomenclature text will be decorated in the document. |
IGNORE_IND | DOUBLE | N | Indicates that this nomenclature has been ignored. |
MAPPED_NOMENCLATURE_ID | DOUBLE | N | Identifies the manually mapped nomenclature row between the start_pos and end_pos locations. |
NOMENCLATURE_ID | DOUBLE | N | Identifies the nomenclature row found by the NLP Engine between the start_pos and end_pos locations. |
PHYSICIAN_ID | DOUBLE | N | This is the value of the unique identifier of the PRSNL table. This identifies the Physician who performed the procedure. |
PROC_DT_TM | DATETIME | Y | Stores the date and time the procedure was performed |
START_POS | DOUBLE | N | The character start position this nomenclature was found at. |
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 - CAC_NOMENCLATURE
Child Column in CAC_NOMENCLATURE(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | CAC_DOCUMENT_ID | CAC_DOCUMENT | CAC_DOCUMENT_ID |
CAC_RULE_ID | CAC_RULE | CAC_RULE_ID | |
MAPPED_NOMENCLATURE_ID | NOMENCLATURE | NOMENCLATURE_ID | |
NOMENCLATURE_ID | NOMENCLATURE | NOMENCLATURE_ID | |
PHYSICIAN_ID | PRSNL | PERSON_ID |