Last Updated: 7/22/2025 8:42:49 PM
Intergy Version: 22.00.00.00
PHIDisclosure
Table Definition Parent Tables Child Tables
Table Definition| Field | Datatype | Default | Null Option | Comment |
|---|---|---|---|---|
| PHIDisclosureSID | INTEGER | ? | MANDATORY | Syetem generated unique identifier form the PHI sequence. |
| PracticeID | INTEGER | ? | MANDATORY | FK |
| PatientID | INTEGER | ? | MANDATORY | FK |
| DisclosureType | CHARACTER(1) | OPTIONAL | Indicates whether the disclosure is related to authorization. Supported by lookup type PHIDiscType. Possible values: (A)uthorization , (O)ther. | |
| DisclosureDate | DATE | MANDATORY | Date of disclosure. | |
| ReceiverSID | INTEGER | ? | MANDATORY | System generated unique id using the Entity sequence. |
| PHIAuthSID | INTEGER | ? | OPTIONAL | FK when DisclosureType = A. |
| DisclosureReason | CHARACTER(1000) | MANDATORY | Reason for disclosure. | |
| DisclosureText | CHARACTER(1000) | MANDATORY | PHI information disclosed. | |
| DisclosureStatus | CHARACTER(1) | OPTIONAL | Disclosure status. Supported by lookup type PHIDiscStatus. Possible values: R - Reported , S - Report Suspended and V - Voided | |
| Note | CHARACTER(1000) | OPTIONAL | Short note or comment of disclosure. | |
| 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. |
| SuspendEndDate | DATE | OPTIONAL | Date when disclosure suspension ends and disclosure may be reported. | |
| Attention | CHARACTER(30) | OPTIONAL | Name of individual to send correspondence in attention to. User entered when receiver is company. |
| Parent Table | Join Phrase | When deleting parent record... |
|---|---|---|
| Entity | PHIDisclosure.ReceiverSID = Entity.EntitySID | CASCADE if PHIDisclosure exists |
| PHIAuthorization | PHIDisclosure.PHIAuthSID = PHIAuthorization.PHIAuthSID | NONE if PHIDisclosure exists |
| Patient | PHIDisclosure.PracticeID = Patient.PracticeID and PHIDisclosure.PatientID = Patient.PatientID |
CASCADE if PHIDisclosure exists |
| Child Table | Join Phrase | When deleting PHIDisclosure record... |
|---|---|---|
| PHIDiscActivity | PHIDiscActivity.PHIDisclosureSID = PHIDisclosure.PHIDisclosureSID | CASCADE if PHIDiscActivity exists |