Table Detail Report

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


RC_D_DRG



Column Section Relationship Section Top of Page


Table-level Detail

Description: Revenue Cycle Dimension Diagnosis Related Group
Definition: Contains infrormation related to the diagnosis related group.
Table Type: ACTIVITY





Column Detail - RC_D_DRG


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.
DRG_CODE_TXT VARCHAR(50) N Contains the code that represents diagnosis.
DRG_DESCRIPTION VARCHAR(200) N The description of a drg as defined by the client.
DRG_WEIGHT DOUBLE N Stores the DRG weight for groupers
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_DRG_ID DOUBLE N Uniquely identifies the related DRG from the Millennium nomenclature table.
RC_D_DRG_ID DOUBLE N Uniquely identifies a DRG that has ben posted to the clinical encounter.
SOURCE_VOCABULARY_CODE DOUBLE N Contains the source vocabulary code value.
SOURCE_VOCABULARY_DESC VARCHAR(100) N Contains the source vocabulary code description.
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_DRG




Parent Column in RC_D_DRG (PK) Child Table Name Child Column Name
Children: RC_D_DRG_ID RC_F_CASE_MIX MS_DRG_ID
RC_F_CASE_MIX RC_D_PRI_DRG_ID
RC_F_CODING_ACTIVITY RC_D_DRG_ID
RC_F_DAILY_CENSUS RC_D_DRG_ID
RC_F_DENIAL RC_D_DRG_ID
RC_F_DLY_CODING_ACT_SMRY RC_D_DRG_ID
RC_F_MTH_CODING_ACT_SMRY RC_D_DRG_ID
RC_F_PATIENT_AR_BALANCE RC_D_PRI_DRG_ID


RC_D_DUNNING_LEVEL



Column Section Relationship Section Top of Page


Table-level Detail

Description: Revenue Cycle Dimension Dunning Level
Definition: This table contains the information about the dunning levels to which an encounter can be associated.
Table Type: REFERENCE





Column Detail - RC_D_DUNNING_LEVEL


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.
DUNNING_LEVEL VARCHAR(40) N The level of severity determining the progression through the statement cycle process.
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_DUNNING_LEVEL_CD DOUBLE N Millennium dunning class code. Codeset: 25095.
RC_D_DUNNING_LEVEL_ID DOUBLE N Uniquely identifies a dunning level to which an encounter can be associated.
UPDT_APPLCTX DOUBLE N The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.



Relationship Detail - RC_D_DUNNING_LEVEL




Parent Column in RC_D_DUNNING_LEVEL (PK) Child Table Name Child Column Name
Children: RC_D_DUNNING_LEVEL_ID RC_F_PATIENT_AR_BAL_SMRY RC_D_DUNNING_LEVEL_ID