Table Detail Report

LH_QM_COMPLETE_COND



Column Section Top of Page


Table-level Detail

Description: Lighthouse Quality Measures Complete Conditions
Definition: Keeps track of which measures are completing correctly with the new code.
Table Type: ACTIVITY





Column Detail - LH_QM_COMPLETE_COND


Column Name Type Null? Definition
COMPLETE_COND_BIT DOUBLE Y Keeps track of which conditions successfully complete with the new code.
FIRST_RUN_DT_TM DATETIME Y The first script run that has this outcome.
INCOMPLETE_COND_BIT DOUBLE Y Keeps track of which conditions still rely on the old code to work.
LH_QM_COMPLETE_COND_ID DOUBLE N Unique generated number that identifies a single row on the LH_QM_COMPLETE_CONDS table.;
RUN_CNT DOUBLE Y The number of runs that have had these specific outcomes.
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_SOURCE VARCHAR(50) Y The script name responsible for updating the record.
UPDT_TASK VARCHAR(50) 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.


LH_QM_SEPSIS_METRICS



Column Section Top of Page


Table-level Detail

Description: LH_QM_SEPSIS_METRICS
Definition: Contains information based on the Sepsis condition for LH Quality Measures
Table Type: ACTIVITY





Column Detail - LH_QM_SEPSIS_METRICS


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.
ENCNTR_ID DOUBLE N Identifies the encounter against which the quality measure is associated. Foreign key to the ENCOUNTER table.
EXTRACT_DT_TM DATETIME Y The date/time that the record was extracted from the source system.
FIRST_PROCESS_DT_TM DATETIME Y The date/time the record was first loaded into the table.
HEALTH_SYSTEM_ID DOUBLE N Identifies the delivery network responsible for supplying the data.
HEALTH_SYSTEM_SOURCE_ID DOUBLE N Identifies the unique source within the delivery network responsible for supplying the data.
LAST_PROCESS_DT_TM DATETIME Y The date/time the record was last loaded into the table.
LH_QM_SEPSIS_METRICS_ID DOUBLE N Unique generated number that identifies a single row on the LH_QM_SEPSIS_METRICS table.
LOGICAL_DOMAIN_ID DOUBLE N The unique identifier for the logical domain. This identifier allows the data to be grouped by logical domain.
METRIC_TYPE VARCHAR(500) Y Identifies the type of metric for the row
PARENT_ENTITY_ID DOUBLE N The unique ID of the table that the row on this table is a child of
PARENT_ENTITY_NAME VARCHAR(50) Y The name of the table that the row on this table is a child of
PERSON_ID DOUBLE N Identifies the encounter against which the quality measure is associated. Foreign key to the PERSON table.
PRESENT_DT_TM DATETIME Y The date/time on which sepsis was present.
SEPSIS_TYPE_FLAG DOUBLE Y Identify the type of sepsis
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 Y 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_SOURCE VARCHAR(50) Y The script name responsible for updating the record.
UPDT_TASK VARCHAR(50) Y The registered (assigned) task number for the process that inserted or updated the row.


LH_SDOH_METRICS



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_SDOH_METRICS
Definition: This table contains encounter information for SDOH measures.
Table Type: ACTIVITY





Column Detail - LH_SDOH_METRICS


