Last Updated: 7/22/2025 8:42:49 PM
Intergy Version: 22.00.00.00
PersonRace
Table Definition Parent Tables Child Tables
Table Definition| Field | Datatype | Default | Null Option | Comment |
|---|---|---|---|---|
| PersonID | INTEGER | ? | MANDATORY | FK - from Person table |
| Race | CHAR(3) | MANDATORY | User selects race code. Race codes are defined in the Lookup Code table for the lookup types 'Race' and 'CDCRace'. Codes for lookup types 'Race' and 'CDCRace' are user definable. Certain race codes will be pre-loaded in the system. | |
| LookupType | CHAR(20) | Race | MANDATORY | LookupType of Race code. Will be "Race" or "CDCRace". |
| Order | INTEGER | 0 | OPTIONAL | |
| 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. |
| Parent Table | Join Phrase | When deleting parent record... |
|---|---|---|
| Person | PersonRace.PersonID = Person.PersonID | CASCADE if PersonRace exists |
| Child Table | Join Phrase | When deleting PersonRace record... |
|---|