Table Detail Report

PFT_BILL



Column Section Relationship Section Top of Page


Table-level Detail

Description: ProFit Bill
Definition: ProFit Bill
Table Type: ACTIVITY





Column Detail - PFT_BILL


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.
BALANCE_DUE DOUBLE Y Balance Due
BALANCE_FWD DOUBLE Y Balance Forward
BAL_DUE_DR_CR_FLAG DOUBLE N Debit or Credit flag for the Balance_due field
BAL_FWD_DR_CR_FLAG DOUBLE N Debit or credit flag for the Balance_fwd field
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_VRSN_NBR DOUBLE N Part of Primary Key
CORSP_ACTIVITY_ID DOUBLE N Correspondence Activity ID value
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.
INTERIM_BILL_FLAG DOUBLE Y Interim Bill Flag
NEW_AMOUNT DOUBLE Y New Amount on Bill
NEW_AMT_DR_CR_FLAG DOUBLE N Debit or credit flag for the New_balance field
PFT_BILL_ID DOUBLE N Primary Key
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


Child Column in PFT_BILL(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_ALIAS



Column Section Top of Page


Table-level Detail

Description: Profits bill alias table
Definition: Profits bill alias table
Table Type: ACTIVITY





Column Detail - PFT_BILL_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 VARCHAR(100) Y Identifier for the bill record
ALIAS_POOL_CD DOUBLE N Alias pool code identifies a unique set or list of encounter identifiers and determines the accept/display format for the unique set of identifiers.
ALIAS_TYPE_CD DOUBLE N Bill alias type code identifies a kind or type of alias
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_TYPE_CD DOUBLE N Identifies type of bill
CONTRIBUTOR_SYSTEM_CD DOUBLE N Contributor system identifies the source feed of data from which a row was populated. This is mainly used to determine how to update a set of data that may have originated from more than one source feed.
CORSP_ACTIVITY_ID DOUBLE N Unique identifier for bill record. Foreign key to the activity log table
DATA_STATUS_CD DOUBLE N Data status indicates a level of authenticity of the row data. Typically this will either be AUTHENTICATED or UNAUTHENTICATED.
DATA_STATUS_DT_TM DATETIME Y The date and time that the data_status_cd was set.
DATA_STATUS_PRSNL_ID DOUBLE N The person who caused the data_status_cd to be set or change.
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_ALIAS_ID DOUBLE N This is the value of the unique primary identifier of the bill alias 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.


PFT_BILL_ITEM_COND_CRIT_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: ProFit Billing Item Condition Criteria Relation
Definition: Relates bill items to charge group condition criteria.
Table Type: REFERENCE





Column Detail - PFT_BILL_ITEM_COND_CRIT_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.
BILL_ITEM_COND_CRIT_RELTN_ID DOUBLE N Unique, generated number that identifies a single row on the PFT_BILL_ITEM_COND_CRIT_RELTN table. Relates Bill Item Criteria values to Bill Template condition criteria.
BILL_ITEM_ID DOUBLE N Foreign key to BILL_ITEM that relates the bill item to a bill template criteria condition.
BT_COND_CRIT_R_ID DOUBLE N Uniquely identifies a specific relationship between a Bill Template Condition, a Criteria record, and a Bill Item.
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.
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_BILL_ITEM_COND_CRIT_RELTN


Child Column in PFT_BILL_ITEM_COND_CRIT_RELTN(FK) Parent Table Name Parent Column Name
Parents: BILL_ITEM_ID BILL_ITEM BILL_ITEM_ID
BT_COND_CRIT_R_ID BT_COND_CRIT_RELTN BT_COND_CRIT_R_ID


PFT_BILL_SUMMARY



Column Section Relationship Section Top of Page


Table-level Detail

Description: PFT BILL SUMMARY
Definition: Bill summary table for profit OMF reporting
Table Type: ACTIVITY





Column Detail - PFT_BILL_SUMMARY


Column Name Type Null? Definition
ACCT_ID DOUBLE N References the account id
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.
AUTO_SUBMIT_CD DOUBLE N Code value related to the unit of the specified period after which bill will be submitted automatically. e.g. 25 days, "days" will be the auto_submit_cd.
AUTO_SUBMIT_IND DOUBLE Y Indicate whether the bill should be submitted automatically.
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.
BENEFIT_ORDER_ID DOUBLE N References the benefit order id
BILLED_BALANCE DOUBLE N Bill balance
BILLING_ENTITY_ID DOUBLE N References the billing entity table
BILLING_ENTITY_NAME VARCHAR(100) Y Name of the billing entity
BILL_ALIAS VARCHAR(40) Y Bill alias
BILL_BALANCE_DUE DOUBLE N Bill balance due
BILL_BAL_FORWARD DOUBLE N Bill balance forward
BILL_CLASS_CD DOUBLE N Identifies the class (e.g. Claim, Letter etc.) to which a bill record belongs.
BILL_STATUS_CD DOUBLE N Code value associated to the status of the bill. e.g. pending, ready to bill etc.
BILL_STATUS_REASON_CD DOUBLE N Code value associated to the reason for a particular state of bill.
BILL_TEMPLATE_ID DOUBLE N References the bill template table
BILL_TEMPLATE_NAME VARCHAR(250) Y Name of the bill template
BILL_TYPE_CD DOUBLE N Bill type code value
BILL_VRSN_NBR DOUBLE N Version number of a bill record
CORSP_ACTIVITY_ID DOUBLE N References the corsp_log table
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.
GEN_DT_TM DATETIME Y The date and time the bill record was generated
INTERIM_BILL_FLAG DOUBLE Y Interim billing flag
MANUAL_REVIEW_IND DOUBLE Y Indicates whether the bill record has been manually edited.
MEDIA_SUB_TYPE_CD DOUBLE N Code value associated to the sub type of the bill submission media. e.g. continuous feed, 837 (ANS X.12) etc.
MEDIA_TYPE_CD DOUBLE N The code value associated to the bill submission media.
PAGE_CNT DOUBLE Y Page count
PAYOR_CTRL_NBR_TXT VARCHAR(100) Y Payor Control number text
PFT_BILL_SUMMARY_ID DOUBLE N Unique identifier for this table
PFT_ENCNTR_ID DOUBLE N References the financial encounter id.
SORT_FIELD_1_CD DOUBLE N Code value for primary sort field.
SORT_FIELD_1_VALUE VARCHAR(250) Y Primary sorting field for batch processing.
SORT_FIELD_2_CD DOUBLE N Code value for secondary sort field.
SORT_FIELD_2_VALUE VARCHAR(250) Y Secondary sorting field for batch processing.
SORT_FIELD_3_CD DOUBLE N Code value for tertiary sort field.
SORT_FIELD_3_VALUE VARCHAR(250) Y Tertiary sorting field for the batch processing.
SUBMIT_DT_TM DATETIME Y The date and time for which the bill record is submitted to a payer.
SUBMIT_REASON_CD DOUBLE N Submit reason code
SUBMIT_STATUS_CD DOUBLE N submitted status
SUBMIT_STATUS_REASON_CD DOUBLE N Submitted status reason
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_BILL_SUMMARY


Child Column in PFT_BILL_SUMMARY(FK) Parent Table Name Parent Column Name
Parents: ACCT_ID ACCOUNT ACCT_ID
BENEFIT_ORDER_ID BENEFIT_ORDER BENEFIT_ORDER_ID
PFT_ENCNTR_ID PFT_ENCNTR PFT_ENCNTR_ID


PFT_BR_CLAIM_DETAIL



Column Section Relationship Section Top of Page


Table-level Detail

Description: ProFit Bill Record Claim Detail
Definition: Claim related information is saved in PFT_CLAIMS_DETAILS
Table Type: ACTIVITY





Column Detail - PFT_BR_CLAIM_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.
ACTIVE_STATUS_DT_TM DATETIME N The date and time that the active_status_cd was set.
BILL_VRSN_NBR DOUBLE N The version number identifying which bill
CLAIM_DETAIL_TXT VARCHAR(250) N Additional claim related information.
CORSP_ACTIVITY_ID DOUBLE N Foreign key reference to the corsp_log table
PFT_BR_CLAIM_DETAIL_ID DOUBLE N Unique generated number that identifies a single row on the PFT_BR_CLAIM_DETAIL
TYPE_CD DOUBLE N The type code Identified for 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.



Relationship Detail - PFT_BR_CLAIM_DETAIL


Child Column in PFT_BR_CLAIM_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