Last Updated: 7/22/2025 8:42:49 PM

Intergy Version: 22.00.00.00

Practice

Table Definition  Parent Tables  Child Tables

Table Definition

Description: This table is used to define practices.

Field Datatype Default Null Option Comment
PracticeID INTEGER ?   MANDATORY FK
PracticeCode CHARACTER(4)   MANDATORY Practice code (must be unique). User entered.
SortName CHAR(70)   MANDATORY If entity class is company then name is user entered. If entity class is person then name is set programmatically to combination of person's first name middle name and last name.
GLAcctSuffix CHARACTER(3)   OPTIONAL GL account suffix used to build gl account number dynamically.
TimeStamp CHARACTER(14)   OPTIONAL System generated date/time stamp record was last written.
LastUser INTEGER ?   OPTIONAL User ID of user that last wrote the record.
CreateStamp CHARACTER(14)   OPTIONAL System generated date/time stamp record was created.
CreateUser INTEGER ?   OPTIONAL User ID of user that created the record.
Class CHARACTER(6)   OPTIONAL User selects practice class code. Practice class codes are defined in the LookupCode table for the lookup type 'PracticeClass'. Codes for lookup type 'PracticeClass' are user definable.
SerializationCode CHARACTER(20)   MANDATORY The serialization code for the practice as provided by Medical Manager, which allows the practice to be defined.
SubsystemsCode CHARACTER(20)   OPTIONAL obsolete - This field records the serialization code which enables the subsystems for a practice.
FavoritePharmacyID INTEGER ?   OPTIONAL FK
GroupStaffID INTEGER ?   OPTIONAL FK
InstallCode CHARACTER(20)   OPTIONAL Install code as provided by Medical Manager.
InstallOptions CHARACTER(200)   OPTIONAL
InstallNumUserCode CHARACTER(20)   OPTIONAL Install code specifying number of concurrent users allowed to log in by this practice.
SharePerson CHARACTER(1) Yes_Value__Y_   OPTIONAL
CBOPractice LOGICAL Logical_True   MANDATORY YES = Practice participates in CBO. NO = Standard Practice

Parent Tables
Parent TableJoin PhraseWhen deleting parent record...
Provider Practice.GroupStaffID = Provider.ProviderID RESTRICT if Practice exists
Entity Practice.PracticeID = Entity.EntitySID CASCADE if Practice exists

Child Tables
Child TableJoin PhraseWhen deleting Practice record...
PersonTribalAffiliation PersonTribalAffiliation.LastModifiedByPracticeID = Practice.PracticeID CASCADE if PersonTribalAffiliation exists
PersonOccupation PersonOccupation.LastModifiedByPracticeID = Practice.PracticeID CASCADE if PersonOccupation exists
PlanClaimActivity PlanClaimActivity.PracticeID = Practice.PracticeID CASCADE if PlanClaimActivity exists
PatImplantableDevice PatImplantableDevice.PracticeID = Practice.PracticeID CASCADE if PatImplantableDevice exists
RxChangeRequest RxChangeRequest.PracticeID = Practice.PracticeID RESTRICT if RxChangeRequest exists
PatientRxFill PatientRxFill.PracticeID = Practice.PracticeID CASCADE if PatientRxFill exists
PatientPortalAccess PatientPortalAccess.PracticeID = Practice.PracticeID CASCADE if PatientPortalAccess exists
PracPersonName PracPersonName.PracticeID = Practice.PracticeID CASCADE if PracPersonName exists
CardioOrder CardioOrder.PracticeID = Practice.PracticeID RESTRICT if CardioOrder exists
PersonAllergyHistory PersonAllergyHistory.PracticeID = Practice.PracticeID SET NULL if PersonAllergyHistory exists
PatientRemitPayment PatientRemitPayment.PracticeID = Practice.PracticeID CASCADE if PatientRemitPayment exists
PlanClaimRemit PlanClaimRemit.PracticeID = Practice.PracticeID RESTRICT if PlanClaimRemit exists
PracPerson PracPerson.PracticeID = Practice.PracticeID CASCADE if PracPerson exists
Appointment Appointment.PracticeID = Practice.PracticeID CASCADE if Appointment exists
ChargeCoverage ChargeCoverage.PracticeID = Practice.PracticeID CASCADE if ChargeCoverage exists
Account Account.PracticeID = Practice.PracticeID CASCADE if Account exists
Patient Patient.PracticeID = Practice.PracticeID RESTRICT if Patient exists
Referral Referral.PracticeID = Practice.PracticeID CASCADE if Referral exists
FinanceCenter FinanceCenter.PracticeID = Practice.PracticeID RESTRICT if FinanceCenter exists
Payment Payment.PracticeID = Practice.PracticeID CASCADE if Payment exists
Staff Staff.PracticeID = Practice.PracticeID RESTRICT if Staff exists