Last Updated: 7/22/2025 8:42:49 PM
Intergy Version: 22.00.00.00
PatientRSRInfo
Table Definition Parent Tables Child Tables
Table Definition| Field | Datatype | Default | Null Option | Comment |
|---|---|---|---|---|
| PracticeID | INTEGER | ? | MANDATORY | FK - from Patient table |
| PatientID | INTEGER | ? | MANDATORY | FK - from Patient table |
| EffectiveDate | DATE | MANDATORY | Date that the patient's RSR Status was entered | |
| EnrollmentStatus | CHAR(15) | OPTIONAL | User selected enrollment status. Enrollment status codes are defined in the LookupCode table for the lookup type 'RSREnrollmentStatus'. Codes for lookup type 'RSREnrollmentStatus' are system defined. | |
| HousingStatus | CHAR(15) | OPTIONAL | User selected housing status. Housing status codes are defined in the LookupCode table for the lookup type 'RSRHousingStatus'. Codes for lookup type 'RSRHousingStatus' are system defined. | |
| PremiumFunding | CHAR(15) | OPTIONAL | User selected premium funding. Premium funding codes are defined in the LookupCode table for the lookup type 'RSRPremiumFunding'. Codes for lookup type 'RSRPremiumFunding' are system defined. | |
| 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. |
| FirstServiceDate | DATE | OPTIONAL | User entered date of Patients First Ryan White Service. | |
| NumHouseholdHIV | INTEGER | ? | OPTIONAL | User entered number of people with HIV living in the patient's household (including the patient). |
| HousingStatusCollectionDate | DATE | ? | OPTIONAL | Date when the Housing status is provided |
| Parent Table | Join Phrase | When deleting parent record... |
|---|---|---|
| Patient | PatientRSRInfo.PracticeID = Patient.PracticeID and PatientRSRInfo.PatientID = Patient.PatientID |
CASCADE if PatientRSRInfo exists |
| Child Table | Join Phrase | When deleting PatientRSRInfo record... |
|---|