Last Updated: 7/22/2025 8:42:49 PM
Intergy Version: 22.00.00.00
Entity
Table Definition Parent Tables Child Tables
Table Definition| Field | Datatype | Default | Null Option | Comment |
|---|---|---|---|---|
| EntitySID | INTEGER | ? | MANDATORY | System generated unique id using the Entity sequence. |
| Class | CHARACTER(1) | MANDATORY | Class is set programmatically and may be: P - person C - company , M - practice , S - service center , F - finance center , I - plan (insurance) , D - providers (doctors) , R - carrier , H - protected health information receiver , Y - Payer | |
| Name | CHAR(200) | 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. | |
| SortName | CHAR(200) | MANDATORY | Sort name is set programmatically. | |
| 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. |
| GlobalID | CHAR(36) | Set_To_Empty_String | OPTIONAL | GlobalID of the Entity. This could be application generated GUID. |
| Parent Table | Join Phrase | When deleting parent record... |
|---|
| Child Table | Join Phrase | When deleting Entity record... |
|---|---|---|
| Staff | Staff.PhysicalBillLocationID = Entity.EntitySID | RESTRICT if Staff exists |
| Email.EntitySID = Entity.EntitySID | CASCADE if Email exists | |
| PHIAuthorization | PHIAuthorization.ReceiverSID = Entity.EntitySID | RESTRICT if PHIAuthorization exists |
| PHIDisclosure | PHIDisclosure.ReceiverSID = Entity.EntitySID | CASCADE if PHIDisclosure exists |
| Document | Document.EntitySID = Entity.EntitySID | RESTRICT if Document exists |
| Carrier | Carrier.CarrierID = Entity.EntitySID | CASCADE if Carrier exists |
| Address | Address.EntitySID = Entity.EntitySID | CASCADE if Address exists |
| Practice | Practice.PracticeID = Entity.EntitySID | CASCADE if Practice exists |
| Provider | Provider.ProviderID = Entity.EntitySID | CASCADE if Provider exists |
| ServiceCenter | ServiceCenter.ServiceCenterID = Entity.EntitySID | CASCADE if ServiceCenter exists |
| Company | Company.CompanyID = Entity.EntitySID | CASCADE if Company exists |
| Policy | Policy.SubscriberID = Entity.EntitySID | RESTRICT if Policy exists |
| Person | Person.PersonID = Entity.EntitySID | CASCADE if Person exists |
| Person | Person.HeadOfHouseholdID = Entity.EntitySID | RESTRICT if Person exists |
| Account | Account.GuarantorID = Entity.EntitySID | RESTRICT if Account exists |
| Phone | Phone.EntitySID = Entity.EntitySID | CASCADE if Phone exists |
| Plan | Plan.PlanID = Entity.EntitySID | CASCADE if Plan exists |
| FinanceCenter | FinanceCenter.FinanceCenterID = Entity.EntitySID | CASCADE if FinanceCenter exists |
| Payment | Payment.PayorID = Entity.EntitySID | RESTRICT if Payment exists |
| Staff | Staff.BillingLocationID = Entity.EntitySID | RESTRICT if Staff exists |