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