Table Detail Report

RC_D_BALANCE_TYPE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Revenue Cycle Dimension Balance Type
Definition: This table contains the information about the balance types to which an account can be associated.
Table Type: REFERENCE





Column Detail - RC_D_BALANCE_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.
BALANCE_STATUS VARCHAR(20) N Contains the status of the balance. (i.e. DNFB, In-House, Billed, BD)
BALANCE_TYPE VARCHAR(20) N Type of Balance (i.e. Debit - AR, Credit - AR, Zero - AR, B/D)
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_TYPE_ID DOUBLE N Uniquely identifies the different balance types to which an account can be associated.
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_TYPE




Parent Column in RC_D_BALANCE_TYPE (PK) Child Table Name Child Column Name
Children: RC_D_BALANCE_TYPE_ID RC_F_ALL_AR_SMRY RC_D_BALANCE_TYPE_ID
RC_F_BALANCE_AR RC_D_BALANCE_TYPE_ID
RC_F_DAILY_BAL_AR_SMRY RC_D_BALANCE_TYPE_ID
RC_F_PATIENT_AR_BAL_SMRY RC_D_BALANCE_TYPE_ID


RC_D_BILLING_ENTITY



Column Section Relationship Section Top of Page


Table-level Detail

Description: Revenue Cycle Dimension Billing Entity
Definition: This table contains data pertaining to the Billing Entity such as Name and Type.
Table Type: REFERENCE





Column Detail - RC_D_BILLING_ENTITY


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.
BILLING_ENTITY_NAME VARCHAR(50) N Allows for the billing entity to have a different name than the organization to which it is related.
BILLING_ENTITY_TYPE VARCHAR(40) N Shows whether the Billing entity is a Participating or Non-Participating Billing Entity.
DELIVERY_SYSTEM VARCHAR(50) N Contains the name of the Delivery System.
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_BILLING_ENTITY_ID DOUBLE N Contains the identifier of the Billing Entity on the Millennium database from which this row was derived.
MILL_LOGICAL_DOMAIN_ID DOUBLE N Uniquely identifies the logical domain to which the row data belongs.
RC_D_BILLING_ENTITY_ID DOUBLE N Uniquely identifies data pertaining to the Billing entity such as Name and 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_BILLING_ENTITY




Parent Column in RC_D_BILLING_ENTITY (PK) Child Table Name Child Column Name
Children: RC_D_BILLING_ENTITY_ID RC_F_ADJUSTMENT RC_D_BILLING_ENTITY_ID
RC_F_ALL_AR_SMRY RC_D_BILLING_ENTITY_ID
RC_F_BALANCE_AR RC_D_BILLING_ENTITY_ID
RC_F_CASH RC_D_BILLING_ENTITY_ID
RC_F_CLAIM_EVENT RC_D_BILLING_ENTITY_ID
RC_F_DAILY_BAL_AR_SMRY RC_D_BILLING_ENTITY_ID
RC_F_DAILY_CDM_SMRY RC_D_BILLING_ENTITY_ID
RC_F_DAILY_CLAIM_EVENT_SMRY RC_D_BILLING_ENTITY_ID
RC_F_DAILY_DENIAL_SMRY RC_D_BILLING_ENTITY_ID
RC_F_DAILY_TRANS_SMRY RC_D_BILLING_ENTITY_ID
RC_F_DAYS_IN_AR_SMRY RC_D_BILLING_ENTITY_ID
RC_F_DENIAL RC_D_BILLING_ENTITY_ID
RC_F_DLY_CHRG_ASSOC_SMRY RC_D_BILLING_ENTITY_ID
RC_F_GENERAL_AR_BALANCE RC_D_BILLING_ENTITY_ID
RC_F_GENERAL_AR_BAL_TRANS RC_D_BILLING_ENTITY_ID
RC_F_INVOICE_AR_BALANCE RC_D_BILLING_ENTITY_ID
RC_F_INVOICE_AR_BAL_INV RC_D_BILLING_ENTITY_ID
RC_F_INVOICE_AR_BAL_SMRY RC_D_BILLING_ENTITY_ID
RC_F_MONTHLY_CDM_SMRY RC_D_BILLING_ENTITY_ID
RC_F_MONTHLY_CLAIM_EVENT_SMRY RC_D_BILLING_ENTITY_ID
RC_F_MONTHLY_DENIAL_SMRY RC_D_BILLING_ENTITY_ID
RC_F_MONTHLY_TRANS_SMRY RC_D_BILLING_ENTITY_ID
RC_F_MTH_CHRG_ASSOC_SMRY RC_D_BILLING_ENTITY_ID
RC_F_NON_AR_BALANCE RC_D_BILLING_ENTITY_ID
RC_F_NON_AR_BALANCE_TRANS RC_D_BILLING_ENTITY_ID
RC_F_PATIENT_AR_BALANCE RC_D_BILLING_ENTITY_ID
RC_F_PATIENT_AR_BAL_SMRY RC_D_BILLING_ENTITY_ID
RC_F_REVENUE RC_D_BILLING_ENTITY_ID
RC_F_VARIANCE RC_D_BILLING_ENTITY_ID
RC_F_VAR_CLAIM_SMRY RC_D_BILLING_ENTITY_ID
RC_F_VAR_LINE_ITEM_SMRY RC_D_BILLING_ENTITY_ID


