Last Updated: 7/22/2025 8:42:49 PM
Intergy Version: 22.00.00.00
Practice
Table Definition  Parent Tables  Child Tables
Table DefinitionField | 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 Table | Join Phrase | When deleting parent record... |
---|---|---|
Provider | Practice.GroupStaffID = Provider.ProviderID | RESTRICT if Practice exists |
Entity | Practice.PracticeID = Entity.EntitySID | CASCADE if Practice exists |
Child Table | Join Phrase | When 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 |