Table Detail Report

RC_D_GL_ALIAS



Column Section Relationship Section Top of Page


Table-level Detail

Description: Revenue Cycle Dimension General Ledger Alias
Definition: This table contains GL alias information such as company name and account name.
Table Type: REFERENCE





Column Detail - RC_D_GL_ALIAS


Column Name Type Null? Definition
ACCOUNT_TYPE VARCHAR(40) N Contains a description of the millennium account type code.
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.
GL_ACCOUNT_ALIAS_DESC VARCHAR(255) N The description of the alias for the associated GL account.
GL_ACCOUNT_NAME VARCHAR(100) N The account name associated to a GL alias.
GL_ACCOUNT_UNIT VARCHAR(100) N The account unit associated to a GL alias.
GL_ACCOUNT_UNIT_ALIAS_DESC VARCHAR(255) N The description of the alias for the associated GL account unit.
GL_COMPANY_ALIAS_DESC VARCHAR(255) N The description of the alias for the associated GL company.
GL_COMPANY_NAME VARCHAR(100) N The company name associated to a GL alias.
GL_COMPANY_UNIT VARCHAR(100) N The company unit associated to a GL alias.
GL_COMPANY_UNIT_ALIAS_DESC VARCHAR(255) N The description of the alias for the associated GL company unit.
LAST_PROCESS_DT_TM DATETIME N The date/time that the last ETL process started that updated this record.
MILL_ACCOUNT_ALIAS_ID DOUBLE N Identifies the millennium record from which the account alias was derived.
MILL_ACCOUNT_TYPE_CD DOUBLE N Contains the code value indicating the type of account.
MILL_ACCOUNT_UNIT_ALIAS_ID DOUBLE N Identifies the millennium record from which the account unit alias was derived.
MILL_COMPANY_ALIAS_ID DOUBLE N Identifies the millennium record from which the company alias was derived.
MILL_COMPANY_UNIT_ALIAS_ID DOUBLE N Identifies the millennium record from which the company unit alias was derived.
MILL_LOGICAL_DOMAIN_ID DOUBLE N Uniquely identifies the logical domain to which the row data belongs.
RC_D_GL_ALIAS_ID DOUBLE N Uniquely identifies GL alias information such as company name and account 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 - RC_D_GL_ALIAS




Parent Column in RC_D_GL_ALIAS (PK) Child Table Name Child Column Name
Children: RC_D_GL_ALIAS_ID RC_F_ADJUSTMENT RC_D_AR_GL_ALIAS_ID
RC_F_ADJUSTMENT RC_D_GL_ALIAS_ID
RC_F_CASH RC_D_AR_GL_ALIAS_ID
RC_F_CASH RC_D_GL_ALIAS_ID
RC_F_DAILY_CDM_SMRY RC_D_GL_ALIAS_ID
RC_F_DAILY_TRANS_SMRY RC_D_GL_ALIAS_ID
RC_F_MONTHLY_CDM_SMRY RC_D_GL_ALIAS_ID
RC_F_MONTHLY_TRANS_SMRY RC_D_GL_ALIAS_ID
RC_F_NON_AR_BALANCE_TRANS RC_D_GL_ALIAS_ID
RC_F_NON_AR_BALANCE_TRANS RC_D_OTHER_GL_ALIAS_ID
RC_F_REVENUE RC_D_AR_GL_ALIAS_ID
RC_F_REVENUE RC_D_GL_ALIAS_ID


RC_D_HEALTH_PLAN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Revenue Cycle Dimension Health Plan
Definition: This table contains health plan information such as insurance company and health plan name,
Table Type: ACTIVITY





Column Detail - RC_D_HEALTH_PLAN


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.
GROUP_NAME VARCHAR(200) N The Group to which a health plan belongs.
GROUP_NBR_IDENT VARCHAR(100) N The group number associated with the group name to which a health plan belongs.
HEALTH_PLAN_CLASS VARCHAR(40) N The class of a health plan (i.e. Free text Health Plan, Organization)
HEALTH_PLAN_NAME VARCHAR(100) N The name of a health plan.
HEALTH_PLAN_PRODUCT_TYPE VARCHAR(40) N Determines the product designation for a health plan (Commercial, Auto Insurance, etc.). Uses code set 26310.
INSURANCE_COMPANY VARCHAR(100) N The insurance company associated with a health plan.
LAST_PROCESS_DT_TM DATETIME N The date/time that the last ETL process started that updated this record.
MILL_HEALTH_PLAN_ID DOUBLE N Uniquely identifies the related Health Plan in Millennium from which this data is derived.
MILL_LOGICAL_DOMAIN_ID DOUBLE N Uniquely identifies the logical domain to which the row data belongs.
POLICY_NBR_IDENT VARCHAR(100) N The policy number associated with a Health Plan.
RC_D_HEALTH_PLAN_ID DOUBLE N Uniquely identifies information about a Health Plan such as insurance company and health plan name.
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_HEALTH_PLAN




