Table Detail Report

RC_F_PATIENT_AR_BAL_SMRY



Column Section Relationship Section Top of Page


Table-level Detail

Description: Revenue Cycle Fact Patient AR Balance Summary
Definition: This table contains summarized patient AR balance data.
Table Type: ACTIVITY





Column Detail - RC_F_PATIENT_AR_BAL_SMRY


Column Name Type Null? Definition
ACTIVITY_DT_NBR DOUBLE N A number representing the activity date. References the key in the OMF_DATE table.
FIRST_PROCESS_DT_TM DATETIME N The date/time that the first ETL process started that created this record.
INSURANCE_BALANCE_AMT DOUBLE Y The total balance amount for insurance.
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.
RC_D_AGE_BY_LAST_PAYMENT_ID DOUBLE N Uniquely identifies an age category that represents the difference between the activity date and the last payment made to the encounter balance.
RC_D_BALANCE_TYPE_ID DOUBLE N Uniquely identifies the balance type related to this fact row.
RC_D_BAL_AMT_CATEGORY_ID DOUBLE N Uniquely identifies the amount range category to which the total balance applies.
RC_D_BILLING_ENTITY_ID DOUBLE N Uniquely identifies the billing entity related to this fact row.
RC_D_BILL_AGE_ID DOUBLE N Uniquely identifies an age category that represents the difference between the activity date and the first bill date for the encounter balance.
RC_D_DISCHARGE_AGE_ID DOUBLE N Uniquely identifies the age category to which this fact row is related based on the discharge age.
RC_D_DNFB_STATUS_ID DOUBLE N Uniquely identifies the current status and reason of the DNFB
RC_D_DUNNING_LEVEL_ID DOUBLE N Uniquely identifies the dunning level related to this fact row.
RC_D_ENCNTR_TYPE_CLASS_ID DOUBLE N Uniquely identifies the encounter type class of the encounter.
RC_D_FINANCIAL_CLASS_ID DOUBLE N Uniquely identifies the financial class related to this fact row.
RC_D_MEDICAL_SERVICE_ID DOUBLE N Uniquely identifies medical service information related to this fact row.
RC_D_PRI_HEALTH_PLAN_ID DOUBLE N Uniquely identifies the primary health plan of the financial encounter.
RC_D_RESP_FIN_CLASS_ID DOUBLE N Uniquely identifies the responsible financial class related to this fact row.
RC_D_RESP_HEALTH_PLAN_ID DOUBLE N Uniquely identifies the responsible health plan of the financial encounter.
RC_D_UNBILLED_BAL_AMT_CAT_ID DOUBLE N Uniquely identifies the amount range category to which the total unbilled balance applies.
RC_F_PATIENT_AR_BAL_SMRY_ID DOUBLE N Uniquely identifies summarized patient AR balance data.
SHR_D_LOCATION_ID DOUBLE N Uniquely identifies the location related to this fact row.
SP_BALANCE_AMT DOUBLE N The total balance amount for Selfpay.
TOTAL_BALANCE_AMT DOUBLE N The total balance for the patient AR accounts.
TOTAL_ENCOUNTER_COUNT DOUBLE N The number of encounters rolled up into this fact row.
TOTAL_ENCOUNTER_FINAL_CODED DOUBLE N The total number of encounters that have been final coded within an end day established as a preference.
TOTAL_UNBILLED_BALANCE_AMT DOUBLE N Total balance amount that has not been billed on any claims.
TOTAL_ZERO_BALANCE_CNT DOUBLE N The total number of encounters resolved to a zero dollar balance for the given activity date.
TOT_DSCHRG_FINAL_CODE_DAYS DOUBLE N The total of days between the discharge date and the final coded date.
TOT_ENCNTR_FINAL_CODE_BY_END DOUBLE N The total number of encounters that have been final coded within an end day established as a preference.
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 - RC_F_PATIENT_AR_BAL_SMRY


Child Column in RC_F_PATIENT_AR_BAL_SMRY(FK) Parent Table Name Parent Column Name
Parents: ACTIVITY_DT_NBR OMF_DATE DT_NBR
RC_D_AGE_BY_LAST_PAYMENT_ID RC_D_AGE_CATEGORY RC_D_AGE_CATEGORY_ID
RC_D_BILL_AGE_ID RC_D_AGE_CATEGORY RC_D_AGE_CATEGORY_ID
RC_D_DISCHARGE_AGE_ID RC_D_AGE_CATEGORY RC_D_AGE_CATEGORY_ID
RC_D_BAL_AMT_CATEGORY_ID RC_D_AMOUNT_CATEGORY RC_D_AMOUNT_CATEGORY_ID
RC_D_UNBILLED_BAL_AMT_CAT_ID RC_D_AMOUNT_CATEGORY RC_D_AMOUNT_CATEGORY_ID
RC_D_BALANCE_TYPE_ID RC_D_BALANCE_TYPE RC_D_BALANCE_TYPE_ID
RC_D_BILLING_ENTITY_ID RC_D_BILLING_ENTITY RC_D_BILLING_ENTITY_ID
RC_D_DNFB_STATUS_ID RC_D_DNFB_STATUS RC_D_DNFB_STATUS_ID
RC_D_DUNNING_LEVEL_ID RC_D_DUNNING_LEVEL RC_D_DUNNING_LEVEL_ID
RC_D_ENCNTR_TYPE_CLASS_ID RC_D_ENCNTR_TYPE_CLASS RC_D_ENCNTR_TYPE_CLASS_ID
RC_D_FINANCIAL_CLASS_ID RC_D_FINANCIAL_CLASS RC_D_FINANCIAL_CLASS_ID
RC_D_RESP_FIN_CLASS_ID RC_D_FINANCIAL_CLASS RC_D_FINANCIAL_CLASS_ID
RC_D_PRI_HEALTH_PLAN_ID RC_D_HEALTH_PLAN RC_D_HEALTH_PLAN_ID
RC_D_RESP_HEALTH_PLAN_ID RC_D_HEALTH_PLAN RC_D_HEALTH_PLAN_ID
RC_D_MEDICAL_SERVICE_ID RC_D_MEDICAL_SERVICE RC_D_MEDICAL_SERVICE_ID
SHR_D_LOCATION_ID SHR_D_LOCATION SHR_D_LOCATION_ID


