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 |