Last Updated: 7/22/2025 8:42:49 PM
Intergy Version: 22.00.00.00
PHIConsent
Table Definition Parent Tables Child Tables
Table Definition| Field | Datatype | Default | Null Option | Comment |
|---|---|---|---|---|
| PHIConsentSID | INTEGER | ? | MANDATORY | System defined. Indicates status of patient consent. If empty, the system will use 'Y' if the ConsentFlag is 'Y' else it will use 'N' when doing the actual Rx History EDI Request. Field is supported by the lookup types:[RxHistoryConsent]. Values are defined in the LookupCode table for the above lookup types. |
| PracticeID | INTEGER | ? | MANDATORY | FK |
| PatientID | INTEGER | ? | MANDATORY | FK |
| ConsentFlag | CHARACTER(1) | MANDATORY | Indicates status of patient consent. Consent codes are provided by the Lookup Type PatientConsent. Possible values: N- No , Y- Yes , L- Limited , R - Revoked and U - Unknown | |
| SignedDate | DATE | OPTIONAL | Date consent form was signed by the patient. | |
| Note | CHARACTER(1000) | OPTIONAL | Short note or comment of consent. | |
| 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. |
| ConsentStatus | CHARACTER(1) | OPTIONAL | Indicates the status of the consent record. Valid values: V - Voided, X - Consent has expired | |
| RxHistoryConsentFlag | CHAR(1) | MANDATORY | Indicates status of patient consent as defined by the RxHistoryPatientConsent LookupType. If empty, the system will use 'Y' if the ConsentFlag is 'Y' else it will use 'N' when doing the actual Rx History EDI Request. | |
| RSRConsentFlag | CHARACTER(1) | OPTIONAL | Indicates the status of the patient Ryan White Services Report consent. Consent codes are provided by the Lookup Type RSRConsent. Possible values: Y-Yes , N-No , L-Limited , R-Revoked and U-Unknown |
| Parent Table | Join Phrase | When deleting parent record... |
|---|---|---|
| Patient | PHIConsent.PracticeID = Patient.PracticeID and PHIConsent.PatientID = Patient.PatientID |
CASCADE if PHIConsent exists |
| Child Table | Join Phrase | When deleting PHIConsent record... |
|---|---|---|
| PHIConsentActivity | PHIConsentActivity.PHIConsentSID = PHIConsent.PHIConsentSID | CASCADE if PHIConsentActivity exists |