RC_F_REVENUE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Revenue Cycle Fact Revenue
Definition: This table contains data related to revenue.
Table Type: ACTIVITY





Column Detail - RC_F_REVENUE


Column Name Type Null? Definition
ACTIVITY_DT_NBR DOUBLE N A number representing the activity date. References the key in the OMF_DATE table.
ADMIT_DT_NBR DOUBLE N A number representing the admit date. References the key in the OMF_DATE table.
CDM_FULL_IMPL_FAC_RVU_NBR DOUBLE Y This field contains the CDM fully implemented facility relative value units associated to a charge.
CDM_FULL_IMPL_NON_FAC_RVU_NBR DOUBLE Y This field contains the CDM fully implemented non-facility relative value units associated to a charge.
CDM_MALPRACTICE_RVU_NBR DOUBLE Y This field contains the CDM malpractice relative value units associated to a charge.
CDM_RVU_NBR DOUBLE Y This field contains the CDM relative value units associated to a charge.
DISCHARGE_DT_NBR DOUBLE N A number representing the discharge date. References the key in the OMF_DATE table.
FEDERAL_TAX_ID_NBR VARCHAR(100) Y An identifying federal tax number.
FIRST_PROCESS_DT_TM DATETIME N The date/time that the first ETL process started that created this record.
FULL_IMPL_FAC_RVU_NBR DOUBLE Y This field contains the fully implemented facility relative value units associated to a charge.
FULL_IMPL_NONFAC_RVU_NBR DOUBLE Y This field contains the fully implemented non-facility relative value units associated to a charge.
GL_ACTIVITY_DT_NBR DOUBLE N Contains the GL_ACTIVITY_DT_TM value from GL_TRANS_LOG table.
GL_CREATED_DT_NBR DOUBLE N Contains the GL_CREATED_DT_TM number from the GL_TRANS_LOG table.
GL_IMPACT_DT_NBR DOUBLE N Contains the GL_IMPACT_DT_TM value from GL_TRANS_LOG table.
GL_INTERFACE_DT_NBR DOUBLE N A number representing the GL Interface Date. References the key in the OMF_DATE table.
HCPCS_FULL_IMPL_FAC_RVU_NBR DOUBLE Y This field containes the HCPCS fully implemented facility relative value units associated to a charge.
HCPCS_FULL_IMPL_NONFAC_RVU_NBR DOUBLE Y This field contains the HCPCS fully implemented non-facility relative value units associated to a charge.
HCPCS_MALPRACTICE_RVU_NBR DOUBLE Y This field contains the HCPCS malpractice relative value units associated to a charge.
HCPCS_RVU_NBR DOUBLE Y This field contains the HCPCS work relative value units associated to a charge.
LAST_PROCESS_DT_TM DATETIME N The date/time that the last ETL process started that updated this record.
MALPRACTICE_RVU_NBR DOUBLE Y This field contains the malpractice relative value units associated to a charge.
MILL_GL_TRANS_LOG_ID DOUBLE N Uniquely identifies the row on the GL_TRANS_LOG on which this ID originated.
MILL_LOGICAL_DOMAIN_ID DOUBLE N Uniquely identifies the logical domain to which the row data belongs.
MILL_PFT_CHARGE_ID DOUBLE N Identifies the Millennium record from which the data on this row was derived.
PLACE_OF_SERVICE_DESC VARCHAR(100) Y Description of the place of service.
RC_AF_PATIENT_AR_BALANCE_ID DOUBLE N Uniquely identifies data related to the RC_F_Revenue table.
RC_D_ACCOMMODATION_ID DOUBLE N Uniquely identifies accommodation information related to this fact row.
RC_D_ACCOUNT_ID DOUBLE N Uniquely identifies account information related to this fact.
RC_D_ACCOUNT_TYPE_ID DOUBLE N Unique genereated number that identifies the row on the rc_d_account_type table related to this fact.
RC_D_ADMIT_PHYS_SPECIALTY_ID DOUBLE N This is a foreign key that identifies the specialty assigned to the admitting physician in a given location in the fact table.
RC_D_AR_GL_ALIAS_ID DOUBLE N Uniquely identifies gl alias information such as company name and account name for the records with an account type of AR.
RC_D_ATTEND_PHYS_SPECIALTY_ID DOUBLE N This is a foreign key that identifies the specialty assigned to the attending physician in a given location in the fact table.
RC_D_BILLING_ENTITY_ID DOUBLE N Uniquely identifies the billing entity related to this fact row.
RC_D_BILL_ITEM_ID DOUBLE N Uniquely identifies the bill item related to this fact row.
RC_D_CONSULT_PHYS_SPECIALTY_ID DOUBLE N This is a foreign key that identifies the specialty assigned to the consulting physician in a given location in the fact table.
RC_D_CPT_MODIFIER_ID DOUBLE N Uniquely identifies the related CPT Modifier
RC_D_ENCNTR_TYPE_CLASS_ID DOUBLE N Uniquely identifies encounter type class information related to this fact row.
RC_D_FINANCIAL_CLASS_ID DOUBLE N Uniquely identifies the financial class related to this fact row.
RC_D_GL_ALIAS_ID DOUBLE N Uniquely identifies the GL Alias related to this fact row.
RC_D_HCPCS_MODIFIER_ID DOUBLE N Uniquely identifies the related HCPCS Modifier.
RC_D_HEALTH_PLAN_ID DOUBLE N Uniquely identifies the health plan related to this fact row.
RC_D_MEDICAL_SERVICE_ID DOUBLE N Uniquely identifies medical service information related to this fact row.
RC_D_ORDER_PHYS_SPECIALTY_ID DOUBLE N This is a foreign key that identifies the specialty assigned to the ordering physician in a given location in the fact table.
RC_D_PERFORM_PHYS_SPECIALTY_ID DOUBLE N This is a foreign key that identifies the specialty assigned to the performing physician in a given location in the fact table.
RC_D_REFER_PHYS_SPECIALTY_ID DOUBLE N This is a foreign key that identifies the specialty assigned to the refering physician in a given location in the fact table.
RC_D_REND_PHYS_SPECIALTY_ID DOUBLE N This is a foreign key that identifies the specialty assigned to the rendering physician in a given location in the fact table.
RC_D_SUPERV_PHYS_SPECIALTY_ID DOUBLE N This is a foreign key that identifies the specialty assigned to the supervising physician in a given location in the fact table.
RC_D_TIER_GROUP_ID DOUBLE N Uniquely identifies the tier group related to the charge.
RC_D_TRANSACTION_ALIAS_ID DOUBLE N Uniquely identifies the transaction alias information related to this fact row.
RC_D_TRANSACTION_TYPE_ID DOUBLE N Uniquely identifies a Transaction Type Dimension row realted to this fact row
RC_F_REVENUE_ID DOUBLE N Uniquely identifies data related to revenue.
RELATIVE_VALUE_UNITS_QTY DOUBLE N Contains the workload units associated to a charge.
SERVICE_DT_NBR DOUBLE N A number representing the service date. References the key in the OMF_DATE table.
SERVICE_FACILITY_NAME VARCHAR(100) Y Contains the name of the service facility
SHR_D_ADMIT_PHYSICIAN_ID DOUBLE N Represents the person who was the admitting physician for the related fact row.
SHR_D_ATTEND_PHYSICIAN_ID DOUBLE N Uniquely identifies attending physician information related to this fact row.
SHR_D_CONSULT_PHYSICIAN_ID DOUBLE N Represents the person who was the consulting physician for the related fact row.
SHR_D_CREATED_PRSNL_ID DOUBLE N Uniquely identifier the person related to this fact row who created this information.
SHR_D_ORDER_PHYSICIAN_ID DOUBLE N Uniquely identifies ordering physician information related to this fact row.
SHR_D_PATIENT_LOCATION_ID DOUBLE N Uniquely identifies the location of the patient.
SHR_D_PERFORMING_LOCATION_ID DOUBLE N Contains a number to identify the performing location.
SHR_D_PERFORM_PHYSICIAN_ID DOUBLE N Uniquely identifies performing physician information related to this fact row.
SHR_D_PERSON_ID DOUBLE N Uniquely identifies person information related to this fact row.
SHR_D_REFER_PHYSICIAN_ID DOUBLE N Uniquely identifies referring physician information related to this fact row.
SHR_D_REND_PHYSICIAN_ID DOUBLE N Uniquely identifies a row on the shared person dimension table that represents the person who was the rendering/primary physician about the related fact row.
SHR_D_SUPERV_PHYSICIAN_ID DOUBLE N Uniquely identifies supervising physician information related to this fact row.
TIME_ZONE_INDEX DOUBLE N Stores the time zone from which the data was extracted.
TOTAL_CHARGE_AMT DOUBLE N The total of the charges.
TOTAL_QTY DOUBLE N The total quantity.
UNIT_PRICE_AMT DOUBLE N Unit price for the charge.
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 - RC_F_REVENUE


