Table Detail Report

RC_CONT_MODEL_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Revenue Cycle Continuity Model Relationship
Definition: This table groups the models together. It holds data shared across all models in a group.
Table Type: REFERENCE





Column Detail - RC_CONT_MODEL_RELTN


Column Name Type Null? Definition
MODEL_DRAFT_ID DOUBLE N The ID of the draft for this group. There can only be one draft.
PUBLISHED_MODEL_ID DOUBLE N Uniquely identifies the published model for this relationship.
RC_CONT_MODEL_RELTN_ID DOUBLE N Unique generated number that identifies a single row on the rc_cont_model_reltn 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.



Relationship Detail - RC_CONT_MODEL_RELTN


Child Column in RC_CONT_MODEL_RELTN(FK) Parent Table Name Parent Column Name
Parents: MODEL_DRAFT_ID RC_CONT_MODEL RC_CONT_MODEL_ID
PUBLISHED_MODEL_ID RC_CONT_MODEL RC_CONT_MODEL_ID


RC_CONT_NODE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Revenue Cycle Coninuity Node
Definition: A single node in a continuity of flow model.
Table Type: REFERENCE





Column Detail - RC_CONT_NODE


Column Name Type Null? Definition
DISPLAY_DATA_LONG_TEXT_ID DOUBLE N The id where the position json string is stored.
NODE_DISPLAY_NAME VARCHAR(100) N The display name for the node.
PARENT_ENTITY_ID DOUBLE N The ID of the entity to which this process is associated.
PARENT_ENTITY_NAME VARCHAR(30) N The name of the entity to which this process is associated.
RC_CONT_MODEL_ID DOUBLE N Uniquely identifies the model to which this node belongs.
RC_CONT_NODE_ID DOUBLE N Unique generated number that identifies a single row on the rc_cont_node 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.



Relationship Detail - RC_CONT_NODE


Child Column in RC_CONT_NODE(FK) Parent Table Name Parent Column Name
Parents: DISPLAY_DATA_LONG_TEXT_ID LONG_TEXT_REFERENCE LONG_TEXT_ID
RC_CONT_MODEL_ID RC_CONT_MODEL RC_CONT_MODEL_ID




Parent Column in RC_CONT_NODE (PK) Child Table Name Child Column Name
Children: RC_CONT_NODE_ID RC_CONT_NODE_EDGE FROM_RC_CONT_NODE_ID
RC_CONT_NODE_EDGE TO_RC_CONT_NODE_ID
RC_CONT_PROCESS RC_CONT_CURRENT_NODE_ID
RC_CONT_PROCESS_HIST RC_CONT_NODE_ID


RC_CONT_NODE_EDGE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Revenue Cycle Continuity Node Edge
Definition: An edge defined between two nodes in a continuity of flow model.
Table Type: REFERENCE





Column Detail - RC_CONT_NODE_EDGE


Column Name Type Null? Definition
DISPLAY_DATA_LONG_TEXT_ID DOUBLE N Stores long text id for edge coordinates.
FROM_RC_CONT_NODE_ID DOUBLE N The node from which this edge begins.
RC_CONT_MODEL_ID DOUBLE N The model to which this edge belongs.
RC_CONT_NODE_EDGE_ID DOUBLE N Unique generated number that identifies a single row on the rc_cont_node_edge table.
TO_RC_CONT_NODE_ID DOUBLE N The node at which this edge terminates.
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_CONT_NODE_EDGE


Child Column in RC_CONT_NODE_EDGE(FK) Parent Table Name Parent Column Name
Parents: DISPLAY_DATA_LONG_TEXT_ID LONG_TEXT_REFERENCE LONG_TEXT_ID
RC_CONT_MODEL_ID RC_CONT_MODEL RC_CONT_MODEL_ID
FROM_RC_CONT_NODE_ID RC_CONT_NODE RC_CONT_NODE_ID
TO_RC_CONT_NODE_ID RC_CONT_NODE RC_CONT_NODE_ID


RC_CONT_PROCESS



