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