Child Column in RC_F_REVENUE(FK) Parent Table Name Parent Column Name
Parents: ACTIVITY_DT_NBR OMF_DATE DT_NBR
ADMIT_DT_NBR OMF_DATE DT_NBR
DISCHARGE_DT_NBR OMF_DATE DT_NBR
GL_ACTIVITY_DT_NBR OMF_DATE DT_NBR
GL_CREATED_DT_NBR OMF_DATE DT_NBR
GL_IMPACT_DT_NBR OMF_DATE DT_NBR
GL_INTERFACE_DT_NBR OMF_DATE DT_NBR
SERVICE_DT_NBR OMF_DATE DT_NBR
RC_AF_PATIENT_AR_BALANCE_ID RC_AF_PATIENT_AR_BALANCE RC_AF_PATIENT_AR_BALANCE_ID
RC_D_ACCOMMODATION_ID RC_D_ACCOMMODATION RC_D_ACCOMMODATION_ID
RC_D_ACCOUNT_ID RC_D_ACCOUNT RC_D_ACCOUNT_ID
RC_D_ACCOUNT_TYPE_ID RC_D_ACCOUNT_TYPE RC_D_ACCOUNT_TYPE_ID
RC_D_BILLING_ENTITY_ID RC_D_BILLING_ENTITY RC_D_BILLING_ENTITY_ID
RC_D_BILL_ITEM_ID RC_D_BILL_ITEM RC_D_BILL_ITEM_ID
RC_D_CPT_MODIFIER_ID RC_D_BILL_ITEM_MODIFIER RC_D_BILL_ITEM_MODIFIER_ID
RC_D_HCPCS_MODIFIER_ID RC_D_BILL_ITEM_MODIFIER RC_D_BILL_ITEM_MODIFIER_ID
RC_D_ENCNTR_TYPE_CLASS_ID RC_D_ENCNTR_TYPE_CLASS RC_D_ENCNTR_TYPE_CLASS_ID
RC_D_FINANCIAL_CLASS_ID RC_D_FINANCIAL_CLASS RC_D_FINANCIAL_CLASS_ID
RC_D_AR_GL_ALIAS_ID RC_D_GL_ALIAS RC_D_GL_ALIAS_ID
RC_D_GL_ALIAS_ID RC_D_GL_ALIAS RC_D_GL_ALIAS_ID
RC_D_HEALTH_PLAN_ID RC_D_HEALTH_PLAN RC_D_HEALTH_PLAN_ID
RC_D_MEDICAL_SERVICE_ID RC_D_MEDICAL_SERVICE RC_D_MEDICAL_SERVICE_ID
RC_D_ADMIT_PHYS_SPECIALTY_ID RC_D_PHYSICIAN_SPECIALTY RC_D_PHYSICIAN_SPECIALTY_ID
RC_D_ATTEND_PHYS_SPECIALTY_ID RC_D_PHYSICIAN_SPECIALTY RC_D_PHYSICIAN_SPECIALTY_ID
RC_D_CONSULT_PHYS_SPECIALTY_ID RC_D_PHYSICIAN_SPECIALTY RC_D_PHYSICIAN_SPECIALTY_ID
RC_D_ORDER_PHYS_SPECIALTY_ID RC_D_PHYSICIAN_SPECIALTY RC_D_PHYSICIAN_SPECIALTY_ID
RC_D_PERFORM_PHYS_SPECIALTY_ID RC_D_PHYSICIAN_SPECIALTY RC_D_PHYSICIAN_SPECIALTY_ID
RC_D_REFER_PHYS_SPECIALTY_ID RC_D_PHYSICIAN_SPECIALTY RC_D_PHYSICIAN_SPECIALTY_ID
RC_D_REND_PHYS_SPECIALTY_ID RC_D_PHYSICIAN_SPECIALTY RC_D_PHYSICIAN_SPECIALTY_ID
RC_D_SUPERV_PHYS_SPECIALTY_ID RC_D_PHYSICIAN_SPECIALTY RC_D_PHYSICIAN_SPECIALTY_ID
RC_D_TIER_GROUP_ID RC_D_TIER_GROUP RC_D_TIER_GROUP_ID
RC_D_TRANSACTION_ALIAS_ID RC_D_TRANSACTION_ALIAS RC_D_TRANSACTION_ALIAS_ID
RC_D_TRANSACTION_TYPE_ID RC_D_TRANSACTION_TYPE RC_D_TRANSACTION_TYPE_ID
SHR_D_PATIENT_LOCATION_ID SHR_D_LOCATION SHR_D_LOCATION_ID
SHR_D_PERFORMING_LOCATION_ID SHR_D_LOCATION SHR_D_LOCATION_ID
SHR_D_ADMIT_PHYSICIAN_ID SHR_D_PERSON SHR_D_PERSON_ID
SHR_D_ATTEND_PHYSICIAN_ID SHR_D_PERSON SHR_D_PERSON_ID
SHR_D_CONSULT_PHYSICIAN_ID SHR_D_PERSON SHR_D_PERSON_ID
SHR_D_CREATED_PRSNL_ID SHR_D_PERSON SHR_D_PERSON_ID
SHR_D_ORDER_PHYSICIAN_ID SHR_D_PERSON SHR_D_PERSON_ID
SHR_D_PERFORM_PHYSICIAN_ID SHR_D_PERSON SHR_D_PERSON_ID
SHR_D_PERSON_ID SHR_D_PERSON SHR_D_PERSON_ID
SHR_D_REFER_PHYSICIAN_ID SHR_D_PERSON SHR_D_PERSON_ID
SHR_D_REND_PHYSICIAN_ID SHR_D_PERSON SHR_D_PERSON_ID
SHR_D_SUPERV_PHYSICIAN_ID SHR_D_PERSON SHR_D_PERSON_ID