Column Name Type Null? Definition
BIRTH_DT_TM DATETIME Y Birth date and time of the patient.
D_ATTEND_PRSNL_ID DOUBLE Y SEQUENCE NAME:REFERENCE_SEQ. Identifies the final attending physician associated to the patient encounter.
D_BR_CCN_ID DOUBLE Y SEQUENCE NAME:REFERENCE_SEQ. CMS Certification Number. Foreign key to LH_D_BR_CCN.
D_BR_HCO_ID DOUBLE Y SEQUENCE NAME:REFERENCE_SEQ. Healthcare Organization Number. Foreign key to LH_D_BR_HCO.
D_DISCHARGE_BUILDING_ID DOUBLE Y SEQUENCE NAME:REFERENCE_SEQ. The building from which the patient encounter was discharged.
D_DISCHARGE_FACILITY_ID DOUBLE Y SEQUENCE NAME:REFERENCE_SEQ. The facility from which the patient encounter was discharged.
D_DISCHARGE_NURSE_UNIT_ID DOUBLE Y SEQUENCE NAME:REFERENCE_SEQ. The nurse unit from which the patient encounter was discharged.
D_METRIC_SDOH1_ID DOUBLE Y SEQUENCE NAME:REFERENCE_SEQ. Identifies the metric identifier for the SDOH-1 measure.
D_METRIC_SDOH2_ID DOUBLE Y SEQUENCE NAME:REFERENCE_SEQ. Identifies the metric identifier for the SDOH-2 measure.
D_PERSON_ID DOUBLE Y SEQUENCE NAME:REFERENCE_SEQ. Identifies the person associated with the quality measure. Foreign key to the LH_D_PERSON.
ENCNTR_ID DOUBLE Y SEQUENCE NAME:ENCOUNTER_ONLY_SEQ. Identifies the encounter against which the quality measure is associated. Foreign key to the ENCOUNTER table.
ENC_TYPE_TXT VARCHAR(50) Y Discharge encounter type of the patient encounter.
ETHNICITY_TXT VARCHAR(50) Y Ethniticy/Ethnicities of the patient.
EXCLUDE_SDOH1_IND DOUBLE Y Identifies if the patient encounter qualifies for exclusion for SDOH-1.
FINANCIAL_NBR_TXT VARCHAR(50) Y The financial number alias associated to the encounter.
FOOD_INSECURITY_DT_TM DATETIME Y The date and time (local) when Food Insecurity screening is documented.
FOOD_INSECURITY_FLAG DOUBLE Y Identiess if the patient encounter is Not screened (= 0), Positive (= 1), Opt-out/Unable (= 999) or Negative(= -1) for Food Insecurity Screened measure.
FOOD_INSECURITY_UTC_DT_TM DATETIME Y The date and time (UTC) when Food Insecurity screening is documented.
HEALTH_SYSTEM_ID DOUBLE Y Identifies the delivery network responsible for supplying the data.
HEALTH_SYSTEM_SOURCE_ID DOUBLE Y Identifies the unique source within the delivery network responsible for supplying the data.
HOUSE_INSTABILITY_DT_TM DATETIME Y The date and time (local) when House Instability screening is documented.
HOUSE_INSTABILITY_FLAG DOUBLE Y Identifies if the patient encounter is Not screened (= 0), Positive (= 1), Opt-out/Unable (= 999) or Negative(= -1) for Housing Instability Screened measure.
HOUSE_INSTABILITY_UTC_DT_TM DATETIME Y The date and time (UTC) when House Instability screening is documented.
INPATIENT_END_DT_TM DATETIME Y Discharge date and time (local) of the patient encounter.
INPATIENT_END_UTC_DT_TM DATETIME Y Discharge date and time (UTC) of the patient encounter.
INPATIENT_START_DT_TM DATETIME Y Inpatient admit date and time (local) of the patient encounter.
INPATIENT_START_UTC_DT_TM DATETIME Y Inpatient admit date and time (UTC) of the patient encounter.
INTERPERSONAL_SAFETY_DT_TM DATETIME Y The date and time (local) when Interpersonal Safety screening is documented.
INTERPERSONAL_SAFETY_FLAG DOUBLE Y Identifies if the patient encounter is Not screened (= 0), Positive (= 1), Opt-out/Unable (= 999) or Negative(= -1) for Interpersonal Safety Screened measure.
INTERPERSONAL_SAFETY_UTC_DT_TM DATETIME Y The date and time (UTC) when Interpersonal Safety screening is documented.
LH_SDOH_METRICS_ID DOUBLE N Unique generated number that identifies a single row on the LH_SDOH_METRICS table.
LOGICAL_DOMAIN_ID DOUBLE Y The unique identifier for a logical domain. This identifier allows the data to be grouped by logical domain. For example, If you assign clients a logical_domain_id this would allow you to store data for multiple clients on this table.
NUMERATOR_SDOH1_IND DOUBLE Y Identifies if the patient encounter qualifies for numerator for SDOH-1.
ORG_MRN_TXT VARCHAR(50) Y Identifies the medical record number of the patient
PAYER_TXT VARCHAR(50) Y Payment source of the patient encounter.
RACE_TXT VARCHAR(75) Y Race(s) of the patient.
SAMPLE_IND DOUBLE Y Indicates if the case is sampled. 0 -No, 1 - Yes.
TRANSPORTATION_NEEDS_DT_TM DATETIME Y The date and time (local) when Transportation Needs screening is documented.
TRANSPORTATION_NEEDS_FLAG DOUBLE Y Identifies if the patient encounter is Not screened (= 0), Positive (= 1), Opt-out/Unable (= 999) or Negative(= -1) for Transportation Needs Screened measure.
TRANSPORTATION_NEEDS_UTC_DT_TM DATETIME Y The date and time (UTC) when Transportation Needs screening is documented.
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_SOURCE VARCHAR(50) Y The registered (assigned) task number for the process that inserted or updated the row.
UPDT_TASK VARCHAR(50) 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.
UTILITY_DIFFICULTIES_DT_TM DATETIME Y The date and time (local) when Utility Difficulties screening is documented.
UTILITY_DIFFICULTIES_FLAG DOUBLE Y Identifies if the patient encounter is Not screened (= 0), Positive (= 1), Opt-out/Unable (= 999) or Negative(= -1) for Utility Difficulties Screened measure.
UTILITY_DIFFICULTIES_UTC_DT_TM DATETIME Y The date and time (UTC) when Utility Difficulties screening is documented.



