Table Detail Report
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 |
RC_D_BILL_TYPE
| Column Section | Relationship Section | Top of Page |
Table-level Detail
| Description: | Revenue Cycle Dimension Bill Type |
| Definition: | This table contains bill type information such as the bill type. |
| Table Type: | REFERENCE |
Column Detail - RC_D_BILL_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. |
| 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_TYPE | VARCHAR(40) | N | Identifies the type of bill (i.e. Client Invoice, Patient Invoice, HCFA 1500, 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_BILL_TYPE_CD | DOUBLE | N | This identifies the Bill Type code on the Millennium table from which this row was derived. |
| RC_D_BILL_TYPE_ID | DOUBLE | N | Uniquely identifies bill type 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_BILL_TYPE
| Parent Column in RC_D_BILL_TYPE (PK) | Child Table Name | Child Column Name | |
|---|---|---|---|
| Children: | RC_D_BILL_TYPE_ID | RC_F_ADJUSTMENT | RC_D_BILL_TYPE_ID |
| RC_F_CASH | RC_D_BILL_TYPE_ID | ||
| RC_F_CLAIM_EVENT | RC_D_BILL_TYPE_ID | ||
| RC_F_DAILY_CLAIM_EVENT_SMRY | RC_D_BILL_TYPE_ID | ||
| RC_F_DAILY_DENIAL_SMRY | RC_D_BILL_TYPE_ID | ||
| RC_F_DENIAL | RC_D_BILL_TYPE_ID | ||
| RC_F_MONTHLY_CLAIM_EVENT_SMRY | RC_D_BILL_TYPE_ID | ||
| RC_F_MONTHLY_DENIAL_SMRY | RC_D_BILL_TYPE_ID | ||
| RC_F_VARIANCE | RC_D_BILL_TYPE_ID | ||
| RC_F_VAR_CLAIM_SMRY | RC_D_BILL_TYPE_ID | ||
| RC_F_VAR_LINE_ITEM_SMRY | RC_D_BILL_TYPE_ID |
RC_D_CENSUS_EVENT
| Column Section | Relationship Section | Top of Page |
Table-level Detail
| Description: | Revenue Cycle Dimension Census Event |
| Definition: | This table contains the information about the census events that can occur throughtout a day. |
| Table Type: | REFERENCE |
Column Detail - RC_D_CENSUS_EVENT
| 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. |
| CENSUS_EVENT | VARCHAR(50) | N | Contains the type of event that can occur for census data. |
| CENSUS_EVENT_KEY | VARCHAR(50) | N | Contains the key value for the census event. The column contains all caps with no spaces or special characters. |
| 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_CENSUS_EVENT_ID | DOUBLE | N | Uniquely identifies information about census events that can occur throughout a day. |
| 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_CENSUS_EVENT
| Parent Column in RC_D_CENSUS_EVENT (PK) | Child Table Name | Child Column Name | |
|---|---|---|---|
| Children: | RC_D_CENSUS_EVENT_ID | RC_F_DAILY_CENSUS | RC_D_CENSUS_EVENT_ID |
| RC_F_DAILY_CENSUS_SMRY | RC_D_CENSUS_EVENT_ID | ||
| RC_F_MONTHLY_CENSUS_SMRY | RC_D_CENSUS_EVENT_ID |
RC_D_CLAIM_EVENT_TYPE
| Column Section | Relationship Section | Top of Page |
Table-level Detail
| Description: | Revenue Cycle Dimension Claim Event Type |
| Definition: | This table contains claim event type information such as claim event type and sub type. |
| Table Type: | REFERENCE |
Column Detail - RC_D_CLAIM_EVENT_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. |
| 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. |
| CLAIM_EVENT_SUB_TYPE | VARCHAR(40) | N | Contains the sub type associated with a claim event. |
| CLAIM_EVENT_TYPE | VARCHAR(40) | N | Contains the type related to a claim event. |
| 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_CLAIM_EVENT_TYPE_ID | DOUBLE | N | Uniquely identifies claim event type information such as claim event type and sub 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_CLAIM_EVENT_TYPE
| Parent Column in RC_D_CLAIM_EVENT_TYPE (PK) | Child Table Name | Child Column Name | |
|---|---|---|---|
| Children: | RC_D_CLAIM_EVENT_TYPE_ID | RC_F_CLAIM_EVENT | RC_D_CLAIM_EVENT_TYPE_ID |
| RC_F_DAILY_CLAIM_EVENT_SMRY | RC_D_CLAIM_EVENT_TYPE_ID | ||
| RC_F_MONTHLY_CLAIM_EVENT_SMRY | RC_D_CLAIM_EVENT_TYPE_ID |