Table Detail Report
PFT_LINE_ITEM_DETAIL
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | ProFit Line Item Detail |
Definition: | Additional information related to Line_item is saved in pft_line_item_details table. |
Table Type: | ACTIVITY |
Column Detail - PFT_LINE_ITEM_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. |
LINE_ITEM_DETAIL_TXT | VARCHAR(250) | N | Contains additional information about the claim line item |
PFT_LINE_ITEM_DETAIL_ID | DOUBLE | N | Unique generated number that identifies a single row on the PFT_LINE_ITEM_DETAIL table. |
PFT_LINE_ITEM_ID | DOUBLE | N | Uniquely identifies the related row on the PFT_LINE_ITEM table. |
TYPE_CD | DOUBLE | N | 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_LINE_ITEM_DETAIL
Child Column in PFT_LINE_ITEM_DETAIL(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | PFT_LINE_ITEM_ID | PFT_LINE_ITEM | PFT_LINE_ITEM_ID |
PFT_MLP
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | PFT MLP |
Definition: | This table stores specific MLP information |
Table Type: | REFERENCE |
Column Detail - PFT_MLP
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. |
DEGREE_CREDENTIALS | VARCHAR(20) | Y | Stores MLP degree/credentials information |
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. |
LICENSE_NBR | VARCHAR(20) | Y | Stores MLP License number |
PFT_MLP_ID | DOUBLE | N | Unique identifier of table |
PRSNL_ID | DOUBLE | N | Foreign key to prsnl table. Represents the MLP |
SSN | DOUBLE | Y | Stores MLP SSN |
START_DT_TM | DATETIME | Y | Stores the MLP start date and time |
TAX_ID_NBR | VARCHAR(20) | Y | Stores MLP tax identification |
TERMINATION_DT_TM | DATETIME | Y | Stores the MLP termination date and time |
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. |
UPIN | VARCHAR(20) | Y | Stores MLP UPIN |
Relationship Detail - PFT_MLP
Child Column in PFT_MLP(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ACTIVE_STATUS_PRSNL_ID | PRSNL | PERSON_ID |
PRSNL_ID | PRSNL | PERSON_ID |
PFT_PENDING_BILL
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | ProFit Pending Bill |
Definition: | Contains a placeholder for a bill in the system whose metadata has been successfully generated by the billing server but has not been submitted. This type of bill is not visible to users of the system. |
Table Type: | ACTIVITY |
Column Detail - PFT_PENDING_BILL
Column Name | Type | Null? | Definition |
---|---|---|---|
BATCH_NUMBER_IDENT | DOUBLE | N | The batch number is a unique identifier for a bill submission job and is stamped on all claims generated by that batch. It allows the user to identify what claims were submitted together in batch. |
BILL_DATE_SORT_TXT | VARCHAR(100) | N | The bill date sort key that will determine how claims are ordered for electronic batching or printing based on bill date. |
CORSP_ACTIVITY_ID | DOUBLE | N | Uniquely identifies the related pending bill. |
HEALTH_PLAN_SORT_TXT | VARCHAR(100) | N | The health plan sort key that will determine how claims are ordered for electronic batching or printing based on provider. |
PAGES_SORT_TXT | VARCHAR(100) | N | The pages sort key that will determine how claims are ordered for electronic batching or printing based on pages. |
PATIENT_SORT_TXT | VARCHAR(100) | N | The patient sort key that will determine how claims are ordered for electronic batching or printing based on patient. |
PAYER_SORT_TXT | VARCHAR(100) | N | The payer sort key that will determine how claims are ordered for electronic batching or printing based on payer. |
PFT_ENCNTR_ID | DOUBLE | N | Uniquely identifies the ProFit encounter related to this pending bill. |
PFT_PENDING_BILL_ID | DOUBLE | N | Uniquely identifies a pending bill. |
PROVIDER_SORT_TXT | VARCHAR(100) | N | The provider sort key that will determine how claims are ordered for electronic batching or printing based on provider. |
SUBSCRIBER_SORT_TXT | VARCHAR(100) | N | The subscriber sort key that will determine how claims are ordered for electronic batching or printing based on subscriber. |
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_PENDING_BILL
Child Column in PFT_PENDING_BILL(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | PFT_ENCNTR_ID | PFT_ENCNTR | PFT_ENCNTR_ID |
PFT_PROVIDER_NBR
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | PFT PROVIDER NBR |
Definition: | This table defines an organization provider number |
Table Type: | REFERENCE |
Column Detail - PFT_PROVIDER_NBR
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. |
BILLING_ENTITY_ID | DOUBLE | N | Identifies a record in the billing entity table |
DEFAULT_IND | DOUBLE | N | Indicates whether or not this record is the default provider number for a billing entity/health plan combination |
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. |
HEALTH_PLAN_ID | DOUBLE | N | Identifies a record in the health plan table |
INSURANCE_ORG_ID | DOUBLE | N | Foreign key to the Organization table. This field will realte Provider Numbers to Organizations of Org Type InsCo. |
PFT_PROVIDER_NBR_ID | DOUBLE | N | Unique identifier of table |
PROVIDER_NBR | VARCHAR(13) | Y | Health plan assigned provider 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_PROVIDER_NBR
Child Column in PFT_PROVIDER_NBR(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | HEALTH_PLAN_ID | HEALTH_PLAN | HEALTH_PLAN_ID |
INSURANCE_ORG_ID | ORGANIZATION | ORGANIZATION_ID |
PFT_PROVIDER_NBR_RELTN
Column Section | Top of Page |
Table-level Detail
Description: | PFT PROVIDER NBR RELTN |
Definition: | This table defines a relationship for an organization provider number |
Table Type: | REFERENCE |
Column Detail - PFT_PROVIDER_NBR_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. |
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. |
PARENT_ENTITY_ID | DOUBLE | N | The identifier of the parent entity. Current values will be code values from encntr_type_cd (71) and med_service_cd (34) |
PARENT_ENTITY_NAME | VARCHAR(30) | Y | Identifies the reltn entity. Current values will be: ENCNTR_TYPE_CD, MED_SERVICE_CD |
PFT_PROVIDER_NBR_ID | DOUBLE | N | Identifies a record in the pft_provider_nbr table |
PFT_PROVIDER_NBR_RELTN_ID | DOUBLE | N | Unique identifier of this table |
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. |