Last Updated: 9/24/2025 12:09:38 PM
Intergy Version: 22.00.00.00
Practice
Table Definition Parent Tables Child Tables
Table Definition| 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 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 |