Table Detail Report

FINANCE_CHRG_CAT



Column Section Relationship Section Top of Page


Table-level Detail

Description: This table stores various finance and interest charges available to Profit.
Definition: Finance Charge Catalog
Table Type: REFERENCE





Column Detail - FINANCE_CHRG_CAT


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.
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.
FINANCE_CHRG_AMT DOUBLE Y Amount of the finance charge.
FINANCE_CHRG_CD DOUBLE N Categorizes the differents charges (Late Fee, Interest, Returned Check Fee..)
FINANCE_CHRG_DESC VARCHAR(250) Y Free text description of the charge.
FINANCE_CHRG_FLAG DOUBLE Y Identifies the charge as either a Finance Charge or Interest Charge.
FINANCE_CHRG_ID DOUBLE N Primary Key
GLOBAL_IND DOUBLE Y Indicates whether this charge is available to all billing entities.
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 - FINANCE_CHRG_CAT




Parent Column in FINANCE_CHRG_CAT (PK) Child Table Name Child Column Name
Children: FINANCE_CHRG_ID PFT_TRANS_RELTN FINANCE_CHRG_ID


HP_GROUP_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: HP GROUP RELTN
Definition: Health Plan Group Relation
Table Type: REFERENCE





Column Detail - HP_GROUP_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 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.
BT_COND_CRIT_R_ID DOUBLE N Bill Template Condition Criteria Relation
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.
HEALTH_PLAN_ID DOUBLE N Health Plan ID
HP_GROUP_R_ID DOUBLE N Health Plan Group Reltn ID
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 - HP_GROUP_RELTN


Child Column in HP_GROUP_RELTN(FK) Parent Table Name Parent Column Name
Parents: BT_COND_CRIT_R_ID BT_COND_CRIT_RELTN BT_COND_CRIT_R_ID
HEALTH_PLAN_ID HEALTH_PLAN HEALTH_PLAN_ID


ORG_GROUP_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Oragnaization Group Relation
Definition: Oragnaization Group Relation
Table Type: REFERENCE





Column Detail - ORG_GROUP_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 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.
BT_COND_CRIT_R_ID DOUBLE N Bill Template Condition Criteria 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.
ORGANIZATION_ID DOUBLE N Organization ID
ORG_GROUP_R_ID DOUBLE N Organization Group Relation ID
ORG_TYPE_CD DOUBLE N Organization Type Code
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 - ORG_GROUP_RELTN


Child Column in ORG_GROUP_RELTN(FK) Parent Table Name Parent Column Name
Parents: BT_COND_CRIT_R_ID BT_COND_CRIT_RELTN BT_COND_CRIT_R_ID
ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID


PE_STATUS_REASON



Column Section Relationship Section Top of Page


Table-level Detail

Description: PE STATUS REASON
Definition: ProFit Encounter Status Reason
Table Type: ACTIVITY





Column Detail - PE_STATUS_REASON


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.
BILL_HOLD_RPTS_SUPPRESS_IND DOUBLE N Indicates whether or not encounter should be included on bill hold reports. 0 - Include encounter on bill hold reports, 1 - Don't include encounter on bill hold reports
BO_HP_RELTN_ID DOUBLE Y Uniquely identifies the bo_hp_reltn to which this hold applies.
CLAIM_SUPPRESS_IND DOUBLE N Indicates whether or not claims should be held for the encounter. 0 - Generate claims, 1 - Hold claims
COLL_SUPPRESS_IND DOUBLE N Indicates whether the hold that it associated with the encounter is to be suppressed from sending to Collections.
CORSP_SUPPRESS_IND DOUBLE Y Indicates whether or not correspondence should be held for the encounter. 0 - generate correspondence1 - hold correspondence
DUNNING_SUPPRESS_IND DOUBLE N Indicates whether the hold that it associated with the encounter should have dunning messages suppressed from the statement.
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.
GUAR_ACCT_ID DOUBLE Y Uniquely identifies the account id of the guarantor for this record.
INSURANCE_BO_ID DOUBLE Y **Obsolete** - no longer used - Uniquely identifies the related benefit order on the benefit_order table. **Obsolete**
PE_HOLD_DT_TM DATETIME Y The date ProFit encounter was put on hold.
PE_RELEASE_DT_TM DATETIME Y The date and time on which the hold on the ProFit encounter was released.
PE_STATUS_REASON_CD DOUBLE N Describes the reason this hold was applied, e.g. standard delay period, waiting for encounter discharge.
PE_STATUS_REASON_ID DOUBLE N Uniquely identifies a ProFit Encounter status reason.
PE_SUB_STATUS_REASON_CD DOUBLE N Provides additional information about the reason for applying this hole. This field is optional.
PFT_BALANCE_ID DOUBLE Y Identifies the associated account with a balance level hold
PFT_ENCNTR_ID DOUBLE N Uniquely identifies the pft_encntr to which this hold has been applied.
PFT_HOLD_ID DOUBLE N FK to the pft_hold table
PRECOLL_SUPPRESS_IND DOUBLE N Indicates whether the hold that it associated with the encounter is to be suppressed from sending to PreCollections.
REASON_COMMENT VARCHAR(40) Y User-defined text comment that gives reason for placing a hold
STMT_SUPPRESS_IND DOUBLE N Indicates whether or not statements should be held for the encounter. 0 - Generate statements, 1 - Hold statements
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 - PE_STATUS_REASON