RC_F_VARIANCE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Revenue Cycle Fact Variance
Definition: Contains the detail data associated to variance for reporting purposes.
Table Type: ACTIVITY





Column Detail - RC_F_VARIANCE


Column Name Type Null? Definition
ACTIVITY_DT_NBR DOUBLE N A number representing the activity date. References the key in the OMF_DATE table.
ACTIVITY_DT_TM DATETIME N Date and time of the charge.
ACTUAL_REIMBURSEMENT_AMT DOUBLE N The actual amount of the reimbursement.
ADJUSTED_VARIANCE_AMT DOUBLE N Contains the adjusted original variance dollar amount that has been identified for this fact row.
ADJUSTED_VARIANCE_DT_NBR DOUBLE N A number representing the adjusted original variance identified date for this fact row. References the key in the omf_date table.
ADMIT_DT_NBR DOUBLE N A number representing the admit date. References the key in the OMF_DATE table.
APPEAL_IND DOUBLE N An indicator that will be set to true only for the queue item ids that represent an appeal.
BILLED_AMT DOUBLE N The amount billed
CLAIM_NBR_IDENT VARCHAR(50) Y The claim number related to this fact row.
CLAIM_SERVICE_ITEM_IDENT VARCHAR(50) Y The claim service item related to this fact row.
CLAIM_TRANSMIT_DT_NBR DOUBLE N A number representing the claim transmission date. References the key in the OMF_DATE table.
CPT VARCHAR(200) Y This will store the CPT information.
CURRENT_VARIANCE_AMT DOUBLE N Contains the current variance dollar amount that has been identified for this fact row.
DISCHARGE_DT_NBR DOUBLE N A number representing the discharge date. References the key in the OMF_DATE table.
EST_CONTRACTUAL_AMT DOUBLE N Contains the estimated contractual dollar amount on the claim.
EST_REIMBURSEMENT_AMT DOUBLE N Contains the estimated reimbursement dollar amount on the claim.
FIN_NBR_IDENT VARCHAR(50) Y identifier of a financial number.
LAST_PAYMENT_AMT DOUBLE N The last payment amount on the ProFit encounter.
LAST_PAYMENT_DT_NBR DOUBLE N Date of the last time a payment was made to the financial encounter. Related to the OMF_DATE table.
LAST_VAR_ACTIVITY_DT_NBR DOUBLE N Stores the equivalent date number for the last date/time that the variance activity occurred.
LAST_VAR_ACTIVITY_DT_TM DATETIME N Stores the data and time of the last variance activity.
MILL_CORSP_ID DOUBLE N Uniquely identifies a row in the BILL_REC table on the Millennium data base from which this data was derived.
MILL_LOGICAL_DOMAIN_ID DOUBLE N Uniquely identifies the related logical domain record.
MILL_PFT_QUEUE_ITEM_ID DOUBLE N Identifies the millennium related queue item for which the history data on the ID was derived.
MILL_PFT_QUEUE_ITEM_WF_HIST_ID DOUBLE N Identifies the millennium related workflow history for which the history data on the ID was derived.
MRN_NBR_IDENT VARCHAR(50) Y Identifier of a medical record number.
ORIGINAL_VARIANCE_AMT DOUBLE N Contains the first variance dollar amount that has been identified for this fact row.
ORIG_VARIANCE_DT_NBR DOUBLE N A number representing the first variance identified date for this fact row. References the key in the omf_date table.
PATIENT_RESPONSIBILITY_AMT DOUBLE N Contains the patient responsibility dollar amount on the claim.
RC_D_BILLING_ENTITY_ID DOUBLE N Uniquely identifies the billing entity related to this fact row.
RC_D_BILL_PROPERTY_ID DOUBLE N Uniquely identifies data associated to claim attributes for reporting purposes.
RC_D_BILL_TYPE_ID DOUBLE N Uniquely identifies the bill type related to this fact row.
RC_D_DENIAL_ALIAS_ID DOUBLE N Uniquely identifies the related RC_D_DENIAL_ALIAS row.
RC_D_ENCNTR_TYPE_CLASS_ID DOUBLE N Uniquely identifies data related to the clinical encounter type and class.
RC_D_FINANCIAL_CLASS_ID DOUBLE N Uniquely identifies the financial class related to this fact row.
RC_D_HEALTH_PLAN_ID DOUBLE N Uniquely identifies the health plan related to this fact row.
RC_D_VARIANCE_ACTION_ID DOUBLE N Uniquely identifies data associated to variance attributes for Reporting purposes.
RC_D_VARIANCE_ORIGIN_ID DOUBLE N Uniquely identifies the related RC_D_VARIANCE_ORIGIN row.
RC_D_VARIANCE_PROPERTY_ID DOUBLE N Uniquely identifies data associated to variance attributes for reporting purposes.
RC_F_VARIANCE_ID DOUBLE N Uniquely identifies data associated to a variance for reporting purposes.
RECOVERY_AMT DOUBLE N Contains the recovery dollar amount on the claim.
SELF_PAY_BALANCE_AMT DOUBLE N Contains the last self pay balance dollar amount for this fact row.
SELF_PAY_PAYMENT_AMT DOUBLE N Contains the selfpay payment dollar amount on the claim.
SHR_D_ACTION_PERSON_ID DOUBLE N Uniquely identifies the person related to this fact row.
SHR_D_PATIENT_ID DOUBLE N Uniquely identifies the patient related to this fact row.
SHR_D_PATIENT_LOCATION_ID DOUBLE N Uniquely identifies the location of the patient.
SHR_D_QUEUE_PERSON_ID DOUBLE N Uniquely identifies the person to whom the responsible financial encounter balance is assigned in a workflow.
SHR_D_REND_PHYSICIAN_ID DOUBLE N This will store the related rendering physician ID from the shr_d_person table. Will be used to obtain the rendering physician name.
TIME_ZONE_INDEX DOUBLE N Stores the time zone from which the data was extracted.
TOTAL_ADJUSTMENT_AMT DOUBLE N Contains the total of the adjustments of this balance fact row.
TOTAL_PAYMENT_AMT DOUBLE N Contains the total payment dollar amount for this claim.
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.
VARIANCE_SEQUENCE DOUBLE N A sequence number that uniquely identifies the sequence on actions on a particular variance.



