Table Detail Report

PATIENT_CASE_OUT_PMT_AGMT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Patient Case Outbound Payment Agreement
Definition: An outbound payment agreement patient case tracks a patient and their details when the patient is sent to another healthcare entity for care where a payment agreement exists between the two healthcare entities.
Table Type: ACTIVITY





Column Detail - PATIENT_CASE_OUT_PMT_AGMT


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.
APPROVING_PRSNL_ID DOUBLE N This is the value of the unique primary identifier of the PRSNL table. It is an internal system assigned number for the personnel who approved the referral to a different care provider.
CARE_TYPE_CD DOUBLE N The type of care the patient will be receiving.
PATIENT_CASE_ID DOUBLE N This is the value of the unique primary identifier of the PATIENT_CASE table. It is an internal system assigned number.
PATIENT_CASE_OUT_PMT_AGMT_ID DOUBLE N Unique generated number that identifies a single row on the PATIENT_CASE-OUT_PMT_AGMT table.
PAYMENT_CONNECTION_IDENT VARCHAR(50) Y The unique identifier of the payment agreement referral from the referring facility to communicate with the receiving facility.
RECEIVING_FACILITY_CD DOUBLE N A code that represents the external facility to which the referral is to be sent.
REFERRAL_REASON_CD DOUBLE N The reason for the patient referral to a different care provider.
REFERRING_CARE_GIVER_ORG_ID DOUBLE N This is the value of the unique primary identifier of the ORGANIZATION table. It is an internal system assigned number for the care giver organization that referred the patient to the receiving facility.
REFERRING_CARE_UNIT_ORG_ID DOUBLE N This is the value of the unique primary identifier of the ORGANIZATION table. It is an internal system assigned number for the care unit organization that referred the patient to the receiving facility.
REFERRING_FACILITY_ORG_ID DOUBLE N This is the value of the unique primary identifier of the ORGANIZATION table. It is an internal system assigned number for the facility organization that referred the patient to the receiving facility.
REFERRING_PROVIDER_PRSNL_ID DOUBLE N This is the value of the unique primary identifier of the PRSNL table. It is an internal system assigned number for the referring provider.
SPECIALTY_CD DOUBLE N The medical specialty for which the patient is to be seen.
TYPE_CD DOUBLE N The patient case payment agreement type.
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 - PATIENT_CASE_OUT_PMT_AGMT


Child Column in PATIENT_CASE_OUT_PMT_AGMT(FK) Parent Table Name Parent Column Name
Parents: REFERRING_CARE_GIVER_ORG_ID ORGANIZATION ORGANIZATION_ID
REFERRING_CARE_UNIT_ORG_ID ORGANIZATION ORGANIZATION_ID
REFERRING_FACILITY_ORG_ID ORGANIZATION ORGANIZATION_ID
PATIENT_CASE_ID PATIENT_CASE PATIENT_CASE_ID
APPROVING_PRSNL_ID PRSNL PERSON_ID
REFERRING_PROVIDER_PRSNL_ID PRSNL PERSON_ID


PATIENT_CASE_THERAPY



Column Section Relationship Section Top of Page


Table-level Detail

Description: Patient Case Therapy
Definition: Stores infromation about a patient's therapy case.
Table Type: ACTIVITY





Column Detail - PATIENT_CASE_THERAPY


Column Name Type Null? Definition
ACUTE_MANIFEST_DT_TM DATETIME Y The date that the condition developed into or becomes a condition with a rapid onset and/or a short course.
HEARING_VISION_RX_DT_TM DATETIME Y The date that a prescription was written for hearing devices or vision frames and lenses.
INITIAL_TREATMENT_DT_TM DATETIME Y The date of the first treatment for the medical condition being treated for the patient case.
LAST_SEEN_DT_TM DATETIME Y The date and time that the patient was last seen by the attending or supervising physician for the condition related to the patient case.
LAST_XRAY_DT_TM DATETIME Y The date of the last x-ray for the medical condition being treated for the patient case.
PATIENT_CASE_ID DOUBLE N Uniquely identifies the related patient case.
PATIENT_CASE_THERAPY_ID DOUBLE N Uniquely identifies information about a patient's therapy case.
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 - PATIENT_CASE_THERAPY


Child Column in PATIENT_CASE_THERAPY(FK) Parent Table Name Parent Column Name
Parents: PATIENT_CASE_ID PATIENT_CASE PATIENT_CASE_ID


PATIENT_EVENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Patient Event
Definition: Table to capture event details for a patient_event row
Table Type: ACTIVITY





