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 |