Table Detail Report

PFT_BR_CLAIM_STATUS_DETAIL



Column Section Relationship Section Top of Page


Table-level Detail

Description: ProFit Bill Record Claim Status Detail
Definition: Stores the claim acknowledgments from the payer.
Table Type: ACTIVITY





Column Detail - PFT_BR_CLAIM_STATUS_DETAIL


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.
ADDL_STATUS_INFO_TEXT VARCHAR(1000) Y Stores the additional status information.
BILL_VRSN_NBR DOUBLE N Version number of a bill record.
CORSP_ACTIVITY_ID DOUBLE N Foreign key reference to BILL_REC table.
CREATED_DT_TM DATETIME N The date and time for which this table row is created.
PAYER_CATEGORY_CD DOUBLE N Indicates the general category of a claim's status.
PAYER_CATEGORY_TXT VARCHAR(30) Y Stores the X12 value of the general category of a claim's status.
PAYER_CONTROL_IDENT VARCHAR(50) Y Stores the payer claim control number.
PAYER_ENTITY_CD DOUBLE Y Stores the entity codes.
PAYER_STATUS_CD DOUBLE N These convey the status of an entire claim.
PAYER_STATUS_DT_TM DATETIME Y The date/time of the status codes that sent in from upstream.
PAYER_STATUS_TXT VARCHAR(30) Y Stores the X12 value of the status of an entire claim.
PFT_BR_CLAIM_STATUS_DETAIL_ID DOUBLE N Unique system generated number that identifies a row on the PFT_BR_CLAIM_STATUS_DETAIL table.
TRANSACTION_CONTROL_IDENT VARCHAR(50) N Stores the claim status transaction trace number which is unique for each transaction.
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_BR_CLAIM_STATUS_DETAIL


