Table Detail Report
CODING
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Coding |
Definition: | Stores some of the coded information captured from a coding system. Examples of coded information include length of stay, birthweight and ascpay. |
Table Type: | ACTIVITY |
Column Detail - CODING
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. |
ASCPAY | DOUBLE | Y | This is the ascpay field |
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. |
BIRTH_WEIGHT | DOUBLE | Y | This is the birth weight from the coding system. |
CANCER_CODE_CNT | DOUBLE | N | The number of diagnoses that have the Cancer Notification form needed. |
CODING_DT_TM | DATETIME | Y | Date and time coding of episode took place. |
CODING_ENTITY_ID | DOUBLE | Y | Foreign key, Unique generated number that identifies a single row on the CODING_ENTITY table. |
CODING_ID | DOUBLE | N | This is the value of the unique primary identifier of the coding table. It is an internal system assigned number. |
CODING_PRSNL_ID | DOUBLE | N | Personnel who last coded the episode. |
COMPLETED_DT_TM | DATETIME | Y | This is the date and time that the coding record was saved as completed. |
CONTRIBUTOR_SYSTEM_CD | DOUBLE | N | Contributor system identifies the source feed of data from which a row was populated. This is mainly used to determine how to update a set of data that may have originated from more than one source feed. |
CREATE_DT_TM | DATETIME | Y | The date and time the row was created. |
CREATE_PRSNL_ID | DOUBLE | N | The personnel id of the user that created the row, from the personnel table (prsnl). This is the value of the unique primary identifier of the personnel table. It is an internal system assigned number |
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. |
EVENT_ID | DOUBLE | N | This is the value of the unique primary identifier of the clinical_event table. It is an internal system assigned number. |
LENGTH_OF_STAY | DOUBLE | Y | This is the Length of stay from the coding system |
MERGED_ENCNTR_ID | DOUBLE | N | The encounter ID for the encounter that has been merged with this one. (If it is a merged account). |
PARENT_ENTITY_ID | DOUBLE | N | Primary key ID from the parent table. |
PARENT_ENTITY_NAME | VARCHAR(30) | N | Parent table name. |
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 field is a unique identifier for the service category history table. |
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 - CODING
Child Column in CODING(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | CODING_ENTITY_ID | CODING_ENTITY | CODING_ENTITY_ID |
ENCNTR_SLICE_ID | ENCNTR_SLICE | ENCNTR_SLICE_ID | |
ENCNTR_ID | ENCOUNTER | ENCNTR_ID | |
PERSON_ID | PERSON | PERSON_ID | |
CODING_PRSNL_ID | PRSNL | PERSON_ID | |
CREATE_PRSNL_ID | PRSNL | PERSON_ID | |
SVC_CAT_HIST_ID | SERVICE_CATEGORY_HIST | SVC_CAT_HIST_ID |
CODING_AUDIT
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Coding Audit |
Definition: | Used to store information on Coding Audits that have taken place. |
Table Type: | ACTIVITY |
Column Detail - CODING_AUDIT
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. |
AUDIT_PRSNL_ID | DOUBLE | N | The personnel identifier of the user that performed the audit of the coding row. 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. |
CODING_AUDIT_ID | DOUBLE | N | This is the unique identifier for a coding audit row. It is an internal, system-assigned number. |
CODING_AUDIT_TRIGGER_ID | DOUBLE | N | This field is a unique identifier for the coding audit trigger table. |
CODING_PRSNL_ID | DOUBLE | N | The personnel identifier of the user that initially coded the row. It is an internal, system-assigned number. |
ENCNTR_ID | DOUBLE | N | This is the value of the unique 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. |
ERROR_SOURCE_IDENT | VARCHAR(50) | N | The identifier of the error source. |
ERROR_SOURCE_TYPE_CD | DOUBLE | N | The type of error source. Examples are Charge, Diagnosis, Grouper, Procedure, etc. |
EXTERNAL_AUDIT_MSG | VARCHAR(4000) | N | The external audit message for the coding audit trigger. The specific reason for the audit. |
OUTCOME_CD | DOUBLE | N | The outcome of the coding audit. |
PARENT_ENTITY_ID | DOUBLE | N | Primary key ID from the parent table. |
PARENT_ENTITY_NAME | VARCHAR(30) | N | Parent table name. |
PERSON_ID | DOUBLE | N | This is the value of the primary identifier of the person table. It is an internal, system-assigned number. |
SEVERITY_CD | DOUBLE | N | The edit severity. Examples are Error and Warning. |
SVC_CAT_HIST_ID | DOUBLE | N | This field is a unique identifier for the service category history table. |
TASK_ID | DOUBLE | N | An identifier from a row on the task_activity table that is related to the coding audit row. |
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 - CODING_AUDIT
Child Column in CODING_AUDIT(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | CODING_AUDIT_TRIGGER_ID | CODING_AUDIT_TRIGGER | CODING_AUDIT_TRIGGER_ID |
ENCNTR_SLICE_ID | ENCNTR_SLICE | ENCNTR_SLICE_ID | |
ENCNTR_ID | ENCOUNTER | ENCNTR_ID | |
PERSON_ID | PERSON | PERSON_ID | |
AUDIT_PRSNL_ID | PRSNL | PERSON_ID | |
CODING_PRSNL_ID | PRSNL | PERSON_ID | |
SVC_CAT_HIST_ID | SERVICE_CATEGORY_HIST | SVC_CAT_HIST_ID | |
TASK_ID | TASK_ACTIVITY | TASK_ID |
CODING_AUDIT_TRIGGER
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Coding Audit Trigger |
Definition: | Used to store unique Coding Audits Triggers. |
Table Type: | REFERENCE |
Column Detail - CODING_AUDIT_TRIGGER
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. |
CODING_AUDIT_TRIGGER_ID | DOUBLE | N | This is the unique identifier for a procedure history row. It is an internal, system-assigned number. |
CONTRIBUTOR_SYSTEM_CD | DOUBLE | N | Contributor system identifies the source feed of data from which a row was populated. This is mainly used to determine how to update a set of data that may have originated from more than one source feed. |
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. |
EXTERNAL_AUDIT_MSG | VARCHAR(4000) | N | The external audit message for the coding audit trigger. The reason for the audit. |
EXTERNAL_AUDIT_MSG_IDENT | DOUBLE | N | The external audit message reference for the coding audit trigger. |
EXTERNAL_EDIT_IDENT | DOUBLE | N | The external edit reference for the coding audit trigger. |
EXTERNAL_EDIT_IDENT_TXT | VARCHAR(100) | N | The external edit reference for the coding audit trigger. |
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. |
USER_DEFINED_IND | DOUBLE | N | Determines if the audit trigger was user defined or system defined. |
Relationship Detail - CODING_AUDIT_TRIGGER
Parent Column in CODING_AUDIT_TRIGGER (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | CODING_AUDIT_TRIGGER_ID | CODING_AUDIT | CODING_AUDIT_TRIGGER_ID |
CODING_ENTITY
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Coding Entity |
Definition: | The entity details of the coding. Used to relate tables to the CODING_LOCK table |
Table Type: | ACTIVITY |
Column Detail - CODING_ENTITY
Column Name | Type | Null? | Definition |
---|---|---|---|
CODING_ENTITY_ID | DOUBLE | N | Unique generated number that identifies a single row on the CODING_ENTITY table. |
ENCNTR_ID | DOUBLE | Y | Foreign key to the ENCOUNTER table. |
UPDT_APPLCTX | DOUBLE | Y | 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 | Y | 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 | Y | 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 | Y | 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 | Y | 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 - CODING_ENTITY
Child Column in CODING_ENTITY(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ENCNTR_ID | ENCOUNTER | ENCNTR_ID |
Parent Column in CODING_ENTITY (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | CODING_ENTITY_ID | CODING | CODING_ENTITY_ID |
CODING_HIST | CODING_ENTITY_ID | ||
CODING_LOCK | CODING_ENTITY_ID | ||
CODING_SPECIALTY | CODING_ENTITY_ID |
CODING_FLEX_SUMMARY
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Coding Flex Summary |
Definition: | This table hold coding flex info such as coding report name |
Table Type: | REFERENCE |
Column Detail - CODING_FLEX_SUMMARY
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. |
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. |
CODING_FLEX_SUMMARY_ID | DOUBLE | N | This is the value of the unique primary identifier of the coding flex summary table. It is an internal system assigned number |
CODING_REPORT_NAME | VARCHAR(255) | Y | This is the name of the report that will be printed |
DEFNCY_REPORT_CD | DOUBLE | N | This is the code value for the deficient report that will be created in the clinical event |
ELECTRONIC_DOC_IND | DOUBLE | Y | This is used to indicate if the document listed in defncy_report_cd needed to be an electronic document, or if just a deficiency needed to be created for it. |
ENCNTR_TYPE_CD | DOUBLE | N | this is the encounter type code |
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. |
FINANCIAL_CLASS_CD | DOUBLE | N | This is the financial class code |
GROUP_PRINCIPLE_TYPE_CD | DOUBLE | N | This is the group principle type |
ORGANIZATION_ID | DOUBLE | N | This is the value of the unique primary identifier of the organization table. |
REQUEST_SIGN_IND | DOUBLE | Y | Indicator specifying whether we post a request for signature for the Attending doctor along with the document we post to OCF |
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 - CODING_FLEX_SUMMARY
Child Column in CODING_FLEX_SUMMARY(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ORGANIZATION_ID | ORGANIZATION | ORGANIZATION_ID |