Table Detail Report
RC_CLOUD_SYNC
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Revenue Cycle Cloud Sync |
Definition: | This table is created for the initial master file load sync between millenium and soarian. |
Table Type: | REFERENCE |
Column Detail - RC_CLOUD_SYNC
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVE_IND | DOUBLE | Y | 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. |
ALIAS_POOL_CD | DOUBLE | Y | Contains the code value related to the alias pool |
HEALTH_PLAN_ID | DOUBLE | Y | Uniquely identifies the related Health Plan record. |
LOCATION_CD | DOUBLE | Y | Uniquely identifies the related value in the Location table. |
ORGANIZATION_ID | DOUBLE | Y | Uniquely identifies the related Organization row. |
PAYLOAD_BLOB | LONGBLOB | Y | Contains the serialized non millennium object |
PROCESS_DT_TM | DATETIME | Y | The date and time the row was processed. |
PRSNL_ID | DOUBLE | Y | Uniquely identifies the related PRSNL row. |
RC_CLOUD_SYNC_ID | DOUBLE | N | A system generated number used to uniquely identify a row on the RC_CLOUD_SYNC table. |
REFERENCE_NAME | VARCHAR(255) | Y | The name of the master file to be synced |
UPDT_APPLCTX | DOUBLE | Y | 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 | Y | 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 | Y | 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 | Y | 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 | Y | 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_CLOUD_SYNC
Child Column in RC_CLOUD_SYNC(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | HEALTH_PLAN_ID | HEALTH_PLAN | HEALTH_PLAN_ID |
LOCATION_CD | LOCATION | LOCATION_CD | |
ORGANIZATION_ID | ORGANIZATION | ORGANIZATION_ID | |
PRSNL_ID | PRSNL | PERSON_ID |
RC_CLOUD_TRANSACTION
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Revenue Cycle Cloud Transaction |
Definition: | Used to store information about revenue cycle cloud transactions |
Table Type: | ACTIVITY |
Column Detail - RC_CLOUD_TRANSACTION
Column Name | Type | Null? | Definition |
---|---|---|---|
CORRELATION_UUID | VARCHAR(50) | N | The unique identifier of the revenue cycle cloud transaction (UUID) |
ENCNTR_ID | DOUBLE | Y | Uniquely identifies the related row on the ENCOUNTER table. |
HTTP_METHOD_FLAG | DOUBLE | N | The HTTP method used for the revenue cycle cloud transaction. |
HTTP_STATUS_CODE | DOUBLE | N | The HTTP status code for the revenue cycle cloud transaction. |
PARENT_CORRELATION_UUID | VARCHAR(50) | Y | The correlation universally unique identifier of the parent RevenueCycle cloud transaction associated with this RevenueCycle cloud transaction. |
RC_CLOUD_TRANSACTION_ID | DOUBLE | N | System Generated Identifer created to uniquely identify a row on the RC_CLOUD_TRANSACTION table. |
RESOURCE_URL | LONGTEXT | Y | The URL to which the revenue cycle cloud transaction was sent. |
RETRY_CNT | DOUBLE | N | The number of times the row has been sent for reprocessing. |
SERVICE_CD | DOUBLE | N | The service code used for the revenue cycle cloud transaction. |
STATUS_CD | DOUBLE | N | This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number. |
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_CLOUD_TRANSACTION
Child Column in RC_CLOUD_TRANSACTION(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ENCNTR_ID | ENCOUNTER | ENCNTR_ID |
Parent Column in RC_CLOUD_TRANSACTION (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | RC_CLOUD_TRANSACTION_ID | RC_CLOUD_TRANSACTION_LT | RC_CLOUD_TRANSACTION_ID |
RC_CLOUD_TRANSACTION_LT
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Revenue Cycle Cloud Transaction Long Text |
Definition: | Used to store long text data for requests and replies for revenue cycle cloud transactions |
Table Type: | ACTIVITY |
Column Detail - RC_CLOUD_TRANSACTION_LT
Column Name | Type | Null? | Definition |
---|---|---|---|
LONG_CLOB | LONGTEXT | Y | Used to store large amounts of text. |
LONG_CLOB_FORMAT_FLAG | DOUBLE | N | The format of the long_clob text. |
LONG_CLOB_TYPE_FLAG | DOUBLE | N | The flag representing the type of the long text. |
RC_CLOUD_TRANSACTION_ID | DOUBLE | N | System Generated Identifer created to uniquely identify a row on the RC_CLOUD_TRANSACTION table. |
RC_CLOUD_TRANSACTION_LT_ID | DOUBLE | N | A system generated number to uniquely identify a row on the RC_CLOUD_TRANSACTION_LT table. |
RETRY_CNT | DOUBLE | Y | Represents the retry count of the service when the request was sent. |
TRANSACTION_DT_TM | DATETIME | Y | The date and time the transaction occurred. |
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_CLOUD_TRANSACTION_LT
Child Column in RC_CLOUD_TRANSACTION_LT(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | RC_CLOUD_TRANSACTION_ID | RC_CLOUD_TRANSACTION | RC_CLOUD_TRANSACTION_ID |
RC_TIMELINE
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Revenue cycle Timeline |
Definition: | Stores the information about the activities applied on a person |
Table Type: | ACTIVITY |
Column Detail - RC_TIMELINE
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. |
ACTIVITY_CREATED_DT_TM | DATETIME | Y | The date and time the activity was added. |
ACTIVITY_CREATED_PRSNL_ID | DOUBLE | N | Identifies the person who has applied the activity. |
ACTIVITY_TYPE_CD | DOUBLE | N | This will be used to identify the type of activity. For example, statement cycle change, balance status changed, move charges, workflow, etc. |
APPLIED_TO_CD | DOUBLE | N | This will carry the type of entity to which this activity is associated . Example : ENCOUNTER, PERSON etc . |
APPLIED_TO_TXT | VARCHAR(200) | Y | This will contain a concatenated string with the entity details. |
CHILD_PARENT_ENTITY_ID | DOUBLE | N | The entity of the comment/activity undergone in a financial combine/uncombine |
CHILD_PARENT_ENTITY_NAME | VARCHAR(30) | N | The entity of the comment/activity undergone in a financial combine/uncombine. |
COMMENT_CLOB | LONGTEXT | Y | User entered comments which need to be displayed in the comment section. |
DESCRIPTION_TXT | VARCHAR(1500) | Y | Textual description of the activity applied. |
PARENT_ENTITY_ID | DOUBLE | N | The idnentifier fo the entity to which the activity is applied. |
PARENT_ENTITY_NAME | VARCHAR(30) | N | The name of the entity of the comment/activity |
PRIORITY_NBR | DOUBLE | Y | This will be the importance level of the comment. |
RC_TIMELINE_ID | DOUBLE | N | Unique generated number that identifies a single row on the RC_TIMELINE table. |
SOLUTION_CD | DOUBLE | N | This will carry solution names like Registtration, Scheduling, HIM, Care Management, CPA |
SOURCE_REFERENCE_IDENT | VARCHAR(64) | Y | The identifier for the source system from which the activity is applied. |
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. |
WORKFLOW_CATEGORY_CD | DOUBLE | Y | Contains the value of the workflow model type. |
Relationship Detail - RC_TIMELINE
Child Column in RC_TIMELINE(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ACTIVITY_CREATED_PRSNL_ID | PRSNL | PERSON_ID |
RC_TIMELINE_MIGRATION
Column Section | Top of Page |
Table-level Detail
Description: | Revenue Cycle Timeline Migration |
Definition: | The table stores the entities for which migration has taken place. |
Table Type: | ACTIVITY |
Column Detail - RC_TIMELINE_MIGRATION
Column Name | Type | Null? | Definition |
---|---|---|---|
FAILURE_CNT | DOUBLE | Y | This field indicates how many times the data migration had failed for a patient. |
FAILURE_REASON_TEXT | LONGTEXT | Y | This field stores the failure reason for the data migration. |
MIGRATION_IND | DOUBLE | N | This will contain information whether migration is completed or not. |
MIGRATION_LEVEL_NBR | DOUBLE | N | This column defines the level of the migration for a parent_entity_id and solution_cd. |
PARENT_ENTITY_ID | DOUBLE | N | The identifier of the entity for which migration has taken place. |
PARENT_ENTITY_NAME | VARCHAR(30) | N | The name of the related parent entity. |
RC_TIMELINE_MIGRATION_ID | DOUBLE | N | Unique generated number that identifies a single row on the RC_TIMELINE_MIGRATION table. |
SOLUTION_CD | DOUBLE | N | This will carry solution names like Registration, Scheduling, HIM, Care Management, CPA |
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. |