Table Detail Report

RC_D_PATIENT_AGE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Revenue Cycle Dimension Patient Age
Definition: This table contains the possible patient ages in years and months.
Table Type: REFERENCE





Column Detail - RC_D_PATIENT_AGE


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.
AGE_IN_MONTHS DOUBLE N Age of Patient in Months
AGE_IN_YEARS DOUBLE N Age of patient in years.
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 Y The date/time that the first ETL process started that created this record.
LAST_PROCESS_DT_TM DATETIME Y The date/time that the last ETL process started that updated this record.
RC_D_PATIENT_AGE_ID DOUBLE N Uniquely identifies information about a patients age.
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_D_PATIENT_AGE




Parent Column in RC_D_PATIENT_AGE (PK) Child Table Name Child Column Name
Children: RC_D_PATIENT_AGE_ID RC_F_DAILY_CENSUS RC_D_PATIENT_AGE_ID
RC_F_DAILY_CENSUS_SMRY RC_D_PATIENT_AGE_ID
RC_F_MONTHLY_CENSUS_SMRY RC_D_PATIENT_AGE_ID


RC_D_PAYMENT_METHOD



Column Section Relationship Section Top of Page


Table-level Detail

Description: Revenue Cycle Dimension Payment Method
Definition: This table contains payment method informaion such as the payment method.
Table Type: REFERENCE





Column Detail - RC_D_PAYMENT_METHOD


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.
CREDIT_CARD_TYPE VARCHAR(40) Y Identifies the type of credit card (i.e. visa, master card, etc.)
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_CREDIT_CARD_TYPE_CD DOUBLE N Uniquely identifies the Millennium code for the type of credit card (i.e. visa, master card, etc.)
MILL_PAYMENT_METHOD_CD DOUBLE N Uniquely identifies a row on the Millennium database related to this dimension row.
PAYMENT_METHOD VARCHAR(40) N Identifies the method of payment (i.e. Cash, Check and Electronic Fund Transfer, etc.).
RC_D_PAYMENT_METHOD_ID DOUBLE N Uniquely identifies payment method information.
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_D_PAYMENT_METHOD




Parent Column in RC_D_PAYMENT_METHOD (PK) Child Table Name Child Column Name
Children: RC_D_PAYMENT_METHOD_ID RC_F_CASH RC_D_PAYMENT_METHOD_ID
RC_F_DAILY_TRANS_SMRY RC_D_PAYMENT_METHOD_ID
RC_F_MONTHLY_TRANS_SMRY RC_D_PAYMENT_METHOD_ID


RC_D_PHYSICIAN_SPECIALTY



Column Section Relationship Section Top of Page


Table-level Detail

Description: Revenue Cycle Dimension Physician Specialty
Definition: This dimension will store the distinct list of provider specialties.
Table Type: REFERENCE





Column Detail - RC_D_PHYSICIAN_SPECIALTY


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.
MILL_SPECIALTY_CD DOUBLE N The code value for the physician specialty.
RC_D_PHYSICIAN_SPECIALTY_ID DOUBLE N Unique generated number that identifies a single row on the RC_D_PHYSICIAN_SPECIALTY table.
SPECIALTY VARCHAR(40) N This is the display value for the physician specialty code value.
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_D_PHYSICIAN_SPECIALTY




