Last Updated: 9/24/2025 12:09:38 PM
Intergy Version: 22.00.00.00
PHIAuthorization
Table Definition Parent Tables Child Tables
Table Definition| Field | Datatype | Default | Null Option | Comment |
|---|---|---|---|---|
| PHIAuthSID | INTEGER | ? | MANDATORY | System generated unique identifier based on the PHI Sequence. |
| PracticeID | INTEGER | ? | MANDATORY | FK |
| PatientID | INTEGER | ? | MANDATORY | FK |
| ReceiverSID | INTEGER | ? | MANDATORY | System generated unique id using the Entity sequence. |
| AuthParty | CHARACTER(60) | OPTIONAL | Indicates party that is authorized to give PHI to receiver. | |
| AuthReason | CHARACTER(1000) | MANDATORY | Reson for the disclosure. | |
| AuthText | CHARACTER(1000) | MANDATORY | PHI Information authorized to be disclosed. | |
| ExpirationDate | DATE | OPTIONAL | Expiration date for authorization. Required for Expired authorizations. | |
| AuthExpirationEvent | CHARACTER(60) | OPTIONAL | Event that causes authorizations to be expired. | |
| SignedDate | DATE | OPTIONAL | Date that authorization was signed. | |
| SignedSource | CHARACTER(1) | OPTIONAL | Source of authorization signature. Field supported by lookup type PHISignSource. Possible values: (P)atient, Paren(t), (L)egal Guardian, additional user defined codes. | |
| AuthStatus | CHARACTER(1) | OPTIONAL | System defined. Authorization status. Field is supported by the lookup types:[PHIAuthStatus]. Values are defined in the LookupCode table for the above lookup types. | |
| Note | CHARACTER(1000) | OPTIONAL | Short note or comment of authorization. | |
| 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. |
| Attention | CHARACTER(30) | OPTIONAL | Name of individual to send correspondence in attention to. User entered when receiver is company. | |
| AuthorizingEntityType | CHARACTER(1) | OPTIONAL | Valid values: P - Patient , G - Government | |
| SuspendEndDate | DATE | OPTIONAL | Date when disclosure suspension ends and disclosure may be reported. | |
| SignedSourceName | CHARACTER(30) | OPTIONAL | User entered name of person signing authorization. |
| Parent Table | Join Phrase | When deleting parent record... |
|---|---|---|
| Entity | PHIAuthorization.ReceiverSID = Entity.EntitySID | RESTRICT if PHIAuthorization exists |
| Patient | PHIAuthorization.PracticeID = Patient.PracticeID and PHIAuthorization.PatientID = Patient.PatientID |
CASCADE if PHIAuthorization exists |
| Child Table | Join Phrase | When deleting PHIAuthorization record... |
|---|---|---|
| PHIDisclosure | PHIDisclosure.PHIAuthSID = PHIAuthorization.PHIAuthSID | NONE if PHIDisclosure exists |