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 |