Relationship Detail - RC_F_VARIANCE


Child Column in RC_F_VARIANCE(FK) Parent Table Name Parent Column Name
Parents: ACTIVITY_DT_NBR OMF_DATE DT_NBR
ADJUSTED_VARIANCE_DT_NBR OMF_DATE DT_NBR
ADMIT_DT_NBR OMF_DATE DT_NBR
CLAIM_TRANSMIT_DT_NBR OMF_DATE DT_NBR
DISCHARGE_DT_NBR OMF_DATE DT_NBR
LAST_PAYMENT_DT_NBR OMF_DATE DT_NBR
LAST_VAR_ACTIVITY_DT_NBR OMF_DATE DT_NBR
ORIG_VARIANCE_DT_NBR OMF_DATE DT_NBR
RC_D_BILLING_ENTITY_ID RC_D_BILLING_ENTITY RC_D_BILLING_ENTITY_ID
RC_D_BILL_PROPERTY_ID RC_D_BILL_PROPERTY RC_D_BILL_PROPERTY_ID
RC_D_BILL_TYPE_ID RC_D_BILL_TYPE RC_D_BILL_TYPE_ID
RC_D_DENIAL_ALIAS_ID RC_D_DENIAL_ALIAS RC_D_DENIAL_ALIAS_ID
RC_D_ENCNTR_TYPE_CLASS_ID RC_D_ENCNTR_TYPE_CLASS RC_D_ENCNTR_TYPE_CLASS_ID
RC_D_FINANCIAL_CLASS_ID RC_D_FINANCIAL_CLASS RC_D_FINANCIAL_CLASS_ID
RC_D_HEALTH_PLAN_ID RC_D_HEALTH_PLAN RC_D_HEALTH_PLAN_ID
RC_D_VARIANCE_ACTION_ID RC_D_VARIANCE_ACTION RC_D_VARIANCE_ACTION_ID
RC_D_VARIANCE_ORIGIN_ID RC_D_VARIANCE_ORIGIN RC_D_VARIANCE_ORIGIN_ID
RC_D_VARIANCE_PROPERTY_ID RC_D_VARIANCE_PROPERTY RC_D_VARIANCE_PROPERTY_ID
SHR_D_PATIENT_LOCATION_ID SHR_D_LOCATION SHR_D_LOCATION_ID
SHR_D_ACTION_PERSON_ID SHR_D_PERSON SHR_D_PERSON_ID
SHR_D_PATIENT_ID SHR_D_PERSON SHR_D_PERSON_ID
SHR_D_QUEUE_PERSON_ID SHR_D_PERSON SHR_D_PERSON_ID
SHR_D_REND_PHYSICIAN_ID SHR_D_PERSON SHR_D_PERSON_ID


