Table Detail Report

PFT_SEL_TASK_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: Profit Selected Task Relation
Definition: Identifies the related entity type and id to a specific selected task that was created in the navagation tool.
Table Type: REFERENCE





Column Detail - PFT_SEL_TASK_R


Column Name Type Null? Definition
ACTIVE_IND DOUBLE Y 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 Y 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 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 Related Entity ID (from prsnl or billing_entity table)
PARENT_ENTITY_NAME VARCHAR(32) N Related Entity (prsnl, be, prsnlgroup)
PFT_SEL_TASK_R_ID DOUBLE N Unique identifier of the table
SELECTED_TASK_ID DOUBLE N Foreign key to the selected_task table
TASK_OWNER_AUTH_FLAG DOUBLE Y Defines if the current personnel can change the owner of this task- this is only used when working with Push
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_SEL_TASK_R


Child Column in PFT_SEL_TASK_R(FK) Parent Table Name Parent Column Name
Parents: SELECTED_TASK_ID SELECTED_TASK SELECTED_TASK_ID


PFT_SURCHARGE_ENABLED



Column Section Top of Page


Table-level Detail

Description: ProFit Surcharge Enabled
Definition: Contains information about entities related to a surcharge
Table Type: REFERENCE





Column Detail - PFT_SURCHARGE_ENABLED


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.
PARENT_ENTITY_ID DOUBLE N Contains the reference to the ID of the parent entity name
PARENT_ENTITY_NAME VARCHAR(30) N Name of the parent entity.
PFT_SURCHARGE_ENABLED_ID DOUBLE N Unique generated number that identifies a single row on the pfr_surcharge_enabled.
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.


PFT_SYSTEM_ACTIVITY_LOG



Column Section Relationship Section Top of Page


Table-level Detail

Description: Patient Accounting System Activity Log
Definition: Stores general logging information for patient accounting processes.
Table Type: ACTIVITY





Column Detail - PFT_SYSTEM_ACTIVITY_LOG


Column Name Type Null? Definition
COMPLETION_MSG VARCHAR(250) N The message returned from the reply block of the task.
CURRENT_NODE_NAME VARCHAR(100) N The name of the node of the executed task.
CURRENT_PROCESS_NAME VARCHAR(100) N Contains the name of the process which is executing the task.
ENCNTR_ID DOUBLE N Uniquely identifies the related Encounter record.
END_DT_TM DATETIME Y The end time of the executed task.
ENTITY_ID DOUBLE N Uniquely identifies a row on the related entity name.
ENTITY_NAME VARCHAR(30) N Identifies the related entity.
EXECUTION_DURATION_SECS DOUBLE N The time it took for the script to execute.
FINAL_STATUS_CD DOUBLE N The final status code that is givien back from the reply block of the task.
LOC_FACILITY_CD DOUBLE N Code value of the facility location.
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.
ORGANIZATION_ID DOUBLE N Uniquely identifies the related organization.
PERSON_ID DOUBLE N Uniquely identifies the related Person record.
PFT_EVENT_OCCUR_LOG_ID DOUBLE N Uniquely identifies the related pft_event_occur_log record.
PFT_SYSTEM_ACTIVITY_LOG_ID DOUBLE N Unique generated number that identifies a single row on the PFT_SYSTEM_ACTIVITY_LOG table.
SERVER_NAME VARCHAR(100) N Name of the server of the executed task.
START_DT_TM DATETIME Y The start time of the executed task.
TASK_NAME VARCHAR(30) N The task that workflow task process performed.
TIMER_IDENT VARCHAR(100) N Used to persist the timer information.
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_SYSTEM_ACTIVITY_LOG


