Table Detail Report

ENCNTR_CONDITION_CODE



Column Section Relationship Section Top of Page


Table-level Detail

Description: ENCNTR CONDITION CODE
Definition: Encounter condition code (UB92).
Table Type: ACTIVITY





Column Detail - ENCNTR_CONDITION_CODE


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.
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 N 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.
CONDITION_CD DOUBLE N A UB92 condition code (Universal Billing).
CONDITION_CODE_ID DOUBLE N This is the value of the unique primary identifier of the encounter condition code table. It is an internal system assigned number.
DATA_STATUS_CD DOUBLE N Data status indicates a level of authenticity of the row data. Typically this will either be AUTHENTICATED or UNAUTHENTICATED.
DATA_STATUS_DT_TM DATETIME Y The date and time that the data_status_cd was set.
DATA_STATUS_PRSNL_ID DOUBLE N The person who caused the data_status_cd to be set or change.
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 N 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.
SEQUENCE DOUBLE Y NOT USED AT THIS TIME. Placeholder for sequential order of the condition codes.
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 - ENCNTR_CONDITION_CODE


Child Column in ENCNTR_CONDITION_CODE(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID


ENCNTR_CRIMINAL_CHARGES_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: ENCNTR CRIMINAL CHARGES R
Definition: This table will hold outstanding criminal charges for an encounter.
Table Type: ACTIVITY





Column Detail - ENCNTR_CRIMINAL_CHARGES_R


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.
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 N 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.
COURT_DT_TM DATETIME Y The court date and time.
COURT_FILE_NUM VARCHAR(40) Y The court file number.
COURT_LOCATION_CD DOUBLE N The location at which the court proceedings took place.
CRIMINAL_CHRG_INACTIVE_IND DOUBLE Y Indicates whether the legal status has been inactivated by the user.
ENCNTR_ID DOUBLE N This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number.
OUTSTANDING_CHARGES_R_ID DOUBLE N The unique identifier for the encntr_criminal_charges_r table.
OUTSTANDING_CHARGE_CD DOUBLE N Facility defined code value representing the outstanding charge for an encounter.
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 - ENCNTR_CRIMINAL_CHARGES_R


Child Column in ENCNTR_CRIMINAL_CHARGES_R(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID




Parent Column in ENCNTR_CRIMINAL_CHARGES_R (PK) Child Table Name Child Column Name
Children: OUTSTANDING_CHARGES_R_ID CRIMINAL_CHARGES_DISP_R OUTSTANDING_CHARGES_R_ID


ENCNTR_CRIMINAL_CHRGS_HIST



Column Section Top of Page


Table-level Detail

Description: Encounter outstanding charges history.
Definition: This table will hold the history of the outstanding criminal charges for an encounter.
Table Type: ACTIVITY





Column Detail - ENCNTR_CRIMINAL_CHRGS_HIST


Column Name Type Null? Definition
BEG_EFFECTIVE_DT_TM DATETIME N 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.
COURT_DT_TM DATETIME Y The court date and time.
COURT_FILE_NUM VARCHAR(40) Y The file number representing the court case.
COURT_LOCATION_CD DOUBLE N The location at which the court proceedings took place.
END_EFFECTIVE_DT_TM DATETIME N 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.
OUTSTANDING_CHARGES_HIST_ID DOUBLE N The unique identifier for the encntr_criminal_chrgs_hist table.
OUTSTANDING_CHARGES_R_ID DOUBLE N The unique identifier for the encntr_criminal_charges_r 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_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.


ENCNTR_DATA_NOT_COLL



Column Section Relationship Section Top of Page


Table-level Detail

Description: Encounter Data Not Collected
Definition: Stores information describing why encounter data was not collected.
Table Type: ACTIVITY





Column Detail - ENCNTR_DATA_NOT_COLL


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.
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 N 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.
ENCNTR_DATA_NOT_COLL_ID DOUBLE N Unique generated number that identifies a single row on the ENCNTR_DATA_NOT_COLL table.
ENCNTR_ID DOUBLE N The value of the primary identifier of the parent table and to which the encounter's data not collected row is related.
EST_FINANCIAL_RESP_AMT_CD DOUBLE N The information describing if the estimated financial responsibility amount is not collected or why it is not collected for the encounter (CS 4660008).
REFERRING_PHYSICIAN_CD DOUBLE N The information describing if the referring provider is not collected or why it is not collected for the encounter.
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 - ENCNTR_DATA_NOT_COLL


Child Column in ENCNTR_DATA_NOT_COLL(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID




Parent Column in ENCNTR_DATA_NOT_COLL (PK) Child Table Name Child Column Name
Children: ENCNTR_DATA_NOT_COLL_ID ENCNTR_DATA_NOT_COLL_HIST ENCNTR_DATA_NOT_COLL_ID


ENCNTR_DATA_NOT_COLL_HIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: Encounter Data Not Collected History
Definition: Used for tracking history of columns on the ENCNTR_DATA_NOT_COLL table.
Table Type: ACTIVITY





Column Detail - ENCNTR_DATA_NOT_COLL_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.
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 N 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.
CHANGE_BIT DOUBLE N Identifies which columns have had a change.
ENCNTR_DATA_NOT_COLL_HIST_ID DOUBLE N Unique generated number that identifies a single row on the ENCNTR_DATA_NOT_COLL_HIST table.
ENCNTR_DATA_NOT_COLL_ID DOUBLE N This is the value of the unique primary identifier of the encounter not collected table.
EST_FINANCIAL_RESP_AMT_CD DOUBLE N The information describing if the estimated financial responsibility amount is not collected or why it is not collected for the encounter (CS 4660008).
PM_HIST_TRACKING_ID DOUBLE N This is the value of the unique primary identifier of the pm_hist_tracking table. It is an internal system assigned number.
REFERRING_PHYSICIAN_CD DOUBLE N The information describing if the referring provider is not collected or why it is not collected for the encounter.
TRACKING_BIT DOUBLE N Identifies which columns are being tracked for history.
TRANSACTION_DT_TM DATETIME N ** OBSOLETE **. Use column updt_dt_tm for any filtering/ordering query. If transaction date time is needed, it should be retrieved from pm_hist_tracking table. Note that its date may be in the past, as in before the update date time.
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 - ENCNTR_DATA_NOT_COLL_HIST


Child Column in ENCNTR_DATA_NOT_COLL_HIST(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_DATA_NOT_COLL_ID ENCNTR_DATA_NOT_COLL ENCNTR_DATA_NOT_COLL_ID