Child Column in PE_STATUS_REASON(FK) Parent Table Name Parent Column Name
Parents: GUAR_ACCT_ID ACCOUNT ACCT_ID
BO_HP_RELTN_ID BO_HP_RELTN BO_HP_RELTN_ID
PFT_BALANCE_ID PFT_BALANCE PFT_BALANCE_ID
PFT_ENCNTR_ID PFT_ENCNTR PFT_ENCNTR_ID
PFT_HOLD_ID PFT_HOLD PFT_HOLD_ID


PFT_ACCT_FIN_ENCNTR



Column Section Relationship Section Top of Page


Table-level Detail

Description: PFT ACCT FIN ENCNTR
Definition: Profit account financial encounter table used for OMF reporting
Table Type: ACTIVITY





Column Detail - PFT_ACCT_FIN_ENCNTR


Column Name Type Null? Definition
ACCT_ADJ_BALANCE DOUBLE N The balance of adjustments made on the account
ACCT_BALANCE DOUBLE N The balance for the account
ACCT_CHRG_BALANCE DOUBLE N The balance of charges for the account
ACCT_COMBINED_IND DOUBLE Y Indicates whether the account was combined or not
ACCT_COMBINED_INTO_ID DOUBLE N If the account was combined, the id of the account it was combined into
ACCT_ID DOUBLE N The id of the account for this financial encounter
ACCT_LAST_CHRG_DATE DATETIME Y Date of last charge for the account
ACCT_LAST_PAY_DATE DATETIME Y Date of last payment on the account
ACCT_PAY_BALANCE DOUBLE N Balance of payments made on the account
ACCT_STATUS_CD DOUBLE N Contains the current status of the account (in collections, review, active)
ACCT_STATUS_REASON_CD DOUBLE N Stores the reason for the account being in its current status
ACCT_SUB_TYPE_CD DOUBLE N Further defines the account type
ACCT_TEMPL_ID DOUBLE N Account template used to generate the account
ACCT_TYPE_CD DOUBLE N Account type (example: Patient, Cash, Revenue...)
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.
BANKRUPTCY_EFF_DT_TM DATETIME Y If filed for bankruptcy, the beginning effective date of bankruptcy
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 ID of the Billing Entity
BILLING_ENTITY_NAME VARCHAR(100) Y Name of the Billing Entity
CLIENT_ORG_ID DOUBLE N If a client account, the organization ID
CLIENT_ORG_NAME VARCHAR(100) Y If client account, the organization name
CONSOL_METH_CD DOUBLE N Method of consolidation (ex: guarantor by account, guarantor by encounter
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_ACCT_ID_TXT VARCHAR(40) Y Account Alias
INTERIM_IND DOUBLE Y From pft_encntr. Indicates whether or not an encounter qualifies for interim billing.
PATIENT_ID DOUBLE N ID of patient associated with this account and encounter
PATIENT_NAME_FIRST VARCHAR(100) Y First name of the patient associated with this account and encounter
PATIENT_NAME_FIRST_KEY VARCHAR(100) Y First name key of the patient associated with this account and encounter
PATIENT_NAME_FULL VARCHAR(100) Y Full name of the patient associated with this account and encounter
PATIENT_NAME_FULL_KEY VARCHAR(100) Y Full name key of the patient associated with this account and encounter
PATIENT_NAME_LAST VARCHAR(100) Y Last name of the patient associated with this account and encounter
PATIENT_NAME_LAST_KEY VARCHAR(100) Y Last name key of the patient associated with this account and encounter
PAYMENT_PLAN_IND DOUBLE Y Indicates if this is on a payment plan
PE_ACTIVITY_120_BALANCE DOUBLE N 120 day aging balance for financial encounter based on activity date
PE_ACTIVITY_180_PLUS_BALANCE DOUBLE N 180 day aging balance for financial encounter based on activity date
PE_ACTIVITY_30_BALANCE DOUBLE N 30 day aging balance for financial encounter based on activity date
PE_ACTIVITY_60_BALANCE DOUBLE N 60 day aging balance for financial encounter based on activity date
PE_ACTIVITY_90_BALANCE DOUBLE N 90 day aging balance for financial encounter based on activity date
PE_ADJ_BALANCE DOUBLE N Balance of adjustments on the financial encounter
PE_BAD_DEBT_BALANCE DOUBLE N Balance of the bad debt on the financial encounter
PE_BAD_DEBT_DT_TM DATETIME Y If this went to bad debt, the date and time it went
PE_BALANCE DOUBLE N The balance for the financial encounter
PE_CHARGE_BALANCE DOUBLE N The balance of the charges on the financial encounter
PE_COMBINED_IND DOUBLE Y Indicates whether the financial encounter was combined or not
PE_COMBINED_INTO_ID DOUBLE N If the financial encounter was combined, the id of the financial encounter it was combined into.
PE_DISCH_120_BALANCE DOUBLE N 120 day aging balance based on the discharge date
PE_DISCH_180_PLUS_BALANCE DOUBLE N 180 day aging balance based on the discharge date
PE_DISCH_30_BALANCE DOUBLE N 30 day aging balance based on the discharge date
PE_DISCH_60_BALANCE DOUBLE N 60 day aging balance based on the discharge date
PE_DISCH_90_BALANCE DOUBLE N 90 day aging balance based on the discharge date
PE_DNFB_120_BALANCE DOUBLE N 120 day aging balance based on the discharged not final billed date
PE_DNFB_180_PLUS_BALANCE DOUBLE N 180 day aging balance based on the discharged not final billed date
PE_DNFB_30_BALANCE DOUBLE N 30 day aging balance based on the discharged not final billed date
PE_DNFB_60_BALANCE DOUBLE N 60 day aging balance based on the discharged not final billed date
PE_DNFB_90_BALANCE DOUBLE N 90 day aging balance based on the discharged not final billed date
PE_DUNNING_LEVEL_CD DOUBLE N Specifies the status of an account
PE_FIN_CHARGE_BALANCE DOUBLE N The balance of the financel changes for the financial encounter
PE_FIN_CLASS_CD DOUBLE N Financial class
PE_LAST_CHRG_DATE DATETIME Y The date of the last charge for the financial encounter
PE_LAST_PAY_DATE DATETIME Y The date of the last payment for the financial encounter
PE_PAY_BALANCE DOUBLE N The balance of payments made on the financial encounter
PE_PAY_PLAN_STATUS_CD DOUBLE N Status of the payment plan (ex. paid, behind, delinquent)
PE_STATUS_CD DOUBLE N Status of the encounter. Active / Pending
PFT_ACCT_FIN_ENCNTR_ID DOUBLE N Unique identifier of this table
PFT_ENCNTR_ALIAS VARCHAR(40) Y From the pft_encntr. Stores the financial encounter's alias which will be used to identify the financial encounter
PFT_ENCNTR_ID DOUBLE N The id of the encounter associated with this entry
RELATED_ACCT_ID DOUBLE N If joined to a delivery system, the id of 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_ACCT_FIN_ENCNTR


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