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 |