Parent Column in RC_D_PHYSICIAN_SPECIALTY (PK) Child Table Name Child Column Name
Children: RC_D_PHYSICIAN_SPECIALTY_ID RC_F_ADJUSTMENT RC_D_ADMIT_PHYS_SPECIALTY_ID
RC_F_ADJUSTMENT RC_D_ATTEND_PHYS_SPECIALTY_ID
RC_F_ADJUSTMENT RC_D_CONSULT_PHYS_SPECIALTY_ID
RC_F_ADJUSTMENT RC_D_ORDER_PHYS_SPECIALTY_ID
RC_F_ADJUSTMENT RC_D_PERFORM_PHYS_SPECIALTY_ID
RC_F_ADJUSTMENT RC_D_REFER_PHYS_SPECIALTY_ID
RC_F_ADJUSTMENT RC_D_REND_PHYS_SPECIALTY_ID
RC_F_ADJUSTMENT RC_D_SUPERV_PHYS_SPECIALTY_ID
RC_F_BALANCE_AR RC_D_ATTEND_PHYS_SPECIALTY_ID
RC_F_CASE_MIX RC_D_ATTEND_PRSNL_SPECIALTY_ID
RC_F_CASH RC_D_ADMIT_PHYS_SPECIALTY_ID
RC_F_CASH RC_D_ATTEND_PHYS_SPECIALTY_ID
RC_F_CASH RC_D_CONSULT_PHYS_SPECIALTY_ID
RC_F_CASH RC_D_ORDER_PHYS_SPECIALTY_ID
RC_F_CASH RC_D_PERFORM_PHYS_SPECIALTY_ID
RC_F_CASH RC_D_REFER_PHYS_SPECIALTY_ID
RC_F_CASH RC_D_REND_PHYS_SPECIALTY_ID
RC_F_CASH RC_D_SUPERV_PHYS_SPECIALTY_ID
RC_F_CODING_ACTIVITY RC_D_ADMIT_PHYS_SPECIALTY_ID
RC_F_CODING_ACTIVITY RC_D_ATTEND_PHYS_SPECIALTY_ID
RC_F_DAILY_BAL_AR_SMRY RC_D_ATTEND_PHYS_SPECIALTY_ID
RC_F_DAILY_CDM_SMRY RC_D_ADMIT_PHYS_SPECIALTY_ID
RC_F_DAILY_CDM_SMRY RC_D_ATTEND_PHYS_SPECIALTY_ID
RC_F_DAILY_CDM_SMRY RC_D_CONSULT_PHYS_SPECIALTY_ID
RC_F_DAILY_CDM_SMRY RC_D_ORDER_PHYS_SPECIALTY_ID
RC_F_DAILY_CDM_SMRY RC_D_PERFORM_PHYS_SPECIALTY_ID
RC_F_DAILY_CDM_SMRY RC_D_REFER_PHYS_SPECIALTY_ID
RC_F_DAILY_CDM_SMRY RC_D_REND_PHYS_SPECIALTY_ID
RC_F_DAILY_CDM_SMRY RC_D_SUPERV_PHYS_SPECIALTY_ID
RC_F_DAILY_CENSUS RC_D_ATTEND_PHYS_SPECIALTY_ID
RC_F_DAILY_CENSUS_SMRY RC_D_ATTEND_PHYS_SPECIALTY_ID
RC_F_DAILY_TRANS_SMRY RC_D_ADMIT_PHYS_SPECIALTY_ID
RC_F_DAILY_TRANS_SMRY RC_D_ATTEND_PHYS_SPECIALTY_ID
RC_F_DAILY_TRANS_SMRY RC_D_CONSULT_PHYS_SPECIALTY_ID
RC_F_DAILY_TRANS_SMRY RC_D_ORDER_PHYS_SPECIALTY_ID
RC_F_DAILY_TRANS_SMRY RC_D_PERFORM_PHYS_SPECIALTY_ID
RC_F_DAILY_TRANS_SMRY RC_D_REFER_PHYS_SPECIALTY_ID
RC_F_DAILY_TRANS_SMRY RC_D_REND_PHYS_SPECIALTY_ID
RC_F_DAILY_TRANS_SMRY RC_D_SUPERV_PHYS_SPECIALTY_ID
RC_F_DLY_CHRG_ASSOC_SMRY RC_D_ADMIT_PHYS_SPECIALTY_ID
RC_F_DLY_CHRG_ASSOC_SMRY RC_D_ATTEND_PHYS_SPECIALTY_ID
RC_F_DLY_CHRG_ASSOC_SMRY RC_D_CONSULT_PHYS_SPECIALTY_ID
RC_F_DLY_CHRG_ASSOC_SMRY RC_D_ORDER_PHYS_SPECIALTY_ID
RC_F_DLY_CHRG_ASSOC_SMRY RC_D_PERFORM_PHYS_SPECIALTY_ID
RC_F_DLY_CHRG_ASSOC_SMRY RC_D_REFER_PHYS_SPECIALTY_ID
RC_F_DLY_CHRG_ASSOC_SMRY RC_D_REND_PHYS_SPECIALTY_ID
RC_F_DLY_CHRG_ASSOC_SMRY RC_D_SUPERV_PHYS_SPECIALTY_ID
RC_F_MONTHLY_CDM_SMRY RC_D_ADMIT_PHYS_SPECIALTY_ID
RC_F_MONTHLY_CDM_SMRY RC_D_ATTEND_PHYS_SPECIALTY_ID
RC_F_MONTHLY_CDM_SMRY RC_D_CONSULT_PHYS_SPECIALTY_ID
RC_F_MONTHLY_CDM_SMRY RC_D_ORDER_PHYS_SPECIALTY_ID
RC_F_MONTHLY_CDM_SMRY RC_D_PERFORM_PHYS_SPECIALTY_ID
RC_F_MONTHLY_CDM_SMRY RC_D_REFER_PHYS_SPECIALTY_ID
RC_F_MONTHLY_CDM_SMRY RC_D_REND_PHYS_SPECIALTY_ID
RC_F_MONTHLY_CDM_SMRY RC_D_SUPERV_PHYS_SPECIALTY_ID
RC_F_MONTHLY_CENSUS_SMRY RC_D_ATTEND_PHYS_SPECIALTY_ID
RC_F_MONTHLY_TRANS_SMRY RC_D_ADMIT_PHYS_SPECIALTY_ID
RC_F_MONTHLY_TRANS_SMRY RC_D_ATTEND_PHYS_SPECIALTY_ID
RC_F_MONTHLY_TRANS_SMRY RC_D_CONSULT_PHYS_SPECIALTY_ID
RC_F_MONTHLY_TRANS_SMRY RC_D_ORDER_PHYS_SPECIALTY_ID
RC_F_MONTHLY_TRANS_SMRY RC_D_PERFORM_PHYS_SPECIALTY_ID
RC_F_MONTHLY_TRANS_SMRY RC_D_REFER_PHYS_SPECIALTY_ID
RC_F_MONTHLY_TRANS_SMRY RC_D_REND_PHYS_SPECIALTY_ID
RC_F_MONTHLY_TRANS_SMRY RC_D_SUPERV_PHYS_SPECIALTY_ID
RC_F_MTH_CHRG_ASSOC_SMRY RC_D_ADMIT_PHYS_SPECIALTY_ID
RC_F_MTH_CHRG_ASSOC_SMRY RC_D_ATTEND_PHYS_SPECIALTY_ID
RC_F_MTH_CHRG_ASSOC_SMRY RC_D_CONSULT_PHYS_SPECIALTY_ID
RC_F_MTH_CHRG_ASSOC_SMRY RC_D_ORDER_PHYS_SPECIALTY_ID
RC_F_MTH_CHRG_ASSOC_SMRY RC_D_PERFORM_PHYS_SPECIALTY_ID
RC_F_MTH_CHRG_ASSOC_SMRY RC_D_REFER_PHYS_SPECIALTY_ID
RC_F_MTH_CHRG_ASSOC_SMRY RC_D_REND_PHYS_SPECIALTY_ID
RC_F_MTH_CHRG_ASSOC_SMRY RC_D_SUPERV_PHYS_SPECIALTY_ID
RC_F_PATIENT_AR_BALANCE RC_D_ATTEND_PHYS_SPECIALTY_ID
RC_F_REVENUE RC_D_ADMIT_PHYS_SPECIALTY_ID
RC_F_REVENUE RC_D_ATTEND_PHYS_SPECIALTY_ID
RC_F_REVENUE RC_D_CONSULT_PHYS_SPECIALTY_ID
RC_F_REVENUE RC_D_ORDER_PHYS_SPECIALTY_ID
RC_F_REVENUE RC_D_PERFORM_PHYS_SPECIALTY_ID
RC_F_REVENUE RC_D_REFER_PHYS_SPECIALTY_ID
RC_F_REVENUE RC_D_REND_PHYS_SPECIALTY_ID
RC_F_REVENUE RC_D_SUPERV_PHYS_SPECIALTY_ID


