Last Updated: 7/22/2025 8:42:49 PM
Intergy Version: 22.00.00.00
PracPersonHousehldIncome
Table Definition Parent Tables Child Tables
Table Definition| 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 Table | Join Phrase | When deleting parent record... |
|---|---|---|
| Patient | PracPersonHousehldIncome.PracticeID = Patient.PracticeID and PracPersonHousehldIncome.PersonID = Patient.PatientID |
CASCADE if PracPersonHousehldIncome exists |
| Child Table | Join Phrase | When deleting PracPersonHousehldIncome record... |
|---|