RC_F_VAR_CLAIM_SMRY



Column Section Relationship Section Top of Page


Table-level Detail

Description: Revenue Cycle Fact Variance Claim Summary
Definition: Contains the detail data associated to variance for reporting purposes.
Table Type: ACTIVITY





Column Detail - RC_F_VAR_CLAIM_SMRY


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.
ACTIVITY_DT_NBR DOUBLE N A number representing the activity date. References the key in the OMF_DATE table.
ADJUSTED_VARIANCE_AMT DOUBLE N Contains the adjusted original variance dollar amount that has been identified for this fact row.
ADJUSTED_VARIANCE_DT_NBR DOUBLE N A number representing the adjusted original variance identified date for this fact row. References the key in the omf_date table.
ADMIT_DT_NBR DOUBLE N A number representing the admit date. References the key in the OMF_DATE table.
APPEAL_CNT DOUBLE N Identifies the total number of appeals related to a specific claim.
BILLED_AMT DOUBLE N Contains the dollar amount billed on the claim.
CLAIM_NBR_IDENT VARCHAR(40) Y The claim number related to this fact row.
CURRENT_VARIANCE_AMT DOUBLE N Contains the current variance dollar amount that has been identified for this fact row.
DISCHARGE_DT_NBR DOUBLE N A number representing the discharge date. References the key in the omf_date table.
EST_CONTRACTUAL_AMT DOUBLE N Contains the estimated contractual dollar amount on the claim.
EST_REIMBURSEMENT_AMT DOUBLE N Contains the estimated reimbursement dollar amount on the claim.
FIN_NBR_IDENT VARCHAR(50) Y Contains the financial number alias related to the patient encounter.
FIRST_PROCESS_DT_TM DATETIME N The date/time that the first ETL process started that created this record.
LAST_APPEAL_DT_NBR DOUBLE N A number representing the appeal action code date for this fact row. References the key in the omf_date table.
LAST_PROCESS_DT_TM DATETIME N The date/time that the last ETL process started that updated this record.
LAST_VAR_ACTIVITY_DT_NBR DOUBLE N Stores the equivalent date number for the last date/time that the variance activity occurred.
MILL_CORSP_ID DOUBLE N Number that identifies the row in the Bill_Rec Millennium database table from which this row was derived.
MILL_PFT_QUEUE_ITEM_ID DOUBLE N Identifies the millennium related queue item for which the history data on the ID was derived.
MRN_NBR_IDENT VARCHAR(50) Y Identifier of a medical record number.
ORIGINAL_VARIANCE_AMT DOUBLE N Contains the first variance dollar amount that has been identified for this fact row.
ORIG_VARIANCE_DT_NBR DOUBLE N A number representing the first variance identified date for this fact row. References the key in the omf_date table.
PATIENT_RESPONSIBILITY_AMT DOUBLE N Contains the patient responsibility dollar amount on the claim.
RC_D_BILLING_ENTITY_ID DOUBLE N Uniquely identifies the billing entity related to this fact row.
RC_D_BILL_PROPERTY_ID DOUBLE N Uniquely identifies information about the billing property related to this fact row.
RC_D_BILL_TYPE_ID DOUBLE N Uniquely identifies the bill type related to this fact row.
RC_D_DENIAL_ALIAS_ID DOUBLE N Uniquely identifies the denial alias dimension row that is related to this fact row.
RC_D_ENCNTR_TYPE_CLASS_ID DOUBLE N Uniquely identifies the encounter type class information related to this fact row.
RC_D_FINANCIAL_CLASS_ID DOUBLE N Uniquely identifies information about the primary financial class related to this fact row.
RC_D_HEALTH_PLAN_ID DOUBLE N Uniquely identifies the health plan related to this fact row.
RC_D_VARIANCE_ACTION_ID DOUBLE N Uniquely identifies information about the variance attributes related to this fact row.
RC_D_VARIANCE_ORIGIN_ID DOUBLE N Uniquely identifies the related RC_D_VARIANCE_ORIGIN row.
RC_D_VARIANCE_PROPERTY_ID DOUBLE N Uniquely identifies information about the variance attributes related to this fact row.
RC_F_VAR_CLAIM_SMRY_ID DOUBLE N Uniquely identifies detail data associated to variance for reporting purposes.
RECOVERY_AMT DOUBLE N Contains the recovery dollar amount on the claim.
SELF_PAY_BALANCE_AMT DOUBLE N Contains the last self pay balance dollar amount for this fact row.
SHR_D_ACTION_PERSON_ID DOUBLE N Uniquely identifies the person related to this fact row.
SHR_D_PATIENT_ID DOUBLE N Uniquely identifies the patient related to this fact row.
SHR_D_PATIENT_LOCATION_ID DOUBLE N Uniquely identifies the location of the patient.
SHR_D_QUEUE_PERSON_ID DOUBLE N Uniquely identifies the person to whom the responsible financial encounter balance is assigned in a workflow.
TOTAL_ADJUSTMENT_AMT DOUBLE N Contains the total adjustment dollar amount for this claim.
TOTAL_PAYMENT_AMT DOUBLE N Contains the total payment dollar amount for this claim.
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 - RC_F_VAR_CLAIM_SMRY


