Last Updated: 7/22/2025 8:42:49 PM
Intergy Version: 22.00.00.00
PersonHistory
Table Definition Parent Tables Child Tables
Table Definition| Field | Datatype | Default | Null Option | Comment |
|---|---|---|---|---|
| PersonHistorySID | INTEGER | ? | MANDATORY | System generated unique ID using the "Entity" sequence. |
| PersonID | INTEGER | ? | MANDATORY | FK |
| NameChanged | CHARACTER(1) | OPTIONAL | Y' - Name changed; 'N' No name changed. | |
| AddressChanged | CHARACTER(1) | OPTIONAL | 'Y' - Address changed; 'N' No address changed. | |
| PhoneChanged | CHARACTER(1) | OPTIONAL | 'Y' - Phone changed; 'N' No phone changed. | |
| EmailChanged | CHARACTER(1) | OPTIONAL | 'Y' - Email changed; 'N' No email changed | |
| EffectiveDate | DATE | MANDATORY | This is the date that the person demographic date change FROM the value that is recorded in the history (PersonHistory, AddressHistory, EmailHistory, or PhoneHistory) table. This is also true for the PersonName table where the 'Primary = N'. See that table for more details. | |
| 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. |
| SexChanged | CHAR(1) | OPTIONAL | 'Y' - Sex changed; 'N' No sex changed. | |
| DOBChanged | CHAR(1) | OPTIONAL | 'Y' - DOB changed; 'N' No DOB changed. | |
| LanguageChanged | CHARACTER(1) | OPTIONAL | 'Y' - Preferred Language changed; 'N' - No Preferred Language changed. |
| Parent Table | Join Phrase | When deleting parent record... |
|---|---|---|
| Person | PersonHistory.PersonID = Person.PersonID | CASCADE if PersonHistory exists |
| Child Table | Join Phrase | When deleting PersonHistory record... |
|---|---|---|
| DOBHistory | DOBHistory.PersonHistorySID = PersonHistory.PersonHistorySID | CASCADE if DOBHistory exists |
| SexHistory | SexHistory.PersonHistorySID = PersonHistory.PersonHistorySID | CASCADE if SexHistory exists |
| PhoneHistory | PhoneHistory.PersonHistorySID = PersonHistory.PersonHistorySID | CASCADE if PhoneHistory exists |
| EmailHistory | EmailHistory.PersonHistorySID = PersonHistory.PersonHistorySID | CASCADE if EmailHistory exists |
| AddressHistory | AddressHistory.PersonHistorySID = PersonHistory.PersonHistorySID | CASCADE if AddressHistory exists |
| PersonName | PersonName.PersonHistorySID = PersonHistory.PersonHistorySID | CASCADE if PersonName exists |