Last Updated: 7/22/2025 8:42:49 PM

Intergy Version: 22.00.00.00

PersonOccupation

Table Definition  Parent Tables  Child Tables

Table Definition

Description: No Description Available

Field Datatype Default Null Option Comment
PersonID INTEGER ?   MANDATORY FK - Person
OccupationCode CHAR(300)   OPTIONAL FK - Occupation
OccupationHireFuzzyDate CHAR(14)   OPTIONAL A "fuzzy" timestamp representing when the person was hired for this occupation. "Fuzzy" means the timestamp precision is variable. The hire date will be in one the following formats: YYYY, YYYY-MM, YYYY-MM-DD,
OccupationIndustryCode CHAR(20)   OPTIONAL FK - OccupationIndustry
LastModifiedByPracticeID INTEGER ?   MANDATORY FK from Practice. The PracticeID of the last practice that modified the occupation fields for the person
LastModifiedByDateTime DATETIME-TZ   MANDATORY The date, time and time zone offset the person occupation was modified.
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 Tables
Parent TableJoin PhraseWhen deleting parent record...
Practice PersonOccupation.LastModifiedByPracticeID = Practice.PracticeID CASCADE if PersonOccupation exists
OccupationIndustry PersonOccupation.OccupationIndustryCode = OccupationIndustry.Code RESTRICT if PersonOccupation exists
Occupation PersonOccupation.OccupationCode = Occupation.Code RESTRICT if PersonOccupation exists
Person PersonOccupation.PersonID = Person.PersonID CASCADE if PersonOccupation exists

Child Tables
Child TableJoin PhraseWhen deleting PersonOccupation record...