Child Column in RC_F_VAR_CLAIM_SMRY(FK) Parent Table Name Parent Column Name
Parents: ACTIVITY_DT_NBR OMF_DATE DT_NBR
ADJUSTED_VARIANCE_DT_NBR OMF_DATE DT_NBR
ADMIT_DT_NBR OMF_DATE DT_NBR
DISCHARGE_DT_NBR OMF_DATE DT_NBR
LAST_APPEAL_DT_NBR OMF_DATE DT_NBR
LAST_VAR_ACTIVITY_DT_NBR OMF_DATE DT_NBR
ORIG_VARIANCE_DT_NBR OMF_DATE DT_NBR
RC_D_BILLING_ENTITY_ID RC_D_BILLING_ENTITY RC_D_BILLING_ENTITY_ID
RC_D_BILL_PROPERTY_ID RC_D_BILL_PROPERTY RC_D_BILL_PROPERTY_ID
RC_D_BILL_TYPE_ID RC_D_BILL_TYPE RC_D_BILL_TYPE_ID
RC_D_DENIAL_ALIAS_ID RC_D_DENIAL_ALIAS RC_D_DENIAL_ALIAS_ID
RC_D_ENCNTR_TYPE_CLASS_ID RC_D_ENCNTR_TYPE_CLASS RC_D_ENCNTR_TYPE_CLASS_ID
RC_D_FINANCIAL_CLASS_ID RC_D_FINANCIAL_CLASS RC_D_FINANCIAL_CLASS_ID
RC_D_HEALTH_PLAN_ID RC_D_HEALTH_PLAN RC_D_HEALTH_PLAN_ID
RC_D_VARIANCE_ACTION_ID RC_D_VARIANCE_ACTION RC_D_VARIANCE_ACTION_ID
RC_D_VARIANCE_ORIGIN_ID RC_D_VARIANCE_ORIGIN RC_D_VARIANCE_ORIGIN_ID
RC_D_VARIANCE_PROPERTY_ID RC_D_VARIANCE_PROPERTY RC_D_VARIANCE_PROPERTY_ID
SHR_D_PATIENT_LOCATION_ID SHR_D_LOCATION SHR_D_LOCATION_ID
SHR_D_ACTION_PERSON_ID SHR_D_PERSON SHR_D_PERSON_ID
SHR_D_PATIENT_ID SHR_D_PERSON SHR_D_PERSON_ID
SHR_D_QUEUE_PERSON_ID SHR_D_PERSON SHR_D_PERSON_ID


RC_F_VAR_LINE_ITEM_SMRY



Column Section Relationship Section Top of Page


Table-level Detail

Description: Revenue Cycle Fact Variance Line Item Summary
Definition: Contains the detail data associated to variance for reporting purposes.
Table Type: ACTIVITY





Column Detail - RC_F_VAR_LINE_ITEM_SMRY


