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