Relationship Detail - LH_SDOH_METRICS


Child Column in LH_SDOH_METRICS(FK) Parent Table Name Parent Column Name
Parents: D_BR_CCN_ID LH_D_BR_CCN D_BR_CCN_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_BR_CCN HEALTH_SYSTEM_SOURCE_ID
D_BR_HCO_ID LH_D_BR_HCO D_BR_HCO_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_BR_HCO HEALTH_SYSTEM_SOURCE_ID
D_DISCHARGE_BUILDING_ID LH_D_BUILDING D_BUILDING_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_BUILDING HEALTH_SYSTEM_SOURCE_ID
D_DISCHARGE_FACILITY_ID LH_D_FACILITY D_FACILITY_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_FACILITY HEALTH_SYSTEM_SOURCE_ID
D_METRIC_SDOH1_ID LH_D_METRIC D_METRIC_ID
D_METRIC_SDOH2_ID LH_D_METRIC D_METRIC_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
D_DISCHARGE_NURSE_UNIT_ID LH_D_NURSE_UNIT D_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_NURSE_UNIT HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_D_PERSON D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_PERSON HEALTH_SYSTEM_SOURCE_ID
D_ATTEND_PRSNL_ID LH_D_PERSONNEL D_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_PERSONNEL HEALTH_SYSTEM_SOURCE_ID
LOGICAL_DOMAIN_ID LOGICAL_DOMAIN LOGICAL_DOMAIN_ID


LH_THA_TKA_METRICS



Column Section Relationship Section Top of Page


Table-level Detail

Description: Lighthouse Total Hip Arthroplasty and Total Knee Arthroplasty Metrics
Definition: This table contains encounter information for THA/TKA measures.
Table Type: ACTIVITY





Column Detail - LH_THA_TKA_METRICS


