Table Detail Report
RC_CONT_PROCESS_GRP_PAUSE
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Revenue Cycle Continuity Process Group Pause |
Definition: | This table stores information about when the workflow was paused or resumed for a particular entity. |
Table Type: | ACTIVITY |
Column Detail - RC_CONT_PROCESS_GRP_PAUSE
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. |
PAUSE_DT_TM | DATETIME | Y | Contains the time when the flow was paused. |
RC_CONT_PROCESS_GROUP_ID | DOUBLE | N | Unique generated number that identifies a single row on the rc_cont_process_group table. |
RC_CONT_PROCESS_GRP_PAUSE_ID | DOUBLE | N | Unique generated number that identifies a single row on the RC_CONT_PROCESS_GRP_PAUSE table. |
RESUME_DT_TM | DATETIME | Y | Contains the time when the flow was resumed. |
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_GRP_PAUSE
Child Column in RC_CONT_PROCESS_GRP_PAUSE(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | RC_CONT_PROCESS_GROUP_ID | RC_CONT_PROCESS_GROUP | RC_CONT_PROCESS_GROUP_ID |
RC_CONT_PROCESS_HIST
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Revenue Cycle Continuity Process History |
Definition: | Contains historical data for an instance of a continuity flow model. |
Table Type: | ACTIVITY |
Column Detail - RC_CONT_PROCESS_HIST
Column Name | Type | Null? | Definition |
---|---|---|---|
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. |
PARENT_ENTITY_ID | DOUBLE | N | Contains 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_NODE_ID | DOUBLE | N | The node, marking the process' progress through the model. |
RC_CONT_PROCESS_GROUP_ID | DOUBLE | N | Uniquely identifies the related process group. |
RC_CONT_PROCESS_HIST_ID | DOUBLE | N | Uniquely generated number that identifies a single row on the rc_cont_process_hist table. |
RC_CONT_PROCESS_ID | DOUBLE | N | Uniquely identifies the related continuity process. |
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_HIST
Child Column in RC_CONT_PROCESS_HIST(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | RC_CONT_NODE_ID | RC_CONT_NODE | RC_CONT_NODE_ID |
RC_CONT_PROCESS_GROUP_ID | RC_CONT_PROCESS_GROUP | RC_CONT_PROCESS_GROUP_ID |
RC_RULE
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Revenue Cycle Rule |
Definition: | Store business rules for revenue cycle. |
Table Type: | REFERENCE |
Column Detail - RC_RULE
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. |
CREATE_DT_TM | DATETIME | N | The date and time this row was created. |
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. |
PARENT_ENTITY_ID | DOUBLE | N | Uniquely identifies a row on the table specified by the corresponding PARENT_ENTITY_NAME column. Identifies the table for which this rule was created. |
PARENT_ENTITY_NAME | VARCHAR(30) | N | Identifies the Parent Entity Table for which this rule was created. |
RAW_RULE_LONG_TEXT_ID | DOUBLE | N | Unique identifier for the row on the long_text_reference table where the raw data of the rule is stored. |
RC_RULE_ID | DOUBLE | N | Uniquely identifies a given rule. |
TRSNL_RULE_LONG_TEXT_ID | DOUBLE | N | Stores the translated business rule(machine readable rule). |
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_RULE
Child Column in RC_RULE(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | RAW_RULE_LONG_TEXT_ID | LONG_TEXT_REFERENCE | LONG_TEXT_ID |
TRSNL_RULE_LONG_TEXT_ID | LONG_TEXT_REFERENCE | LONG_TEXT_ID |
WORKFLOW_TASK_PAUSED
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Workflow Task Paused |
Definition: | Stores information for paused workflow tasks. |
Table Type: | ACTIVITY |
Column Detail - WORKFLOW_TASK_PAUSED
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. |
ENTITY_ID | DOUBLE | N | Id of the entity associated to the original task queue row, as was stored in the workflow_task_queue table |
ENTITY_NAME | VARCHAR(30) | N | Name of the entity associated to the original task queue row, as was stored in the workflow_task_queue table |
ORIGINAL_TASK_QUEUE_ID | DOUBLE | N | Id of the original workflor task |
PARENT_ENTITY_ID | DOUBLE | N | The ID of the entity to which this paused task is related |
PARENT_ENTITY_NAME | VARCHAR(30) | N | The name of the entity to which this paused task is related |
PRIORITY_SEQ | DOUBLE | N | priority sequence of the task |
PROCESS_DT_TM | DATETIME | Y | Time when the task would be processed |
QUEUE_STATUS_CD | DOUBLE | N | Status of the task - from code set 4002853 |
REPLY_LONG_TEXT_ID | DOUBLE | N | Id of the long text row where the task reply is stored |
REQUEST_CLOB | LONGTEXT | Y | Used to store the text related to the request for paused task. |
REQUEST_LONG_TEXT_ID | DOUBLE | N | Id of the long text row where the task request is stored |
RETRY_CNT | DOUBLE | N | Number of times task should be retried |
SCRIPT_NAME | VARCHAR(250) | N | The script used to handle the the task |
TASK_DATA_TXT | VARCHAR(100) | N | task data |
TASK_TYPE_FLAG | DOUBLE | N | The flag indicating which type of task is being saved. 1 = reminder; 2 - delay |
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_TASK_PAUSED_ID | DOUBLE | N | PRIMARY KEY |
Relationship Detail - WORKFLOW_TASK_PAUSED
Child Column in WORKFLOW_TASK_PAUSED(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | REPLY_LONG_TEXT_ID | LONG_TEXT | LONG_TEXT_ID |
REQUEST_LONG_TEXT_ID | LONG_TEXT | LONG_TEXT_ID |
WORKFLOW_TASK_QUEUE
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Workflow Task Queue |
Definition: | This table stores the data that is queued up by a given process to be processed at a later time. |
Table Type: | ACTIVITY |
Column Detail - WORKFLOW_TASK_QUEUE
Column Name | Type | Null? | Definition |
---|---|---|---|
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. |
ENTITY_ID | DOUBLE | Y | Uniquely identifies the related Entity |
ENTITY_NAME | VARCHAR(30) | Y | Identifies the Name of the related Entity. |
ORIG_TASK_QUEUE_ID | DOUBLE | N | The original workflow task queue row identifier for grouping historical data. |
PRIORITY_SEQ | DOUBLE | N | The priority sequence for all the rows. The numbering will be from 1 to 3 to determine the priority of the row. |
PROCESS_DT_TM | DATETIME | N | The date and time for this queue item to be picked up for processing. |
QUEUE_STATUS_CD | DOUBLE | N | Dsiplays the status of the task queue item. |
REPLY_LONG_TEXT_ID | DOUBLE | N | Identifies the long text row in which the processing reply is stored. |
REPLY_WF_TASK_QUEUE_LT_ID | DOUBLE | N | Identifies the workflow task queue long text row in which the reply to be processed is stored. |
REQUEST_LONG_TEXT_ID | DOUBLE | N | Identifies the long text row in which the request to be processed is stored. |
REQ_WF_TASK_QUEUE_LT_ID | DOUBLE | N | Identifies the workflow task queue long text row in which the requst to be processed is stored. |
RETRY_CNT | DOUBLE | N | Counter that increments every time an attempt to process fails. |
TASK_DATA_TXT | VARCHAR(100) | Y | Data further describing the task. |
TASK_IDENT | VARCHAR(250) | N | Identifies which task is queued for processing. |
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_TASK_QUEUE_ID | DOUBLE | N | Uniquely identifies a task that is queued for processing. |
Relationship Detail - WORKFLOW_TASK_QUEUE
Child Column in WORKFLOW_TASK_QUEUE(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | REPLY_LONG_TEXT_ID | LONG_TEXT | LONG_TEXT_ID |
REQUEST_LONG_TEXT_ID | LONG_TEXT | LONG_TEXT_ID | |
ORIG_TASK_QUEUE_ID | WORKFLOW_TASK_QUEUE | WORKFLOW_TASK_QUEUE_ID | |
REPLY_WF_TASK_QUEUE_LT_ID | WORKFLOW_TASK_QUEUE_LT | WORKFLOW_TASK_QUEUE_LT_ID | |
REQ_WF_TASK_QUEUE_LT_ID | WORKFLOW_TASK_QUEUE_LT | WORKFLOW_TASK_QUEUE_LT_ID |
Parent Column in WORKFLOW_TASK_QUEUE (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | WORKFLOW_TASK_QUEUE_ID | WORKFLOW_TASK_QUEUE | ORIG_TASK_QUEUE_ID |