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.