Table Detail Report
RC_D_CODING_ACTION
| Column Section | Relationship Section | Top of Page |
Table-level Detail
| Description: | Revenue Cycle Dimension Coding Action |
| Definition: | This table is used to store the actions related to coding activity. For example: Saved As Draft, Saved As Final, or Merged. |
| Table Type: | REFERENCE |
Column Detail - RC_D_CODING_ACTION
| 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. |
| CODING_ACTION | VARCHAR(100) | Y | Contains the actions that can be performed for coding activity. |
| CODING_ACTION_KEY | VARCHAR(100) | Y | Contains the key value for the Coding Action. 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_CODING_ACTION_ID | DOUBLE | N | Uniquely identifies actions related to coding activity. |
| 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_CODING_ACTION
| Parent Column in RC_D_CODING_ACTION (PK) | Child Table Name | Child Column Name | |
|---|---|---|---|
| Children: | RC_D_CODING_ACTION_ID | RC_F_CODING_ACTIVITY | RC_D_CODING_ACTION_ID |
| RC_F_DLY_CODING_ACT_SMRY | RC_D_CODING_ACTION_ID | ||
| RC_F_MTH_CODING_ACT_SMRY | RC_D_CODING_ACTION_ID |
RC_D_CODING_STATUS
| Column Section | Top of Page |
Table-level Detail
| Description: | Revenue Cycle Dimension Coding Status |
| Definition: | This table is used to store the actions related to an encouter for case mix domain, example are working, draft, coded, coded without drg. |
| Table Type: | REFERENCE |
Column Detail - RC_D_CODING_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. |
| 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. |
| CODING_STATUS | VARCHAR(100) | Y | Contains the coding status of the encounter. |
| CODING_STATUS_KEY | VARCHAR(100) | Y | Contains the key value for the Coding Status. 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. |
| RC_D_CODING_STATUS_ID | DOUBLE | N | Uniquely identifies coding status 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. |
RC_D_DENIAL_ALIAS
| Column Section | Relationship Section | Top of Page |
Table-level Detail
| Description: | Revenue Cycle Dimension Denial Alias |
| Definition: | This table contains denial alias information such as denial type and denial group. |
| Table Type: | ACTIVITY |
Column Detail - RC_D_DENIAL_ALIAS
| 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. |
| DENIAL_ALIAS_REASON | VARCHAR(40) | N | Contains the alias associated with a denial. |
| DENIAL_CODE | VARCHAR(50) | N | The actual denial code sent on an ERA. |
| DENIAL_GROUP | VARCHAR(40) | N | The group associated with a denial code (i.e. Patient Liability, Information Only). |
| DENIAL_TYPE | VARCHAR(40) | N | The based type of the denial. (Provider, Patient, Technical, Information Only). |
| 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_DENIAL_REASON_CD | DOUBLE | N | Represent the denial reason for a particular denial. |
| MILL_LOGICAL_DOMAIN_ID | DOUBLE | N | Uniquely identifies the logical domain to which the row data belongs. |
| RC_D_DENIAL_ALIAS_ID | DOUBLE | N | Uniquely identifies denial alias information such as denial type and denial 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_DENIAL_ALIAS
| Parent Column in RC_D_DENIAL_ALIAS (PK) | Child Table Name | Child Column Name | |
|---|---|---|---|
| Children: | RC_D_DENIAL_ALIAS_ID | RC_F_DAILY_DENIAL_SMRY | RC_D_DENIAL_ALIAS_ID |
| RC_F_DENIAL | RC_D_DENIAL_ALIAS_ID | ||
| RC_F_MONTHLY_DENIAL_SMRY | RC_D_DENIAL_ALIAS_ID | ||
| RC_F_VARIANCE | RC_D_DENIAL_ALIAS_ID | ||
| RC_F_VAR_CLAIM_SMRY | RC_D_DENIAL_ALIAS_ID | ||
| RC_F_VAR_LINE_ITEM_SMRY | RC_D_DENIAL_ALIAS_ID |
RC_D_DISCHARGE_DISPOSITION
| Column Section | Relationship Section | Top of Page |
Table-level Detail
| Description: | Revenue Cycle Dimension Discharge Disposition |
| Definition: | This table contains information related to the conditions under which the patient left the facility at the time of discharge. |
| Table Type: | REFERENCE |
Column Detail - RC_D_DISCHARGE_DISPOSITION
| 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. |
| DISCHARGE_DISPOSITION | VARCHAR(40) | Y | The conditions under which the patient left the facility at the time of discharge. |
| 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_DISCHARGE_DISPOSITION_CD | DOUBLE | N | Contains the discharge code from Millennium from which this was sourced. |
| RC_D_DISCHARGE_DISPOSITION_ID | DOUBLE | N | Uniquely identifies information related to the conditions under which the patient left the facility at the time of discharge. |
| 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_DISCHARGE_DISPOSITION
| Parent Column in RC_D_DISCHARGE_DISPOSITION (PK) | Child Table Name | Child Column Name | |
|---|---|---|---|
| Children: | RC_D_DISCHARGE_DISPOSITION_ID | RC_F_DAILY_CENSUS | RC_D_DISCHARGE_DISPOSITION_ID |
| RC_F_DAILY_CENSUS_SMRY | RC_D_DISCHARGE_DISPOSITION_ID | ||
| RC_F_MONTHLY_CENSUS_SMRY | RC_D_DISCHARGE_DISPOSITION_ID |
RC_D_DNFB_STATUS
| Column Section | Relationship Section | Top of Page |
Table-level Detail
| Description: | Revenue Cycle Dimension Dishcarged Not Final Billed Status |
| Definition: | Contains the statuses and reasons for DNFB records |
| Table Type: | ACTIVITY |
Column Detail - RC_D_DNFB_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. |
| DNFB_REASON | VARCHAR(200) | N | A more detailed description of the DNFB status. |
| DNFB_STATUS | VARCHAR(200) | N | The status description of a given DNFB. |
| 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_DNFB_STATUS_ID | DOUBLE | N | Uniquely identifies a given DNFB status. |
| 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_DNFB_STATUS
| Parent Column in RC_D_DNFB_STATUS (PK) | Child Table Name | Child Column Name | |
|---|---|---|---|
| Children: | RC_D_DNFB_STATUS_ID | RC_F_PATIENT_AR_BALANCE | RC_D_DNFB_STATUS_ID |
| RC_F_PATIENT_AR_BAL_SMRY | RC_D_DNFB_STATUS_ID |