RC_CONFIG_DOCUMENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Revenue Cycle Configuration Document
Definition: This table will define a configuration document.
Table Type: REFERENCE





Column Detail - RC_CONFIG_DOCUMENT


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.
DOCUMENT_VERSION_UUID VARCHAR(36) N Uniquely identifies a document version across all domains.
DOCUMENT_XML_BLOB LONGBLOB Y This column stores a related XML document.
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.
LAST_UPDT_PRSNL_ID DOUBLE N Uniquely identifies the last person to update this configuration document.
LOGICAL_DOMAIN_ID DOUBLE N The unique identifier for a logical domain. This identifier allows the data to be grouped by logical domain. For example, If you assign clients a logical_domain_id this would allow you to store data for multiple clients on this table.
ORIG_RC_CONFIG_DOCUMENT_ID DOUBLE N Used to track versions of the configuration document information. This field will always point back to the initial value created. This may be used to find the correct version when combined with begin and end effective dates and times.
RC_CONFIG_DOCUMENT_ID DOUBLE N Unique generated number that identifies a single row on the RC_CONFIG_DOCUMENT table.
RC_CONFIG_PROFILE_ID DOUBLE N Unique generated number that identifies a single row on the RC_CONFIG_PROFILE table.
RC_CONFIG_SUBSYSTEM_ID DOUBLE N Unique generated number that identifies a single row on the RC_CONFIG_SUBSYSTEM
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_CONFIG_DOCUMENT


Child Column in RC_CONFIG_DOCUMENT(FK) Parent Table Name Parent Column Name
Parents: LOGICAL_DOMAIN_ID LOGICAL_DOMAIN LOGICAL_DOMAIN_ID
LAST_UPDT_PRSNL_ID PRSNL PERSON_ID
ORIG_RC_CONFIG_DOCUMENT_ID RC_CONFIG_DOCUMENT RC_CONFIG_DOCUMENT_ID
RC_CONFIG_PROFILE_ID RC_CONFIG_PROFILE RC_CONFIG_PROFILE_ID
RC_CONFIG_SUBSYSTEM_ID RC_CONFIG_SUBSYSTEM RC_CONFIG_SUBSYSTEM_ID




Parent Column in RC_CONFIG_DOCUMENT (PK) Child Table Name Child Column Name
Children: RC_CONFIG_DOCUMENT_ID RC_CONFIG_DOCUMENT ORIG_RC_CONFIG_DOCUMENT_ID


RC_CONFIG_PROFILE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Revenue Cycle Configuration Profile
Definition: This table will define a configuration profile path. Example: revcycle/ares/patientsearch
Table Type: REFERENCE





Column Detail - RC_CONFIG_PROFILE


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.
PROFILE_PATH VARCHAR(500) N Contains the configuration profile path. This path will be the same across all domains.
RC_CONFIG_PROFILE_ID DOUBLE N Unique generated number that identifies a single row on the RC_CONFIG_PROFILE table.
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_CONFIG_PROFILE




Parent Column in RC_CONFIG_PROFILE (PK) Child Table Name Child Column Name
Children: RC_CONFIG_PROFILE_ID RC_CONFIG_DOCUMENT RC_CONFIG_PROFILE_ID


RC_CONFIG_SUBSYSTEM



Column Section Relationship Section Top of Page


Table-level Detail

Description: Revenue Cycle Configuration Subsystem
Definition: This table will define a configuration subsystem or document type. Example: "genesis:infusion-documentation-1.0"
Table Type: REFERENCE





Column Detail - RC_CONFIG_SUBSYSTEM


Column Name Type Null? Definition
RC_CONFIG_SUBSYSTEM_ID DOUBLE N Unique generated number that identifies a single row on the RC_CONFIG_SUBSYSTEM
UNIFORM_RESOURCE_NAME VARCHAR(200) N The name of this subsystem. Can be thought of as the "type" of a configuration document.
UNIFORM_RESOURCE_NAME_KEY VARCHAR(200) N The Key value of the UNIFORM_RESOURCE_NAME column. Contains the value in the UNIFORM_RESOURCE_NAME column in all caps with special characters removed.
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_CONFIG_SUBSYSTEM




Parent Column in RC_CONFIG_SUBSYSTEM (PK) Child Table Name Child Column Name
Children: RC_CONFIG_SUBSYSTEM_ID RC_CONFIG_DOCUMENT RC_CONFIG_SUBSYSTEM_ID