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