Column Name Type Null? Definition
ADMSN_DT_TM DATETIME Y The date and time (local) when patient admission is documented.
ADMSN_UTC_DT_TM DATETIME Y The date and time (UTC) when patient admission is documented.
BACK_PAIN_FLAG DOUBLE Y Identifies patient reported back pain. None (= 0), Mild (=1), Moderate (=2), Severe (=3), Very Severe (=4) , Worst Imaginable (=5) report.
BACK_PAIN_TXT VARCHAR(50) Y Identifies if the patient has back pain.
BMI_NBR DOUBLE Y Identifies the Body Mass Index of the patient.
COLLECTION_DT_TM DATETIME Y Survey collection date and time (local) of the patient encounter.
COLLECTION_MD_FLAG DOUBLE Y Identifies mode of collection Paper (= 0), Telephone (=1), Electronic (=3) and None(= 999) report.
COLLECTION_MD_TXT VARCHAR(100) Y Identifies the mode of survey collection for the patient.
COLLECTION_UTC_DT_TM DATETIME Y Survey collection date and time (UTC) of the patient encounter.
DATE_OF_BIRTH DATETIME Y Birth date and time of the patient.
D_ATTEND_PRSNL_ID DOUBLE N SEQUENCE NAME:REFERENCE_SEQ Identifies the final attending physician associated to the patient encounter.
D_BR_CCN_ID DOUBLE N SEQUENCE NAME:REFERENCE_SEQ CMS Certification Number. Foreign key to LH_D_BR_CCN.
D_BR_HCO_ID DOUBLE N SEQUENCE NAME:REFERENCE_SEQ Healthcare Organization Number. Foreign key to LH_D_BR_HCO.
D_DISCH_BUILDING_ID DOUBLE N SEQUENCE NAME:REFERENCE_SEQ The building from which the patient encounterwas discharged.
D_DISCH_FACILITY_ID DOUBLE N SEQUENCE NAME:REFERENCE_SEQ The facility from which the patient encounter was discharged.
D_DISCH_NURSE_UNIT_ID DOUBLE N SEQUENCE NAME:REFERENCE_SEQ The nurse unit from which the patient encounter was discharged.
D_PERSON_ID DOUBLE N SEQUENCE NAME:REFERENCE_SEQ Identifies the person associated with the quality measure. Foreign key to the LH_D_PERSON.
ENCNTR_ID DOUBLE N SEQUENCE NAME:ENCOUNTER_ONLY_SEQ Identifies the encounter against which the quality measure is associated. Foreign key to the ENCOUNTER table.
ENC_TYPE_TXT VARCHAR(50) Y Discharge encounter type of the patient encounter.
ETHNICITY_TXT VARCHAR(50) Y Ethniticy/Ethnicities of the patient.
EXTRACT_DT_TM DATETIME Y the date/time that the record was extracted from the source system.
FINANCIAL_NBR_TXT VARCHAR(50) Y The financial number alias associated to the encounter.
GENDER_TXT VARCHAR(50) Y Gender of the patient.
GEN_PROM_FLAG DOUBLE Y Identifies Generic prom version VR-12 (= 1), PROMIS-Global version 1.1 (=2), PROMIS-Global version 1.12 (=3) and None(= 999) report.
GEN_PROM_TXT VARCHAR(100) Y Identifies the generic prom version of the patient.
HEALTH_SYSTEM_ID DOUBLE N Identifies the delivery network responsible for supplying the data.
HEALTH_SYSTEM_SOURCE_ID DOUBLE N Identifies the unique source within the delivery network responsible for supplying the data.
HEIGHT_NBR DOUBLE Y Identifies the height of the patient.
HLTH_LITERACY_FLAG DOUBLE Y Identifies health litracy screeneing questionnaire response Not at all (= 0), A little bit (=1), Somewhat (=2), Quite a bit (=3), Extremely (=4) and None(= 999) report.
HLTH_LITERACY_TXT VARCHAR(50) Y Identifies the health literacy of the person who takes the survey.
HOOSJRQ1_STAIRS_FLAG DOUBLE Y Identifies hip pain when going up and down in stairs. None (= 0), Mild (=1), Moderate (=2), Severe (=3), Extreme (=4) report.
HOOSJRQ1_STAIRS_TXT VARCHAR(50) Y Identifies if the patient has hip pain in the last week going up or down stairs.
HOOSJRQ2_WALKING_FLAG DOUBLE Y Identifies hip pain when walking. None (= 0), Mild (=1), Moderate (=2), Severe (=3), Extreme (=4) report.
HOOSJRQ2_WALKING_TXT VARCHAR(50) Y Identifies if the patient has hip pain in the last week walking on an uneven surafce.
HOOSJRQ3_RISING_FLAG DOUBLE Y Identifies hip pain when rising. None (= 0), Mild (=1), Moderate (=2), Severe (=3), Extreme (=4) report.
HOOSJRQ3_RISING_TXT VARCHAR(50) Y Identifies if the patient has hip pain in the last week when rising from sitting.
HOOSJRQ4_BEND_FLAG DOUBLE Y Identifies hip pain when bending. None (= 0), Mild (=1), Moderate (=2), Severe (=3), Extreme (=4) report.
HOOSJRQ4_BEND_TXT VARCHAR(50) Y Identifies if the patient has hip pain in the last week when bending.
HOOSJRQ5_LYINGBED_TXT VARCHAR(50) Y Identifies if the patient has hip pain in the last week when lying in bed.
HOOSJRQ5_LYINGINBED_FLAG DOUBLE Y Identifies hip pain when lying in bed. None (= 0), Mild (=1), Moderate (=2), Severe (=3), Extreme (=4) report.
HOOSJRQ6_SITTING_FLAG DOUBLE Y Identifies hip pain when sitting. None (= 0), Mild (=1), Moderate (=2), Severe (=3), Extreme (=4) report.
HOOSJRQ6_SITTING_TXT VARCHAR(50) Y Identifies if the patient has hip pain in the last week when sitting.
ICD_10_PCS_CDE_TXT VARCHAR(50) Y Identifies the procedure code added to the patient.
KOOSJRQ1_STIFF_FLAG DOUBLE Y Identifies knee joint stiffness. None (= 0), Mild (=1), Moderate (=2), Severe (=3), Extreme (=4) report.
KOOSJRQ1_STIFF_TXT VARCHAR(50) Y Identifies if the patient has knee joint stiffness pain in the last week.
KOOSJRQ2_TWIST_FLAG DOUBLE Y Identifies knee pain when twisting. None (= 0), Mild (=1), Moderate (=2), Severe (=3), Extreme (=4) report.
KOOSJRQ2_TWIST_TXT VARCHAR(50) Y Identifies if the patient has knee pain in the last week when twisting.
KOOSJRQ3_STRAIGHTEN_FLAG DOUBLE Y Identifies knee pain when straightening. None (= 0), Mild (=1), Moderate (=2), Severe (=3), Extreme (=4) report.
KOOSJRQ3_STRAIGHTEN_TXT VARCHAR(50) Y Identifies if the patient has knee pain in the last week when straightening the knees.
KOOSJRQ4_STAIRS_FLAG DOUBLE Y Identifies knee pain when going up and down stairs. None (= 0), Mild (=1), Moderate (=2), Severe (=3), Extreme (=4) report.
KOOSJRQ4_STAIRS_TXT VARCHAR(50) Y Identifies if the patient has knee pain in the last week when going up or down stairs.
KOOSJRQ5_UPRIGHT_FLAG DOUBLE Y Identifies knee pain when standing upright. None (= 0), Mild (=1), Moderate (=2), Severe (=3), Extreme (=4) report.
KOOSJRQ5_UPRIGHT_TXT VARCHAR(50) Y Identifies if the patient has knee pain in the last week when standing upright.
KOOSJRQ6_SITTING_FLAG DOUBLE Y Identifies knee pain when sitting. None (= 0), Mild (=1), Moderate (=2), Severe (=3), Extreme (=4) report.
KOOSJRQ6_SITTING_TXT VARCHAR(50) Y Identifies if the patient has knee pain in the last week when sitting.
KOOSJRQ7_BENDING_FLAG DOUBLE Y Identifies knee pain when bending. None (= 0), Mild (=1), Moderate (=2), Severe (=3), Extreme (=4) report.
KOOSJRQ7_BENDING_TXT VARCHAR(50) Y Identifies if the patient has knee pain in the last week when bending.
LH_THA_TKA_METRICS_ID DOUBLE N Unique generated number that identifies a single row on the LH_THA_TKA_METRICS table.
LOGICAL_DOMAIN_ID DOUBLE N The unique identifier for a logical domain. This identifier allows the data to be grouped by logical domain. For example, If you assign clients a logical_domain_id this would allow you to store data for multiple clients on this table.
MBI_TXT VARCHAR(50) Y Medicare Beneficiary Identifier (MBI) number for the patient.
NARCOTIC_USE_FLAG DOUBLE Y Identifies chronic use of narcotics. No (= 0), Yes (=1) and None(= 999) report.
NARCOTIC_USE_TXT VARCHAR(50) Y Identifies if the patient is using any chronic narcotics.
ORG_MRN_TXT VARCHAR(50) Y Identifies the medical record number of the patient.
OTHER_JOINT_PAIN_FLAG DOUBLE Y Identifies patient reported pain. None (= 0), Mild (=1), Moderate (=2), Severe (=3), Extreme (=4) report.
OTHER_JOINT_PAIN_TXT VARCHAR(50) Y Identifies if the patient has any other joint pain.
PAYER_TXT VARCHAR(50) Y Payment source of the patient encounter.
PRE_POST_FLAG DOUBLE Y Identifies if the patient encounter is considered for Preoperative (= 1), Postoperative (=2) or None(= 999) survey.
PROC_DT_TM DATETIME Y Procedure date and time (local) of the patient encounter.
PROC_UTC_DT_TM DATETIME Y Procedure date and time (UTC) of the patient encounter.
PROMISGLQ10R_ANXIOUS_FLAG DOUBLE Y Identifies the patients is feeling anxious. Never(=1) ,Rarely(=2),Sometimes(=3),Often(=4), Always(=5) if version 1.1 else Always(=1), Often(=2), Sometimes(=3),Rarely (=4), Never (=5).
PROMISGLQ10R_ANXIOUS_TXT VARCHAR(50) Y Identifies the emotional problems of the patient.
PROMISGLQ2_QUALITYLIFE_FLAG DOUBLE Y Identifies the patients quality of life. Poor(=1) ,Fair(=2),Good(=3),Very Good(=4), Excellent(=5).
PROMISGLQ2_QUALITYLIFE_TXT VARCHAR(50) Y Identifies the quality of life of the patient.
PROMISGLQ4_MENTALHEALTH_FLAG DOUBLE Y Identifies the patients mental health. Poor(=1) ,Fair(=2),Good(=3),Very Good(=4), Excellent(=5).
PROMISGLQ4_MENTALHEALTH_TXT VARCHAR(50) Y Identifies the mental health of the patient.
PROMISGLQ5_ACTIVITIES_FLAG DOUBLE Y Identifies the patients satisfaction with social activities. Poor(=1) ,Fair(=2),Good(=3),Very Good(=4), Excellent(=5).
PROMISGLQ5_ACTIVITIES_TXT VARCHAR(50) Y Identifies the satisfaction ratings of the social activities of the patient.
P_TYPE_FLAG DOUBLE Y Identifies procedure type. Left Hip Replacement (= 1), Right Hip Replacement (=2), Left knee Replacement (=3), Right Knee Replacement (=4) and None(= 999) report.
P_TYPE_TXT VARCHAR(50) Y Identifies the procedure type for the patient.
RACE_TXT VARCHAR(50) Y Race(s) of the patient.
RESPONDER_FLAG DOUBLE Y Identifies person collecting survey. Self (= 0), Surrogate (=1) and None(= 999) report.
RESPONDER_TXT VARCHAR(50) Y Identifies the person who completed the survey.
SAMPLE_IND DOUBLE Y Identifies if the case is sampled.
S_TYPE_FLAG DOUBLE Y Identifies if the patient encounter is considered for Preoperative (= 1), Postoperative (=2) or None(= 999) survey.
S_TYPE_TXT VARCHAR(50) Y Identifies the patient encounter survey type.
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_SOURCE VARCHAR(50) Y The script name responsible for updating the record.
UPDT_TASK VARCHAR(50) 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.
VR_12Q4A_ACCOMPLISH_FLAG DOUBLE Y Identifies if patient accomplished less work No, none of the time (= 1), Yes, a little of the time (=2), Yes, some of the time (=3), Yes, most of the time (=4), Yes, all of the time (=5).
VR_12Q4A_ACCOMPLISH_TXT VARCHAR(50) Y Identifies if the patient has accomplished less work in the last 4 weeks.
VR_12Q4B_CAREFUL_FLAG DOUBLE Y Identifies if patient was able to do work carefully. No, none of the time (= 1), Yes, a little of the time (=2), Yes, some of the time (=3), Yes, most of the time (=4), Yes, all of the time (=5).
VR_12Q4B_CAREFUL_TXT VARCHAR(50) Y Identifies if the patient has not carefully worked as usual in the last 4 weeks.
VR_12Q6A_CALM_FLAG DOUBLE Y Identifies if patient was calm. All of the time (= 1), Most of the time (=2), A good bit of the time (=3), A little of the time (=4), None of the time (=5).
VR_12Q6A_CALM_TXT VARCHAR(50) Y Identifies for how much time the patient is clam and peaceful in the last 4 weeks.
VR_12Q6B_ENERGY_FLAG DOUBLE Y Identifies if patient was full of energy. All of the time (= 1), Most of the time (=2), A good bit of the time (=3), Some of the time (=4),A little of the time (=5), None of the time (=6).
VR_12Q6B_ENERGY_TXT VARCHAR(50) Y Identifies for how much time the patient had a lot of energy in the last 4 weeks.
VR_12Q6C_DOWN_FLAG DOUBLE Y Identifies if patient was downhearted. All of the time (= 1), Most of the time (=2), A good bit of the time (=3), Some of the time (=4),A little of the time (=5), None of the time (=6).
VR_12Q6C_DOWN_TXT VARCHAR(50) Y Identifies for how much time the patient felt downhearted and blue in the last 4 weeks.
VR_12Q7_SOCLACT_FLAG DOUBLE Y Identifies if patient's physical health interfered with social activities. All of the time (= 1), Most of the time (=2), Some of the time (=3),A little of the time (=4), None of the time (=5).
VR_12Q7_SOCLACT_TXT VARCHAR(50) Y Identifies for how much time physical or emotional health of the patient interfered with social activities in the last 4 weeks.
WEIGHT_NBR DOUBLE Y Identifies the weight of the patient.



Relationship Detail - LH_THA_TKA_METRICS


Child Column in LH_THA_TKA_METRICS(FK) Parent Table Name Parent Column Name
Parents: D_BR_CCN_ID LH_D_BR_CCN D_BR_CCN_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_BR_CCN HEALTH_SYSTEM_SOURCE_ID
D_BR_HCO_ID LH_D_BR_HCO D_BR_HCO_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_BR_HCO HEALTH_SYSTEM_SOURCE_ID
D_DISCH_BUILDING_ID LH_D_BUILDING D_BUILDING_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_BUILDING HEALTH_SYSTEM_SOURCE_ID
D_DISCH_FACILITY_ID LH_D_FACILITY D_FACILITY_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_FACILITY HEALTH_SYSTEM_SOURCE_ID
D_DISCH_NURSE_UNIT_ID LH_D_NURSE_UNIT D_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_NURSE_UNIT HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_D_PERSON D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_PERSON HEALTH_SYSTEM_SOURCE_ID
D_ATTEND_PRSNL_ID LH_D_PERSONNEL D_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_PERSONNEL HEALTH_SYSTEM_SOURCE_ID
LOGICAL_DOMAIN_ID LOGICAL_DOMAIN LOGICAL_DOMAIN_ID