Last Updated: 7/22/2025 8:42:49 PM
Intergy Version: 22.00.00.00
Phone
Table Definition Parent Tables Child Tables
Table Definition| Field | Datatype | Default | Null Option | Comment |
|---|---|---|---|---|
| EntitySID | INTEGER | ? | MANDATORY | FK |
| Class | CHARACTER(6) | MANDATORY | User selects phone number class code. Phone classes are defined in the LookupCode table for the lookup types 'CompanyPhone', 'PersonPhone' and 'PlanPhone'. Codes for lookup types are user definable. Certain phone class codes will be pre-loaded in the system. | |
| Number | CHARACTER(20) | OPTIONAL | Phone number. User entered. | |
| Contact | CHARACTER(20) | OPTIONAL | Name of contact at number. | |
| Extension | CHAR(8) | OPTIONAL | Extension to the phone number. User entered. | |
| 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. |
| HL7Updated | CHARACTER(1) | OPTIONAL | This field indicates if HL7 has processed this table entry and will be used by the DB triggers. values "Y" or "N". |
| Parent Table | Join Phrase | When deleting parent record... |
|---|---|---|
| Entity | Phone.EntitySID = Entity.EntitySID | CASCADE if Phone exists |
| Child Table | Join Phrase | When deleting Phone record... |
|---|---|---|
| PhoneHistory | PhoneHistory.EntitySID = Phone.EntitySID and PhoneHistory.Class = Phone.Class |
NONE if PhoneHistory exists |