Table Detail Report
PFT_ACCT_NUMBER
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | ProFit Account Number |
Definition: | ProFit Account Number |
Table Type: | REFERENCE |
Column Detail - PFT_ACCT_NUMBER
Column Name | Type | Null? | Definition |
---|---|---|---|
ACCT_NBR_TYPE_CD | DOUBLE | N | Account Number Type Code |
ACCT_NUMBER_SEQ | DOUBLE | Y | Account Number Sequence |
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_ID | DOUBLE | N | Foreign key to the alias_pool table |
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. |
BILLING_ENTITY_ID | DOUBLE | N | Foreign key to the billing_entity 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. |
MASK | VARCHAR(50) | Y | Mask |
MAX_LENGTH | DOUBLE | Y | Maximum Lenght |
PARENT_ACCT_NBR_ID | DOUBLE | N | Cyclical referece to the table itself |
PFT_ACCT_NUMBER_ID | DOUBLE | N | Primary key |
SEQUENCE_POOL | VARCHAR(50) | Y | Sequence Pool |
START_NBR | DOUBLE | Y | Starting 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. |
USER_DEFINIED_VALUE | VARCHAR(50) | Y | User Defined Value |
Relationship Detail - PFT_ACCT_NUMBER
Child Column in PFT_ACCT_NUMBER(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ALIAS_POOL_ID | ALIAS_POOL | ALIAS_POOL_CD |
BILLING_ENTITY_ID | BILLING_ENTITY | BILLING_ENTITY_ID |
PFT_ACCT_RELTN
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | ProFit Account Relation |
Definition: | ProFit Account Relation |
Table Type: | REFERENCE |
Column Detail - PFT_ACCT_RELTN
Column Name | Type | Null? | Definition |
---|---|---|---|
ACCT_ID | DOUBLE | N | FK to the account table |
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 | 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. |
CREATED_DT_TM | DATETIME | N | Date and time the record was created. |
CREATED_PRSNL_ID | DOUBLE | N | FK to the person 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. |
PARENT_ENTITY_ID | DOUBLE | N | FK to the account, pft_encntr or bill_rec tables |
PARENT_ENTITY_NAME | CHAR(32) | N | Name of the parent entity name |
PFT_ACCT_RELTN_ID | DOUBLE | N | Primary Key |
ROLE_TYPE_CD | DOUBLE | N | Role Type Code |
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_ACCT_RELTN
Child Column in PFT_ACCT_RELTN(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | CREATED_PRSNL_ID | PRSNL | PERSON_ID |
PFT_BATCH
Column Section | Top of Page |
Table-level Detail
Description: | PFT BATCH |
Definition: | PFT Batch table for Prolfit OMF reporting |
Table Type: | ACTIVITY |
Column Detail - PFT_BATCH
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. |
ADJ_COMPUTED_TOTAL | DOUBLE | N | Actual total number of all of the adjustment transactions. Used as a control number for reconciling. |
ADJ_RESTATED_TOTAL | DOUBLE | N | Re-stated total number of all of the adjustment transactions. Used as a control number for reconciling. |
ADJ_STATED_TOTAL | DOUBLE | N | Stated total number of all of the adjustment transactions. Used as a control number for reconciling. |
BATCHJOB_IND | DOUBLE | Y | Indicates whether a batch job |
BATCH_STATUS_CD | DOUBLE | N | Batch status code |
BATCH_TRANS_ID | DOUBLE | N | Id to the batch_trans table |
BATCH_TYPE_FLAG | DOUBLE | Y | The value indicates which tool has created the batch. |
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. |
BILLING_ENTITY_ID | DOUBLE | N | The id of the billing entity |
BILLING_ENTITY_NAME | VARCHAR(100) | Y | The name of the billing entity |
CREATED_DT_TM | DATETIME | Y | The date and time when the batch was created |
CREATED_PRSNL_ID | DOUBLE | N | The id of the person who created the batch |
CREATED_PRSNL_NAME_FULL | VARCHAR(100) | Y | The name of the person who created the batch |
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. |
EXT_BATCH_ID_TXT | VARCHAR(40) | Y | The name of the batch |
FC_COMPUTED_TOTAL | DOUBLE | N | Actual total number of all of the finance charge transactions. Used as a control number for reconciling. |
FC_RESTATED_TOTAL | DOUBLE | N | Re-stated total number of all of the finance charge transactions. Used as a control number for reconciling. |
FC_STATED_TOTAL | DOUBLE | N | Stated total number of all of the finance charge transactions. Used as a control number for reconciling. |
ONEPAYMENT_IND | DOUBLE | Y | Represents that all payments are associated to a single check or funds transfer |
PAY_COMPUTED_TOTAL | DOUBLE | N | Actual total number of all of the payment transactions. Used as a control number for reconciling. |
PAY_RESTATED_TOTAL | DOUBLE | N | Re-stated total number of all of the payment transactions. Used as a control number for reconciling. |
PAY_STATED_TOTAL | DOUBLE | N | Stated total number of all of the payment transactions. Used as a control number for reconciling. |
PFT_BATCH_ID | DOUBLE | N | Unique identifier for this table |
PFT_EVENT_OCCUR_LOG_ID | DOUBLE | N | Id of pft_event_occur_log |
POST_DT_TM | DATETIME | Y | posted date and time |
PURGED_IND | DOUBLE | Y | Indicates whether or not it is a cancelled batch |
SUBMITTED_DT_TM | DATETIME | Y | If submitted, the date and time of submittal |
SUBMITTED_IND | DOUBLE | Y | Indicates whether or not submitted |
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. |
USERNAME | VARCHAR(50) | Y | Username of person who posted the batch |
PFT_BENEFIT_ORDER
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | PFT BENEFIT ORDER |
Definition: | Benefit order for profit OMF reporting |
Table Type: | ACTIVITY |
Column Detail - PFT_BENEFIT_ORDER
Column Name | Type | Null? | Definition |
---|---|---|---|
ACCT_ID | DOUBLE | N | From pft_encntr. The account id for this benefit order |
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 | 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 entry on the benefit order table |
BO_STATUS_CD | DOUBLE | N | State of the benefit order at a particular instance of time |
BO_STATUS_REASON_CD | DOUBLE | N | Reason for state of benefit order. |
CONS_BO_SCHED_ID | DOUBLE | N | References the entry on the cons_bo_sched table |
CROSS_OVER_IND | DOUBLE | Y | Indicates whether or not health plan is a cooperative plan. |
ENCNTR_ID | DOUBLE | N | This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number. |
ENCNTR_PLAN_RELTN_ID | DOUBLE | N | References the entry on the encounter plan relation 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. |
FIN_CLASS_CD | DOUBLE | N | Financial class of health plan. |
GUARANTOR_PERSON_NAME_FULL | VARCHAR(100) | Y | Full name of guarantor |
HEALTH_PLAN_ID | DOUBLE | N | This is the value of the unique primary identifier of the health plan table. |
INS_EMPLY_IDENT_NBR | VARCHAR(50) | Y | Insurance employer identification number |
INS_GROUP_NBR | VARCHAR(100) | Y | Insurance group number |
INS_HEALTH_PLAN_NAME | VARCHAR(100) | Y | Insurance health plan name |
INS_HEALTH_PLAN_TYPE_CD | DOUBLE | N | Health plan type code iditifies the type of health plan. (For example, PPO, HMW, Medicaid, Medicare, etc.) |
INS_POLICY_NBR | VARCHAR(50) | Y | Insurance policy number |
MAN_EDIT_IND | DOUBLE | Y | Indicates whether or not the pft benefit order has been manually edited. |
NEXT_BILL_DT_TM | DATETIME | Y | Date and time for next bill |
ORIG_BILL_DT_TM | DATETIME | Y | The date and time the bill was originally billed. |
PAT_BILL_PREF_FLAG | DOUBLE | Y | Patient bill preference flag |
PAYOR_AUTH_NBR | VARCHAR(50) | Y | Payor authorization number |
PAYOR_EST_AMT_DUE | DOUBLE | N | Payor estimated amount due |
PAYOR_PAYMENTS | DOUBLE | N | payor payments |
PFT_BENEFIT_ORDER_ID | DOUBLE | N | Unique identifier for this table |
PFT_ENCNTR_ID | DOUBLE | N | From pft_encntr. The id of the profit encounter. |
PRIORITY_SEQ | DOUBLE | Y | Priority sequence ( ex. primary, secondary, tertiary) |
PRI_CONCURRENT_IND | DOUBLE | Y | Indicate whether a patient should be billed at the same time when the bill is sent to the primary |
SEC_CONCURRENT_IND | DOUBLE | Y | Indicate whether a patient should be billed at the same time when the bill is sent to the secondary |
SUBSCRIBER_ID | DOUBLE | N | Identifies the person who is the subscriber of the health plan. |
SUBSCRIBER_NAME_FULL | VARCHAR(100) | Y | Full name of the 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_BENEFIT_ORDER
Child Column in PFT_BENEFIT_ORDER(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ACCT_ID | ACCOUNT | ACCT_ID |
ENCNTR_ID | ENCOUNTER | ENCNTR_ID | |
HEALTH_PLAN_ID | HEALTH_PLAN | HEALTH_PLAN_ID | |
PFT_ENCNTR_ID | PFT_ENCNTR | PFT_ENCNTR_ID |
PFT_BE_CNVT_RATE_RELTN
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | ProFit Billing Entity Conversion Rate Relationship |
Definition: | Stores a relationship between a billing entity and a conversion rate definition. |
Table Type: | REFERENCE |
Column Detail - PFT_BE_CNVT_RATE_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. |
BILLING_ENTITY_ID | DOUBLE | N | Identifies a billing entity record. FK from the billing_entity table. |
CNVT_RATE_ID | DOUBLE | N | Identifies a conversion rate record. FK from the cnvt_rate 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. |
PFT_BE_CNVT_RATE_RELTN_ID | DOUBLE | N | Uniquely identifies the record that stores the relationship between a billing entity and a convert rate. |
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_BE_CNVT_RATE_RELTN
Child Column in PFT_BE_CNVT_RATE_RELTN(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | BILLING_ENTITY_ID | BILLING_ENTITY | BILLING_ENTITY_ID |
CNVT_RATE_ID | CNVT_RATE | CNVT_RATE_ID |