Column Detail - PATIENT_EVENT


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_ID DOUBLE N Uniquely identifies the related Encounter
EVENT_DT_TM DATETIME Y The date and time the event took place.
EVENT_TYPE_CD DOUBLE N Type of event being written.
PATIENT_EVENT_ID DOUBLE N Uniquely identifies a captured event for a patient.
PERSON_ID DOUBLE N Uniquely identifies a related person.
TRANSACTION_DT_TM DATETIME Y The date and time the event was written to the database.
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 - PATIENT_EVENT


Child Column in PATIENT_EVENT(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
PERSON_ID PERSON PERSON_ID




Parent Column in PATIENT_EVENT (PK) Child Table Name Child Column Name
Children: PATIENT_EVENT_ID PATIENT_EVENT_DETAIL PATIENT_EVENT_ID
PATIENT_EVENT_DETAIL_HIST PATIENT_EVENT_ID
PATIENT_EVENT_HIST PATIENT_EVENT_ID


PATIENT_EVENT_DETAIL



Column Section Relationship Section Top of Page


Table-level Detail

Description: Patient Event Detail
Definition: Captures event details for a given Patient_Event row.
Table Type: ACTIVITY





Column Detail - PATIENT_EVENT_DETAIL


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.
PATIENT_EVENT_DETAIL_ID DOUBLE N Uniquely identifies details about a patient event.
PATIENT_EVENT_ID DOUBLE N Uniquely identifies a related patient event.
PE_VALUE_CD DOUBLE N Coded value for the given patient event detail.
PE_VALUE_DT_TM DATETIME Y Date and time value for the given patient event detail.
PE_VALUE_ID DOUBLE N Uniquely identifies the related row on the table identified in the PE_VALUE_NAME column.
PE_VALUE_MEANING VARCHAR(25) Y This meaning will define what value is being saved. This value can be created by whomever is writing the row. When reading from the table, every meaning should only have 1 of the corresponding pe_value columns actually valued.
PE_VALUE_NAME VARCHAR(30) N Identifies the table to which this event is related.
PE_VALUE_NUMERIC DOUBLE Y Numeric value for the given patient event detail.
PE_VALUE_STRING VARCHAR(4000) Y The string value for the given patient event detail.
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 - PATIENT_EVENT_DETAIL


Child Column in PATIENT_EVENT_DETAIL(FK) Parent Table Name Parent Column Name
Parents: PATIENT_EVENT_ID PATIENT_EVENT PATIENT_EVENT_ID




Parent Column in PATIENT_EVENT_DETAIL (PK) Child Table Name Child Column Name
Children: PATIENT_EVENT_DETAIL_ID PATIENT_EVENT_DETAIL_HIST PATIENT_EVENT_DETAIL_ID


PATIENT_EVENT_DETAIL_HIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: Patient Event Detail History
Definition: Used for tracking history of changes to patient event detail.
Table Type: ACTIVITY





Column Detail - PATIENT_EVENT_DETAIL_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.
PATIENT_EVENT_DETAIL_HIST_ID DOUBLE N Uniquely identifies a history record of a change to the person event detail table.
PATIENT_EVENT_DETAIL_ID DOUBLE N Uniquely identifies the related patient_event_detail row.
PATIENT_EVENT_ID DOUBLE N Uniquely identifies the related patient event.
PE_VALUE_CD DOUBLE N The code value for the given patient event detail.
PE_VALUE_DT_TM DATETIME Y The date and time value for the given patient event detail.
PE_VALUE_ID DOUBLE N Uniquley identifies the related row on the table identified in the PE_VALUE_NAME column.
PE_VALUE_MEANING VARCHAR(25) Y This meaning will define what value is being saved. this value can be created by whomever is writing the row. When reading from the table, every meaning should only have 1 of the corresponding pe_value columns actually valued.
PE_VALUE_NAME VARCHAR(30) N Identifies the table to which this event is related.
PE_VALUE_NUMERIC DOUBLE Y The numeric value for the given patient event detail.
PE_VALUE_STRING VARCHAR(4000) Y The string value for the given patient event detail.
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.
TRACKING_BIT DOUBLE N Identifies which columns are being tracked for history.
TRANSACTION_DT_TM DATETIME Y ** 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 - PATIENT_EVENT_DETAIL_HIST


Child Column in PATIENT_EVENT_DETAIL_HIST(FK) Parent Table Name Parent Column Name
Parents: PATIENT_EVENT_ID PATIENT_EVENT PATIENT_EVENT_ID
PATIENT_EVENT_DETAIL_ID PATIENT_EVENT_DETAIL PATIENT_EVENT_DETAIL_ID
PM_HIST_TRACKING_ID PM_HIST_TRACKING PM_HIST_TRACKING_ID