Table Detail Report

PFT_HP_COV_SCH_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: PFT HP COV SCH RELTN
Definition: Stores the relationship between health plan and covered/non-covered schedules
Table Type: REFERENCE





Column Detail - PFT_HP_COV_SCH_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.
BILLING_ENTITY_ID DOUBLE N Foreign Key to the Billing_Entity table.
ENCNTR_TYPE_CD DOUBLE N This is the encounter type code
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
PFT_HP_COV_SCH_RELTN_ID DOUBLE N Unique key
SCHEDULE_CD DOUBLE N Stores the schedule that the health plan is related to
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_HP_COV_SCH_RELTN


Child Column in PFT_HP_COV_SCH_RELTN(FK) Parent Table Name Parent Column Name
Parents: HEALTH_PLAN_ID HEALTH_PLAN HEALTH_PLAN_ID


PFT_HP_MEDIA_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Stores media types needed for each Health_Plan instead of firing off a rule.
Definition: Stores media types needed for each Health_Plan instead of firing off a rule every time we gen a claim to see what media type it goes out on.
Table Type: REFERENCE





Column Detail - PFT_HP_MEDIA_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.
BATCH_ROUTE_IDENT VARCHAR(100) N Identifies the batch route used to send electronic claims.
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
BILL_TYPE_CD DOUBLE N Code value for the bill type
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.
MEDIA_SUB_TYPE_CD DOUBLE N The Media sub type of the claim.
MEDIA_TYPE_CD DOUBLE N Media type code from code set
PARENT_ENTITY_ID DOUBLE N Id to the table identified in parent entity name
PARENT_ENTITY_NAME VARCHAR(250) N Table referenced by the parent entity id
PFT_HP_MEDIA_RELTN_ID DOUBLE N Unique identifier of this table
PRIORITY_SEQ DOUBLE N The sequence of the priority for this row
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_HP_MEDIA_RELTN


Child Column in PFT_HP_MEDIA_RELTN(FK) Parent Table Name Parent Column Name
Parents: BILLING_ENTITY_ID BILLING_ENTITY BILLING_ENTITY_ID


PFT_LINE_ITEM



Column Section Relationship Section Top of Page


Table-level Detail

Description: ProFit Line Item
Definition: Stores Line Item data from a claim.
Table Type: ACTIVITY





Column Detail - PFT_LINE_ITEM


Column Name Type Null? Definition
BILL_TYPE_CD DOUBLE N Identifies type of bill
BILL_VRSN_NBR DOUBLE N Identifies the Version Number of the Claim
CORSP_ACTIVITY_ID DOUBLE N Internal number to identify claim
DESCRIPTION VARCHAR(100) Y Description of the revenue code for this line on the claim
FROM_SERVICE_DT_TM DATETIME Y From Service Date of the charges on this line of the claim
LINE_ITEM_IDENT VARCHAR(20) Y Contains the reference id for the line item on the claim. This column is in the format of nnnnn-rrr where the nnnnn represents the claim number and the sss is a randomly generated number.
LINE_NBR DOUBLE Y Line number of the given line on a claim
MODIFIER_FLAG DOUBLE Y Identifies if the modifier_value is a nomenclature_id or a code value
MODIFIER_VALUE DOUBLE Y Charge Modifier for this line or charge on the claim
NONCOVERED_CHARGES DOUBLE Y Total Non-Covered Charge Amount for this line on the claim
PAGE_NBR DOUBLE Y Page number of the give line on a claim
PFT_LINE_ITEM_ID DOUBLE N Uniquely identifies a line item data from a claim.
PROCEDURE_CODE DOUBLE Y Procedure Code for this line on the claim
REVENUE_CD DOUBLE N Revenue code identified for this line on the claim
TOTAL_ADJUSTMENTS DOUBLE N Total adjustments that have been applied to this charge
TOTAL_CHARGES DOUBLE Y Total charge amount for this line on the claim
TOTAL_PAYMENTS DOUBLE N Total Payments that have been applied to this charge
TOTAL_UNITS DOUBLE Y Units or days of service for this line on the claim
TO_SERVICE_DT_TM DATETIME Y To service date of charges on this line of the claim
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.
VARIANCE_AMT DOUBLE N Differences between estimated and actual reimbursement.



Relationship Detail - PFT_LINE_ITEM


Child Column in PFT_LINE_ITEM(FK) Parent Table Name Parent Column Name
Parents: BILL_VRSN_NBR BILL_REC BILL_VRSN_NBR
CORSP_ACTIVITY_ID BILL_REC CORSP_ACTIVITY_ID




Parent Column in PFT_LINE_ITEM (PK) Child Table Name Child Column Name
Children: PFT_LINE_ITEM_ID BATCH_TRANS_FILE PFT_LINE_ITEM_ID
DENIAL PFT_LINE_ITEM_ID
PFT_BR_LINE_STATUS_DETAIL PFT_LINE_ITEM_ID
PFT_LINE_ITEM_CHRG_RELTN PFT_LINE_ITEM_ID
PFT_LINE_ITEM_DETAIL PFT_LINE_ITEM_ID


PFT_LINE_ITEM_ACTIVITY



Column Section Relationship Section Top of Page


Table-level Detail

Description: ProFit Line Item Activity
Definition: Relates activity (Payments, Adjustments, Balance Forwards of other Invoices) from PFT_BILL_ACTIVITY to a Bill
Table Type: ACTIVITY





Column Detail - PFT_LINE_ITEM_ACTIVITY


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 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.
BILL_VRSN_NBR DOUBLE N Version number of a bill record
CORSP_ACTIVITY_ID DOUBLE N The related bill record.
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.
PFT_BILL_ACTIVITY_ID DOUBLE N Identifies the activity for a bill record
PFT_LINE_ITEM_ACTIVITY_ID DOUBLE N Identifies related activity (Payments, Adjustments, Balance Forwards of other Invoices) between the Bill and Bill Activity
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_LINE_ITEM_ACTIVITY


Child Column in PFT_LINE_ITEM_ACTIVITY(FK) Parent Table Name Parent Column Name
Parents: BILL_VRSN_NBR BILL_REC BILL_VRSN_NBR
CORSP_ACTIVITY_ID BILL_REC CORSP_ACTIVITY_ID
PFT_BILL_ACTIVITY_ID PFT_BILL_ACTIVITY PFT_BILL_ACTIVITY_ID


PFT_LINE_ITEM_CHRG_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: ProFit Line Item Charge Relationship
Definition: Stores the relationship of charges to line items.
Table Type: ACTIVITY





Column Detail - PFT_LINE_ITEM_CHRG_RELTN


Column Name Type Null? Definition
PFT_CHARGE_ID DOUBLE N Identifies the relationship to the PFT_CHARGE table
PFT_LINE_ITEM_CHRG_RELTN_ID DOUBLE N Uniquely identifies the charge for a specific line item
PFT_LINE_ITEM_ID DOUBLE N Identifies the relationship to the PFT_LINE_ITEM 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_LINE_ITEM_CHRG_RELTN


Child Column in PFT_LINE_ITEM_CHRG_RELTN(FK) Parent Table Name Parent Column Name
Parents: PFT_CHARGE_ID PFT_CHARGE PFT_CHARGE_ID
PFT_LINE_ITEM_ID PFT_LINE_ITEM PFT_LINE_ITEM_ID