Parent Column in RC_D_HEALTH_PLAN (PK) Child Table Name Child Column Name
Children: RC_D_HEALTH_PLAN_ID RC_F_ADJUSTMENT RC_D_HEALTH_PLAN_ID
RC_F_BALANCE_AR RC_D_HEALTH_PLAN_ID
RC_F_BALANCE_AR RC_D_PRI_HEALTH_PLAN_ID
RC_F_BALANCE_AR RC_D_RESP_HEALTH_PLAN_ID
RC_F_CASE_MIX RC_D_PRI_HEALTH_PLAN_ID
RC_F_CASH RC_D_HEALTH_PLAN_ID
RC_F_CLAIM_EVENT RC_D_HEALTH_PLAN_ID
RC_F_CODING_ACTIVITY RC_D_PRI_HEALTH_PLAN_ID
RC_F_DAILY_BAL_AR_SMRY RC_D_HEALTH_PLAN_ID
RC_F_DAILY_BAL_AR_SMRY RC_D_PRI_HEALTH_PLAN_ID
RC_F_DAILY_BAL_AR_SMRY RC_D_RESP_HEALTH_PLAN_ID
RC_F_DAILY_CDM_SMRY RC_D_HEALTH_PLAN_ID
RC_F_DAILY_CLAIM_EVENT_SMRY RC_D_HEALTH_PLAN_ID
RC_F_DAILY_DENIAL_SMRY RC_D_HEALTH_PLAN_ID
RC_F_DAILY_TRANS_SMRY RC_D_HEALTH_PLAN_ID
RC_F_DENIAL RC_D_HEALTH_PLAN_ID
RC_F_DLY_CHRG_ASSOC_SMRY RC_D_HEALTH_PLAN_ID
RC_F_DLY_CODING_ACT_SMRY RC_D_PRI_HEALTH_PLAN_ID
RC_F_MONTHLY_CDM_SMRY RC_D_HEALTH_PLAN_ID
RC_F_MONTHLY_CLAIM_EVENT_SMRY RC_D_HEALTH_PLAN_ID
RC_F_MONTHLY_DENIAL_SMRY RC_D_HEALTH_PLAN_ID
RC_F_MONTHLY_TRANS_SMRY RC_D_HEALTH_PLAN_ID
RC_F_MTH_CHRG_ASSOC_SMRY RC_D_HEALTH_PLAN_ID
RC_F_MTH_CODING_ACT_SMRY RC_D_PRI_HEALTH_PLAN_ID
RC_F_PATIENT_AR_BALANCE RC_D_PRI_HEALTH_PLAN_ID
RC_F_PATIENT_AR_BALANCE RC_D_RESP_HEALTH_PLAN_ID
RC_F_PATIENT_AR_BAL_SMRY RC_D_PRI_HEALTH_PLAN_ID
RC_F_PATIENT_AR_BAL_SMRY RC_D_RESP_HEALTH_PLAN_ID
RC_F_REVENUE RC_D_HEALTH_PLAN_ID
RC_F_VARIANCE RC_D_HEALTH_PLAN_ID
RC_F_VAR_CLAIM_SMRY RC_D_HEALTH_PLAN_ID
RC_F_VAR_LINE_ITEM_SMRY RC_D_HEALTH_PLAN_ID
SHR_F_ENCOUNTER_VISIT RC_D_PRI_HEALTH_PLAN_ID


RC_D_HOLD



Column Section Relationship Section Top of Page


Table-level Detail

Description: Revenue Cycle Dimension Hold
Definition: This table contains hold information such as hold reason and hold type.
Table Type: REFERENCE





Column Detail - RC_D_HOLD


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.
HOLD_REASON VARCHAR(40) N The reason associated to a hold.
HOLD_TYPE VARCHAR(40) N The type associated to a hold.
LAST_PROCESS_DT_TM DATETIME N The date/time that the last ETL process started that updated this record.
MILL_PE_HOLD_REASON_CD DOUBLE N Code value that uniquely identifies a row in the Millennium database related to this hold dimension row.
RC_D_HOLD_ID DOUBLE N Uniquely identifies a hold information such as hold reason and hold type.
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_HOLD




