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 |