Column Name Type Null? Definition
ACTIVITY_DT_NBR DOUBLE N A number representing the activity date. References the key in the OMF_DATE table.
ADJUSTED_VARIANCE_AMT DOUBLE N Contains the adjusted original variance dollar amount that has been identified for this fact row.
ADJUSTED_VARIANCE_DT_NBR DOUBLE N A number representing the adjusted original variance identified date for this fact row. References the key in the omf_date table.
ADMIT_DT_NBR DOUBLE N A number representing the admit date. References the key in the OMF_DATE table.
APPEAL_CNT DOUBLE N Identifies the total number of appeals related to a specific claim.
CLAIM_BILLED_AMT DOUBLE N Contains the dollar amount billed on the claim.
CLAIM_NBR_IDENT VARCHAR(40) Y The claim number related to this fact row.
CLAIM_SERVICE_ITEM_IDENT VARCHAR(50) N The claim service item related to this fact row.
CURRENT_VARIANCE_AMT DOUBLE N Contains the current variance dollar amount that has been identified for this fact row.
DISCHARGE_DT_NBR DOUBLE N A number representing the discharge date. References the key in the omf_date table.
EST_CONTRACTUAL_AMT DOUBLE N Contains the estimated contractual dollar amount on the claim.
EST_REIMBURSEMENT_AMT DOUBLE N Contains the estimated reimbursement dollar amount on the claim.
FIN_NBR_IDENT VARCHAR(50) Y Contains the financial number alias related to the patient encounter.
FIRST_PROCESS_DT_TM DATETIME N The date/time that the first ETL process started that created this record.
LAST_APPEAL_DT_NBR DOUBLE N A number representing the appeal action code date for this fact row. References the key in the omf_date table.
LAST_PROCESS_DT_TM DATETIME N The date/time that the last ETL process started that updated this record.
LAST_VAR_ACTIVITY_DT_NBR DOUBLE N Stores the equivalent date number for the last date/time that the variance activity occurred.
MILL_CORSP_ID DOUBLE N Identifies the related row in the BILL_REC table in the millennium database from which the data for this table was derived.
MILL_PFT_QUEUE_ITEM_ID DOUBLE N Identifies the millennium related queue item for which the history data on the ID was derived.
MRN_NBR_IDENT VARCHAR(50) Y Identifier of a medical record number.
ORIGINAL_VARIANCE_AMT DOUBLE N Contains the first variance dollar amount that has been identified for this fact row.
ORIG_VARIANCE_DT_NBR DOUBLE N A number representing the first variance identified date for this fact row. References the key in the omf_date table.
PATIENT_RESPONSIBILITY_AMT DOUBLE N Contains the patient responsibility dollar amount on the claim.
RC_D_BILLING_ENTITY_ID DOUBLE N Uniquely identifies the billing entity related to this fact row.
RC_D_BILL_PROPERTY_ID DOUBLE N Uniquely identifies information about the billing property related to this fact row.
RC_D_BILL_TYPE_ID DOUBLE N Uniquely identifies the bill type related to this fact row.
RC_D_DENIAL_ALIAS_ID DOUBLE N Uniquely identifies the denial alias dimension row that is related to this fact row.
RC_D_ENCNTR_TYPE_CLASS_ID DOUBLE N Uniquely identifies the encounter type class information related to this fact row.
RC_D_FINANCIAL_CLASS_ID DOUBLE N Uniquely identifies information about the primary financial class related to this fact row.
RC_D_HEALTH_PLAN_ID DOUBLE N Uniquely identifies the health plan related to this fact row.
RC_D_VARIANCE_ACTION_ID DOUBLE N Uniquely identifies information about the variance attributes related to this fact row.
RC_D_VARIANCE_ORIGIN_ID DOUBLE N Uniquely identifies the related RC_D_VARIANCE_ORIGIN row.
RC_D_VARIANCE_PROPERTY_ID DOUBLE N Uniquely identifies information about the variance attributes related to this fact row.
RC_F_VAR_LINE_ITEM_SMRY_ID DOUBLE N Uniquely identifies detail data associated to variance for reporting purposes.
RECOVERY_AMT DOUBLE N Contains the recovery dollar amount on the claim.
SELF_PAY_BALANCE_AMT DOUBLE N Contains the last self pay balance dollar amount for this fact row.
SHR_D_ACTION_PERSON_ID DOUBLE N Uniquely identifies the person related to this fact row.
SHR_D_PATIENT_ID DOUBLE N Uniquely identifies the patient related to this fact row.
SHR_D_PATIENT_LOCATION_ID DOUBLE N Uniquely identifies the location of the patient.
SHR_D_QUEUE_PERSON_ID DOUBLE N Uniquely identifies the person to whom the responsible financial encounter balance is assigned in a workflow.
TOTAL_ADJUSTMENT_AMT DOUBLE N Contains the total adjustment dollar amount for this claim.
TOTAL_PAYMENT_AMT DOUBLE N Contains the total payment dollar amount for this claim.
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 - RC_F_VAR_LINE_ITEM_SMRY


Child Column in RC_F_VAR_LINE_ITEM_SMRY(FK) Parent Table Name Parent Column Name
Parents: ACTIVITY_DT_NBR OMF_DATE DT_NBR
ADJUSTED_VARIANCE_DT_NBR OMF_DATE DT_NBR
ADMIT_DT_NBR OMF_DATE DT_NBR
DISCHARGE_DT_NBR OMF_DATE DT_NBR
LAST_APPEAL_DT_NBR OMF_DATE DT_NBR
LAST_VAR_ACTIVITY_DT_NBR OMF_DATE DT_NBR
ORIG_VARIANCE_DT_NBR OMF_DATE DT_NBR
RC_D_BILLING_ENTITY_ID RC_D_BILLING_ENTITY RC_D_BILLING_ENTITY_ID
RC_D_BILL_PROPERTY_ID RC_D_BILL_PROPERTY RC_D_BILL_PROPERTY_ID
RC_D_BILL_TYPE_ID RC_D_BILL_TYPE RC_D_BILL_TYPE_ID
RC_D_DENIAL_ALIAS_ID RC_D_DENIAL_ALIAS RC_D_DENIAL_ALIAS_ID
RC_D_ENCNTR_TYPE_CLASS_ID RC_D_ENCNTR_TYPE_CLASS RC_D_ENCNTR_TYPE_CLASS_ID
RC_D_FINANCIAL_CLASS_ID RC_D_FINANCIAL_CLASS RC_D_FINANCIAL_CLASS_ID
RC_D_HEALTH_PLAN_ID RC_D_HEALTH_PLAN RC_D_HEALTH_PLAN_ID
RC_D_VARIANCE_ACTION_ID RC_D_VARIANCE_ACTION RC_D_VARIANCE_ACTION_ID
RC_D_VARIANCE_ORIGIN_ID RC_D_VARIANCE_ORIGIN RC_D_VARIANCE_ORIGIN_ID
RC_D_VARIANCE_PROPERTY_ID RC_D_VARIANCE_PROPERTY RC_D_VARIANCE_PROPERTY_ID
SHR_D_PATIENT_LOCATION_ID SHR_D_LOCATION SHR_D_LOCATION_ID
SHR_D_ACTION_PERSON_ID SHR_D_PERSON SHR_D_PERSON_ID
SHR_D_PATIENT_ID SHR_D_PERSON SHR_D_PERSON_ID
SHR_D_QUEUE_PERSON_ID SHR_D_PERSON SHR_D_PERSON_ID