Parent Column in RC_D_HOLD (PK) Child Table Name Child Column Name
Children: RC_D_HOLD_ID RC_F_BALANCE_AR RC_D_BAL_HOLD_ID
RC_F_BALANCE_AR RC_D_ENCNTR_HOLD_ID
RC_F_DAILY_BAL_AR_SMRY RC_D_BAL_HOLD_ID
RC_F_DAILY_BAL_AR_SMRY RC_D_ENCNTR_HOLD_ID
RC_F_DAYS_IN_AR_SMRY RC_D_HOLD_ID
RC_F_PATIENT_AR_BALANCE RC_D_PRI_HOLD_ID


RC_D_MEDICAL_SERVICE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Revenue Cycle Dimension Medical Service
Definition: This table contains the type or category of medical service that the patient is receiving in relation to their encounter.
Table Type: REFERENCE





Column Detail - RC_D_MEDICAL_SERVICE


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.
MEDICAL_SERVICE VARCHAR(40) N The type or category of medical service that the patient is receiving in relation to their encounter. The category may be of treatment type, surgery, general resources, or others.
MILL_MEDICAL_SERVICE_CD DOUBLE N Uniquely identifies a row in the Millennium database related to this medical service.
RC_D_MEDICAL_SERVICE_ID DOUBLE N Uniquely identifies medical service information such as type or category, that the patient is receiving in relation to their encounter.
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_MEDICAL_SERVICE




Parent Column in RC_D_MEDICAL_SERVICE (PK) Child Table Name Child Column Name
Children: RC_D_MEDICAL_SERVICE_ID RC_F_ADJUSTMENT RC_D_MEDICAL_SERVICE_ID
RC_F_BALANCE_AR RC_D_MEDICAL_SERVICE_ID
RC_F_CASE_MIX RC_D_MEDICAL_SERVICE_ID
RC_F_CASH RC_D_MEDICAL_SERVICE_ID
RC_F_CODING_ACTIVITY RC_D_MEDICAL_SERVICE_ID
RC_F_DAILY_BAL_AR_SMRY RC_D_MEDICAL_SERVICE_ID
RC_F_DAILY_CDM_SMRY RC_D_MEDICAL_SERVICE_ID
RC_F_DAILY_CENSUS RC_D_MEDICAL_SERVICE_ID
RC_F_DAILY_CENSUS_SMRY RC_D_MEDICAL_SERVICE_ID
RC_F_DAILY_TRANS_SMRY RC_D_MEDICAL_SERVICE_ID
RC_F_DENIAL RC_D_MEDICAL_SERVICE_ID
RC_F_DLY_CHRG_ASSOC_SMRY RC_D_MEDICAL_SERVICE_ID
RC_F_DLY_CODING_ACT_SMRY RC_D_MEDICAL_SERVICE_ID
RC_F_MONTHLY_CDM_SMRY RC_D_MEDICAL_SERVICE_ID
RC_F_MONTHLY_CENSUS_SMRY RC_D_MEDICAL_SERVICE_ID
RC_F_MONTHLY_TRANS_SMRY RC_D_MEDICAL_SERVICE_ID
RC_F_MTH_CHRG_ASSOC_SMRY RC_D_MEDICAL_SERVICE_ID
RC_F_MTH_CODING_ACT_SMRY RC_D_MEDICAL_SERVICE_ID
RC_F_PATIENT_AR_BALANCE RC_D_MEDICAL_SERVICE_ID
RC_F_PATIENT_AR_BAL_SMRY RC_D_MEDICAL_SERVICE_ID
RC_F_REVENUE RC_D_MEDICAL_SERVICE_ID
SHR_F_ENCOUNTER_VISIT RC_D_MEDICAL_SERVICE_ID


RC_D_NEWBORN_STATUS



Column Section Relationship Section Top of Page


Table-level Detail

Description: Revenue Cycle Dimension Newborn Status
Definition: The table is used to define the various statuses of patient's who are newborns
Table Type: REFERENCE





Column Detail - RC_D_NEWBORN_STATUS


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.
NEWBORN_STATUS VARCHAR(100) Y Uniquely identifies newborn status information related to this fact row.
NEWBORN_STATUS_KEY VARCHAR(100) Y Contains the key value for the newborn status. The column contains all caps with no spaces or special characters.
RC_D_NEWBORN_STATUS_ID DOUBLE N Uniquely identifies information about the status of a newborn.
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_NEWBORN_STATUS




Parent Column in RC_D_NEWBORN_STATUS (PK) Child Table Name Child Column Name
Children: RC_D_NEWBORN_STATUS_ID RC_F_CASE_MIX RC_D_NEWBORN_STATUS_ID
RC_F_DAILY_CENSUS RC_D_NEWBORN_STATUS_ID
RC_F_DAILY_CENSUS_SMRY RC_D_NEWBORN_STATUS_ID
RC_F_MONTHLY_CENSUS_SMRY RC_D_NEWBORN_STATUS_ID