Table Detail Report

PFT_DENIAL_CODE_REF



Column Section Relationship Section Top of Page


Table-level Detail

Description: Stores information related to each HIPPA related Denial code in the system.
Definition: This table store information related to each HIPPA related Denial code in the system.
Table Type: REFERENCE





Column Detail - PFT_DENIAL_CODE_REF


Column Name Type Null? Definition
AUTOWRITEOFF_IND DOUBLE N If the value is 1 then this denial will cause the associated claim to be written off.
DENIAL_CD DOUBLE N Denial Code
DENIAL_GROUP_CD DOUBLE N Grouping mechanism for the Denial codes.
DENIAL_TYPE_CD DOUBLE N This defines the base type of the denial code. Provider, Patient, Technical, Information Only
DIRECT_TO_NON_AR_IND DOUBLE N The indicator denoting a transaction is posted directly to non Account Receivable.
LOGICAL_DOMAIN_ID DOUBLE N The unique identifier for a logical domain. This identifier allows the data to be grouped by logical domain. For example, If you assign clients a logical_domain_id this would allow you to store data for multiple clients on this table.
PFT_DENIAL_CODE_REF_ID DOUBLE N Unique Identifier
POST_NO_POST_METHOD_FLAG DOUBLE N The transaction posting method flag 0 - post primary, post secondary, post tertiary; 1 - no post primary, no post secondary, no post tertiary; 2 - post primary, no post secondary, post tertiary; 3 - post primary, no post secondary, no post tertiary; 4 - post primary, post secondary, no post tertiary; 5 - no post priamry, no post secondary, post tertiary; 6 - no post primary, post secondary, no post tertiary; 7 - no post primary, post secondary, post tertiary
PRIORITY_LEVEL DOUBLE N Ranking mechanism for Denial Decision making process.
PROCESS_IND DOUBLE N If the value is 1 then this denial should process as specified by its denial_type_cd, 0 will behave as if it is an information only denial.
REVERSE_EXPECTED_IND DOUBLE N The indicator denoting a transaction reversal is expected.
TRANS_ALIAS_CD DOUBLE N If this denial code causes write-offs, this is the Transaction Alias to use for the write-off 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.
X12_CODE VARCHAR(250) N Custom X12 Alias for denial code



Relationship Detail - PFT_DENIAL_CODE_REF


Child Column in PFT_DENIAL_CODE_REF(FK) Parent Table Name Parent Column Name
Parents: LOGICAL_DOMAIN_ID LOGICAL_DOMAIN LOGICAL_DOMAIN_ID


PFT_FEE_SCHED_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Profit Fee Schedule Relationship
Definition: Provides necessary relationship between a price schedule and a bill item modifier row for fee schedules.
Table Type: REFERENCE





Column Detail - PFT_FEE_SCHED_RELTN


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 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_CODE_TYPE_FLAG DOUBLE N Flag value that identifies the type of bill code represented by the Bll_item_modifier record. Valid flag values are: 1 = CPT4 Code , 2 = Modifier
BILL_ITEM_MOD_ID DOUBLE N This is the value of the unique primary identifier of the bill item modifier 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.
PFT_FEE_SCHED_RELTN_ID DOUBLE N Unique identifier.
PRICE_SCHED_ITEMS_ID DOUBLE N This is the value of the unique primary identifier of the price_sched_items table. It is an internal system assigned number.
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_FEE_SCHED_RELTN


Child Column in PFT_FEE_SCHED_RELTN(FK) Parent Table Name Parent Column Name
Parents: BILL_ITEM_MOD_ID BILL_ITEM_MODIFIER BILL_ITEM_MOD_ID
PRICE_SCHED_ITEMS_ID PRICE_SCHED_ITEMS PRICE_SCHED_ITEMS_ID


PFT_FISCAL_PERIOD



Column Section Relationship Section Top of Page


Table-level Detail

Description: Profit fiscal period
Definition: Profit fiscal period
Table Type: REFERENCE





Column Detail - PFT_FISCAL_PERIOD


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.
ACTUAL_CLOSE_DT_TM DATETIME Y Actual close date and time
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
CLOSE_DT_TM DATETIME N close 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.
PERIOD_GROUPER DOUBLE N period grouper
PERIOD_NUM DOUBLE N period number
PERIOD_YEAR DOUBLE N period year
PFT_FISCAL_PERIOD_ID DOUBLE N profit fiscal period identifier
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_FISCAL_PERIOD


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




Parent Column in PFT_FISCAL_PERIOD (PK) Child Table Name Child Column Name
Children: PFT_FISCAL_PERIOD_ID PFT_ENCNTR_CENSUS_SUMMARY PFT_FISCAL_PERIOD_ID
PFT_REVENUE_SUMMARY PFT_FISCAL_PERIOD_ID


PFT_RECEIPT_ALIAS



Column Section Relationship Section Top of Page


Table-level Detail

Description: ProFit Receipt Alias
Definition: This table stores the receipt alias of a self pay remittance receipt.
Table Type: ACTIVITY





Column Detail - PFT_RECEIPT_ALIAS


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.
ALIAS_POOL_CD DOUBLE N Identifies a unique set or list of encounter identifiers and determines the accept/display format for the unique set of identifiers.
ALIAS_RECEIPT_IDENT VARCHAR(100) Y The identifier for the receipt.
ALIAS_TYPE_CD DOUBLE N Receipt alias type code identifies a kind or type of alias.
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.
PAYMENT_DETAIL_ID DOUBLE N Uniquely identifies the payment_detail for this row.
PFT_RECEIPT_ALIAS_ID DOUBLE N Uniquely identifies a receipt alias of a self pay remittance receipt.
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_RECEIPT_ALIAS


