Table Detail Report
LH_QRDA_PROBLEM
Column Section | Top of Page |
Table-level Detail
Description: | LH_QRDA_PROBLEM |
Definition: | This table is used to store elements that are used to create the Problem Section in the body of a QRDA file for submission |
Table Type: | ACTIVITY |
Column Detail - LH_QRDA_PROBLEM
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. |
EVENT_END_DT_TM | DATETIME | Y | This field is to specify the end date time of the event either Diagnosis or Problem |
EXTRACT_DT_TM | DATETIME | Y | The date/time that the record was extracted from the source system. |
FAMILY_MBR_CODE | VARCHAR(50) | Y | Family member associated with the patient for family history diagnosis |
FAMILY_MBR_CODE_NAME | VARCHAR(50) | Y | Family member associated with the patient for family history diagnosis |
FIRST_PROCESS_DT_TM | DATETIME | Y | The date/time that the first ETL process started that created this record. |
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 that the last ETL process started that updated this record. |
LH_QRDA_PROBLEM_ID | DOUBLE | N | Unique generated number that identifies a single row on the LH_QRDA_PROBLEM 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. |
NEGATION_IND | DOUBLE | Y | Indicates whether a negation exists or not |
ONSET_DT_TM | DATETIME | Y | Indicates the timing of the concern |
PARENT_ENTITY_ID | DOUBLE | N | The value of the primary identifier of the table to which the Problem section is related (i.e. lh_qrda_pqrs_id) |
PARENT_ENTITY_ID2 | DOUBLE | N | The value of the primary identifier of millennium source table |
PARENT_ENTITY_NAME | VARCHAR(50) | N | The name of the table this Problem section is related (i.e. LH_QRDA_PQRS) |
PARENT_ENTITY_NAME2 | VARCHAR(50) | N | The name of millennium source table |
PRIORITY_LEVEL | DOUBLE | Y | Indicates the priority of the diagnosis. |
PROBLEM_INSTANCE_ID | DOUBLE | N | Unique identifier for PROBLEM table |
PROBLEM_STATUS_CODE | VARCHAR(50) | Y | The code that will be used to represent the @code attribute in value node |
PROBLEM_STATUS_CODE_SYSTEM | VARCHAR(50) | Y | The code system from which problem_status_cd was derived from |
PROBLEM_STATUS_DISPLAY | VARCHAR(500) | Y | Text representation of the status of a problem |
PROBLEM_STATUS_DT_TM | DATETIME | Y | The date and time on which the status of the problem was changed |
PROBLEM_TEMPLATE | VARCHAR(50) | Y | The name of the template the problem corresponds to |
PROBLEM_VALUE | VARCHAR(50) | Y | The problem value code associated with a problem |
PROBLEM_VALUE_DISPLAY | VARCHAR(500) | Y | Text representation of a problem |
PROBLEM_VALUE_DISPLAY_NEG | VARCHAR(500) | Y | Text representation of a negation reason of a problem |
PROBLEM_VALUE_NEG | VARCHAR(50) | Y | The problem value code associated with a negation reason for a problem |
PROBLEM_VALUE_SYSTEM | VARCHAR(50) | Y | The codeSystem from which the problem_value was derived from |
PROBLEM_VALUE_SYSTEM_NAME | VARCHAR(50) | Y | Coding system name |
PROBLEM_VALUE_SYSTEM_NAME_NEG | VARCHAR(50) | Y | Coding system name of negation reason |
PROBLEM_VALUE_SYSTEM_NEG | VARCHAR(50) | Y | The codeSystem from which the negation reason of a problem_value was derived from |
PROBLEM_VALUE_SYSTEM_SDTC | VARCHAR(50) | Y | OID of value set |
PROBLEM_VALUE_SYSTEM_SDTC_NEG | VARCHAR(50) | Y | OID of value set of negation reason |
REPORTING_YEAR | DOUBLE | Y | Stores the reporting year. |
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_SOURCE | VARCHAR(50) | N | The script name responsible for updating the record. |
UPDT_TASK | VARCHAR(50) | 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. |
LH_QRDA_PROCEDURE
Column Section | Top of Page |
Table-level Detail
Description: | LH_QRDA_PROCEDURE |
Definition: | This table is used to store elements that are used to create the Procedure Section in the body of a QRDA file for submission |
Table Type: | ACTIVITY |
Column Detail - LH_QRDA_PROCEDURE
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. |
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 that the first ETL process started that created this record. |
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 that the last ETL process started that updated this record. |
LH_QRDA_PROCEDURE_ID | DOUBLE | N | Unique generated number that identifies a single row on the LH_QRDA_PROCEDURE 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. |
NEGATION_IND | DOUBLE | Y | Indicates whether a negation exists or not |
PARENT_ENTITY_ID | DOUBLE | N | The value of the primary identifier of the table to which the Procedure section is related (i.e. lh_qrda_pqrs_id) |
PARENT_ENTITY_ID2 | DOUBLE | N | The value of the primary identifier of the millennium table to which the Procedure section is related |
PARENT_ENTITY_NAME | VARCHAR(50) | Y | The name of the table this Procedure section is related (i.e. LH_QRDA_PQRS) |
PARENT_ENTITY_NAME2 | VARCHAR(50) | N | The name of the millennium table this Procedure section is related |
PRIORITY_LEVEL | DOUBLE | N | Indicates the priority of the procedure. |
PROCEDURE_ID | DOUBLE | N | Unique identifier for PROCEDURE table |
PROC_CODE | VARCHAR(50) | Y | Represents a given code value (not Cerner's code value) from proc_cd_system |
PROC_CODE_DISPLAY | VARCHAR(500) | Y | Text representation of the procedure |
PROC_CODE_DISPLAY_NEG | VARCHAR(500) | Y | Text representation of the procedure (negation) |
PROC_CODE_NEG | VARCHAR(50) | Y | Represents a given code value (not Cerner's code value) from proc_cd_system (negation) |
PROC_CODE_SYSTEM | VARCHAR(50) | Y | Represents the codeSystem string of the code node |
PROC_CODE_SYSTEM_NAME | VARCHAR(50) | Y | The name of the procedure's code system (e.g. SNMCT) |
PROC_CODE_SYSTEM_NAME_NEG | VARCHAR(50) | Y | The name of the procedure's code system (negation) (e.g. SNMCT) |
PROC_CODE_SYSTEM_NEG | VARCHAR(50) | Y | Represents the codeSystem string of the code node (negation) |
PROC_CODE_SYSTEM_SDTC | VARCHAR(50) | Y | The OID of the code system's value set |
PROC_CODE_SYSTEM_SDTC_NEG | VARCHAR(50) | Y | The OID of the code system's value set (negation) |
PROC_DT_TM | DATETIME | Y | The date and time the procedure was performed. |
PROC_END_DT_TM | DATETIME | Y | The date/time the record was end date for procedure into the table. |
PROC_STATUS_CODE | VARCHAR(50) | Y | The status code of the procedure |
PROC_TEMPLATE | VARCHAR(50) | Y | The name of the template the procedure corresponds to |
REPORTING_YEAR | DOUBLE | Y | Stores the reporting year. |
RESULT_OBS_CODE | VARCHAR(50) | Y | Result value set code |
RESULT_OBS_CODE_DISPLAY | VARCHAR(500) | Y | Display of value set of result |
RESULT_OBS_CODE_SYSTEM | VARCHAR(50) | Y | OID of value set coding system of result |
RESULT_OBS_CODE_SYSTEM_NAME | VARCHAR(50) | Y | Value set coding system name of result |
RESULT_OBS_CODE_SYSTEM_SDTC | VARCHAR(50) | Y | OID of value set of result |
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_SOURCE | VARCHAR(50) | N | The script name responsible for updating the record. |
UPDT_TASK | VARCHAR(50) | 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. |
LH_QRDA_PROV_DET
Column Section | Top of Page |
Table-level Detail
Description: | LH_QRDA_PROV_DET |
Definition: | This table is used to store elements that are used to provide additional information for each provider needed in QRDA Category 1 and 3 file for submission. This table is at the grain of one provider per row. |
Table Type: | ACTIVITY |
Column Detail - LH_QRDA_PROV_DET
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. |
AUTHOR_CITY | VARCHAR(50) | Y | The author's location city |
AUTHOR_NPI | VARCHAR(50) | Y | The author's national provider ID |
AUTHOR_ORG_NAME | VARCHAR(50) | Y | The name of the author's organization |
AUTHOR_STATE | VARCHAR(50) | Y | The author's location state |
AUTHOR_STREET_ADDR | VARCHAR(200) | Y | The author's street address |
AUTHOR_STREET_ADDR2 | VARCHAR(200) | Y | The second line of the author's street address |
AUTHOR_TELECOM | VARCHAR(50) | Y | The author's phone number |
AUTHOR_ZIPCODE | VARCHAR(50) | Y | The author's location zip code |
BR_CPC_ID | DOUBLE | N | The id of the cpc practice site set in bedrock |
BR_GPRO_ID | DOUBLE | N | The id of the provider group set in bedrock |
BR_GPRO_SUB_ID | DOUBLE | Y | Unique generated number that identifies a single row on the BR_GPRO_SUB table. |
CMS_PROGRAM | VARCHAR(100) | Y | Type of submission program: 'NQF', 'PQRS', 'GPRO-PQRS', 'GPRO-NQF', 'CPC' |
CUSTODIAN_CITY | VARCHAR(50) | Y | The custodian's location city |
CUSTODIAN_NPI | VARCHAR(50) | Y | The custodian's national provider ID |
CUSTODIAN_ORG_NAME | VARCHAR(50) | Y | The name of the custodian's organization |
CUSTODIAN_STATE | VARCHAR(50) | Y | The custodian's location state |
CUSTODIAN_STREET_ADDR | VARCHAR(200) | Y | The custodian's street address |
CUSTODIAN_STREET_ADDR2 | VARCHAR(200) | Y | The second line of the custodian's street address |
CUSTODIAN_TELECOM | VARCHAR(50) | Y | The custodian's phone number |
CUSTODIAN_ZIPCODE | VARCHAR(50) | Y | The custodian's location zip code |
D_PRSNL_ID | DOUBLE | N | The value of the primary identifier of the table to which the Other Template section is related (i.e. lh_qrda_pqrs_id) |
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 that the first ETL process started that created this record. |
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 that the last ETL process started that updated this record. |
LEGAL_AUTH_CITY | VARCHAR(50) | Y | The legal authenticator's location city |
LEGAL_AUTH_NPI | VARCHAR(50) | Y | The legal authenticator's national provider ID |
LEGAL_AUTH_ORG_NAME | VARCHAR(50) | Y | The name of the legal authenticator's organization |
LEGAL_AUTH_STATE | VARCHAR(50) | Y | The legal authenticator's location state |
LEGAL_AUTH_STREET_ADDR | VARCHAR(200) | Y | The legal authenticator's street address |
LEGAL_AUTH_STREET_ADDR2 | VARCHAR(200) | Y | The second line of the legal authenticator's street address |
LEGAL_AUTH_TELECOM | VARCHAR(50) | Y | The legal authenticator's phone number |
LEGAL_AUTH_ZIPCODE | VARCHAR(50) | Y | The legal authenticator's location zip code |
LH_QRDA_PROV_DET_ID | DOUBLE | N | Unique generated number that identifies a single row on the LH_QRDA_PROV_DET 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. |
PROV_CITY | VARCHAR(100) | Y | The provider's location city |
PROV_ORG_NAME | VARCHAR(255) | Y | The name of the provider's organization |
PROV_STATE | VARCHAR(50) | Y | The provider's location state |
PROV_STREET_ADDR | VARCHAR(200) | Y | The provider's street address |
PROV_STREET_ADDR2 | VARCHAR(200) | Y | The second line of the provider's street address |
PROV_TELECOM | VARCHAR(50) | Y | The provider's phone number |
PROV_ZIPCODE | VARCHAR(50) | Y | The provider's location zip code |
REPORTING_CATEGORY | DOUBLE | Y | Indicates if the report category is QRDA 1 or QRDA 3. |
REPORTING_YEAR | DOUBLE | Y | Stores the reporting year. |
SRC_UPDT_DT_TM | DATETIME | Y | Indicates the actual time when the row was inserted or updated at the source. This column is used only for date extraction and will not be populated on the client site. |
SRC_UPDT_SOURCE | VARCHAR(50) | Y | This column is updated with the name of the source program that loaded these rows into this table in Quality Clearinghouse when the Power Insight extracts were executed. This column is used only for date extraction and will not be populated on the client site. |
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_SOURCE | VARCHAR(50) | N | The script name responsible for updating the record. |
UPDT_TASK | VARCHAR(50) | 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. |
LH_QRDA_RESULT
Column Section | Top of Page |
Table-level Detail
Description: | LH_QRDA_RESULT |
Definition: | This table is used to store elements that are used to create the Result Section in the body of a QRDA file for submission |
Table Type: | ACTIVITY |
Column Detail - LH_QRDA_RESULT
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. |
EFFECTIVE_DT_TM | DATETIME | Y | The date and time on which the status of the problem was changed |
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. |
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 that the first ETL process started that created this record. |
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 that the last ETL process started that updated this record. |
LH_QRDA_RESULT_ID | DOUBLE | N | Unique generated number that identifies a single row on the LH_QRDA_RESULT 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. |
NEGATION_IND | DOUBLE | Y | Indicates whether a negation exists or not |
OBSERVATION_CODE | VARCHAR(50) | Y | Code derived from Appendix_F-Results tab of Downloadable Resources Table |
OBSERVATION_CODE_SYSTEM | VARCHAR(50) | Y | The code system from which observation_code was derived from |
OBS_CODE_DISPLAY | VARCHAR(500) | Y | Text representation of the result |
OBS_CODE_DISPLAY_NEG | VARCHAR(500) | Y | Text representation of the result (negation) |
OBS_CODE_NEG | VARCHAR(50) | Y | Represents a given code value (not Cerner's code value) from obs_cd_system (negation) |
OBS_CODE_SYSTEM_NAME | VARCHAR(50) | Y | The name of the result's code system (e.g. SNMCT) |
OBS_CODE_SYSTEM_NAME_NEG | VARCHAR(50) | Y | The name of the result's code system (negation) (e.g. SNMCT) |
OBS_CODE_SYSTEM_NEG | VARCHAR(50) | Y | Represents the codeSystem string of the code node (negation) |
OBS_CODE_SYSTEM_SDTC | VARCHAR(50) | Y | The OID of the code system's value set |
OBS_CODE_SYSTEM_SDTC_NEG | VARCHAR(50) | Y | The OID of the code system's value set (negation) |
PARENT_ENTITY_ID | DOUBLE | N | The value of the primary identifier of the table to which the Result section is related (i.e. lh_qrda_pqrs_id) |
PARENT_ENTITY_ID2 | DOUBLE | N | The value of the primary identifier of the table to which the Result section is related (i.e. lh_qrda_pqrs_id) |
PARENT_ENTITY_NAME | VARCHAR(50) | Y | The name of the table this Result section is related (i.e. LH_QRDA_PQRS) |
PARENT_ENTITY_NAME2 | VARCHAR(50) | N | The name of the table this Result section is related (i.e. LH_QRDA_PQRS) |
REPORTING_YEAR | DOUBLE | Y | Stores the reporting year. |
RESULT_CODE | VARCHAR(50) | Y | The code associated with a result |
RESULT_DISPLAY | VARCHAR(500) | Y | Text description of the result |
RESULT_ID | DOUBLE | N | Unique result id |
RESULT_TEMPLATE | VARCHAR(50) | Y | The name of the template the result corresponds to |
RESULT_TYPE | VARCHAR(50) | Y | The type of code associated with a given result (e.g. SNOMED CT / CPT-4 / LOINC) |
RESULT_UNIT | VARCHAR(50) | Y | Represents the unit (e.g. %) for a result_value |
RESULT_VALUE | VARCHAR(255) | Y | Represents the value that is within the range of values for the chosen observation_cd |
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_SOURCE | VARCHAR(50) | N | The script name responsible for updating the record. |
UPDT_TASK | VARCHAR(50) | 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. |
LH_QRDA_SETUP_DATA
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Lighthouse Quality Reporting Document Architecture Setup Data |
Definition: | Stores data in relation to how an entity is setup when running the QRDA loads. |
Table Type: | ACTIVITY |
Column Detail - LH_QRDA_SETUP_DATA
Column Name | Type | Null? | Definition |
---|---|---|---|
BR_CPC_ID | DOUBLE | N | The BR_CPC_ID for the CPC the QRDA load was run for when run for CPCs. |
BR_GPRO_ID | DOUBLE | N | The BR_GPRO_ID for the group the QRDA load was run for when run for Groups. |
BR_GPRO_SUB_ID | DOUBLE | Y | Unique generated number that identifies a single row on the BR_GPRO_SUB table. |
CATEGORY_NUMBER | DOUBLE | Y | Whether the QRDA load was run as a Category 3 or Category 1 load. |
D_PRSNL_ID | DOUBLE | N | The LH_D_PERSONNEL_ID for the provider the QRDA load was run for when run for individuals. |
FIRST_PROCESS_DT_TM | DATETIME | Y | The date/time that the first ETL process started that created this record. |
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 that the last ETL process started that updated this record. |
LH_QRDA_SETUP_DATA_ID | DOUBLE | N | Unique generated number that identifies a single row on the LH_QRDA_SETUP_DATA table.; |
REPORTING_YEAR | DOUBLE | Y | The year the QRDA load was run for. |
SETUP_TYPE | VARCHAR(50) | Y | A short identifier for the type of data being stored. |
SETUP_VALUE | DOUBLE | N | An ID of a value represented in setup, such as a location ID. |
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. |
Relationship Detail - LH_QRDA_SETUP_DATA
Child Column in LH_QRDA_SETUP_DATA(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | BR_CPC_ID | BR_CPC | BR_CPC_ID |
BR_GPRO_ID | BR_GPRO | BR_GPRO_ID | |
D_PRSNL_ID | LH_D_PERSONNEL | D_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_PERSONNEL | HEALTH_SYSTEM_SOURCE_ID |