Column Section Relationship Section Top of Page


Table-level Detail

Description: Revenue Cycle Continuity Process
Definition: Current position for an instance of a continuity of flow model.
Table Type: ACTIVITY





Column Detail - RC_CONT_PROCESS


Column Name Type Null? Definition
DELAYED_PROCESS_DT_TM DATETIME Y The timestamp set in the workflow task process (WORKFLOW_TASK_QUEUE table) for delayed processing.
DELAYED_REQUEST_LONG_TEXT_ID DOUBLE Y Long Text Id that stores a request which needs to be enqueued in the workflow task processing (WORKFLOW_TASK_QUEUE table) when the flow is resumed.
DELAYED_TASK_IDENT VARCHAR(250) N Identifies a script that needs to be executed in workflow task processing (WORKFLOW_TASK_QUEUE table).
PARENT_ENTITY_ID DOUBLE N The ID of the entity to which this process is associated.
PARENT_ENTITY_NAME VARCHAR(30) N The name of the entity to which this process is associated.
RC_CONT_CURRENT_NODE_ID DOUBLE N The current node, marking the process' progress through the model.
RC_CONT_PROCESS_GROUP_ID DOUBLE N The Id representing a group of processes on a specific model instance.
RC_CONT_PROCESS_ID DOUBLE N Unique generated number that identifies a single row on the RC_CONT_PROCESS table.
STATUS_CD DOUBLE N The code representing the status of the current process.
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_CONT_PROCESS


Child Column in RC_CONT_PROCESS(FK) Parent Table Name Parent Column Name
Parents: RC_CONT_CURRENT_NODE_ID RC_CONT_NODE RC_CONT_NODE_ID
RC_CONT_PROCESS_GROUP_ID RC_CONT_PROCESS_GROUP RC_CONT_PROCESS_GROUP_ID




Parent Column in RC_CONT_PROCESS (PK) Child Table Name Child Column Name
Children: RC_CONT_PROCESS_ID CONS_BO_SCHED RC_CONT_PROCESS_ID


RC_CONT_PROCESS_GROUP



Column Section Relationship Section Top of Page


Table-level Detail

Description: Revenue Cycle Continuity Process Group
Definition: Data that is common to all processes representing an instance of a continuous workflow model.
Table Type: ACTIVITY





Column Detail - RC_CONT_PROCESS_GROUP


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.
PAUSE_IND DOUBLE N Indicates whether this particular group is paused or not.
PFT_EVENT_OCCUR_LOG_ID DOUBLE N The id of the event occurrence that is unique to this model instance.
PROCESS_CNT DOUBLE N The column stores the value of the number of work items that a model has and updates the value of the counter accordingly (decrements if pbm rules don't qualify)and checks for other child nodes and increments/decrements accordingly
RC_CONT_MODEL_ID DOUBLE N Stores the link to the table which stores workflow model reference data.
RC_CONT_PROCESS_GROUP_ID DOUBLE N Unique generated number that identifies a single row on the RC_CONT_PROCESS_GROUP table.
STATUS_CD DOUBLE N Contains the status of the model instance.
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_CONT_PROCESS_GROUP


Child Column in RC_CONT_PROCESS_GROUP(FK) Parent Table Name Parent Column Name
Parents: PFT_EVENT_OCCUR_LOG_ID PFT_EVENT_OCCUR_LOG PFT_EVENT_OCCUR_LOG_ID
RC_CONT_MODEL_ID RC_CONT_MODEL RC_CONT_MODEL_ID




Parent Column in RC_CONT_PROCESS_GROUP (PK) Child Table Name Child Column Name
Children: RC_CONT_PROCESS_GROUP_ID PFT_ENCNTR RC_CONT_PROCESS_GROUP_ID
RC_CONT_PROCESS RC_CONT_PROCESS_GROUP_ID
RC_CONT_PROCESS_GRP_PAUSE RC_CONT_PROCESS_GROUP_ID
RC_CONT_PROCESS_HIST RC_CONT_PROCESS_GROUP_ID