Table Detail Report
RC_GSR_DIMENSION_TMP
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Revenue Cycle Gold Standard Reporting Dimension Temporary |
Definition: | This table is used by the GSR dimension load process to identify the distinct set of rows in each of the dimension tables which must be inserted or updated during the current job execution. This table does not need a unique PK value or associated index. |
Table Type: | ACTIVITY |
Column Detail - RC_GSR_DIMENSION_TMP
Column Name | Type | Null? | Definition |
---|---|---|---|
BATCH_ID | DOUBLE | N | A sequential batch identifier assigned to a group of rows inserted into this table by the GSR dimension load process for the logical_domain_id in which the process is being executed. |
DIM_INDEX | DOUBLE | N | This field is an index into the recDWItems structure that is used by the GSR dimension load process to access the parameters needed to process the loading of data for each dimension table |
INSERT_IND | DOUBLE | N | This field will be set to 0 if the dimension row related to this row already exists and must be updated, or 1 if a new row will need to be inserted. |
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. |
LONG_TEXT_MD5_HASH_TXT | VARCHAR(32) | N | This field is a unique identifier based on the value of the long_text string that is linked to the referenced rc_cln_area row. While rc_cln_area may include large numbers of rows that reference the same dimension row, only one row will be inserted into this table for each distinct dimension row based on the value of this column. |
RCR_GSR_CONTEXT_ID | DOUBLE | N | Unique generated number that identifies a single row on the RCR_GSR_CONTEXT table. |
RC_CLN_AREA_ID | DOUBLE | N | This is the primary key of a row on the rc_cln_area staging table. |
RC_DIMENSION_ID | DOUBLE | N | This field is a numeric identifier that is associated with each GSR dimension table. The specific values assigned to each dimension table are defined in the pft_load_dw.inc include file. |
Relationship Detail - RC_GSR_DIMENSION_TMP
Child Column in RC_GSR_DIMENSION_TMP(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | RCR_GSR_CONTEXT_ID | RCR_GSR_CONTEXT | RCR_GSR_CONTEXT_ID |
RC_GSR_SUM_AGG_TMP
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Revenue Cycle Gold Standard Reporting Summary Aggregate Temporary |
Definition: | This tables is used in the GSR summarization process to control the distributed summarization of data based on all possible values of an extract-specific dimension. |
Table Type: | ACTIVITY |
Column Detail - RC_GSR_SUM_AGG_TMP
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVITY_DATE | DOUBLE | N | The date for which activity data is to be summarized. |
AGGREGATE_INFO | VARCHAR(250) | N | This is a delimited string that defines the names of the source activity table, the column in that table containing the dimension id found in the attribute_value and the name of the dimension table for which this value represents the primary key. |
ATTRIBUTE_VALUE | DOUBLE | N | The value of a specific dimension id by which activity data is to be summarized. This value may be 0.0 to allow summarization to occur for activity data for which there is no related dimension row. See the aggregate_info column for information defining which dimension table is referenced, what it's primary key column name is, and what the name of the activity table being summarized is. |
LOAD_SCRIPT_NAME | VARCHAR(32) | N | The name of the load script that is responsible for summarizing the data associated with this row. |
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. |
RCR_GSR_CONTEXT_ID | DOUBLE | N | Uniquely identifies the related GSR Context Identifier |
TEMP_ID | DOUBLE | N | A sequential identifier for the rows that are inserted by the GSR summary load process for the logical_domain_id in which the process is being executed. |
Relationship Detail - RC_GSR_SUM_AGG_TMP
Child Column in RC_GSR_SUM_AGG_TMP(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | RCR_GSR_CONTEXT_ID | RCR_GSR_CONTEXT | RCR_GSR_CONTEXT_ID |
SHR_D_LOCATION
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Shared Dimension Location |
Definition: | This table contains location information such as facility and building name. |
Table Type: | REFERENCE |
Column Detail - SHR_D_LOCATION
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. |
BED | VARCHAR(40) | N | The bed associate with a location. |
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. |
BUILDING | VARCHAR(40) | N | The building associated with a location. |
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. |
FACILITY | VARCHAR(40) | N | The facility associated with a location. |
FIRST_PROCESS_DT_TM | DATETIME | N | The date/time that the first ETL process started that created this record. |
LAST_PROCESS_DT_TM | DATETIME | N | The date/time that the last ETL process started that updated this record. |
LOCATION_DESC | VARCHAR(40) | N | The current permanent location of the patient (The location of a patient will be valued with the lowest level location type in the hierarchy of facility, building, room, bed). |
LOCATION_MD5_HASH_TXT | VARCHAR(32) | N | This column contains an MD5 hash code based upon the combined values of the LOCATION_DESC, FACILITY, BUILDING, ROOM, BED, MILL_LOGICAL_DOMAIN_ID and ACTIVE_IND columns. |
MILL_LOGICAL_DOMAIN_ID | DOUBLE | N | Uniquely identifies the logical domain to which the row data belongs. |
ROOM | VARCHAR(40) | N | The room associated with a location. |
SHR_D_LOCATION_ID | DOUBLE | N | Uniquely identifies location information such as facility and building name. |
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 - SHR_D_LOCATION
Parent Column in SHR_D_LOCATION (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | SHR_D_LOCATION_ID | RC_F_ADJUSTMENT | SHR_D_PATIENT_LOCATION_ID |
RC_F_BALANCE_AR | SHR_D_LOCATION_ID | ||
RC_F_CASE_MIX | SHR_D_LOCATION_ID | ||
RC_F_CASH | SHR_D_PATIENT_LOCATION_ID | ||
RC_F_CLAIM_EVENT | SHR_D_LOCATION_ID | ||
RC_F_CODING_ACTIVITY | SHR_D_LOCATION_ID | ||
RC_F_DAILY_BAL_AR_SMRY | SHR_D_LOCATION_ID | ||
RC_F_DAILY_CDM_SMRY | SHR_D_LOCATION_ID | ||
RC_F_DAILY_CENSUS | SHR_D_LOCATION_ID | ||
RC_F_DAILY_CENSUS_SMRY | SHR_D_LOCATION_ID | ||
RC_F_DAILY_CLAIM_EVENT_SMRY | SHR_D_LOCATION_ID | ||
RC_F_DAILY_ENCNTR_VISIT_SMRY | SHR_D_LOCATION_ID | ||
RC_F_DAILY_TRANS_SMRY | SHR_D_LOCATION_ID | ||
RC_F_DENIAL | SHR_D_LOCATION_ID | ||
RC_F_DLY_CHRG_ASSOC_SMRY | SHR_D_PATIENT_LOCATION_ID | ||
RC_F_DLY_CODING_ACT_SMRY | SHR_D_LOCATION_ID | ||
RC_F_INVOICE_AR_BALANCE | SHR_D_LOCATION_ID | ||
RC_F_MONTHLY_CDM_SMRY | SHR_D_LOCATION_ID | ||
RC_F_MONTHLY_CENSUS_SMRY | SHR_D_LOCATION_ID | ||
RC_F_MONTHLY_CLAIM_EVENT_SMRY | SHR_D_LOCATION_ID | ||
RC_F_MONTHLY_ENCNTR_VISIT_SMRY | SHR_D_LOCATION_ID | ||
RC_F_MONTHLY_TRANS_SMRY | SHR_D_LOCATION_ID | ||
RC_F_MTH_CHRG_ASSOC_SMRY | SHR_D_PATIENT_LOCATION_ID | ||
RC_F_MTH_CODING_ACT_SMRY | SHR_D_LOCATION_ID | ||
RC_F_PATIENT_AR_BALANCE | SHR_D_LOCATION_ID | ||
RC_F_PATIENT_AR_BAL_SMRY | SHR_D_LOCATION_ID | ||
RC_F_REVENUE | SHR_D_PATIENT_LOCATION_ID | ||
RC_F_REVENUE | SHR_D_PERFORMING_LOCATION_ID | ||
RC_F_VARIANCE | SHR_D_PATIENT_LOCATION_ID | ||
RC_F_VAR_CLAIM_SMRY | SHR_D_PATIENT_LOCATION_ID | ||
RC_F_VAR_LINE_ITEM_SMRY | SHR_D_PATIENT_LOCATION_ID | ||
SHR_F_ENCOUNTER_VISIT | SHR_D_LOCATION_ID |
SHR_D_MONTH
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Shared Dimension Month |
Definition: | Contains data related to the months of the year. |
Table Type: | REFERENCE |
Column Detail - SHR_D_MONTH
Column Name | Type | Null? | Definition |
---|---|---|---|
FIRST_PROCESS_DT_TM | DATETIME | N | The date/time that the first ETL process started that created this record. |
LAST_PROCESS_DT_TM | DATETIME | N | The date/time that the last ETL process started that updated this record. |
MONTH_ABBREVIATION | VARCHAR(5) | N | Contains the first three letters of the name of the month. |
MONTH_NAME | VARCHAR(10) | N | Contains the name of the month. |
SHR_D_MONTH_ID | DOUBLE | N | Uniquely identifies a row for each month of the year. |
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 - SHR_D_MONTH
Parent Column in SHR_D_MONTH (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | SHR_D_MONTH_ID | RC_F_DAILY_TRANS_SMRY | DISCHARGE_MONTH_ID |
RC_F_MONTHLY_CDM_SMRY | SHR_D_MONTH_ID | ||
RC_F_MONTHLY_CLAIM_EVENT_SMRY | SHR_D_MONTH_ID | ||
RC_F_MONTHLY_DENIAL_SMRY | SHR_D_MONTH_ID | ||
RC_F_MONTHLY_ENCNTR_VISIT_SMRY | SHR_D_MONTH_ID | ||
RC_F_MONTHLY_TRANS_SMRY | DISCHARGE_MONTH_ID | ||
RC_F_MONTHLY_TRANS_SMRY | SHR_D_MONTH_ID | ||
RC_F_MTH_CHRG_ASSOC_SMRY | SHR_D_SERVICE_MONTH_ID |
SHR_D_PERSON
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Shared Dimension Person |
Definition: | This table contains person information such as a person's and a supervisor's name. |
Table Type: | ACTIVITY |
Column Detail - SHR_D_PERSON
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. |
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. |
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. |
FIRST_PROCESS_DT_TM | DATETIME | N | The date/time that the first ETL process started that created this record. |
LAST_PROCESS_DT_TM | DATETIME | N | The date/time that the last ETL process started that updated this record. |
MILL_LOGICAL_DOMAIN_ID | DOUBLE | N | Uniquely identifies the logical domain to which the row data belongs. |
MILL_PERSON_ID | DOUBLE | N | Uniquely identifies the person id from the Millennium database person table related to this dimension row. |
PERSON_FIRST_NAME | VARCHAR(100) | N | The first name of a person. |
PERSON_FULL_NAME | VARCHAR(100) | N | The full name of the person. |
PERSON_LAST_NAME | VARCHAR(100) | N | The last name of the person. |
PERSON_MIDDLE_NAME | VARCHAR(100) | N | The middle name of the person. |
SHR_D_PERSON_ID | DOUBLE | N | Uniquely identifies person information. |
SUPERVISOR_FULL_NAME | VARCHAR(100) | N | The full name of the supervisor. |
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 - SHR_D_PERSON
Parent Column in SHR_D_PERSON (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | SHR_D_PERSON_ID | RC_D_RACE_BRIDGE | SHR_D_PERSON_ID |
RC_F_ADJUSTMENT | SHR_D_ADMIT_PHYSICIAN_ID | ||
RC_F_ADJUSTMENT | SHR_D_ATTEND_PHYSICIAN_ID | ||
RC_F_ADJUSTMENT | SHR_D_CONSULT_PHYSICIAN_ID | ||
RC_F_ADJUSTMENT | SHR_D_ORDER_PHYSICIAN_ID | ||
RC_F_ADJUSTMENT | SHR_D_PERFORM_PHYSICIAN_ID | ||
RC_F_ADJUSTMENT | SHR_D_PERSON_ID | ||
RC_F_ADJUSTMENT | SHR_D_POSTING_PRSNL_ID | ||
RC_F_ADJUSTMENT | SHR_D_REFER_PHYSICIAN_ID | ||
RC_F_ADJUSTMENT | SHR_D_REND_PHYSICIAN_ID | ||
RC_F_ADJUSTMENT | SHR_D_SUPERV_PHYSICIAN_ID | ||
RC_F_BALANCE_AR | SHR_D_ATTENDING_PHYSICIAN_ID | ||
RC_F_BALANCE_AR | SHR_D_PERSON_ID | ||
RC_F_CASE_MIX | SHR_D_ATTENDING_PRSNL_ID | ||
RC_F_CASE_MIX | SHR_D_CODING_PRSNL_ID | ||
RC_F_CASE_MIX | SHR_D_PERSON_ID | ||
RC_F_CASH | SHR_D_ADMIT_PHYSICIAN_ID | ||
RC_F_CASH | SHR_D_ATTEND_PHYSICIAN_ID | ||
RC_F_CASH | SHR_D_CONSULT_PHYSICIAN_ID | ||
RC_F_CASH | SHR_D_ORDER_PHYSICIAN_ID | ||
RC_F_CASH | SHR_D_PERFORM_PHYSICIAN_ID | ||
RC_F_CASH | SHR_D_PERSON_ID | ||
RC_F_CASH | SHR_D_POSTING_PRSNL_ID | ||
RC_F_CASH | SHR_D_REFER_PHYSICIAN_ID | ||
RC_F_CASH | SHR_D_REND_PHYSICIAN_ID | ||
RC_F_CASH | SHR_D_SUPERV_PHYSICIAN_ID | ||
RC_F_CLAIM_EVENT | SHR_D_ADMIT_PRSNL_ID | ||
RC_F_CLAIM_EVENT | SHR_D_PERSON_ID | ||
RC_F_CODING_ACTIVITY | SHR_D_ADMITTING_PRSNL_ID | ||
RC_F_CODING_ACTIVITY | SHR_D_ATTENDING_PRSNL_ID | ||
RC_F_CODING_ACTIVITY | SHR_D_CODING_PRSNL_ID | ||
RC_F_CODING_ACTIVITY | SHR_D_PERSON_ID | ||
RC_F_DAILY_BAL_AR_SMRY | SHR_D_ATTENDING_PHYSICIAN_ID | ||
RC_F_DAILY_CDM_SMRY | SHR_D_ADMIT_PHYSICIAN_ID | ||
RC_F_DAILY_CDM_SMRY | SHR_D_ATTEND_PHYSICIAN_ID | ||
RC_F_DAILY_CDM_SMRY | SHR_D_CONSULT_PHYSICIAN_ID | ||
RC_F_DAILY_CDM_SMRY | SHR_D_ORDER_PHYSICIAN_ID | ||
RC_F_DAILY_CDM_SMRY | SHR_D_PERFORM_PHYSICIAN_ID | ||
RC_F_DAILY_CDM_SMRY | SHR_D_REFER_PHYSICIAN_ID | ||
RC_F_DAILY_CDM_SMRY | SHR_D_REND_PHYSICIAN_ID | ||
RC_F_DAILY_CDM_SMRY | SHR_D_SUPERV_PHYSICIAN_ID | ||
RC_F_DAILY_CENSUS | SHR_D_ATTENDING_PHYSICIAN_ID | ||
RC_F_DAILY_CENSUS | SHR_D_PERSON_ID | ||
RC_F_DAILY_CENSUS_SMRY | SHR_D_ATTENDING_PHYSICIAN_ID | ||
RC_F_DAILY_TRANS_SMRY | SHR_D_ADMIT_PHYSICIAN_ID | ||
RC_F_DAILY_TRANS_SMRY | SHR_D_ATTEND_PHYSICIAN_ID | ||
RC_F_DAILY_TRANS_SMRY | SHR_D_CONSULT_PHYSICIAN_ID | ||
RC_F_DAILY_TRANS_SMRY | SHR_D_ORDER_PHYSICIAN_ID | ||
RC_F_DAILY_TRANS_SMRY | SHR_D_PERFORM_PHYSICIAN_ID | ||
RC_F_DAILY_TRANS_SMRY | SHR_D_REFER_PHYSICIAN_ID | ||
RC_F_DAILY_TRANS_SMRY | SHR_D_REND_PHYSICIAN_ID | ||
RC_F_DAILY_TRANS_SMRY | SHR_D_SUPERV_PHYSICIAN_ID | ||
RC_F_DENIAL | SHR_D_ATTENDING_PHYSICIAN_ID | ||
RC_F_DENIAL | SHR_D_PERSON_ID | ||
RC_F_DENIAL | SHR_D_POSTED_PERSON_ID | ||
RC_F_DLY_CHRG_ASSOC_SMRY | SHR_D_ADMIT_PHYSICIAN_ID | ||
RC_F_DLY_CHRG_ASSOC_SMRY | SHR_D_ATTEND_PHYSICIAN_ID | ||
RC_F_DLY_CHRG_ASSOC_SMRY | SHR_D_CONSULT_PHYSICIAN_ID | ||
RC_F_DLY_CHRG_ASSOC_SMRY | SHR_D_ORDER_PHYSICIAN_ID | ||
RC_F_DLY_CHRG_ASSOC_SMRY | SHR_D_PERFORM_PHYSICIAN_ID | ||
RC_F_DLY_CHRG_ASSOC_SMRY | SHR_D_REFER_PHYSICIAN_ID | ||
RC_F_DLY_CHRG_ASSOC_SMRY | SHR_D_REND_PHYSICIAN_ID | ||
RC_F_DLY_CHRG_ASSOC_SMRY | SHR_D_SUPERV_PHYSICIAN_ID | ||
RC_F_DLY_CODING_ACT_SMRY | SHR_D_CODING_PRSNL_ID | ||
RC_F_GENERAL_AR_BAL_TRANS | SHR_D_POSTING_PRSNL_ID | ||
RC_F_INVOICE_AR_BALANCE | SHR_D_PERSON_ID | ||
RC_F_MONTHLY_CDM_SMRY | SHR_D_ADMIT_PHYSICIAN_ID | ||
RC_F_MONTHLY_CDM_SMRY | SHR_D_ATTEND_PHYSICIAN_ID | ||
RC_F_MONTHLY_CDM_SMRY | SHR_D_CONSULT_PHYSICIAN_ID | ||
RC_F_MONTHLY_CDM_SMRY | SHR_D_ORDER_PHYSICIAN_ID | ||
RC_F_MONTHLY_CDM_SMRY | SHR_D_PERFORM_PHYSICIAN_ID | ||
RC_F_MONTHLY_CDM_SMRY | SHR_D_REFER_PHYSICIAN_ID | ||
RC_F_MONTHLY_CDM_SMRY | SHR_D_REND_PHYSICIAN_ID | ||
RC_F_MONTHLY_CDM_SMRY | SHR_D_SUPERV_PHYSICIAN_ID | ||
RC_F_MONTHLY_CENSUS_SMRY | SHR_D_ATTENDING_PHYSICIAN_ID | ||
RC_F_MONTHLY_TRANS_SMRY | SHR_D_ADMIT_PHYSICIAN_ID | ||
RC_F_MONTHLY_TRANS_SMRY | SHR_D_ATTEND_PHYSICIAN_ID | ||
RC_F_MONTHLY_TRANS_SMRY | SHR_D_ORDER_PHYSICIAN_ID | ||
RC_F_MONTHLY_TRANS_SMRY | SHR_D_PERFORM_PHYSICIAN_ID | ||
RC_F_MONTHLY_TRANS_SMRY | SHR_D_REFER_PHYSICIAN_ID | ||
RC_F_MONTHLY_TRANS_SMRY | SHR_D_REND_PHYSICIAN_ID | ||
RC_F_MONTHLY_TRANS_SMRY | SHR_D_SUPERV_PHYSICIAN_ID | ||
RC_F_MTH_CHRG_ASSOC_SMRY | SHR_D_ADMIT_PHYSICIAN_ID | ||
RC_F_MTH_CHRG_ASSOC_SMRY | SHR_D_ATTEND_PHYSICIAN_ID | ||
RC_F_MTH_CHRG_ASSOC_SMRY | SHR_D_CONSULT_PHYSICIAN_ID | ||
RC_F_MTH_CHRG_ASSOC_SMRY | SHR_D_ORDER_PHYSICIAN_ID | ||
RC_F_MTH_CHRG_ASSOC_SMRY | SHR_D_PERFORM_PHYSICIAN_ID | ||
RC_F_MTH_CHRG_ASSOC_SMRY | SHR_D_REFER_PHYSICIAN_ID | ||
RC_F_MTH_CHRG_ASSOC_SMRY | SHR_D_REND_PHYSICIAN_ID | ||
RC_F_MTH_CHRG_ASSOC_SMRY | SHR_D_SUPERV_PHYSICIAN_ID | ||
RC_F_MTH_CODING_ACT_SMRY | SHR_D_CODING_PRSNL_ID | ||
RC_F_NON_AR_BALANCE_TRANS | SHR_D_POSTING_PRSNL_ID | ||
RC_F_PATIENT_AR_BALANCE | SHR_D_ATTENDING_PHYSICIAN_ID | ||
RC_F_PATIENT_AR_BALANCE | SHR_D_CODING_PERSON_ID | ||
RC_F_PATIENT_AR_BALANCE | SHR_D_PERSON_ID | ||
RC_F_PATIENT_AR_BALANCE | SHR_D_QUEUE_PERSON_ID | ||
RC_F_REVENUE | SHR_D_ADMIT_PHYSICIAN_ID | ||
RC_F_REVENUE | SHR_D_ATTEND_PHYSICIAN_ID | ||
RC_F_REVENUE | SHR_D_CONSULT_PHYSICIAN_ID | ||
RC_F_REVENUE | SHR_D_CREATED_PRSNL_ID | ||
RC_F_REVENUE | SHR_D_ORDER_PHYSICIAN_ID | ||
RC_F_REVENUE | SHR_D_PERFORM_PHYSICIAN_ID | ||
RC_F_REVENUE | SHR_D_PERSON_ID | ||
RC_F_REVENUE | SHR_D_REFER_PHYSICIAN_ID | ||
RC_F_REVENUE | SHR_D_REND_PHYSICIAN_ID | ||
RC_F_REVENUE | SHR_D_SUPERV_PHYSICIAN_ID | ||
RC_F_VARIANCE | SHR_D_ACTION_PERSON_ID | ||
RC_F_VARIANCE | SHR_D_PATIENT_ID | ||
RC_F_VARIANCE | SHR_D_QUEUE_PERSON_ID | ||
RC_F_VARIANCE | SHR_D_REND_PHYSICIAN_ID | ||
RC_F_VAR_CLAIM_SMRY | SHR_D_ACTION_PERSON_ID | ||
RC_F_VAR_CLAIM_SMRY | SHR_D_PATIENT_ID | ||
RC_F_VAR_CLAIM_SMRY | SHR_D_QUEUE_PERSON_ID | ||
RC_F_VAR_LINE_ITEM_SMRY | SHR_D_ACTION_PERSON_ID | ||
RC_F_VAR_LINE_ITEM_SMRY | SHR_D_PATIENT_ID | ||
RC_F_VAR_LINE_ITEM_SMRY | SHR_D_QUEUE_PERSON_ID | ||
SHR_F_ENCOUNTER_VISIT | SHR_D_ATTENDING_PHYSICIAN_ID | ||
SHR_F_ENCOUNTER_VISIT | SHR_D_PERSON_ID | ||
SHR_F_ENCOUNTER_VISIT | SHR_D_VERIFY_PRSNL_ID |