Last Updated: 7/22/2025 8:42:49 PM
Intergy Version: 22.00.00.00
Person
Table Definition Parent Tables Child Tables
Table Definition| Field | Datatype | Default | Null Option | Comment |
|---|---|---|---|---|
| PersonID | INTEGER | ? | MANDATORY | FK |
| LastName | CHAR(35) | MANDATORY | User entered last name of the person. | |
| FirstName | CHAR(35) | MANDATORY | User entered first name of the person. | |
| MiddleName | CHAR(35) | OPTIONAL | User entered middle name of person. | |
| NameSuffix | CHARACTER(20) | OPTIONAL | User entered name suffix (e.g. Jr. , M.D. , etc.). | |
| SortName | CHAR(200) | MANDATORY | Programmatically set name for providing sorted name list. If class is person then sort name is last name, first name middle name. | |
| SSN | CHARACTER(11) | OPTIONAL | User entered social security number of person. | |
| Sex | CHARACTER(1) | OPTIONAL | User selects sex code of person. Sex codes are defined in the LookupCode table for the lookup type 'Gender'. Codes for lookup type 'Gender' are not user definable. | |
| DOB | DATE | OPTIONAL | User entered date of birth of person. | |
| Race | CHARACTER(2) | OPTIONAL | User selects race code. Race codes are defined in the Lookup Code table for the lookup type 'Race'. Codes for lookup type 'Race' are user definable. Certains race codes will be pre-loaded in the system. | |
| Language | CHARACTER(3) | OPTIONAL | User selects language code. Language codes are defined in the LookupCode table for the lookup type 'Language'. Codes for lookup type 'Language' are user definable. Certain language codes will be pre-loaded in the system. | |
| MaritalStatus | CHARACTER(1) | OPTIONAL | User selects marital status code. Marital status codes are defined in the LookupCode table for the lookup type 'MaritalStatus'. Codes for lookup type 'MaritalStatus' are user definable. Certain marital status codes will be pre-loaded in the system. | |
| HomePhone | CHARACTER(20) | OPTIONAL | Phone number. User entered. | |
| CHAR(254) | OPTIONAL | Person's email address. | ||
| EmploymentStatus | CHARACTER(1) | OPTIONAL | User selects employment status code. Employment status codes are defined in the LookupCode table for the lookup type 'EmploymentStatus'. Codes for lookup type 'EmploymentStatus' are user definable. Certain employment status codes will be pre-loaded in the system. | |
| SoundEx | CHARACTER(4) | OPTIONAL | Soundex code is set programmatically and is not seen by the user. | |
| HeadOfHouseholdID | INTEGER | ? | OPTIONAL | FK - Additional Contact Person ID for Person |
| RelationToHeadOfHouse | CHAR(12) | OPTIONAL | System defined. Relationship with Patient. Field is supported by the lookup type: PersonalAndLegalRelationship, which is derived from ValueSet: [Personal And Legal Relationship Role Type from National Library of Medicine]. Values are defined in the LookupCode table for the above lookup type. | |
| 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. |
| PersonNumber | CHARACTER(14) | OPTIONAL | System wide number which holds the equivalent of the patient number. | |
| DeceasedDate | DATE | OPTIONAL | Person date of death. | |
| RelToParentGuardian | CHAR(12) | OPTIONAL | System defined. Relationship with Patient. Field is supported by the lookup type: PersonalAndLegalRelationship, which is derived from ValueSet: [Personal And Legal Relationship Role Type from National Library of Medicine]. Values are defined in the LookupCode table for the above lookup type. | |
| ParentGuardianID | INTEGER | ? | OPTIONAL | FK
If a person has a parent or legal guardian specified then the clinical mailings will be address as follows:
|
| DNSortPersonNumber | CHARACTER(14) | OPTIONAL | This is a denormalized field that is maintained by a customized write trigger and used for sorting purposes. | |
| AllergyIndicator | CHARACTER(1) | OPTIONAL | Indicates if Allergies have been reported for the person. Possible values: 'Y' - allergies have been reported and stored in the allergy table for the person. 'N' - Patient reported that they have no known allergies. ' ' - no information regarding the presence of allergies has been reported. Note: The existence of allergy records in the PersonAllergy table will override the value of this flag. | |
| AllergyConfirmationUser | INTEGER | 0 | OPTIONAL | UserID of person that confirms that existence or lack of allergies for the patient. |
| AllergyConfirmationStamp | CHARACTER(14) | OPTIONAL | Timestamp for the event of confirming the existence of allergies or lack of allergies for the patient. | |
| DNHomeZip | CHARACTER(10) | OPTIONAL | This is a denormalized field that is maintained by a customized write trigger and used for sorting purposes. | |
| 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". | |
| Ethnicity | CHAR(2) | OPTIONAL | Where Person.Race represents a categorization of a person's genetic background, Person.Ethnicity represents a categorization of a person's (patient's) general geographic, cultural, political makeup. This was added with CHC sites in mind who must track Race and Ethnicity carefully. It should be a value from the list of codes defined for 'Ethnicity' lookup type. | |
| TimeOfBirth | INTEGER | ? | OPTIONAL | User entered - This is the patient's time of birth in number of seconds since midnight (from DOB). |
| MotherMaidenName | CHAR(60) | OPTIONAL | Mother's maiden name. This is mainly used for immunization report. | |
| PreferredPhoneClass | CHAR(6) | OPTIONAL | The predefined phone class code used in Class field of the Phone table. If the field is not set then person doesn't have any preferred phone selected. | |
| HasInternetAccess | LOGICAL | Logical_True | OPTIONAL | Indicates if the person has internet access. |
| PreferredName | CHAR(20) | OPTIONAL | User entered preferred name of the person. | |
| DNMobilePhone | CHARACTER(20) | OPTIONAL | Denormalized for performance reasons from the Person table. Do not write to this field. The person write triggers will keep field up-to-date. | |
| IsMultipleBirth | LOGICAL | Logical_False | OPTIONAL | Yes/No - indicates if the person is a twin (part of multiple birth). |
| MultipleBirthOrder | INTEGER | ? | OPTIONAL | If part of a multiple birth, indicates birth order. |
| BirthSex | CHAR(1) | OPTIONAL | Person's sex assigned at birth. It is not currently used. | |
| RxTextPhone | CHARACTER(20) | OPTIONAL | Phone number used to text Rx supporting information to patient. | |
| Pronoun | CHAR(10) | OPTIONAL | User selected pronoun of the person. Field is supported by the lookup type: [Pronoun], which is derived from ValueSet: [LONIC Industry standard coding system]. Values are defined in the LookupCode table for the above lookup type. | |
| PronounFreeText | CHAR(60) | OPTIONAL | Free text field for pronouns when the user selects 'Other' in the pronoun field. |
| Parent Table | Join Phrase | When deleting parent record... |
|---|---|---|
| Person | Person.ParentGuardianID = Person.PersonID | SET NULL if Person exists |
| Entity | Person.PersonID = Entity.EntitySID | CASCADE if Person exists |
| Entity | Person.HeadOfHouseholdID = Entity.EntitySID | RESTRICT if Person exists |
| Child Table | Join Phrase | When deleting Person record... |
|---|---|---|
| PersonTribalAffiliation | PersonTribalAffiliation.PersonID = Person.PersonID | CASCADE if PersonTribalAffiliation exists |
| PersonOccupation | PersonOccupation.PersonID = Person.PersonID | CASCADE if PersonOccupation exists |
| CareTeamMember | CareTeamMember.EntitySID = Person.PersonID | RESTRICT if CareTeamMember exists |
| PersonRelationship | PersonRelationship.RelatedPersonID = Person.PersonID | CASCADE if PersonRelationship exists |
| PersonRelationship | PersonRelationship.PersonID = Person.PersonID | CASCADE if PersonRelationship exists |
| PersonContactMethod | PersonContactMethod.PersonID = Person.PersonID | CASCADE if PersonContactMethod exists |
| PersonRace | PersonRace.PersonID = Person.PersonID | CASCADE if PersonRace exists |
| PersonDrugIneffective | PersonDrugIneffective.PersonID = Person.PersonID | CASCADE if PersonDrugIneffective exists |
| PersonName | PersonName.PersonID = Person.PersonID | CASCADE if PersonName exists |
| PersonHistory | PersonHistory.PersonID = Person.PersonID | CASCADE if PersonHistory exists |
| Patient | Patient.DuplicatePersonID = Person.PersonID | SET NULL if Patient exists |
| PracPerson | PracPerson.PersonID = Person.PersonID | CASCADE if PracPerson exists |
| Person | Person.ParentGuardianID = Person.PersonID | SET NULL if Person exists |
| PersonAllergy | PersonAllergy.PersonID = Person.PersonID | CASCADE if PersonAllergy exists |
| EAObjectData | EAObjectData.EAObjectSID = Person.PersonID | CASCADE if EAObjectData exists |
| PolicyMember | PolicyMember.PersonID = Person.PersonID | CASCADE if PolicyMember exists |
| PersonAltID | PersonAltID.PersonID = Person.PersonID | CASCADE if PersonAltID exists |
| Employee | Employee.PersonID = Person.PersonID | CASCADE if Employee exists |
| Patient | Patient.PatientID = Person.PersonID | RESTRICT if Patient exists |