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 |