Table Detail Report

CODING_HIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: Coding History
Definition: Used to store history of the coding information.
Table Type: ACTIVITY





Column Detail - CODING_HIST


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.
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_HIST_ID DOUBLE N The unique primary key of this table. It is an internally assigned number.
CODING_PARENT_ENTITY_ID DOUBLE N Primary key ID from the parent Coding or Coding_Specialty table.
CODING_PARENT_ENTITY_NAME VARCHAR(30) N Parent Coding or Coding_Specialty table name.
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 a unique secondary 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_HIST


Child Column in CODING_HIST(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_LOCK



Column Section Relationship Section Top of Page


Table-level Detail

Description: Coding Lock
Definition: Stores the coding entities that are currently being accessed by a user. This table will be queried before any operation begins on a coding entity to ensure that they are not being accessed by another user.
Table Type: ACTIVITY





Column Detail - CODING_LOCK


Column Name Type Null? Definition
CODING_ENTITY_ID DOUBLE Y Foreign key to CODING_ENTITY table. Used to relate CODING_LOCK table to multiple other tables.
CODING_LOCK_ID DOUBLE N Unique generated number that identifies a single row on the CODING_LOCK table.
LOCK_DT_TM DATETIME Y Date/time of the lock.
LOCK_PRSNL_ID DOUBLE Y Foreign key, Unique generated number that identifies a single row on the PRSNL table. The prsnl identifier of the person that requested the lock
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_LOCK


Child Column in CODING_LOCK(FK) Parent Table Name Parent Column Name
Parents: CODING_ENTITY_ID CODING_ENTITY CODING_ENTITY_ID
LOCK_PRSNL_ID PRSNL PERSON_ID


CODING_PARAMS



Column Section Top of Page


Table-level Detail

Description: ProFile encoder interface parameters
Definition: This tables stores coding interface parameters such as interface input path, interface output path and interface source path.
Table Type: REFERENCE





Column Detail - CODING_PARAMS


Column Name Type Null? Definition
ABSTR_REQ_FINAL_IND DOUBLE N Abstract Request Final Indicator
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.
ADMIT_DIAG_REQUIRED_IND DOUBLE Y When this indicator is set to1, admit diagonosis is required to save as final.
AUTO_IMPORT_IND DOUBLE Y auto import indicator
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.
CANCER_CODE_CNT_IND DOUBLE N Cancer Code Count Indicator
CHANGE_AFTER_FINAL_IND DOUBLE Y Enable or disable the ability for users to change codes after they have been saved as final
CLINICAL_CODING_IND DOUBLE Y clinical coding indicator
CODING_PARAMS_ID DOUBLE N This is the value of the unique primary identifier of the coding params table. It is an internal system assigned number
CPT_CODE_CNT DOUBLE Y This is the number of cpt codes that the encoder interface is expecting, used with fixed length file interface.
DEFAULT_REPORT_NAME VARCHAR(255) Y This is the default report name that will be used if no report name is found in the coding flex summary
DIAGNOSIS_CODE_CNT DOUBLE Y This is the number of diagnosis codes that the encoder interface is expecting, used with fixed length file interface.
DRAFT_DROP_BILL_IND DOUBLE Y To send outbound drop bill info when coding saved as draft
DRG_CODE_CNT DOUBLE Y This is the number of drg codes that the encoder interface is expecting, used with fixed length file interface.
DROP_BILL_FLAG DOUBLE Y Drop Bill Flag
DROP_BILL_IND DOUBLE Y Indicates if a drop bill notification should be sent
EDIT_CHK_IND DOUBLE Y Parameter to turn ICD-10 edit checking on/off.
ENCNTR_SLICE_IND DOUBLE Y Indicates whether coding is at the encounter slice level
ENCODER_INPUT_PATH VARCHAR(255) Y This is the path of the encoder interface input directory
ENCODER_OUTPUT_PATH VARCHAR(255) Y This is the path of the encoder interface output directory
ENCODER_SOURCE_PATH VARCHAR(255) Y This is the path of the encoder interface source directory
ENCODER_TYPE_CD DOUBLE N This is the type of encoder used
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.
GENERIC_COLUMN_IND DOUBLE Y Flag that determines if the "Generic Field" will have it's value displayed in a column on the procedure view in himChartCoding.
GENERIC_DEFAULT_VAL_CD DOUBLE N Stores the default value for the Generic Field in himChartCoding.
GENERIC_LABEL_NAME VARCHAR(100) Y Stores the label for the Generic Field in himChartCoding.
GENERIC_REQUIRED_IND DOUBLE Y Flag that determines if the Generic Field is required in himChartCoding.
GENERIC_VISIBLE_IND DOUBLE Y Flag that determines if the Generic Field is enabled in himChartCoding.
GROUPER_REQUIRED_FLAG DOUBLE N Flag specifying whether a grouper code is required in certain scenarios.
GROUP_PRINCIPLE_TYPE_CD DOUBLE N This is the default group principle type used.
INTERFACE_PATH VARCHAR(255) Y This is the path of the encoder interface
LAUNCH_ABSTR_DRAFT_IND DOUBLE N Launch Abstract Draft indicator
MERGED_ACCOUNT_IND DOUBLE Y Yes if this site will be merging two encounters for coding purposes, no if the site will not be merging two encounters for coding purposes.
OCE_DEF_INFOX_CARRIER VARCHAR(40) Y Default value to be used for the CarrierID field of the USER record when generating OCE Edits input files for use with the Info-X system. CarrierID is to be filled out with the CODE_VALUE.Display for the Outbound Code Value Alias for Info-X (contributor system) for the Financial Class associated with an encounter. If an Outbound Code Value Alias is not found for Info-X for the encounter's Financial_Class_Cd, the value in this field will be used to populate the CarrierID field.
OCE_EDITS_FLAG DOUBLE N The flag indicates if OCE edits should be called and when.
OCE_EDITS_INPUT_PATH VARCHAR(255) Y This is the directory where we will put the input file for the OCE edits.
OCE_EDITS_OUTPUT_PATH VARCHAR(255) Y This is the directory where we will look for the output file created from the OCE edits.
PAYER_VALIDATION_IND DOUBLE N indicator for payer validation
PROBLEM_LIST_IND DOUBLE Y Indicator that toggles whether a site will be able to launch to the Problem List from Chart Coding.
PROCEDURE_CODE_CNT DOUBLE Y This is the number of procedure codes that the encoder interface is expecting, used with fixed length file interface.
SERVICE_CAT_IND DOUBLE Y Determines if site is coding at service category level or encounterlevel.
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.


CODING_SPECIALTY



Column Section Relationship Section Top of Page


Table-level Detail

Description: Coding Specialty
Definition: Stores coding information, including length of stay, birthweight and ascpay for speciality coding instances.
Table Type: ACTIVITY





Column Detail - CODING_SPECIALTY


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 Unique generated number that identifies a single row on the coding_specialty table.
CODING_PRSNL_ID DOUBLE N Personnel who last coded this episode.
COMPLETED_DT_TM DATETIME Y Thi si the date and time the coding specialty 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 beeen 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_SPECIALTY


Child Column in CODING_SPECIALTY(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
MERGED_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


COMPLETION_HOLD



Column Section Relationship Section Top of Page


Table-level Detail

Description: Stores hold information based on hold type
Definition: Store hold start time, hold stop time, hold reason, hold type, etc for each completion hold
Table Type: ACTIVITY





Column Detail - COMPLETION_HOLD


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.
COMPLETION_HOLD_ID DOUBLE N This is the value of the unique primary identifier of the completion hold 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.
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.
HOLD_REASON_CD DOUBLE N This is the reason the hold was created
HOLD_START_DT_TM DATETIME Y This is the date and time that the hold is started
HOLD_STOP_DT_TM DATETIME Y This is the date and time that the hold will stop
HOLD_TYPE_CD DOUBLE N This identifies the type of hold that this is (i.e. physician, document, request or, visit)
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.
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
PROVIDER_ID DOUBLE N This is the physician on hold. This is the value of the unique primary identifier of the prsnl table. It is an internal system assigned number.
REQUEST_ID DOUBLE N this is the value of the unique prinary identifier to the ROI request 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 - COMPLETION_HOLD


Child Column in COMPLETION_HOLD(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
PERSON_ID PERSON PERSON_ID
PROVIDER_ID PRSNL PERSON_ID