Table Detail Report

PFT_BILL_ACTIVITY



Column Section Relationship Section Top of Page


Table-level Detail

Description: ProFit Bill Activity
Definition: Relates bill activity to a benefit order health plan for pre-billing and charge balance evaluation.
Table Type: ACTIVITY





Column Detail - PFT_BILL_ACTIVITY


Column Name Type Null? Definition
ACTIVITY_AMT DOUBLE Y Specifies the amount of a bill activity (Payment, Adjustment, Charge, co-pay, co-insurance, etc.).
ACTIVITY_DT_TM DATETIME N Date and time the bill activity occurred.
ACTIVITY_ID DOUBLE N Identifies the associated transaction from TRANS_LOG
AMT_TYPE_CD DOUBLE N Type of amount (Payment, Adjustment, Charge, co-pay, co-insurance, etc.).
BILLED_DT_TM DATETIME Y Date and time the bill activity occurred.
BILL_ACTIVITY_SUBTYPE_CD DOUBLE N Subtype of activity (Co-Pay, Transfer, etc.)
BILL_ACTIVITY_TYPE_CD DOUBLE N Type of activity (Payment, Adjustment, Balance Forward, etc.)
BILL_VRSN_NBR DOUBLE N Identifies the version of the bill record.
BO_HP_RELTN_ID DOUBLE N The benefit order health plan the charge or bill is related to.
CORSP_ACTIVITY_ID DOUBLE N The related bill record.
PFT_BALANCE_ID DOUBLE N This field uniquely identifies the balance to which this activity is associated.
PFT_BILL_ACTIVITY_ID DOUBLE N Identifies the activity for a bill record
PFT_CHARGE_ID DOUBLE N Identifies the associated charge to the bill record activity.
TRANSFER_AMT DOUBLE Y Amount of transfer (balance transfer), if applicable.
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_BILL_ACTIVITY


Child Column in PFT_BILL_ACTIVITY(FK) Parent Table Name Parent Column Name
Parents: ACTIVITY_ID ACTIVITY_LOG ACTIVITY_ID
BILL_VRSN_NBR BILL_REC BILL_VRSN_NBR
CORSP_ACTIVITY_ID BILL_REC CORSP_ACTIVITY_ID
BO_HP_RELTN_ID BO_HP_RELTN BO_HP_RELTN_ID
PFT_BALANCE_ID PFT_BALANCE PFT_BALANCE_ID
PFT_CHARGE_ID PFT_CHARGE PFT_CHARGE_ID




Parent Column in PFT_BILL_ACTIVITY (PK) Child Table Name Child Column Name
Children: PFT_BILL_ACTIVITY_ID PFT_LINE_ITEM_ACTIVITY PFT_BILL_ACTIVITY_ID


PFT_CA_CRITERIA_VALUE



Column Section Relationship Section Top of Page


Table-level Detail

Description: PFT CA CRITERIA VALUE
Definition: Collection Agency Criteria Values
Table Type: REFERENCE





Column Detail - PFT_CA_CRITERIA_VALUE


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.
CLIENT_NUMBER VARCHAR(20) Y The reference that the collection/precollection agency assigns to the billing entity
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.
EVALUATOR_TXT VARCHAR(250) Y The value that the criteria is to be evaluated upon
EVALUATOR_TYPE DOUBLE Y Value of the type of evaluation used. This enumeration is defines as 0 >, 1 >=, 2 =, 3 <=, 4 < , 5 Is Not Defined , 6 Is Not Defined or Not Equal to Itself
ORDER_SEQ DOUBLE Y Sequence Criteria that was originally entered
PFT_CA_CRITERIA_VALUE_ID DOUBLE N Primary key
PFT_COLLECTION_AGENCY_ID DOUBLE N Foreign Key to PFT_collection_agency table
PFT_TASK_CRITERIA_ID DOUBLE N Foreign Key to the Task_Criteria table
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_CA_CRITERIA_VALUE


Child Column in PFT_CA_CRITERIA_VALUE(FK) Parent Table Name Parent Column Name
Parents: PFT_COLLECTION_AGENCY_ID PFT_COLLECTION_AGENCY PFT_COLLECTION_AGENCY_ID
PFT_TASK_CRITERIA_ID TASK_CRITERIA PFT_TASK_CRITERIA_ID




Parent Column in PFT_CA_CRITERIA_VALUE (PK) Child Table Name Child Column Name
Children: PFT_CA_CRITERIA_VALUE_ID PFT_ENCNTR_COLLECTION_RELTN PFT_CA_CRITERIA_VALUE_ID


PFT_CHILD_CRITERIA



Column Section Relationship Section Top of Page


Table-level Detail

Description: PFT CHILD CRITERIA
Definition: Child table off of the PFT_Hold table
Table Type: REFERENCE





Column Detail - PFT_CHILD_CRITERIA


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.
CHILD_CRITERIA VARCHAR(255) Y Child Criteria Description
CHILD_CRITERIA_CD DOUBLE N Child Criteria Code
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.
MAX_VALUE VARCHAR(100) Y Maximum Value of the criteira
MIN_VALUE VARCHAR(100) Y Minimum Value of the Criteria
PFT_CHILD_CRITERIA_ID DOUBLE N Primary Key to this table
PFT_HOLD_CRITERIA_ID DOUBLE N Foreign key to the PFT_Hold_Criteria table
SEQUENCE DOUBLE Y Sequence of the Child Criteria
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_CHILD_CRITERIA