Child Column in PFT_SYSTEM_ACTIVITY_LOG(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
LOGICAL_DOMAIN_ID LOGICAL_DOMAIN LOGICAL_DOMAIN_ID
ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID
PERSON_ID PERSON PERSON_ID
PFT_EVENT_OCCUR_LOG_ID PFT_EVENT_OCCUR_LOG PFT_EVENT_OCCUR_LOG_ID


PFT_TOOLS



Column Section Top of Page


Table-level Detail

Description: PFT TOOLS
Definition: Stores the information related to the ProFit tools.
Table Type: REFERENCE





Column Detail - PFT_TOOLS


Column Name Type Null? Definition
ACTIVE_IND DOUBLE Y 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 Y 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.
DISPLAY_NAME VARCHAR(250) Y The tool name to be displayed.
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.
ENTRY_POINT VARCHAR(250) Y Entry Point
ICON_KEY VARCHAR(250) Y Icon key
PFT_TOOLS_ID DOUBLE N Primary key
TOOL_TIP_TEXT VARCHAR(250) Y Tool tip text
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.


PFT_TRANSACTION



Column Section Relationship Section Top of Page


Table-level Detail

Description: PFT TRANSACTION
Definition: Profit transaction table for OMF reporting
Table Type: ACTIVITY





Column Detail - PFT_TRANSACTION


Column Name Type Null? Definition
ACTIVE_IND DOUBLE Y 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 Y 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 References entry to activity table
BATCH_DESC VARCHAR(100) Y If it was in a batch, a description of what batch
BATCH_TRANS_ID DOUBLE N If it was in a batch, the id of the batch
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.
BENEFIT_ORDER_ID DOUBLE N References an entry on the benefit order table
BILLED_IND DOUBLE Y Indicates whether or not it has been put on a bill
BILLING_ENTITY_ID DOUBLE N References an entry on the billing entity table
BILLING_ENTITY_NAME VARCHAR(100) Y The name of the billing entity
BILLING_ENTITY_ORG_ID DOUBLE N References an entry on the billing entity organization table
BILLING_ENTITY_ORG_NAME VARCHAR(100) Y The billing entity organization name
BILL_ALIAS VARCHAR(100) Y The bill alias
BILL_VRSN_NBR DOUBLE Y The version number identifying which bill
CC_AUTH_NBR VARCHAR(100) Y Credit card authorization number
CC_BEG_EFF_DT_TM DATETIME Y Credit card beginning effective date
CC_END_EFF_DT_TM DATETIME Y Credit card ending effective date
CHARGE_ITEM_ID DOUBLE N References an entry on the charge table
CHECK_DATE DATETIME Y The date of the check if paid by check
CORSP_ACTIVITY_ID DOUBLE N References the id of the bill
CR_ACCT_ID DOUBLE N References credit account id
CURRENT_CUR_CD DOUBLE N Current currency type
DR_ACCT_ID DOUBLE N References the debit account ID
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.
EXT_CR_ACCT_ID_TXT VARCHAR(40) Y Alias for the credit account id
EXT_DR_ACCT_ID_TXT VARCHAR(40) Y Alias for the debit account id
GEN_LEDG_POSTED_IND DOUBLE Y Indicates whether or not it has been posted to the general ledger
ORIGINAL_CUR_CD DOUBLE N Original currency type
PAYMENT_METH_CD DOUBLE N payment method
PAYMENT_NUM_DESC VARCHAR(255) Y Payment number description (ex. the check number if paid by chec, the credit card number if paid by a credit card)
PAYOR_NAME VARCHAR(100) Y The name of the payor
PAYOR_ORG_ID DOUBLE N The payor ID if it is an organization
PAYOR_ORG_NAME VARCHAR(100) Y The payor name if it is an organization
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
PERSON_NAME_FULL VARCHAR(100) Y Person name if paid by a person
PFT_CHARGE_ID DOUBLE N References the pft_charge table
PFT_ENCNTR_ALIAS VARCHAR(100) Y Financial encounter alias
PFT_ENCNTR_ID DOUBLE N References an entry on the pft encntr table
PFT_TRANSACTION_ID DOUBLE N Unique identifier for this table
POSTED_DT_TM DATETIME Y Date and time posted to the system
POSTING_METH_CD DOUBLE N Posted method (ex: LIFO, FIFO, or Distributed)
SUPPRESSION_FLAG DOUBLE Y Indicates whether to suppress for printing and or viewing on claim, statement, power account or all
TOTAL_TRANS_AMOUNT DOUBLE N Total amount of transaction
TPM_ID DOUBLE N References an entry for a transaction posting matrix rule for this transaction
TRANS_ALIAS_ID DOUBLE N Alias for combination of trans_type_cd, trans_sub_type_cd and trans_reason_cd
TRANS_REASON_CD DOUBLE N Code value identifying the transaction reason.
TRANS_SUB_TYPE_CD DOUBLE N Transaction sub type code value
TRANS_TYPE_CD DOUBLE N Transaction type code value
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.
USERNAME VARCHAR(50) Y The username of the person who posted the transaction.



Relationship Detail - PFT_TRANSACTION


Child Column in PFT_TRANSACTION(FK) Parent Table Name Parent Column Name
Parents: PERSON_ID PERSON PERSON_ID