RC_D_RACE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Revenue Cycle Dimension Race
Definition: Contains information about the race of a person.
Table Type: REFERENCE





Column Detail - RC_D_RACE


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.
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.
MILL_RACE_CD DOUBLE Y Uniquely identifies the related Race in Millennium from which this data is derived.
RACE_TXT VARCHAR(40) Y Description of the Race
RACE_VALUE DOUBLE Y ** Obsolete ** This column is no longer used. Value uniquely identifying a race type
RC_D_RACE_ID DOUBLE N Uniquely identifies information about the race of the person.
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_D_RACE




Parent Column in RC_D_RACE (PK) Child Table Name Child Column Name
Children: RC_D_RACE_ID RC_D_RACE_BRIDGE RC_D_RACE_ID


RC_D_RACE_BRIDGE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Revenue Cycle Dimenstion Race Bridge
Definition: This table stores the relationship between a Person and Race.
Table Type: ACTIVITY





Column Detail - RC_D_RACE_BRIDGE


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.
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.
RC_D_RACE_BRIDGE_ID DOUBLE N Unique generated number that identifies a single row on the RC_D_RACE_BRIDGE table.
RC_D_RACE_ID DOUBLE N Uniquely identifies information about the race of the person.
SHR_D_PERSON_ID DOUBLE N Uniquely identifies a Person Dimension Row related to this row.
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_D_RACE_BRIDGE


Child Column in RC_D_RACE_BRIDGE(FK) Parent Table Name Parent Column Name
Parents: RC_D_RACE_ID RC_D_RACE RC_D_RACE_ID
SHR_D_PERSON_ID SHR_D_PERSON SHR_D_PERSON_ID