RC_D_BILL_ITEM



Column Section Relationship Section Top of Page


Table-level Detail

Description: Revenue Cycle Dimension Bill Item
Definition: This table contains bill item information such as activity type and charge description.
Table Type: REFERENCE





Column Detail - RC_D_BILL_ITEM


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.
ACTIVITY_TYPE VARCHAR(40) N The type of activity associated with a given bill item.
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.
CDM VARCHAR(50) Y Charge Description Master Code. A client defined value representing a charge.
CHARGE_DESCRIPTION VARCHAR(200) N The description of a charge associated to a given bill item.
CPT VARCHAR(40) N The Current Procedural Terminology associated to a given bill item.
CPT_DESCRIPTION VARCHAR(200) Y The description of a CPT associated to a given bill item.
DIAGNOSIS_CODE VARCHAR(50) Y Contains diagnosis codes.
DIAGNOSIS_CODE_DESC VARCHAR(200) Y Contains the description of the diagnosis code.
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.
HCPCS VARCHAR(200) N Contains the HCFA Common Procedural Coding System associated to a given bill item.
HCPCS_DESCRIPTION VARCHAR(200) Y Contains the description for HCPCS.
LAST_PROCESS_DT_TM DATETIME N The date/time that the last ETL process started that updated this record.
MILL_BILL_ITEM_ID DOUBLE N The bill item identifier from the Millennium Database Bill Item Table.
MILL_DIAGNOSIS_CD DOUBLE N Identifies the code value for the diagnosis code. This column is derived from the code in the Charge_Mod table.
MILL_LOGICAL_DOMAIN_ID DOUBLE N Uniquely identifies the logical domain to which the row data belongs.
PROCEDURE_CODE VARCHAR(200) N The procedure code associated to a given bill item.
PROCEDURE_MODIFIER_TXT VARCHAR(3) Y The modifier associated to the Procedure(CPT4 and HCPCS) code.
RC_D_BILL_ITEM_ID DOUBLE N Uniquely identifies Bill Item information such as activity type and charge description.
REVENUE_CODE VARCHAR(40) N The Revenue Code associated to a given bill item.
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_BILL_ITEM




Parent Column in RC_D_BILL_ITEM (PK) Child Table Name Child Column Name
Children: RC_D_BILL_ITEM_ID RC_F_DAILY_CDM_SMRY RC_D_BILL_ITEM_ID
RC_F_DLY_CHRG_ASSOC_SMRY RC_D_BILL_ITEM_ID
RC_F_MONTHLY_CDM_SMRY RC_D_BILL_ITEM_ID
RC_F_MTH_CHRG_ASSOC_SMRY RC_D_BILL_ITEM_ID
RC_F_REVENUE RC_D_BILL_ITEM_ID


