Table Detail Report
PFT_QUEUE_ITEM
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | ProFit Queue Item |
Definition: | This table stores data representing items within the system that require processing in workflow.. |
Table Type: | ACTIVITY |
Column Detail - PFT_QUEUE_ITEM
Column Name | Type | Null? | Definition |
---|---|---|---|
ACCT_ID | DOUBLE | N | Used to track Accounts throughout Workflow. Foreign Key link to the ACCOUNT table. |
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. |
ACTIVE_STATUS_CD | DOUBLE | N | Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc. |
ACTIVE_STATUS_DT_TM | DATETIME | N | The date and time that the active_status_cd was set. |
ACTIVE_STATUS_PRSNL_ID | DOUBLE | N | The person who caused the active_status_cd to be set or change. |
ACTIVITY_ID | DOUBLE | N | Foreign key from the Trans_log table. This defines a charge, or payment in a batch job. |
AR_BALANCE | DOUBLE | Y | Used for State Based Work Flow queue items when tracking their balances. The current balance of the pft_queue_item. |
AR_BALANCE_DR_CR_FLAG | DOUBLE | Y | Debit/Credit Flag for the AR Balance Column |
ASSIGNED_PRSNL_ID | DOUBLE | N | Personnel currently assigned to the PFT_QUEUE_ITEM. |
BATCH_TRANS_ID | DOUBLE | N | Batch Transaction ID value |
BEG_EFFECTIVE_DT_TM | DATETIME | Y | 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. |
BILLING_ENTITY_ID | DOUBLE | N | Uniquely identifies the billing entity that the work item is associated to. |
BILL_VRSN_NBR | DOUBLE | N | The version number identifying which bill |
BLOB_REF_ID | DOUBLE | N | Unique id from blob_reference table used to relate workflow exceptions to images that enter a queue. |
BO_HP_RELTN_ID | DOUBLE | N | Used to track the history each Benefit Order/Health Plan Relations throughout Workflow. Foreign Key link to the BO_HP_RELTN table |
CONTRIBUTOR_SYSTEM_CD | DOUBLE | N | Contributor system identifies the source feed of data from which a row was populated. This is mainly used to determine how to update a set of data that may have originated from more than one source feed. |
CORSP_ACTIVITY_ID | DOUBLE | N | Correspondence Activity ID value |
CREATED_DT_TM | DATETIME | Y | Used for aging pft_queue_item_hist rows. |
DEPARTMENT_ID | DOUBLE | Y | Stores the department id (prsnl_group_id) that the workitem has been assigned to. |
DEPARTMENT_TYPE_CD | DOUBLE | Y | The type of department assigned to this work item.For Just In Time alone value is filled from pft_wf_process_model table. For other department types value is filled from pft_wf_department_reltn table. |
ENCNTR_ID | DOUBLE | N | Uniquely identifies the related clinical encounter for this item. |
END_EFFECTIVE_DT_TM | DATETIME | Y | 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 | Store event code of the event identifying the work item. |
EVENT_PARAMETER | VARCHAR(200) | Y | String that will hold parameters for action batch jobs setup in Workflow. |
IMPACT_CATEGORY_FLAG | DOUBLE | Y | The impact category. 1-High, 2-Medium, 3-Low |
ITEM_STATUS_CD | DOUBLE | N | Current state of the entity. Pulls item status code from both code sets (4002267 for work items & continuous workflow and 29823 for state & exception queues) |
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. |
LONG_TEXT_ID | DOUBLE | N | Uniquely identifies the related description of an issue. |
OWNER_ID | DOUBLE | N | The workflow item owner. The table from which this ID comes is indicated by the owner_table_name column. The type of owner (Personnel, Guarantor, etc.) is indicated by the owner_type_cd column. |
OWNER_TABLE_NAME | VARCHAR(32) | N | The name of the table from which the owner_id originates. |
OWNER_TYPE_CD | DOUBLE | N | Defines the owner type (Personnel, Guarantor, etc.) |
PENDING_EVENT_CD | DOUBLE | N | Event codes that are only defined for queue items that are waiting for a batch job to execute. |
PERCENTILE_RANK_NBR | DOUBLE | N | The percentile rank of the work item. |
PERSON_ID | DOUBLE | N | The person ID associated to this workflow. |
PFT_BALANCE_ID | DOUBLE | N | This column stores the relationship between the queue item and it's affected balance. |
PFT_ENCNTR_ID | DOUBLE | N | Foreign key reference to a ProFit encounter. |
PFT_ENTITY_STATUS_CD | DOUBLE | N | The status of the information contained in a workflow queue. |
PFT_ENTITY_STATUS_GROUP_CD | DOUBLE | N | The group to which the PFT_QUEUE_ITEM status is related. |
PFT_ENTITY_SUB_STATUS_TXT | VARCHAR(200) | Y | Used to Describe the corresponding substate for the item in Work Flow. |
PFT_ENTITY_TYPE_CD | DOUBLE | N | Type of information contained in a workflow queue. |
PFT_EVENT_OCCUR_LOG_ID | DOUBLE | N | The event occur log ID repsonisble for creating this queue Item. |
PFT_QUEUE_ITEM_ID | DOUBLE | N | Unique identifier for the pft_queue_item table. |
PFT_REPORT_INSTANCE_ID | DOUBLE | N | References PFT_REPORT_INSTANCE |
PFT_WF_ISSUE_ID | DOUBLE | N | The workflow issue id related to this queue item. |
PREV_ASSIGNED_PRSNL_ID | DOUBLE | N | Personnel previously assigned to the PFT_QUEUE_ITEM. |
PRIORITY_ASSESSMENT_TYPE_FLAG | DOUBLE | N | The priority assessment type flag. 0-System, 1-External, 2-Manual |
PRIORITY_FLAG | DOUBLE | N | The work item priority. 1-Critical, 2-High, 3-Medium, 4-Low, 5-Minor |
PRIORITY_RETRY_CNT | DOUBLE | N | The priority assignment retry count. |
PRIORITY_STATUS_FLAG | DOUBLE | Y | The priority status. 1 - In-process, 2 - Complete, 3 - In-error |
PRIORITY_UPDT_DT_TM | DATETIME | Y | This column indicates when the priority is last updated on this work item. |
PROCESS_MSG_TXT | VARCHAR(110) | N | Additional message data associated with any processing job. |
QUEUE_ITEM_STATUS_DT_TM | DATETIME | N | The date and time the status of the queue item was last updated. |
REASON_CD | DOUBLE | N | Applied action code on work item or reason code (CS 4003103) in case system applied action code. |
REFERRAL_EXT_IDENT | DOUBLE | N | Uniquely identifies the related referral for this item. |
RESPONSIBLE_ID | DOUBLE | N | The resolver for this workflow item. The table from which this ID comes is indicated by the responsible_table_name column. The type of owner (Personnel, Guarantor, etc.) is indicated by the owner_type_cd column. |
RESPONSIBLE_PRSNL_ID | DOUBLE | N | Uniquely identifies the related responsible personnel or department associated to an issue. |
RESPONSIBLE_TABLE_NAME | VARCHAR(32) | N | The table from which the resolver(responsible_id) originates. |
RESPONSIBLE_TYPE_CD | DOUBLE | N | The resolver type (personnel, guarantor, etc.) |
REVIEWING_PRSNL_ID | DOUBLE | N | Uniquely Identifies the reviewer associated to an issue. |
SCH_ENTRY_ID | DOUBLE | Y | Uniquely identifies the related scheduling entry for this item. |
SCH_EVENT_ID | DOUBLE | N | Uniquely identifies the related scheduling evento for this item. |
SECONDARY_PRSNL_ID | DOUBLE | N | Contains the ID of the Secondary Owner of the work item when primary owner is Out of Office. |
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. |
URGENCY_CATEGORY_FLAG | DOUBLE | Y | The urgency category. 1-High, 2-Medium, 3-Low |
WI_ASSIGNED_DT_TM | DATETIME | Y | The date and time this work item was triggered. |
WORKITEM_ORIGIN_CD | DOUBLE | N | Stores the origin for the Orok Item created. |
WORK_ITEM_AMT | DOUBLE | N | Contains the work item dollar amount. |
Relationship Detail - PFT_QUEUE_ITEM
Child Column in PFT_QUEUE_ITEM(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ACCT_ID | ACCOUNT | ACCT_ID |
BATCH_TRANS_ID | BATCH_TRANS | BATCH_TRANS_ID | |
BILLING_ENTITY_ID | BILLING_ENTITY | BILLING_ENTITY_ID | |
BLOB_REF_ID | BLOB_REFERENCE | BLOB_REF_ID | |
BO_HP_RELTN_ID | BO_HP_RELTN | BO_HP_RELTN_ID | |
ENCNTR_ID | ENCOUNTER | ENCNTR_ID | |
LOGICAL_DOMAIN_ID | LOGICAL_DOMAIN | LOGICAL_DOMAIN_ID | |
LONG_TEXT_ID | LONG_TEXT | LONG_TEXT_ID | |
PERSON_ID | PERSON | PERSON_ID | |
PFT_BALANCE_ID | PFT_BALANCE | PFT_BALANCE_ID | |
PFT_ENCNTR_ID | PFT_ENCNTR | PFT_ENCNTR_ID | |
PFT_EVENT_OCCUR_LOG_ID | PFT_EVENT_OCCUR_LOG | PFT_EVENT_OCCUR_LOG_ID | |
PFT_REPORT_INSTANCE_ID | PFT_REPORT_INSTANCE | PFT_REPORT_INSTANCE_ID | |
PFT_WF_ISSUE_ID | PFT_WF_ISSUE | PFT_WF_ISSUE_ID | |
RESPONSIBLE_PRSNL_ID | PRSNL | PERSON_ID | |
REVIEWING_PRSNL_ID | PRSNL | PERSON_ID | |
SECONDARY_PRSNL_ID | PRSNL | PERSON_ID | |
DEPARTMENT_ID | PRSNL_GROUP | PRSNL_GROUP_ID | |
SCH_ENTRY_ID | SCH_ENTRY | SCH_ENTRY_ID | |
SCH_EVENT_ID | SCH_EVENT | SCH_EVENT_ID | |
ACTIVITY_ID | TRANS_LOG | ACTIVITY_ID |
PFT_QUEUE_ITEM_HIST
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Contains the profit workflow queue items. |
Definition: | The purpose of this table is to store history for the pft_queue_item table. |
Table Type: | ACTIVITY |
Column Detail - PFT_QUEUE_ITEM_HIST
Column Name | Type | Null? | Definition |
---|---|---|---|
ACCT_ID | DOUBLE | N | Used to track Accounts throughout Workflow. Foreign Key link to the ACCOUNT table. |
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. |
ACTIVE_STATUS_CD | DOUBLE | N | Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc. |
ACTIVE_STATUS_DT_TM | DATETIME | N | The date and time that the active_status_cd was set. |
ACTIVE_STATUS_PRSNL_ID | DOUBLE | N | The person who caused the active_status_cd to be set or change. |
ACTIVITY_ID | DOUBLE | N | Foreign key from the Trans_log table. This defines a charge, or payment in a batch job. |
AR_BALANCE | DOUBLE | Y | Used for State Based Work Flow queue items when tracking their balances. The current balance of the pft_queue_item. |
AR_BALANCE_DR_CR_FLAG | DOUBLE | Y | Debit/Credit Flag for the AR Balance Column |
ASSIGNED_PRSNL_ID | DOUBLE | N | The personnel the workqueue item has been assigned to. |
BATCH_TRANS_ID | DOUBLE | N | Batch Transaction ID value |
BEG_EFFECTIVE_DT_TM | DATETIME | Y | 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. |
BILLING_ENTITY_ID | DOUBLE | N | Uniquely identifies the billing entity to which the work item is associated.. |
BILL_VRSN_NBR | DOUBLE | N | The version number identifying which bill |
BLOB_REF_ID | DOUBLE | N | Unique id from blob_reference table used to relate workflow exceptions to images that enter a queue. |
BO_HP_RELTN_ID | DOUBLE | N | Used to track the history each Benefit Order/Health Plan Relations throughout Workflow. Foreign Key link to the BO_HP_RELTN table |
CONTRIBUTOR_SYSTEM_CD | DOUBLE | N | Contributor system identifies the source feed of data from which a row was populated. This is mainly used to determine how to update a set of data that may have originated from more than one source feed. |
CORSP_ACTIVITY_ID | DOUBLE | N | Correspondence Activity ID value |
CREATED_DT_TM | DATETIME | Y | Used for aging pft_queue_item_hist rows. |
ENCNTR_ID | DOUBLE | N | Uniquely identifies to which encounter this history relates. |
END_EFFECTIVE_DT_TM | DATETIME | Y | 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. |
ITEM_STATUS_CD | DOUBLE | N | This field represents the status or work item for the workflow item. |
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. |
PERSON_ID | DOUBLE | N | The person ID associated to this work flow. |
PFT_BALANCE_ID | DOUBLE | N | This column relates a queue item history to a pft_balance record. |
PFT_ENCNTR_ID | DOUBLE | N | FK to the pft_encntr table. Represenents a financial Encounter |
PFT_ENTITY_STATUS_CD | DOUBLE | N | The status of the information contained in a workflow queue. |
PFT_ENTITY_STATUS_GROUP_CD | DOUBLE | N | The status of the information contained in a workflow queue. |
PFT_ENTITY_SUB_STATUS_TXT | VARCHAR(200) | Y | Used to Describe the corresponding substate for the item in Work Flow. |
PFT_ENTITY_TYPE_CD | DOUBLE | N | Type of information contained in a workflow queue. |
PFT_QUEUE_EVENT_CD | DOUBLE | N | Specifies what the event associated to the queue. |
PFT_QUEUE_EVENT_TYPE_FLAG | DOUBLE | N | Flag to store the type of queue event. ENQUEUE = 1, DEQUEUE = 2 |
PFT_QUEUE_ITEM_HIST_ID | DOUBLE | N | Unique identifier for the pft_queue_item table. |
PFT_REPORT_INSTANCE_ID | DOUBLE | N | References PFT_REPORT_INSTANCE |
PREV_ASSIGNED_PRSNL_ID | DOUBLE | N | Previous assigned personnel person identifier. |
REFERRAL_EXT_IDENT | DOUBLE | N | Uniquely identifies the related referral for this item. |
SCH_ENTRY_ID | DOUBLE | Y | Uniquely identifies the related scheduling entry for this item. |
SCH_EVENT_ID | DOUBLE | N | Uniquely identifies the related scheduling evento for this item. |
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 - PFT_QUEUE_ITEM_HIST
Child Column in PFT_QUEUE_ITEM_HIST(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ACCT_ID | ACCOUNT | ACCT_ID |
BATCH_TRANS_ID | BATCH_TRANS | BATCH_TRANS_ID | |
BILLING_ENTITY_ID | BILLING_ENTITY | BILLING_ENTITY_ID | |
BILL_VRSN_NBR | BILL_REC | BILL_VRSN_NBR | |
CORSP_ACTIVITY_ID | BILL_REC | CORSP_ACTIVITY_ID | |
BLOB_REF_ID | BLOB_REFERENCE | BLOB_REF_ID | |
BO_HP_RELTN_ID | BO_HP_RELTN | BO_HP_RELTN_ID | |
LOGICAL_DOMAIN_ID | LOGICAL_DOMAIN | LOGICAL_DOMAIN_ID | |
PERSON_ID | PERSON | PERSON_ID | |
PFT_ENCNTR_ID | PFT_ENCNTR | PFT_ENCNTR_ID | |
PFT_REPORT_INSTANCE_ID | PFT_REPORT_INSTANCE | PFT_REPORT_INSTANCE_ID | |
SCH_ENTRY_ID | SCH_ENTRY | SCH_ENTRY_ID | |
SCH_EVENT_ID | SCH_EVENT | SCH_EVENT_ID | |
ACTIVITY_ID | TRANS_LOG | ACTIVITY_ID |
PFT_QUEUE_ITEM_WF_HIST
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | ProFit Queue Item Workflow History |
Definition: | This table keeps history of workflow item cycle process. |
Table Type: | ACTIVITY |
Column Detail - PFT_QUEUE_ITEM_WF_HIST
Column Name | Type | Null? | Definition |
---|---|---|---|
ACCOUNTABLE_ENTITY_CD | DOUBLE | N | The code value from code set 4002623 representing the supported accountable entities. For example, personnek, department, guarantor, etc. |
ACCOUNTABLE_ENTITY_ID | DOUBLE | N | Indicates the accountable party for this work item. |
ACCOUNTABLE_PERSON_ID | DOUBLE | N | Indicates the accountable person for this work item. |
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. |
BALANCE | DOUBLE | Y | The balance amount of the entity at the time of perfroming the action. |
BEG_EFFECTIVE_DT_TM | DATETIME | Y | 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. |
BILLING_ENTITY_ID | DOUBLE | N | Uniquely identifies the billing entity to which the work item is associated. |
BILLING_HOLD_CD | DOUBLE | N | The billing hold which is applied on the entity when work the work item is identified. |
CREATED_DT_TM | DATETIME | N | Creation time of the entry in the pft_queue_item table. |
CURRENT_RESPONSIBILITY_FLAG | DOUBLE | N | Indicates where responsibility currently lies. Options: 1- Assessment, 2 - Resolution, 3 - Review |
DEPARTMENT_ID | DOUBLE | Y | Stores the department id (prsnl_group_id) that the workitem has been assigned to. |
DEPARTMENT_TYPE_CD | DOUBLE | Y | The type of department assigned to this work item.For Just In Time alone value is filled from pft_wf_process_model table. For other department types value is filled from pft_wf_department_reltn table. |
END_EFFECTIVE_DT_TM | DATETIME | Y | 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 | Store event code of the event identifying the work item. |
IDENTIFER_PERSON_ID | DOUBLE | N | Indicates the person who identified the work item |
IDENTIFIER_ENTITY_CD | DOUBLE | N | Code value from code set 4002623 representing the supported identifier entities. For example, personnel, department, guarantor, etc. |
IDENTIFIER_ENTITY_ID | DOUBLE | N | Indicates the identifier party of this work. |
IMPACT_CATEGORY_FLAG | DOUBLE | Y | The impact category. 1-High, 2-Medium, 3-Low |
ITEM_STATUS_CD | DOUBLE | N | Code value from code set 4002267 representing the state of the work item |
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. |
LONG_TEXT_ID | DOUBLE | N | This contains a reference to the long_text table. The corresponding long_text column contains the work item's critical attribute values like billing hold. |
OWNER_ID | DOUBLE | N | the workflow item owner. the table from which this id comes is indicated by the owner_table_name column. the type of owner (personnel, guarantor, etc.) is indicated by the owner_type_cd column. |
OWNER_TABLE_NAME | VARCHAR(30) | N | Identifies which table the owner_id is related. (PERSON or HEALTH_PLAN.) |
PARENT_ENTITY_ID | DOUBLE | N | Identifies a record related to the parent_entity_name. |
PARENT_ENTITY_NAME | VARCHAR(32) | N | The table name associated with the entity id. For example, PFT_ENCNTR, BO_HP_RELTN |
PERCENTILE_RANK_NBR | DOUBLE | N | The percentile rank of the work item. |
PFT_ENTITY_STATUS_CD | DOUBLE | N | Indicates the current state for the work item. |
PFT_ENTITY_TYPE_CD | DOUBLE | N | The type of informaiton contained in a workflow queue. |
PFT_QUEUE_ITEM_ID | DOUBLE | N | Uniquely identifies the related queue item. |
PFT_QUEUE_ITEM_WF_HIST_ID | DOUBLE | N | Uniquely identifies a row of history from the PFT_QUEUE_ITEM table. |
PFT_WF_ISSUE_ID | DOUBLE | N | Uniquely identifies the related workflow issue. |
PRIORITY_ASSESSMENT_TYPE_FLAG | DOUBLE | N | The priority assessment type flag. 0-System, 1-External, 2-Manual |
PRIORITY_FLAG | DOUBLE | N | The work item priority. 1-Critical, 2-High, 3-Medium, 4-Low, 5-Minor |
PRIORITY_RETRY_CNT | DOUBLE | N | The priority assignment retry count. |
PRIORITY_STATUS_FLAG | DOUBLE | Y | The priority status. 1 - In-process, 2 - Complete, 3 - In-error |
QUEUE_ITEM_STATUS_DT_TM | DATETIME | N | The date and time the status of the queue item was last updated. |
REASON_CD | DOUBLE | N | Applied action code on work item or reason code (CS 4003103) in case system applied action code. |
RESPONSIBLE_ENTITY_CD | DOUBLE | N | Code value from code set 4002623 representing the supported responsible entities. For example, personnel, department, guarantor, etc. |
RESPONSIBLE_ENTITY_ID | DOUBLE | N | Indicates the responsible party for this work. |
RESPONSIBLE_PERSON_ID | DOUBLE | N | Indicates the responsible person for this work item |
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. |
URGENCY_CATEGORY_FLAG | DOUBLE | Y | The urgency category. 1-High, 2-Medium, 3-Low |
WORKITEM_ORIGIN_CD | DOUBLE | N | Stores the origin for the Orok Item created. |
WORK_ITEM_ACTION_FLAG | DOUBLE | N | Flag indication for supported performed actions on this queue item.1 - identified.2 - Approved3 - Denied4 - Resolved5 - Completed6 - Incompleted7 - Cancelled8 - Reassigned9 - No Action |
WORK_ITEM_AMT | DOUBLE | N | Contains the work item dollar amount. |
Relationship Detail - PFT_QUEUE_ITEM_WF_HIST
Child Column in PFT_QUEUE_ITEM_WF_HIST(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | BILLING_ENTITY_ID | BILLING_ENTITY | BILLING_ENTITY_ID |
LOGICAL_DOMAIN_ID | LOGICAL_DOMAIN | LOGICAL_DOMAIN_ID | |
LONG_TEXT_ID | LONG_TEXT | LONG_TEXT_ID | |
PFT_WF_ISSUE_ID | PFT_WF_ISSUE | PFT_WF_ISSUE_ID | |
DEPARTMENT_ID | PRSNL_GROUP | PRSNL_GROUP_ID |
Parent Column in PFT_QUEUE_ITEM_WF_HIST (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | PFT_QUEUE_ITEM_WF_HIST_ID | PFT_QUEUE_ITEM_WF_RELTN | PFT_QUEUE_ITEM_WF_HIST_ID |
PFT_WF_HIST_REMINDER_RELTN | PFT_QUEUE_ITEM_WF_HIST_ID | ||
TASK_ACTIVITY | PFT_QUEUE_ITEM_WF_HIST_ID |
PFT_QUEUE_ITEM_WF_RELTN
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | ProFit Queue Item Work Flow Relationship |
Definition: | This table stores additional metadata related to work items. |
Table Type: | ACTIVITY |
Column Detail - PFT_QUEUE_ITEM_WF_RELTN
Column Name | Type | Null? | Definition |
---|---|---|---|
PARENT_ENTITY_ID | DOUBLE | N | Contains the identity of the row in the parent entity table that is related to this queue item. |
PARENT_ENTITY_NAME | VARCHAR(30) | N | Uniquely identifies the name of the table related to this queue item. |
PFT_QUEUE_ITEM_WF_HIST_ID | DOUBLE | N | Uniquely identifies the related queue item wf history row involved in this relationship. |
PFT_QUEUE_ITEM_WF_RELTN_ID | DOUBLE | N | Uniquely identifies metadata related to work items. |
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_QUEUE_ITEM_WF_RELTN
Child Column in PFT_QUEUE_ITEM_WF_RELTN(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | PFT_QUEUE_ITEM_WF_HIST_ID | PFT_QUEUE_ITEM_WF_HIST | PFT_QUEUE_ITEM_WF_HIST_ID |
PFT_RULE
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | PFT Rule |
Definition: | This table contains top-level information for each rule (i.e. type, name, description, etc.) |
Table Type: | REFERENCE |
Column Detail - PFT_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. |
ACTIVE_STATUS_CD | DOUBLE | N | Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc. |
ACTIVE_STATUS_DT_TM | DATETIME | N | The date and time that the active_status_cd was set. |
ACTIVE_STATUS_PRSNL_ID | DOUBLE | N | The person who caused the active_status_cd to be set or change. |
BEG_EFFECTIVE_DT_TM | DATETIME | Y | 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 | Y | The date that the record was created in the table. |
CREATE_PRSNL_ID | DOUBLE | N | The person responsible for inserting this row on the table |
END_EFFECTIVE_DT_TM | DATETIME | Y | 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. |
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. |
OBJECT_NAME | VARCHAR(100) | Y | Name of the object to be used in place of rule defined through tool. |
RULE_DESC | VARCHAR(100) | Y | Description of the rule. |
RULE_ID | DOUBLE | N | Unique ID for rule. |
RULE_LONG_TEXT_ID | DOUBLE | N | Logical string used in script to avoid regeneration upon each claim generation. |
RULE_NAME | VARCHAR(50) | N | Name of the rule. |
RULE_SUB_TYPE_CD | DOUBLE | N | Sub-type of rule (i.e. HCFA Standard, State Regulatory, etc.) |
RULE_TYPE_CD | DOUBLE | N | Type of rule (i.e. HCFA 1450: Condition Codes, HCFA 1500, etc.) |
STANDARD_IND | DOUBLE | N | Indicator for whether or not the rule was defined by Cerner as a standard rule. |
STATE_CD | DOUBLE | N | State for which rule is defined. Used only for State Regulatory rules. |
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_RULE
Child Column in PFT_RULE(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | LOGICAL_DOMAIN_ID | LOGICAL_DOMAIN | LOGICAL_DOMAIN_ID |
RULE_LONG_TEXT_ID | LONG_TEXT_REFERENCE | LONG_TEXT_ID | |
CREATE_PRSNL_ID | PRSNL | PERSON_ID |
Parent Column in PFT_RULE (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | RULE_ID | PFT_RULE_ACTION | RULE_ID |
PFT_RULE_GROUP | RULE_ID |