Last Updated: 7/22/2025 8:42:49 PM
Intergy Version: 22.00.00.00
PHIConsentActivity
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. |
| ActivityCount | INTEGER | 0 | MANDATORY | Programmatically set to the next sequential number that represents the next activity that occurred against the PHI Disclosure. |
| ActivityText | CHARACTER(80) | OPTIONAL | Programmatically set text describing the activity. | |
| 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. |
| ActivityCode | CHARACTER(1) | OPTIONAL | Indicates type of activity. Possible values: C - Created , E - Edited , V - Voided , R - Report |
| Parent Table | Join Phrase | When deleting parent record... |
|---|---|---|
| PHIConsent | PHIConsentActivity.PHIConsentSID = PHIConsent.PHIConsentSID | CASCADE if PHIConsentActivity exists |
| Child Table | Join Phrase | When deleting PHIConsentActivity record... |
|---|