Table Detail Report

ENCNTR_MEDICARE_MGMT_HIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: Encounter Medicare Management History
Definition: Used for tracking history of columns on the encntr_medicare_mgmt table.
Table Type: ACTIVITY





Column Detail - ENCNTR_MEDICARE_MGMT_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.
AVAILABLE_DAYS DOUBLE Y The date and time at which the number of available days was verified.
AVAILABLE_DAYS_VERIFY_DT_TM DATETIME Y The date and time at which the number of available days was verified.
CHANGE_BIT DOUBLE N Identifies which columns have had a change.
ENCNTR_MEDICARE_MGMT_HIST_ID DOUBLE N Unique generated number that identifies a single row on the encntr_medicare_mgmt_hist table.
ENCNTR_MEDICARE_MGMT_ID DOUBLE N Unique generated number that identifies a single row on the encntr_medicare_mgmt table.
IN_RESIDENCE_DAYS DOUBLE Y The total number of individual days that qualified as being in residence, and does not include future or planned days.
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.
REMAINING_COVERED_DAYS DOUBLE Y The number of covered days remaining for Medicare in the current benefit period as of the current date.
TRACKING_BIT DOUBLE N Identifies which columns are being tracked for history.
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_MEDICARE_MGMT_HIST


Child Column in ENCNTR_MEDICARE_MGMT_HIST(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_MEDICARE_MGMT_ID ENCNTR_MEDICARE_MGMT ENCNTR_MEDICARE_MGMT_ID
PM_HIST_TRACKING_ID PM_HIST_TRACKING PM_HIST_TRACKING_ID


ENCNTR_MOTHER_CHILD_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Encounter Mother Child Relationship
Definition: This table relates a mother's encounter to their child's encounter.
Table Type: ACTIVITY





Column Detail - ENCNTR_MOTHER_CHILD_RELTN


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.
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.
CHILD_ENCNTR_ID DOUBLE N Uniquely identifies the child of the encounter.
ENCNTR_MOTHER_CHILD_RELTN_ID DOUBLE N Uniquely relates a mother's encounter to her child's encounter.
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.
MOTHER_ENCNTR_ID DOUBLE N Uniquely identifies the mother in this encounter relationship.
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_MOTHER_CHILD_RELTN


Child Column in ENCNTR_MOTHER_CHILD_RELTN(FK) Parent Table Name Parent Column Name
Parents: CHILD_ENCNTR_ID ENCOUNTER ENCNTR_ID
MOTHER_ENCNTR_ID ENCOUNTER ENCNTR_ID


ENCNTR_NEWBORN_CE_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Encounter Newborn Clinical Event Relationship
Definition: This table links the clinical dynamic lable to the newborn's encounter.
Table Type: ACTIVITY





Column Detail - ENCNTR_NEWBORN_CE_RELTN


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.
CE_DYNAMIC_LABEL_ID DOUBLE N The label_id of the dynamic label to which this newborn is associated. (From CE_DYNAMIC_LABEL table)
ENCNTR_ID DOUBLE N The newborn's encounter ID
ENCNTR_NEWBORN_CE_RELTN_ID DOUBLE N Uniquely relates a newborn and their clinical dynamic label.
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_NEWBORN_CE_RELTN


Child Column in ENCNTR_NEWBORN_CE_RELTN(FK) Parent Table Name Parent Column Name
Parents: CE_DYNAMIC_LABEL_ID CE_DYNAMIC_LABEL CE_DYNAMIC_LABEL_ID
ENCNTR_ID ENCOUNTER ENCNTR_ID


ENCNTR_OCCURRENCE_CODE



Column Section Relationship Section Top of Page


Table-level Detail

Description: ENCNTR OCCURRENCE CODE
Definition: Encounter occurrence code (UB92).
Table Type: ACTIVITY





Column Detail - ENCNTR_OCCURRENCE_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.
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.
OCCURRENCE_CD DOUBLE N A UB92 occurrence code (Universal Billing).
OCCURRENCE_CODE_ID DOUBLE N This is the value of the unique primary identifier of the encounter occurrence code table. It is an internal system assigned number.
OCCURRENCE_DT_TM DATETIME Y Date and time that the UB92 occurrence, indicated by the row, happened.
SEQUENCE DOUBLE Y NOT USED AT THIS TIME. Placeholder for sequential order of the occurrence 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_OCCURRENCE_CODE


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




Parent Column in ENCNTR_OCCURRENCE_CODE (PK) Child Table Name Child Column Name
Children: OCCURRENCE_CODE_ID ENCNTR_OCCURRENCE_CODE_HIST OCCURRENCE_CODE_ID


ENCNTR_OCCURRENCE_CODE_HIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: Encounter Occurrence Code History
Definition: Used for tracking history of certain columns on the encntr_occurrence_code table.
Table Type: ACTIVITY





Column Detail - ENCNTR_OCCURRENCE_CODE_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 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.
CHANGE_BIT DOUBLE N Identifies which columns have had a change.
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.
OCCURRENCE_CD DOUBLE N A UB92 occurrence code (Universal Billing).
OCCURRENCE_CODE_HIST_ID DOUBLE N Uniquely identifies a row tracking history of certain columns on the encntr_occurrence_code table.
OCCURRENCE_CODE_ID DOUBLE N Uniquely identifies the related ENCNTR_OCCURRENCE_CODE record.
OCCURRENCE_DT_TM DATETIME Y Date and time that the UB92 occurrence, indicated by the row, happened.
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.
SEQUENCE DOUBLE Y NOT USED AT THIS TIME. Placeholder for sequential order of the occurrence codes.
TRANSACTION_DT_TM DATETIME Y More aptly named activity_dt_tm; holds the current date and time of the system when the row was inserted. This will match the create_dt_tm from the corresponding pm_hist_tracking 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 - ENCNTR_OCCURRENCE_CODE_HIST


Child Column in ENCNTR_OCCURRENCE_CODE_HIST(FK) Parent Table Name Parent Column Name
Parents: OCCURRENCE_CODE_ID ENCNTR_OCCURRENCE_CODE OCCURRENCE_CODE_ID
PM_HIST_TRACKING_ID PM_HIST_TRACKING PM_HIST_TRACKING_ID