Child Column in PFT_BR_CLAIM_STATUS_DETAIL(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_BR_CLAIM_STATUS_DETAIL (PK) Child Table Name Child Column Name
Children: PFT_BR_CLAIM_STATUS_DETAIL_ID PFT_BR_LINE_STATUS_DETAIL PFT_BR_CLAIM_STATUS_DETAIL_ID


PFT_BR_EDIT_FAILURE



Column Section Relationship Section Top of Page


Table-level Detail

Description: ProFit Bill Record Edit Failure
Definition: Stores a list of claim scrubbing edit failures for a bill record.
Table Type: ACTIVITY





Column Detail - PFT_BR_EDIT_FAILURE


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.
BILL_VRSN_NBR DOUBLE N Contains the Bill Version Number
BO_HP_RELTN_ID DOUBLE Y Contains the ID of the balance on the BO_HP_RELTN table to which the edit failure is associated.
CORSP_ACTIVITY_ID DOUBLE N Identifies the bill record to which the edit is related.
EDIT_DT_TM DATETIME N The time the edit occurred.
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.
EXTERNAL_GROUP_IDENT VARCHAR(250) N The unique transaction external identifier from the cloud scrubbing service for this edit failure.
EXT_PARTNER_IDENT VARCHAR(250) N The identifier referencing this edit failure at an external claim scrubbing partner.
FAILURE_INSTANCE_SEQ DOUBLE N Indicates the sequence number for this edit failure.
PFT_BR_EDIT_FAILURE_ID DOUBLE N Uniquely identifies a claim scrubbing edit failure for a bill record.
PRSNL_ID DOUBLE N The identifier of the person who initiated the edit.
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_BR_EDIT_FAILURE


Child Column in PFT_BR_EDIT_FAILURE(FK) Parent Table Name Parent Column Name
Parents: BO_HP_RELTN_ID BO_HP_RELTN BO_HP_RELTN_ID
PRSNL_ID PRSNL PERSON_ID




Parent Column in PFT_BR_EDIT_FAILURE (PK) Child Table Name Child Column Name
Children: PFT_BR_EDIT_FAILURE_ID PFT_BR_EDIT_FAILURE_DETAIL PFT_BR_EDIT_FAILURE_ID


PFT_BR_EDIT_FAILURE_DETAIL



Column Section Relationship Section Top of Page


Table-level Detail

Description: ProFit Bill Record Edit Failure Detail
Definition: Stores a list of claim scrubbing detail information for an edit failure for a bill record.
Table Type: ACTIVITY





Column Detail - PFT_BR_EDIT_FAILURE_DETAIL


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.
FAILURE_ALIAS_NAME VARCHAR(40) N The alias for the edit failure error that was returned from the scrubbing service.
FAILURE_ALIAS_NAME_KEY VARCHAR(40) N The indexed alias for the edit failure error that was returned from the scrubbing service.
FAILURE_CATEGORY_CD DOUBLE N Provides information about the category of the edit failure.
FAILURE_CATEGORY_GROUP_CD DOUBLE N This column provides information about the category group of the edit failure.
FAILURE_DESC VARCHAR(2000) Y The description for the edit failure that was returned from the scrubbing service.
LINE_ITEM_INDEX_NBR DOUBLE N The clain line item to which this failure is associated.
PFT_BR_EDIT_FAILURE_DETAIL_ID DOUBLE N Uniquely identifies detail information from the claim scrubbing for an edit failurefor a bill record.
PFT_BR_EDIT_FAILURE_ID DOUBLE N Uniquely identifies the billing record failure to which this detail is related.
PROVIDER_ENROLLMENT_ID DOUBLE N Uniquely identifies the related provider enrollment to which an edit failure detail is related.
RESOLUTION_ACTION_DT_TM DATETIME Y the date time of a resolution action being applied
RESOLUTION_ACTION_FLAG DOUBLE N the indicator denoting the resolution action applied. 0 = Default, 1 = Cancel and Regenerate Claim, 2 = Ignore
RESOLUTION_ACTION_PRSNL_ID DOUBLE N the personnel Id applying the resolution action
SEVERITY_CATEGORY_TEXT VARCHAR(100) Y The severity reason category for the edit failure.
SEVERITY_CD DOUBLE N Contains the severity code of the edit failure.
SEVERITY_TEXT VARCHAR(100) Y *** OBSOLETE *** This field is no longer supported and should not be used.
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_BR_EDIT_FAILURE_DETAIL


Child Column in PFT_BR_EDIT_FAILURE_DETAIL(FK) Parent Table Name Parent Column Name
Parents: PFT_BR_EDIT_FAILURE_ID PFT_BR_EDIT_FAILURE PFT_BR_EDIT_FAILURE_ID
PROVIDER_ENROLLMENT_ID PROVIDER_ENROLLMENT PROVIDER_ENROLLMENT_ID
RESOLUTION_ACTION_PRSNL_ID PRSNL PERSON_ID


PFT_BR_LINE_STATUS_DETAIL



Column Section Relationship Section Top of Page


Table-level Detail

Description: ProFit Bill Record Claim Line Status Detail
Definition: Stores the claim line acknowledgements from the payer.
Table Type: ACTIVITY





Column Detail - PFT_BR_LINE_STATUS_DETAIL


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.
ADDL_STATUS_INFO_TXT VARCHAR(1000) Y Stores additional status information.
CREATED_DT_TM DATETIME Y The date and time this row was created.
PFT_BR_CLAIM_STATUS_DETAIL_ID DOUBLE Y Uniquely identifies the related row on the PFT_BR_CLAIM_STATUS_DETAIL table.
PFT_BR_LINE_STATUS_DETAIL_ID DOUBLE N A system generated number used to uniquely identify a row on the PFT_BR_LINE_STATUS_DETAIL table.
PFT_LINE_ITEM_ID DOUBLE Y Uniquely identifies the related row on the PFT_LINE_ITEM table.
SVC_LINE_ENTITY_CD DOUBLE Y Stores the entity code for the claim line.
SVC_LINE_STATUS_CATEGORY_CD DOUBLE Y Indicates the general category of a claim line status.
SVC_LINE_STATUS_CATEGORY_TXT VARCHAR(30) Y Indicates the general category in a textual format of a claim line status.
SVC_LINE_STATUS_CD DOUBLE Y This code conveys the staus of a claim line item.
SVC_LINE_STATUS_DT_TM DATETIME Y The date and time of the status codes that were sent in from upstream.
SVC_LINE_STATUS_TXT VARCHAR(30) Y Conveys the status of a claim line item in a textual format.
UPDT_APPLCTX DOUBLE Y 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 Y 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 Y 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 Y 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 Y 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_BR_LINE_STATUS_DETAIL


Child Column in PFT_BR_LINE_STATUS_DETAIL(FK) Parent Table Name Parent Column Name
Parents: PFT_BR_CLAIM_STATUS_DETAIL_ID PFT_BR_CLAIM_STATUS_DETAIL PFT_BR_CLAIM_STATUS_DETAIL_ID
PFT_LINE_ITEM_ID PFT_LINE_ITEM PFT_LINE_ITEM_ID


PFT_CHARGE



Column Section Relationship Section Top of Page


Table-level Detail

Description: ProFit Charge
Definition: Represents the fact that a charge has posted into ProFit Billing system.
Table Type: ACTIVITY





Column Detail - PFT_CHARGE


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 FK to the activity_log
ALT_BILLING_AMT DOUBLE N Charge billing amount as calculated using an alternate formula
ALT_BILLING_QTY DOUBLE N Charge quantity as calculated using alternate formula
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.
BE_ORG_ID DOUBLE N FK to the organization table
BILLING_AMOUNT DOUBLE Y This field reflects the total charge amount minus the credit charges made to this charge.
BILLING_ENTITY_ID DOUBLE N FK to the billing_entity table
BILLING_QUANTITY DOUBLE Y This field reflects the total number of items a charge is for minus the credit charges made to this charge.
BO_GEN_IND DOUBLE Y The indicator that describes if the charge group has generated a claim with the charge on it.
CHARGE_ITEM_ID DOUBLE N FK to the charge table
CLIENT_BILL_IND DOUBLE Y Indicates if the charge will be billed for a client account.
CLIENT_ORG_ID DOUBLE N FK to the organization table
COLLECTION_PRIORITY_CD DOUBLE N Describes the priority of collection.
CR_ACCT_ID DOUBLE N The revenue account associated to the charge.
CR_ACCT_TEMPL_ID DOUBLE N The account template assigned to the revenue account.
DR_ACCT_ID DOUBLE N The A/R account associated to the charge.
DR_ACCT_TEMPL_ID DOUBLE N The account template assigned to the A/R account.
ENCNTR_TYPE_CD DOUBLE N Code value indicating the type of encounter (e.g. Inpatient, outpatient).
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_BILLED_IND DOUBLE N Stores the external_billed_ind value - The value is set to 1 if the charge is billed by the external system, 0 otherwise
INST_FIN_NBR_KEY VARCHAR(250) Y The financial number associated to the charges encounter.
INTERFACE_ID DOUBLE N FK to the csi_log
LATE_CHRG_FLAG DOUBLE Y Describes if the charge was posted after billing has begun. 0 = Not a late charge; 1 = debit late charge; 3 = PBM credit late charge; 4 = adjusted late charge; 5 = manual late charge; 7 = credit late charge; 9 = Regenerate all charges
MOVE_CHRG_IND DOUBLE N ** obsolete ** No longer used. Indicates wheather charge moved from one financial encounter to another. ** obsolete **
MV_ORIG_CHRG_ITEM_ID DOUBLE Y This Column will be populated with charge item id of the charge which has been moved for the first time.2. Any other workflow on same charge like move charge, financial combine or encntr_mod will copy the same value which has been persisted for first time.
OFFSET_IND DOUBLE Y Describes if the charge has been offset.
ORIGINAL_UPDT_CNT DOUBLE Y Value of the update count on the inserted row.
PACKAGE_PFT_CHARGE_ID DOUBLE N Uniquely identifies the pft_charge related to this package.
PARENT_ENTITY_ID DOUBLE N Identifies the name of the parent entity.
PATIENT_LOC_CD DOUBLE N Code value identifying the location of the patient.
PFT_CHARGE_ID DOUBLE N Primary Key
PFT_CHARGE_STATUS_CD DOUBLE N Describes the current status of the charge.
PFT_CHARGE_STATUS_REASON_CD DOUBLE N Describes the status reason for the charge.
PFT_ENCNTR_ID DOUBLE N FK to the pft_encntr table
PFT_ENCNTR_IND DOUBLE Y ProFit Encounter Table
REPORT_PRIORITY_CD DOUBLE N Describes the priority of the report.
SERVICE_RESOURCE_CD DOUBLE N Identifies the Service Resource Code related to this record.
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_CHARGE


Child Column in PFT_CHARGE(FK) Parent Table Name Parent Column Name
Parents: CR_ACCT_ID ACCOUNT ACCT_ID
DR_ACCT_ID ACCOUNT ACCT_ID
CR_ACCT_TEMPL_ID ACCT_TEMPLATE ACCT_TEMPL_ID
DR_ACCT_TEMPL_ID ACCT_TEMPLATE ACCT_TEMPL_ID
ACTIVITY_ID ACTIVITY_LOG ACTIVITY_ID
BILLING_ENTITY_ID BILLING_ENTITY BILLING_ENTITY_ID
CHARGE_ITEM_ID CHARGE CHARGE_ITEM_ID
MV_ORIG_CHRG_ITEM_ID CHARGE CHARGE_ITEM_ID
INTERFACE_ID CSI_LOG INTERFACE_ID
BE_ORG_ID ORGANIZATION ORGANIZATION_ID
CLIENT_ORG_ID ORGANIZATION ORGANIZATION_ID
PACKAGE_PFT_CHARGE_ID PFT_CHARGE PFT_CHARGE_ID
PFT_ENCNTR_ID PFT_ENCNTR PFT_ENCNTR_ID




Parent Column in PFT_CHARGE (PK) Child Table Name Child Column Name
Children: PFT_CHARGE_ID CSI_ERROR_LOG PFT_CHARGE_ID
PFT_BALANCE PFT_CHARGE_ID
PFT_BILL_ACTIVITY PFT_CHARGE_ID
PFT_CHARGE PACKAGE_PFT_CHARGE_ID
PFT_CHARGE_BO_RELTN PFT_CHARGE_ID
PFT_CHARGE_GLOBAL_DAYS PFT_CHARGE_ID
PFT_DAILY_BO_HP_CHRG_BAL PFT_CHARGE_ID
PFT_LINE_ITEM_CHRG_RELTN PFT_CHARGE_ID