Table Detail Report

PFT_ENCNTR_CODE



Column Section Relationship Section Top of Page


Table-level Detail

Description: PFT ENCNTR CODE
Definition: Encounter codes to be included for billing.
Table Type: ACTIVITY





Column Detail - PFT_ENCNTR_CODE


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.
CODE_ERROR_IND DOUBLE N Indicates that the RUG code or Qualifier is in error
ENCNTR_CODE_DURATION_DAYS DOUBLE N This field indicates the number of days that the encounter code is valid for.
ENCNTR_CODE_ID DOUBLE N This field is the unique identifier for the encounter code table.
ENCNTR_CODE_START_DATE DATETIME N This field contains the active start date for the encounter code.
ENCNTR_CODE_STRING VARCHAR(40) Y This field contains the value for the encounter code.
ENCNTR_CODE_TYPE_FLAG DOUBLE N This field contains a value indicating the type of encounter codfe.
ENCNTR_ID DOUBLE N This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number.
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.
FROM_ENCNTR_CODE_ID DOUBLE N Unique identifier of the from encounter code
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
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_ENCNTR_CODE


Child Column in PFT_ENCNTR_CODE(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
PERSON_ID PERSON PERSON_ID


PFT_ENCNTR_COLLECTION_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: PFT ENCNTR COLLECTION RELTN
Definition: Relation table of Collection activity for a pft encounter
Table Type: ACTIVITY





Column Detail - PFT_ENCNTR_COLLECTION_RELTN


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.
BENEFIT_ORDER_ID DOUBLE Y ** OBSOLETE ** NO LONGER USED. Uniquely identifies the related row on the benefit_order table. ** OBSOLETE **
COLLECTION_STATE_CD DOUBLE N Identifies the collection state (example: ready to send, at agency, returned)
COLL_PERCENTAGE DOUBLE Y The percentage of retrieved money that is owed to the agency.
CONTRIBUTOR_SYSTEM_CD DOUBLE Y 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.
CURRENT_BALANCE DOUBLE N The current balance of the financial encounter.
CURR_BAL_DR_CR_FLAG DOUBLE N Debit/Credit balance indicator
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_BAL_SENT_AMT DOUBLE N Contains the amount of the original balance sent to collections.
ORIG_WRITE_OFF_BAL DOUBLE N The original amount written off to bad debt for a financial encounter.
ORIG_WRITE_OFF_DT_TM DATETIME Y The date and time a financial encounter was written off to bad debt.
PARENT_ENTITY_ID DOUBLE N Foreign key to the table for which this entry points (Collectionagency, prsnl)
PARENT_ENTITY_NAME CHAR(32) N Name of parent entity
PFT_CA_CRITERIA_VALUE_ID DOUBLE N Foreign key to the pft_ca_criteria_value table
PFT_ENCNTR_COLLECTION_R_ID DOUBLE N Unique identifier
PFT_ENCNTR_ID DOUBLE N Foreign key to pft encounter table
RETURN_BALANCE DOUBLE N To capture the financial encounter balance returned from a Collection or Precollection Agency
RETURN_DT_TM DATETIME Y Date that the encounter was returned from the collection agency
SEND_BACK_REASON_CD DOUBLE N Identifies the reason it was sent back from the collection agency (example: bankruptcy, patient deceased, client request return of encntr)
SEND_DT_TM DATETIME Y Date that the encntr was sent to a collection agency
TOTAL_ADJ_AMT DOUBLE N Amount of total adjustment
TOTAL_ADJ_DR_CR_FLAG DOUBLE N Debit/Credit flag for total adjustment
TOTAL_PAYMENT_AMT DOUBLE N Amount of total payment
TOTAL_PAY_DR_CR_FLAG DOUBLE N Debit/Credit flag for total payment
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_ENCNTR_COLLECTION_RELTN


Child Column in PFT_ENCNTR_COLLECTION_RELTN(FK) Parent Table Name Parent Column Name
Parents: BENEFIT_ORDER_ID BENEFIT_ORDER BENEFIT_ORDER_ID
CONTRIBUTOR_SYSTEM_CD CONTRIBUTOR_SYSTEM CONTRIBUTOR_SYSTEM_CD
PFT_CA_CRITERIA_VALUE_ID PFT_CA_CRITERIA_VALUE PFT_CA_CRITERIA_VALUE_ID
PFT_ENCNTR_ID PFT_ENCNTR PFT_ENCNTR_ID


PFT_ENCNTR_FACT



Column Section Relationship Section Top of Page


Table-level Detail

Description: ProFit Encounter Fact
Definition: ProFit encounter fact table persists all active encounters
Table Type: ACTIVITY





Column Detail - PFT_ENCNTR_FACT


Column Name Type Null? Definition
BILLING_ENTITY_ID DOUBLE N Identifies the related Billing Entity for this ENCNTR fact
CLIENT_NUMBER_TXT_KEY VARCHAR(20) Y The textual description of the Client number
COLL_SEND_DT_TM DATETIME Y Date that the ENCOUNTER was sent to a collection agency
DUNNING_LEVEL_CD DOUBLE N Code value indicating collections state that a ProFit encounter is in.
ENCNTR_FIN_CLASS_CD DOUBLE N The financial classification used for a given encounter. Examples may include Worker's Comp, Self Pay, etc.
ENCNTR_ID DOUBLE N Identifies the ENCOUNTER relation to the ENCOUNTER fact.
ENCNTR_TYPE_CD DOUBLE N Categorizes the encounter into a logical group or type. Examples may include inpatient, outpatient, etc.
HEALTH_PLAN_TYPE_CD DOUBLE N Health plan type code identifies the type of health plan. (For example, PPO, HMW, Medicade, Medicare, etc.)
LAST_ADJUSTMENT_AMT DOUBLE N The last adjustment amount made on the ProFit encounter.
LAST_ADJUSTMENT_DT_TM DATETIME Y Date of the last adjustment made against this encounter
LAST_ADJ_SUB_TYPE_CD DOUBLE N Last Adjustment Transaction Sub Type
LAST_PAYMENT_AMT DOUBLE N The last payment amount on the ProFit encounter.
LAST_PAYMENT_DT_TM DATETIME Y Stores the last payment date and time
LAST_PAY_SUB_TYPE_CD DOUBLE N Last Payment Transaction Sub Type
LAST_STMT_DT_TM DATETIME Y Date of the last Statement made against this encounter
PFT_ENCNTR_FACT_ID DOUBLE N Uniquely identifies each ENCOUNTER fact
PFT_ENCNTR_ID DOUBLE N Identifies the associated ENCOUNTER as related to the ENCOUNTER fact
PRE_COLL_SEND_DT_TM DATETIME Y Date that the ENCOUNTER was sent to a collection agency
PRIMARY_HP_ID DOUBLE N The associated primary health plan for this fact
QUALIFIER_CD DOUBLE N Allows a user-defined qualifier to be attached to each ProFit financial encounter.
SECONDARY_HP_ID DOUBLE N The associated secondary health plan for this fact
TERTIARY_HP_ID DOUBLE N The associated tertiary health plan for this fact
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.
VIP_CD DOUBLE N The VIP code indicates for this encounter that the person is to be identified and possibly treated with special consideration during the active time of the encounter. (i.e., employee, board member, famous person).



Relationship Detail - PFT_ENCNTR_FACT


Child Column in PFT_ENCNTR_FACT(FK) Parent Table Name Parent Column Name
Parents: BILLING_ENTITY_ID BILLING_ENTITY BILLING_ENTITY_ID
ENCNTR_ID ENCOUNTER ENCNTR_ID
PRIMARY_HP_ID HEALTH_PLAN HEALTH_PLAN_ID
SECONDARY_HP_ID HEALTH_PLAN HEALTH_PLAN_ID
TERTIARY_HP_ID HEALTH_PLAN HEALTH_PLAN_ID
PFT_ENCNTR_ID PFT_ENCNTR PFT_ENCNTR_ID


PFT_ENCNTR_HIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: PFT ENCNTR HIST
Definition: ProFit's encounter history
Table Type: ACTIVITY





Column Detail - PFT_ENCNTR_HIST


Column Name Type Null? Definition
ACCT_ID DOUBLE N Candidate key reference to an account.
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.
ADJUSTMENT_BALANCE DOUBLE Y Total adjustment balance for financial encounter in history.
ADJ_BAL_DR_CR_FLAG DOUBLE Y Determines if the Balance is a Debit or Credit Balance
APPLIED_PAYMENT_BALANCE DOUBLE Y Total applied payment balance for financial encounter in history.
BAD_DEBT_BALANCE DOUBLE N Bad debt balance on finanical encounter
BAD_DEBT_BAL_DR_CR_FLAG DOUBLE N debit/credit flag for bad_debt_balance field
BALANCE DOUBLE Y Total balance for financial encounter in history.
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 Billing Entity ID
BILL_STATUS_CD DOUBLE N Billing status of an invoice. Examples: Complete, Inprocess, Generated
CHARGE_BALANCE DOUBLE Y Total Charge Balance for financial encounter in history.
CHRG_BAL_DR_CR_FLAG DOUBLE Y Charge Balance Debit Credit Flag for financial encounter in history.0 - Unknown or zero balance.1 - Debit Balance2 - Credit Balance
COL_LETTER_IND DOUBLE N Indicates this financial encounter is excluded from collection letters
COMBINED_INTO_ID DOUBLE N Candidate key reference to a PFT Encounter.
CONSOLIDATION_IND DOUBLE N Indicates this financial encounter is excluded from a consolidation statement
CR_START_DT_TM DATETIME Y stores the start of the cardiac rehab treatment
CR_TOTAL_VISITS DOUBLE Y stores the running total of cardiac rehab treatment visits
DISCH_DT_TM DATETIME Y Discharged Date Time of financial encounter in history.
DR_CR_FLAG DOUBLE Y Flag identifying whether the balance is debit or credit.
DUNNING_HOLD_IND DOUBLE N Indicates if this financial encounter remains at the same dunning level regardless of other criteria
DUNNING_IND DOUBLE N Indicates this financial encounter is exluded from dunning messages
DUNNING_LEVEL_CD DOUBLE N Dunning Level Cd for financial encounter in history.
DUNNING_LEVEL_CHANGE_DT_TM DATETIME Y Date and Time of Dunning Level Change for the financial encounter in history.
DUNNING_LEVEL_CNT DOUBLE Y Dunning Level Count for financial encounter in history.
ENCNTR_ID DOUBLE N This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number.
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_BILLING_IND DOUBLE Y External Billing Indicator for financial encounter in history.
FIN_CLASS_CD DOUBLE N Financial Class Code
GOOD_WILL_IND DOUBLE Y Tells if the ProFit encounter is being paid off timely.
INTERIM_BILL_IND DOUBLE Y Indicates whether or not an encounter qualifies for interim billing.
INTERIM_IND DOUBLE Y Interim Indicator for financial encounter in history.
LAST_ADJUSTMENT_DT_TM DATETIME Y Date of the last adjustment made against this encounter
LAST_CLAIM_DT_TM DATETIME Y Date of the last claim made against this encounter
LAST_PATIENT_PAY_DT_TM DATETIME Y The latest date/time of a patient payment
LAST_STMT_DT_TM DATETIME Y Date of the last Statement made against this encounter
OT_START_DT_TM DATETIME Y stores the start of the occupational therapy treatment
OT_TOTAL_VISITS DOUBLE Y stores the running total of occupational therapy treatment visits
PAYMENT_PLAN_FLAG DOUBLE Y This fields holds a flag value that defines the type of payment plan.
PAYMENT_PLAN_STATUS_CD DOUBLE N This field defines the status of the payment plan
PFT_ENCNTR_HIST_ALIAS VARCHAR(215) Y stores the financial encounter's alias which will be used to identify the financial encounter
PFT_ENCNTR_HIST_ID DOUBLE N Uniquely identifies a historical record of a ProFit encounter.
PFT_ENCNTR_ID DOUBLE N Foreign key reference to a ProFit encounter.
PFT_ENCNTR_STATUS_CD DOUBLE N Active or Pending
PT_START_DT_TM DATETIME Y stores the start of the physical therapy visits
PT_TOTAL_VISITS DOUBLE Y stores the running total of physical therapy treatment visits
RECUR_BILL_GEN_IND DOUBLE Y stores whether or not a bill has been generated for the recurring financial encounter
RECUR_BILL_READY_IND DOUBLE Y stores whether or not a recurring bill is ready to be generated for a financial encounter. Should only be valued if recur_ind = 1
RECUR_CURRENT_MONTH DOUBLE Y stores the value for the current month for recurring billing. Valid values are limited to 1 - 12.
RECUR_IND DOUBLE Y stores whether or not the financial encounter is related to a recurring clinical encounter. Should only be valued if the encounter type class on the clinical encounter is "RECURRING"
RECUR_SEQ DOUBLE Y stores the sequence of the recurring financial encounters. Should only be valued if the recur_ind = 1.
SELF_PAY_EDIT_FLAG DOUBLE Y Values: (0) No edits to self-pay plan (1) Self-pay plan added (2) Self-pay plan removed (3) Self-pay plan out of sequence
SEND_COL_IND DOUBLE N Indicates this financial encounter is exluded from being sent to collections
SLT_START_DT_TM DATETIME Y stores the start of the speech language therapy treatment
SLT_TOTAL_VISITS DOUBLE Y stores the running total of speech language therapy treatment visits
STMT_BILLING_LEVEL_CD DOUBLE Y ** OBSOLETE ** This column is no longer used. This field indicates the level at which statements are billed for the financial encounter. (Ex. Encounter, Balance) ** Obsolete**
UNAPPLIED_PAYMENT_BALANCE DOUBLE Y Total amount of unapplied payments to the account
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_ENCNTR_HIST


Child Column in PFT_ENCNTR_HIST(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID


PFT_EXPCT_ACTUAL_DEF



Column Section Relationship Section Top of Page


Table-level Detail

Description: PFT EXPCT ACTUAL DEF
Definition: Client choice of how to handle expected reimbursement vs. actual reimbursement
Table Type: REFERENCE





Column Detail - PFT_EXPCT_ACTUAL_DEF


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.
BILLING_ENTITY_ID DOUBLE N Foreign key to the billing_entity table
DOLLAR_THRESHOLD_AMT DOUBLE N The dollar threshold that client selects for posting blindly or queueing
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.
HEALTH_PLAN_ID DOUBLE N Foreign key to the health_plan table
PERCENT_THRESHOLD_AMT DOUBLE N The percentage threshold that the client selects for posting blindly or queueing
PERFORMED_ACTION_CD DOUBLE N Defines the action that was performed on these adjustments
PFT_EXPCT_ACTUAL_DEF_ID DOUBLE N Unique identifier for this table
RULE_FLAG DOUBLE N Distinguishes between rules for match and rules for no match
SELECTED_TASK_ID DOUBLE N Foreign key to the selected_task 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 - PFT_EXPCT_ACTUAL_DEF


Child Column in PFT_EXPCT_ACTUAL_DEF(FK) Parent Table Name Parent Column Name
Parents: BILLING_ENTITY_ID BILLING_ENTITY BILLING_ENTITY_ID
HEALTH_PLAN_ID HEALTH_PLAN HEALTH_PLAN_ID