Table Detail Report

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


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.