Table Detail Report

PFT_WF_STATE_ACTION_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: ProFit Workflow State Action Relationship
Definition: This table stores the relationship between different states that the work item can be in, and the respective action code that is applied on that specific state to transition it to another state.
Table Type: REFERENCE





Column Detail - PFT_WF_STATE_ACTION_RELTN


Column Name Type Null? Definition
ACTION_CD DOUBLE N The action code that will transition the work item from its current state.
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.
PFT_ENTITY_STATUS_CD DOUBLE N Represents the state that the work items of this process model can be in.
PFT_WF_PROCESS_MODEL_ID DOUBLE N Uniquely identifies the related ProFit workflow process model.
PFT_WF_STATE_ACTION_RELTN_ID DOUBLE N Uniquely identifies a relationship between the pft_wf_process_model and a pft_entity_status.
PRIORITY_SEQ DOUBLE N Represents the priority sequence for the action code.
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 - PFT_WF_STATE_ACTION_RELTN


Child Column in PFT_WF_STATE_ACTION_RELTN(FK) Parent Table Name Parent Column Name
Parents: PFT_WF_PROCESS_MODEL_ID PFT_WF_PROCESS_MODEL PFT_WF_PROCESS_MODEL_ID


RC_CONT_MODEL



Column Section Relationship Section Top of Page


Table-level Detail

Description: Revenue Cycle Continuity
Definition: Contains model definitions for continuity of flow.
Table Type: REFERENCE





Column Detail - RC_CONT_MODEL


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.
DISPLAY_DATA_LONG_TEXT_ID DOUBLE N The id where the position json string is stored.
LOGICAL_DOMAIN_ID DOUBLE N The unique identifier for a logical domain. This identifier allows the data to be grouped by logical domain. For example, If you assign clients a logical_domain_id this would allow you to store data for multiple clients on this table.
MODEL_BEG_EFF_DT_TM DATETIME N The date that the model will start to be honored in Work Flows
MODEL_DRAFT_IND DOUBLE N Indicates if the model is a draft or published.
MODEL_END_EFF_DT_TM DATETIME N The date that the model will no longer be honored in Work Flows
MODEL_NAME VARCHAR(200) N The name of the model, chosen by the user.
MODEL_NAME_KEY VARCHAR(200) N The name key for the model This will be the original model name and cannot be changed.
RC_CONT_MODEL_ID DOUBLE N Uniquely generated number that identifies a single row on the rc_cont_model table.
TARGETED_DAYS DOUBLE N The column stores the ideal number of days in which the workflow should complete.
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_TYPE_CD DOUBLE N The column stores the workflow type of the model.



Relationship Detail - RC_CONT_MODEL


Child Column in RC_CONT_MODEL(FK) Parent Table Name Parent Column Name
Parents: LOGICAL_DOMAIN_ID LOGICAL_DOMAIN LOGICAL_DOMAIN_ID
DISPLAY_DATA_LONG_TEXT_ID LONG_TEXT_REFERENCE LONG_TEXT_ID




Parent Column in RC_CONT_MODEL (PK) Child Table Name Child Column Name
Children: RC_CONT_MODEL_ID RC_CONT_MODEL_EVENT_RELTN RC_CONT_MODEL_ID
RC_CONT_MODEL_GROUP_R RC_CONT_MODEL_DRAFT_ID
RC_CONT_MODEL_RELTN MODEL_DRAFT_ID
RC_CONT_MODEL_RELTN PUBLISHED_MODEL_ID
RC_CONT_NODE RC_CONT_MODEL_ID
RC_CONT_NODE_EDGE RC_CONT_MODEL_ID
RC_CONT_PROCESS_GROUP RC_CONT_MODEL_ID


RC_CONT_MODEL_EVENT_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Revenue Cycle Continuity Model Event Relation
Definition: This table stores the relation between an event happening in the system and the workflow model.
Table Type: REFERENCE





