Table Detail Report

PFT_PRSNL_ALIAS



Column Section Relationship Section Top of Page


Table-level Detail

Description: ProFit Personnel Alias
Definition: ProFit Personnel Alias
Table Type: REFERENCE





Column Detail - PFT_PRSNL_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.
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.
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.
HEALTH_PLAN_ID DOUBLE N The unique identifier in the health plan table for a health plan
LOCATION_CD DOUBLE N Location Code
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
PFT_PRSNL_ALIAS_ID DOUBLE N ProFit Personnel Alias ID
PRSNL_ALIAS VARCHAR(250) Y Personnel Alias
PRSNL_ALIAS_TYPE_CD DOUBLE N Personnel Alias 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_PRSNL_ALIAS


Child Column in PFT_PRSNL_ALIAS(FK) Parent Table Name Parent Column Name
Parents: HEALTH_PLAN_ID HEALTH_PLAN HEALTH_PLAN_ID
PERSON_ID PERSON PERSON_ID


PFT_PRSNL_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: PFT PRSNL RELTN
Definition: This table relates two personnel together
Table Type: REFERENCE





Column Detail - PFT_PRSNL_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.
PFT_PRSNL_RELTN_ID DOUBLE N Unique identifier
RELATED_PRSNL_ID DOUBLE N Id to the prsnl table. Represents personnel being supervised
RELTN_BEGIN_DT_TM DATETIME Y The date that the relationship between supervising and related personnel begins
RELTN_END_DT_TM DATETIME Y The date that the relationship between supervising and related personnel ends
SUPERVISING_PRSNL_ID DOUBLE N Id to the prsnl table. Represents the supervising physician
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_PRSNL_RELTN


Child Column in PFT_PRSNL_RELTN(FK) Parent Table Name Parent Column Name
Parents: RELATED_PRSNL_ID PRSNL PERSON_ID
SUPERVISING_PRSNL_ID PRSNL PERSON_ID


PFT_SURCHARGE_CONFIG



Column Section Relationship Section Top of Page


Table-level Detail

Description: ProFit Surcharge Configuration
Definition: Stores Surcharge Configurations
Table Type: REFERENCE





Column Detail - PFT_SURCHARGE_CONFIG


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.
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.
CREATE_PRSNL_ID DOUBLE N Contains the id of the person who created the record.
DENIAL_CD DOUBLE N Denial Code Value used by a particular Payer to identify Surcharge Adjustments in the 835.
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.
LOGICAL_DOMAIN_ID DOUBLE N The unique identifier for a logical domain. This identifier allows the data to be grouped by logical domain. For example, If you assign clients a logical_domain_id this would allow you to store data for multiple clients on this table.
PARENT_ENTITY_ID DOUBLE N Uniquely identifies a single row based on the value of PARENT_ENTITY_NAME.
PARENT_ENTITY_NAME VARCHAR(30) N Identifies the name of the related entity. This would usually refer to a table name.
PARTICIPATION_STATUS_CD DOUBLE N The Code Value representing the Participation Status.
PFT_SURCHARGE_CONFIG_ID DOUBLE N Unique generated number that identifies a single row on the PFT_SURCHARGE_CONFIG table.
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_SURCHARGE_CONFIG


Child Column in PFT_SURCHARGE_CONFIG(FK) Parent Table Name Parent Column Name
Parents: LOGICAL_DOMAIN_ID LOGICAL_DOMAIN LOGICAL_DOMAIN_ID
CREATE_PRSNL_ID PRSNL PERSON_ID


PFT_SURCHARGE_RATE_CONFIG



Column Section Relationship Section Top of Page


Table-level Detail

Description: Patient Accounting Surcharge Rate Configuration
Definition: Configuration of the surcharge percentages based on the payer's participation status.
Table Type: REFERENCE





Column Detail - PFT_SURCHARGE_RATE_CONFIG


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.
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.
CREATE_PRSNL_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the original insert of the row in the table.
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.
LOGICAL_DOMAIN_ID DOUBLE N The unique identifier for a logical domain. This identifier allows the data to be grouped by logical domain. For example, If you assign clients a logical_domain_id this would allow you to store data for multiple clients on this table.
PARTICIPATION_STATUS_CD DOUBLE N Codeset which contains participation types to which we are associating surcharge percentages.
PFT_SURCHARGE_RATE_CONFIG_ID DOUBLE N Unique generated number that identifies a single row on the PFT_SURCHARGE_RATE_CONFIG table.
RATE_PCT DOUBLE N Surcharge percentage rates for Payers.
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_SURCHARGE_RATE_CONFIG


Child Column in PFT_SURCHARGE_RATE_CONFIG(FK) Parent Table Name Parent Column Name
Parents: LOGICAL_DOMAIN_ID LOGICAL_DOMAIN LOGICAL_DOMAIN_ID
CREATE_PRSNL_ID PRSNL PERSON_ID


PFT_UNIFIED_BILLING_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: ProFit Unified Billing Reltn
Definition: Used to establish links between institutional and professional charge groups for specific payers when a payer requires that all charges be billed on an institutional claim. Specifically it will relate an institutional bo_hp_reltn row to a professional bo_hp_reltn row. An institutional row can have 0 to many professional rows.
Table Type: ACTIVITY





Column Detail - PFT_UNIFIED_BILLING_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.
DIRECTION_FLAG DOUBLE N Indicates the direction the balance association will happen. 1 - Professional -> Institutional2 - Institutional -> Professional
INST_BO_HP_RELTN_ID DOUBLE N Uniquely identifies an institutional benefit order health plan
PFT_UNIFIED_BILLING_RELTN_ID DOUBLE N Uniquely identifies a relationship between an instirutional benefit order health plan and a professional bennefit order health plan.
PROF_BO_HP_RELTN_ID DOUBLE N Uniquely identifies a professional benefit order health plan
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_UNIFIED_BILLING_RELTN


Child Column in PFT_UNIFIED_BILLING_RELTN(FK) Parent Table Name Parent Column Name
Parents: INST_BO_HP_RELTN_ID BO_HP_RELTN BO_HP_RELTN_ID
PROF_BO_HP_RELTN_ID BO_HP_RELTN BO_HP_RELTN_ID