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 |