Table Detail Report

RC_D_TRANSACTION_LOCATION



Column Section Relationship Section Top of Page


Table-level Detail

Description: Revenue Cycle Dimension Transaction Location
Definition: Contains information about the transaction location.
Table Type: REFERENCE





Column Detail - RC_D_TRANSACTION_LOCATION


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.
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.
LOCATION_DESCRIPTION VARCHAR(255) Y Represents the full description of the transaction's location
LOCATION_NAME VARCHAR(255) Y Represents the name of the transaction's location
LOCATION_NAME_KEY VARCHAR(255) Y Represents the transaction's location in uppercase with all spaces and symbols removed.
MILL_LOGICAL_DOMAIN_ID DOUBLE N Represents the transaction's logical domain.
MILL_ORGANIZATION_ID DOUBLE N Represents the transaction's organization
MILL_PAYMENT_LOCATION_ID DOUBLE N Represents the payment location for the transaction
RC_D_TRANSACTION_LOCATION_ID DOUBLE N Contains information on the location of the transactions.
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_TRANSACTION_LOCATION




Parent Column in RC_D_TRANSACTION_LOCATION (PK) Child Table Name Child Column Name
Children: RC_D_TRANSACTION_LOCATION_ID RC_F_ADJUSTMENT RC_D_TRANSACTION_LOCATION_ID
RC_F_CASH RC_D_TRANSACTION_LOCATION_ID
RC_F_DAILY_TRANS_SMRY RC_D_TRANSACTION_LOCATION_ID
RC_F_MONTHLY_TRANS_SMRY RC_D_TRANSACTION_LOCATION_ID


RC_D_TRANSACTION_TYPE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Revenue Cycle Dimension Transaction Type
Definition: This table stores the transaction type, its corresponding code value, sub type and reason.
Table Type: REFERENCE





Column Detail - RC_D_TRANSACTION_TYPE


Column Name Type Null? Definition
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_TRANSACTION_REASON_CD DOUBLE N Holds the code associated with corresponding transaction reason
MILL_TRANSACTION_SUB_TYPE_CD DOUBLE N Holds the code associated with corresponding transaction sub type
MILL_TRANSACTION_TYPE_CD DOUBLE N Holds the code associated with corresponding transaction type.
RC_D_TRANSACTION_TYPE_ID DOUBLE N Unique generated number that identifies a single row on the RC_D_TRANSACTION _TYPE table.
TRANSACTION_REASON VARCHAR(40) N The transaction reason associated with the transaction type (i.e. bankruptcy, bad debt recovery, patient payment.
TRANSACTION_SUB_TYPE VARCHAR(40) N The transaction sub type associated with the transaction type (i.e. commercial insturance payment, refund payment).
TRANSACTION_TYPE VARCHAR(40) N The transaction type associated with the transaction type code value (i.e. adjustment, charge, payment).
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_TRANSACTION_TYPE




Parent Column in RC_D_TRANSACTION_TYPE (PK) Child Table Name Child Column Name
Children: RC_D_TRANSACTION_TYPE_ID RC_F_ADJUSTMENT RC_D_TRANSACTION_TYPE_ID
RC_F_CASH RC_D_TRANSACTION_TYPE_ID
RC_F_DAILY_TRANS_SMRY RC_D_TRANSACTION_TYPE_ID
RC_F_GENERAL_AR_BAL_TRANS RC_D_TRANSACTION_TYPE_ID
RC_F_MONTHLY_TRANS_SMRY RC_D_TRANSACTION_TYPE_ID
RC_F_NON_AR_BALANCE_TRANS RC_D_TRANSACTION_TYPE_ID
RC_F_REVENUE RC_D_TRANSACTION_TYPE_ID


RC_D_VARIANCE_ACTION



Column Section Relationship Section Top of Page


Table-level Detail

Description: Revenue Cycle Dimension Variance Action
Definition: Contains the data associated to variance attributes for reporting purposes.
Table Type: REFERENCE





Column Detail - RC_D_VARIANCE_ACTION


Column Name Type Null? Definition
ACTION VARCHAR(200) Y Contains action display values that can be applied to work item based on the MILL_ACTION_CD or MILL_REASON_CD.
ACTION_DESCRIPTION VARCHAR(200) Y Contains the description of the corresponding action applied on the work item based on the MILL_REASON_CD column.
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.
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_ACTION_CD DOUBLE N Contains the user custom action code value applied to the work item.
MILL_REASON_CD DOUBLE N Applied action code or reason code in case system applied action code.
RC_D_VARIANCE_ACTION_ID DOUBLE N Uniquely identifies data associated to variance 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_VARIANCE_ACTION




Parent Column in RC_D_VARIANCE_ACTION (PK) Child Table Name Child Column Name
Children: RC_D_VARIANCE_ACTION_ID RC_F_VARIANCE RC_D_VARIANCE_ACTION_ID
RC_F_VAR_CLAIM_SMRY RC_D_VARIANCE_ACTION_ID
RC_F_VAR_LINE_ITEM_SMRY RC_D_VARIANCE_ACTION_ID


RC_D_VARIANCE_ORIGIN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Revenue Cycle Dimension Variance Origin
Definition: Contains the data associated to variance attributes for reporting purposes.
Table Type: REFERENCE





Column Detail - RC_D_VARIANCE_ORIGIN


Column Name Type Null? Definition
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_WORKITEM_ORIGIN_CD DOUBLE N Stores the code value for the origin of the work item created.
RC_D_VARIANCE_ORIGIN_ID DOUBLE N Unique generated nuymber that identifies a single row on the RC_D_VARIANCE_ORIGIN table.
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.
WORKITEM_ORIGIN_DESC VARCHAR(50) N Stores the description of origin for the Wrok Item created.



Relationship Detail - RC_D_VARIANCE_ORIGIN




Parent Column in RC_D_VARIANCE_ORIGIN (PK) Child Table Name Child Column Name
Children: RC_D_VARIANCE_ORIGIN_ID RC_F_VARIANCE RC_D_VARIANCE_ORIGIN_ID
RC_F_VAR_CLAIM_SMRY RC_D_VARIANCE_ORIGIN_ID
RC_F_VAR_LINE_ITEM_SMRY RC_D_VARIANCE_ORIGIN_ID


RC_D_VARIANCE_PROPERTY



Column Section Relationship Section Top of Page


Table-level Detail

Description: Revenue Cycle Dimension Variance Property
Definition: Contains the data associated to variance attributes for Reporting purposes
Table Type: REFERENCE





Column Detail - RC_D_VARIANCE_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.
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_PFT_ENTITY_STATUS_CD DOUBLE N Contains all the current state for the work Items.
RC_D_VARIANCE_PROPERTY_ID DOUBLE N Uniquely identifies data associated to variance 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.
VARIANCE_STATUS VARCHAR(40) Y Contains all the statuses associated to a variance work item based on the MILL_PFT_ENTITY_STATUS_CD
WORK_ITEM_ACTION VARCHAR(40) Y Contains supported performed actions on this queue item



Relationship Detail - RC_D_VARIANCE_PROPERTY




Parent Column in RC_D_VARIANCE_PROPERTY (PK) Child Table Name Child Column Name
Children: RC_D_VARIANCE_PROPERTY_ID RC_F_VARIANCE RC_D_VARIANCE_PROPERTY_ID
RC_F_VAR_CLAIM_SMRY RC_D_VARIANCE_PROPERTY_ID
RC_F_VAR_LINE_ITEM_SMRY RC_D_VARIANCE_PROPERTY_ID