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