Last Updated: 7/22/2025 8:42:49 PM
Intergy Version: 22.00.00.00
PracPersonSpecialInfo
Table Definition Parent Tables Child Tables
Table Definition| Field | Datatype | Default | Null Option | Comment |
|---|---|---|---|---|
| PracticeID | INTEGER | ? | MANDATORY | FK |
| PersonID | INTEGER | ? | MANDATORY | FK |
| EffectiveDate | DATE | 01/01/1900 | MANDATORY | Date that the current PracPersonSpecialInfo was documented. |
| HomelessStatus | CHARACTER(1) | MANDATORY | ||
| WorkerStatus | CHARACTER(1) | MANDATORY | ||
| PublicHousing | CHARACTER(1) | MANDATORY | ||
| Veteran | CHAR(1) | MANDATORY | Values obtained from LookupType Veteran | |
| 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. |
| Disabled | CHAR(1) | No_Value__N_ | OPTIONAL | Indicates whether the patient is disabled. Uses Confirmation Lookup Code. |
| MilitaryDischargedStatus | CHAR(1) | OPTIONAL | Indicates whether the person is discharged from military. Defined by Confirmation LookupType. | |
| MilitaryDischargedDate | DATE | OPTIONAL | Discharge date from military. | |
| RefugeeStatus | CHAR(1) | OPTIONAL | Defines refugee status. Defined by Confirmation lookupType. | |
| CountryOfOrigin | CHAR(3) | OPTIONAL | Refugee's country of origin. Defined by LookupType CountryMasterList. |
| Parent Table | Join Phrase | When deleting parent record... |
|---|---|---|
| Patient | PracPersonSpecialInfo.PracticeID = Patient.PracticeID and PracPersonSpecialInfo.PersonID = Patient.PatientID |
CASCADE if PracPersonSpecialInfo exists |
| Child Table | Join Phrase | When deleting PracPersonSpecialInfo record... |
|---|