Child Column in PFT_RECEIPT_ALIAS(FK) Parent Table Name Parent Column Name
Parents: PAYMENT_DETAIL_ID PAYMENT_DETAIL PAYMENT_DETAIL_ID


PFT_REVENUE_SUMMARY



Column Section Relationship Section Top of Page


Table-level Detail

Description: ProFit Revenue Summary
Definition: Monthly summarization view by period date. The summarized date will provide year to date trending analysis availability and enhanced performance revenue summary. reports for acute and physician care.
Table Type: ACTIVITY





Column Detail - PFT_REVENUE_SUMMARY


Column Name Type Null? Definition
ACCOMMODATION_CD DOUBLE N Current type of accommodations in which the patient (encounter) has been placed. (e.g. Private, Semi Private, etc.)
ACTIVITY_TYPE_CD DOUBLE N Identifies to which "net" (pathnet, Radnet) and/or what department (general lab, microbiology) an order belongs.
ATTEND_PHYS_ID DOUBLE N PRSNL Identifier for the attending physician.
BILLING_ENTITY_ID DOUBLE N Identifies the Billing entity
BILL_ITEM_ID DOUBLE N Identifier for billable item
CDM_NBR_TXT VARCHAR(40) Y CDM Number from a Bill Item that was modified.
CPT_NOMEN_ID DOUBLE N Identifies the associated CPT code nomenclature Id
DRG_NOMEN_ID DOUBLE N Identifies the associated DRG nomenclature
ENCNTR_TYPE_CD DOUBLE N Categorizes the encounter into a logical group or type. examples may include inpatient, outpatient, etc.
ENCNTR_TYPE_CLASS_CD DOUBLE N Further categorization of patients into general groups (i.e., inpatient, outpatient, emergency, recurring outpatient).
FIN_CLASS_CD DOUBLE N Financial classification used for a given encounter. Examples may include worker's comp, self pay, etc.
GL_ACCOUNT_ALIAS_NBR_TXT VARCHAR(100) Y Defines the account structure in the general account number
GL_ACCT_UNIT_ALIAS_NBR_TXT VARCHAR(100) Y Defines an account unit in the general ledger account number
GL_COMPANY_ALIAS_NBR_TXT VARCHAR(100) Y Defines the company in the general ledger account number
GL_COMPANY_UNIT_ALIAS_NBR_TXT VARCHAR(100) Y Defines the sub account in the general ledger account number
HCPCS_NOMEN_ID DOUBLE N Identifies the associated HCPCS nomenclature Id
HEALTH_PLAN_ID DOUBLE N Identifies the associated Health Plan
ICD9_NOMEN_ID DOUBLE N Identifies the associated ICD9 code nomenclature Id
LOC_BUILDING_CD DOUBLE N Identifies the associated building of the patient
LOC_FACILITY_CD DOUBLE N Identifies the associated facility of the patient
LOC_NURSING_CD DOUBLE N Identifies the associated Nursing Unit of the patient
MED_SERVICE_CD DOUBLE N Category of medical service that the patient is receiving in relation to their encounter. The category may be of treatment type, surgery, general resources, or others.
PAYOR_ORG_ID DOUBLE N Identifies the associated payer's organization
PERF_LOC_CD DOUBLE N Identifies the associated location at which services were provided.
PFT_FISCAL_PERIOD_ID DOUBLE N Identifies the associated fiscal period to which billing applied.
PFT_REVENUE_SUMMARY_ID DOUBLE N Uniquely identifies each Monthly Revenue Summarization of acute and physician care.
REVENUE_CD DOUBLE N Identifies the associated Revenue code
REV_CLASS_CD DOUBLE N Identifies the associated classification of the revenue.
TOT_CHRG_AMT DOUBLE Y Total charge amount for a given Revenue code for a given fiscal period
TOT_CHRG_QTY DOUBLE Y Total charge quantity for a given Revenue code for a given fiscal period
TOT_CREDIT_AMT DOUBLE Y Total credit amount for a given Revenue code for a given fiscal period
TOT_CREDIT_QTY DOUBLE Y Total charge quantity for a given Revenue code for a given fiscal period
TOT_DEBIT_AMT DOUBLE Y Total debit amount for a given Revenue code for a given fiscal period
TOT_DEBIT_QTY DOUBLE Y Total charge quantity for a given Revenue code for a given fiscal period
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_REVENUE_SUMMARY


Child Column in PFT_REVENUE_SUMMARY(FK) Parent Table Name Parent Column Name
Parents: BILLING_ENTITY_ID BILLING_ENTITY BILLING_ENTITY_ID
BILL_ITEM_ID BILL_ITEM BILL_ITEM_ID
HEALTH_PLAN_ID HEALTH_PLAN HEALTH_PLAN_ID
CPT_NOMEN_ID NOMENCLATURE NOMENCLATURE_ID
DRG_NOMEN_ID NOMENCLATURE NOMENCLATURE_ID
HCPCS_NOMEN_ID NOMENCLATURE NOMENCLATURE_ID
ICD9_NOMEN_ID NOMENCLATURE NOMENCLATURE_ID
PAYOR_ORG_ID ORGANIZATION ORGANIZATION_ID
PFT_FISCAL_PERIOD_ID PFT_FISCAL_PERIOD PFT_FISCAL_PERIOD_ID
ATTEND_PHYS_ID PRSNL PERSON_ID




Parent Column in PFT_REVENUE_SUMMARY (PK) Child Table Name Child Column Name
Children: PFT_REVENUE_SUMMARY_ID PFT_TRANS_RELTN REVENUE_SUMMARY_ID