RC_D_BILL_ITEM_MODIFIER



Column Section Relationship Section Top of Page


Table-level Detail

Description: Revenue Cycle Dimension Bill Item Modifier
Definition: Stores modifiers in a specific order for each bill code from data captured by GSR Revenue Extract
Table Type: REFERENCE





Column Detail - RC_D_BILL_ITEM_MODIFIER


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.
PRIMARY_MODIFIER VARCHAR(50) Y This is the first modifier associated to a bill item.
QUATERNARY_MODIFIER VARCHAR(50) Y This is the fourth modifier associated to a bill item.
RC_D_BILL_ITEM_MODIFIER_ID DOUBLE N Unique generated number that identifies a single row on the RC_D_BILL_ITEM_MODIFIER table.
SECONDARY_MODIFIER VARCHAR(50) Y The second modifier associated to a bill item.
SOURCE_VOCABULARY_CD DOUBLE N CODE SET:400 The external vocabulary or lexicon that contributed the string, e.g. CPT, HCPCS, etc.
SOURCE_VOCABULARY_TEXT VARCHAR(40) Y Stores the display of the source_vocabulary_cd.
TERTIARY_MODIFIER VARCHAR(50) Y The third modifier associated to a bill_item.
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_BILL_ITEM_MODIFIER




Parent Column in RC_D_BILL_ITEM_MODIFIER (PK) Child Table Name Child Column Name
Children: RC_D_BILL_ITEM_MODIFIER_ID RC_F_DAILY_CDM_SMRY RC_D_CPT_MODIFIER_ID
RC_F_DAILY_CDM_SMRY RC_D_HCPCS_MODIFIER_ID
RC_F_MONTHLY_CDM_SMRY RC_D_CPT_MODIFIER_ID
RC_F_MONTHLY_CDM_SMRY RC_D_HCPCS_MODIFIER_ID
RC_F_REVENUE RC_D_CPT_MODIFIER_ID
RC_F_REVENUE RC_D_HCPCS_MODIFIER_ID


RC_D_BILL_PROPERTY



Column Section Relationship Section Top of Page


Table-level Detail

Description: Revenue Cycle Dimension Bill Property
Definition: Contains the data associated to claim attributes for reporting purposes.
Table Type: REFERENCE





Column Detail - RC_D_BILL_PROPERTY


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.
BILL_STATUS VARCHAR(40) Y Contains all the statuses for a claim. (ex: pending, ready to bill, 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.
MEDIA_SUB_TYPE VARCHAR(40) Y Identifies the media sub type of claim. (ex: cms1500, etc.:)
MEDIA_TYPE VARCHAR(40) Y Identifies the media type of claim. (ex: edi, paper, etc.:)
MILL_BILL_STATUS_CD DOUBLE N Identifies the bill status code on the Millennium table from which this row was derived.
MILL_MEDIA_SUB_TYPE_CD DOUBLE N Identifies the media sub type code on the millennium table from which this row was derived.
MILL_MEDIA_TYPE_CD DOUBLE N Identifies the media type of claim (ex: edi, paper, etc.)
RC_D_BILL_PROPERTY_ID DOUBLE N Uniquely identifies data associated to claim attributes for reporting purposes.
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_BILL_PROPERTY




Parent Column in RC_D_BILL_PROPERTY (PK) Child Table Name Child Column Name
Children: RC_D_BILL_PROPERTY_ID RC_F_BALANCE_AR RC_D_BILL_PROPERTY_ID
RC_F_INVOICE_AR_BALANCE RC_D_BILL_PROPERTY_ID
RC_F_VARIANCE RC_D_BILL_PROPERTY_ID
RC_F_VAR_CLAIM_SMRY RC_D_BILL_PROPERTY_ID
RC_F_VAR_LINE_ITEM_SMRY RC_D_BILL_PROPERTY_ID