Child Column in PFT_CHILD_CRITERIA(FK) Parent Table Name Parent Column Name
Parents: PFT_HOLD_CRITERIA_ID PFT_HOLD_CRITERIA PFT_HOLD_CRITERIA_ID


PFT_COLLECTION_AGENCY



Column Section Relationship Section Top of Page


Table-level Detail

Description: PFT COLLECTION AGENCY
Definition: ProFit Collection Agency Table
Table Type: REFERENCE





Column Detail - PFT_COLLECTION_AGENCY


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.
AGENCY_TYPE_CD DOUBLE N Type of agency
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 Foreign Key to Billing Entity table
CLIENT_NUMBER VARCHAR(20) Y The reference that the collection/precollection agency assigns to the billing entity
COLLECTION_PERCENTAGE DOUBLE Y Collection Percentage amount
DEFAULT_IND DOUBLE Y Indicates if this is the default collection agency
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.
EXCLUDE_OUTBOUND_INTERFACE_IND DOUBLE N Indicates if encounters associated to this collections agency or precollections agency for the given billing entity should be excluded from the outbound interface operations job. True(1) indicates the encounters should be excluded. False(0) indicates encounters should be included.
INFO_SEND_FLAG DOUBLE N Info send
MEDIA_TYPE_CD DOUBLE N Media type code from code set
ORGANIZATION_ID DOUBLE N Foreign Key to Organization table
PFT_COLLECTION_AGENCY_ID DOUBLE N Primary Key
SELECTED_TASK_ID DOUBLE N Stores the queue that the user selected to use
SEQUENCE DOUBLE Y Sequence of the collection agencies
THIRD_SELF_FLAG DOUBLE N Third party or Self pay
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.
WRITE_OFF_IND DOUBLE Y Indicates write offs



Relationship Detail - PFT_COLLECTION_AGENCY


Child Column in PFT_COLLECTION_AGENCY(FK) Parent Table Name Parent Column Name
Parents: BILLING_ENTITY_ID BILLING_ENTITY BILLING_ENTITY_ID
ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID




Parent Column in PFT_COLLECTION_AGENCY (PK) Child Table Name Child Column Name
Children: PFT_COLLECTION_AGENCY_ID PFT_CA_CRITERIA_VALUE PFT_COLLECTION_AGENCY_ID


PFT_COMBINE_LOG



Column Section Relationship Section Top of Page


Table-level Detail

Description: PFT COMBINE LOG
Definition: Store the inforamtion related to various ProFit combine processes.
Table Type: ACTIVITY





Column Detail - PFT_COMBINE_LOG


Column Name Type Null? Definition
ACCT_PERSON_RELTN_ID DOUBLE N References to a relation record in the in acct_person_reltn table. This corresponds to the FROM person of the FROM/TO combine pair. This field is left NULL if the FROM person's role type anything other than Guarantor - No longer used
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.
CHARGE_ITEM_ID DOUBLE Y Unique identifier of the charge that was reassociated from charge group to another. It is null for all combine types except Modify Charge Group.
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_ID DOUBLE Y Contains the Encounter Identifier belonging to the from side of the combine.
FROM_XXX_ID DOUBLE N Reference to the person or encounter table.Identiifes the FROM item in the FROM/TO pair of Person/Encounter combine.
PFT_COMBINE_LOG_ID DOUBLE N System generated number used to uniquely identify a row on the PFT_COMBINE_LOG table.
PFT_COMBINE_TYPE_CD DOUBLE N Code value indicating the type of combine (e.g. Person, Encounter etc.)
RESOLVED_DT_TM DATETIME Y The date and time when the combine situation was resolved in ProFit. This gives the date and time when the manual combine (Person or Encounter) within ProFit was completed.
RESOLVED_IND DOUBLE Y Indicator telling whether the combine process within ProFit has been completed. A value of 0 or 1 indicate and incomplete or complete combine respectively.
RESOLVED_PRSNL_ID DOUBLE N Identifies the person who manually completed the combine within ProFit.
RULE_DESC VARCHAR(350) Y The description of the rule/reason that caused the combine/linking.
RULE_IDENT VARCHAR(200) Y The identifier that defines uniqueness of a rule/reason that caused the combine/linking.
RULE_VERSION VARCHAR(200) Y Contains a version number for the rule.
SOURCE_FLAG DOUBLE N Identifies classification of the source feed from which a set of data originated from.
TO_ENCNTR_ID DOUBLE Y Uniquely identifies the related encounter identifier on the to side of the combine.
TO_XXX_ID DOUBLE N Reference to the person or encounter table. Identiifes the TO item in the FROM/TO pair of Person/Encounter combine.
UNCOMBINE_IND DOUBLE Y Indicates that the combine pair needs to be uncombined. 1 indicated that uncombine is needed.
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_COMBINE_LOG


Child Column in PFT_COMBINE_LOG(FK) Parent Table Name Parent Column Name
Parents: CHARGE_ITEM_ID CHARGE CHARGE_ITEM_ID
FROM_ENCNTR_ID ENCOUNTER ENCNTR_ID
TO_ENCNTR_ID ENCOUNTER ENCNTR_ID




Parent Column in PFT_COMBINE_LOG (PK) Child Table Name Child Column Name
Children: PFT_COMBINE_LOG_ID PFT_COMBINE_RULE PFT_COMBINE_LOG_ID