Last Updated: 9/24/2025 12:09:38 PM

Intergy Version: 22.00.00.00

PracPersonHousehldIncome

Table Definition  Parent Tables  Child Tables

Table Definition

Description: This table stores the household income information for the practice person.

Field Datatype Default Null Option Comment
PracticeID INTEGER ?   MANDATORY FK - From Patient
PersonID INTEGER ?   MANDATORY FK - From Patient
EffectiveDate DATE   MANDATORY Date that the current household income information was documented.
IncomePeriod CHAR(2)   OPTIONAL Determines how often the patient is paid their Gross Income and is used to calculate Annual Income. Valid values are stored in Lookup Type IncomePeriod.
GrossIncome DECIMAL(10,2) 0   OPTIONAL Patient's total household income per pay period.
AnnualIncome DECIMAL(10,2) 0   OPTIONAL Patient's total household income per year.
ExpirationDate DATE   OPTIONAL Date that the current household information expires and must be renewed by the patient.
NumberSupported INTEGER 0   OPTIONAL Number of people supported by the household's income.
Documented CHARACTER(1)   MANDATORY System defined. Whether the patient adequately documented or proved their income to the practice. Valid values are stored with the lookup type. Field is supported by the lookup types:[Documented]. Values are defined in the LookupCode table for the above lookup types.
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.
DependentTeen CHAR(1) No_Value__N_   OPTIONAL Indicates whether the patient is a dependent, useful for separating their income out. Based on confirmation lookup code.

Parent Tables
Parent TableJoin PhraseWhen deleting parent record...
Patient PracPersonHousehldIncome.PracticeID = Patient.PracticeID and
PracPersonHousehldIncome.PersonID = Patient.PatientID		 CASCADE if PracPersonHousehldIncome exists

Child Tables
Child TableJoin PhraseWhen deleting PracPersonHousehldIncome record...