Table Detail Report

RC_D_ADMIT_SOURCE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Revenue Cycle Dimension Admit Source
Definition: This table contains information about the place from which the patient came before being admitted. (i.e., transfer from another hospital)
Table Type: REFERENCE





Column Detail - RC_D_ADMIT_SOURCE


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.
ADMIT_SOURCE_TXT VARCHAR(40) Y The place from which the patient came before being admitted. (i.e., transfer from another hospital)
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_ADMIT_SOURCE_CD DOUBLE N This identifies the admit source code on the millennium table from which this row was derived.
RC_D_ADMIT_SOURCE_ID DOUBLE N Uniquely identifies information about the place from which the patient came before being admitted. (i.e., transfer from another hospital)
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_ADMIT_SOURCE




Parent Column in RC_D_ADMIT_SOURCE (PK) Child Table Name Child Column Name
Children: RC_D_ADMIT_SOURCE_ID RC_F_DAILY_CENSUS RC_D_ADMIT_SOURCE_ID
RC_F_DAILY_CENSUS_SMRY RC_D_ADMIT_SOURCE_ID
RC_F_MONTHLY_CENSUS_SMRY RC_D_ADMIT_SOURCE_ID


RC_D_ADMIT_TYPE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Revenue Cycle Admit Type
Definition: This table contains information related to the circumstance under which the patient was admitted or will be admitted. (i.e., accident, emergent, routine, elective, labor/delivery, etc.)
Table Type: REFERENCE





Column Detail - RC_D_ADMIT_TYPE


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.
ADMIT_TYPE_TXT VARCHAR(40) Y The circumstance under which the patient was admitted or will be admitted. (i.e., accident, emergent, routine, elective, labor/delivery, 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_ADMIT_TYPE_CD DOUBLE N This identifies the admit type code on the millennium table from which this row was derived.
RC_D_ADMIT_TYPE_ID DOUBLE N Uniquely identifies an admit 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_ADMIT_TYPE




Parent Column in RC_D_ADMIT_TYPE (PK) Child Table Name Child Column Name
Children: RC_D_ADMIT_TYPE_ID RC_F_DAILY_CENSUS RC_D_ADMIT_TYPE_ID
RC_F_DAILY_CENSUS_SMRY RC_D_ADMIT_TYPE_ID
RC_F_MONTHLY_CENSUS_SMRY RC_D_ADMIT_TYPE_ID


RC_D_AGE_CATEGORY



Column Section Relationship Section Top of Page


Table-level Detail

Description: Revenue Cycle Dimension Age Category
Definition: This table contains the different aging categories.
Table Type: REFERENCE





Column Detail - RC_D_AGE_CATEGORY


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.
BEGIN_AGE_DAY DOUBLE N The beginning age for this category.
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.
CATEGORY_DESCRIPTION VARCHAR(100) N The textual description of the given age category.
CATEGORY_GROUP DOUBLE N Range defining the order of the different categories.
CUSTOM_AGE_GROUP VARCHAR(100) Y Defines the custom age group to which this age row is assigned.
DNFB_DESCRIPTION VARCHAR(100) N Discharged Not Final Billed Age Range Description
END_AGE_DAY DOUBLE N The ending age for this category.
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.
RC_D_AGE_CATEGORY_ID DOUBLE N Uniquely identifies a given age category.
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_AGE_CATEGORY




Parent Column in RC_D_AGE_CATEGORY (PK) Child Table Name Child Column Name
Children: RC_D_AGE_CATEGORY_ID RC_F_BALANCE_AR RC_D_AGE_BY_BILL_ID
RC_F_BALANCE_AR RC_D_AGE_BY_DISCHARGE_ID
RC_F_BALANCE_AR RC_D_AGE_BY_FIRST_SERVICE_ID
RC_F_BALANCE_AR RC_D_AGE_BY_LAST_PAYMENT_ID
RC_F_BALANCE_AR RC_D_AGE_BY_ORIG_BILL_ID
RC_F_DAILY_BAL_AR_SMRY RC_D_AGE_BY_DISCHARGE_ID
RC_F_DAILY_BAL_AR_SMRY RC_D_AGE_BY_FIRST_SERVICE_ID
RC_F_DAILY_BAL_AR_SMRY RC_D_AGE_BY_ORIG_BILL_ID
RC_F_DAYS_IN_AR_SMRY RC_D_DISCHARGE_AGE_ID
RC_F_INVOICE_AR_BALANCE RC_D_AGE_BY_BILL_ID
RC_F_INVOICE_AR_BALANCE RC_D_AGE_BY_INVOICE_ID
RC_F_INVOICE_AR_BAL_INV RC_D_AGE_BY_INVOICE_ID
RC_F_PATIENT_AR_BALANCE RC_D_AGE_BY_BILL_ID
RC_F_PATIENT_AR_BALANCE RC_D_AGE_BY_DISCHARGE_ID
RC_F_PATIENT_AR_BALANCE RC_D_AGE_BY_LAST_PAYMENT_ID
RC_F_PATIENT_AR_BAL_SMRY RC_D_AGE_BY_LAST_PAYMENT_ID
RC_F_PATIENT_AR_BAL_SMRY RC_D_BILL_AGE_ID
RC_F_PATIENT_AR_BAL_SMRY RC_D_DISCHARGE_AGE_ID


RC_D_AMOUNT_CATEGORY



Column Section Relationship Section Top of Page


Table-level Detail

Description: Revenue Cycle Dimension Amount Category
Definition: Contains pre-defined currency range categories.
Table Type: REFERENCE





Column Detail - RC_D_AMOUNT_CATEGORY


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.
BEGIN_AMOUNT DOUBLE N The beginning amount for this category.
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.
CATEGORY_DESCRIPTION VARCHAR(100) N The textual description of the given amount category.
END_AMOUNT DOUBLE N The ending amount for this category.
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.
RC_D_AMOUNT_CATEGORY_ID DOUBLE N Uniquely identifies a given amount category.
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_AMOUNT_CATEGORY




Parent Column in RC_D_AMOUNT_CATEGORY (PK) Child Table Name Child Column Name
Children: RC_D_AMOUNT_CATEGORY_ID RC_F_PATIENT_AR_BALANCE RC_D_BAL_AMT_CATEGORY_ID
RC_F_PATIENT_AR_BALANCE RC_D_UNBILLED_BAL_AMT_CAT_ID
RC_F_PATIENT_AR_BAL_SMRY RC_D_BAL_AMT_CATEGORY_ID
RC_F_PATIENT_AR_BAL_SMRY RC_D_UNBILLED_BAL_AMT_CAT_ID


RC_D_BALANCE_GROUP



Column Section Relationship Section Top of Page


Table-level Detail

Description: Revenue Cycle Demension Balance Group
Definition: This table contains the information about the balance groups to which an account can be associated. i.e. Selfpay, Institutional, Professional
Table Type: REFERENCE





Column Detail - RC_D_BALANCE_GROUP


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.
BALANCE_GROUP_TXT VARCHAR(20) N Balance Group (i.e. Selfpay, Institutional, Professional)
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_BALANCE_GROUP_ID DOUBLE N Uniquely identifies a balance group.
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_BALANCE_GROUP




Parent Column in RC_D_BALANCE_GROUP (PK) Child Table Name Child Column Name
Children: RC_D_BALANCE_GROUP_ID RC_F_BALANCE_AR RC_D_BALANCE_GROUP_ID
RC_F_DAILY_BAL_AR_SMRY RC_D_BALANCE_GROUP_ID