Column Detail - RC_CONT_MODEL_EVENT_RELTN


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.
EVENT_CD DOUBLE N Stores information about the automated system or user event that happens in the system.
EVENT_MODEL_RELTN_TYPE_FLAG DOUBLE N Stores information about how a particular event is related to the model. The relationship can be a pause, resume, cancel or reset. Based on these relations, the system will take appropriate action.
RC_CONT_MODEL_EVENT_RELTN_ID DOUBLE N Unique, generated number that identifies a single row on the RC_CONT_MODEL_EVENT_RELTN table.
RC_CONT_MODEL_ID DOUBLE N Stores the link to the table which stores workflow model reference data.
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_MODEL_EVENT_RELTN


Child Column in RC_CONT_MODEL_EVENT_RELTN(FK) Parent Table Name Parent Column Name
Parents: RC_CONT_MODEL_ID RC_CONT_MODEL RC_CONT_MODEL_ID


RC_CONT_MODEL_GROUP



Column Section Relationship Section Top of Page


Table-level Detail

Description: Revenue Cycle - Continuity Model Group
Definition: A group of prioritized workflow models.
Table Type: REFERENCE





Column Detail - RC_CONT_MODEL_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.
CREATE_DT_TM DATETIME Y The date and time this record was created.
EVENT_CD DOUBLE N The column stores the event code for the starting event for the models in the group.
MODEL_GROUP_NAME VARCHAR(200) N Contains the name of the group.
MODEL_GROUP_NAME_KEY VARCHAR(200) N The unique key of a given model group name.
RC_CONT_MODEL_GROUP_ID DOUBLE N Unique generated number that identifies a single row on the rc_cont_model_group table.
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_MODEL_GROUP




Parent Column in RC_CONT_MODEL_GROUP (PK) Child Table Name Child Column Name
Children: RC_CONT_MODEL_GROUP_ID RC_CONT_MODEL_GROUP_R RC_CONT_MODEL_GROUP_ID


RC_CONT_MODEL_GROUP_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: Revenue Cycle Continuity Model Group Relationship
Definition: Relates a model group to models.
Table Type: REFERENCE





Column Detail - RC_CONT_MODEL_GROUP_R


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.
ORIG_RC_CONT_MODEL_GROUP_R_ID DOUBLE N Used to track versions of a revenue cycle continuity model group relationship. This field will always point back to the initial value created. This may be used to find the correct version when combined with begin and end effective dates and times.
PRIORITY_SEQ DOUBLE N The priority of the related model in the group. Lower sequence values indicate higher priority. The highest priority model will take precedence when the model group is started, falling back to lower priority models if the business rules don't trigger.
RC_CONT_MODEL_DRAFT_ID DOUBLE N Contains the unique identifier of the related draft model associated with the group.
RC_CONT_MODEL_GROUP_ID DOUBLE N Uniquely identifies the related continuity model group.
RC_CONT_MODEL_GROUP_R_ID DOUBLE N Unique generated number that identifies a single row on the rc_cont_model_group_r 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_GROUP_R


Child Column in RC_CONT_MODEL_GROUP_R(FK) Parent Table Name Parent Column Name
Parents: RC_CONT_MODEL_DRAFT_ID RC_CONT_MODEL RC_CONT_MODEL_ID
RC_CONT_MODEL_GROUP_ID RC_CONT_MODEL_GROUP RC_CONT_MODEL_GROUP_ID
ORIG_RC_CONT_MODEL_GROUP_R_ID RC_CONT_MODEL_GROUP_R RC_CONT_MODEL_GROUP_R_ID




Parent Column in RC_CONT_MODEL_GROUP_R (PK) Child Table Name Child Column Name
Children: RC_CONT_MODEL_GROUP_R_ID RC_CONT_MODEL_GROUP_R ORIG_RC_CONT_MODEL_GROUP_R_ID