Last Updated: 7/22/2025 8:42:49 PM
Intergy Version: 22.00.00.00
AdvanceDirective
Table Definition Parent Tables Child Tables
Table Definition| Field | Datatype | Default | Null Option | Comment |
|---|---|---|---|---|
| AdvanceDirectiveSID | INTEGER | ? | MANDATORY | System generated document identifier. The identifier value is obtained from the "AdvanceDirective" sequence. |
| DocumentSID | INTEGER | ? | OPTIONAL | FK to Document |
| PracticeID | INTEGER | ? | MANDATORY | FK to Patient |
| PatientID | INTEGER | ? | MANDATORY | FK to Patient |
| DateSigned | DATE | MANDATORY | Date when the Advance Directive was signed. | |
| Type | CHAR(15) | MANDATORY | User entered. Field is supported by the lookup types:[AdvDir]. Values are defined in the LookupCode table for the above lookup types. | |
| PatientAware | LOGICAL | OPTIONAL | A logical signifying whether or not the patient is aware of the advance directive placed on them. If set to yes, the ThirdParty value will be filled in. | |
| ThirdParty | CHARACTER(60) | OPTIONAL | User filled field signifying who placed the advance directive on the patient if the PatientAware field is true. This is NOT a FK to some other table in Intergy. | |
| Note | CHARACTER(14000) | OPTIONAL | User entered body of the note | |
| RevokedNote | CHARACTER(14000) | OPTIONAL | User entered body of the note when revoked. | |
| RecordStatus | CHAR(1) | MANDATORY | System maintained. Possible values: C - "Current" or R - "Revoked" | |
| 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. |
| VerifiedWithFamily | LOGICAL | ? | OPTIONAL | A logical signifying if the family member(s) is/are aware of the advance directive placed on the patient. TRUE indicates that the family is. Values of FALSE and ? will both indicate an 'Unknown status' as in 'It is not known if the family verified the advanced directive. The user interface will not capture the value of "FALSE". It will only capture Yes/?.' |
| Parent Table | Join Phrase | When deleting parent record... |
|---|---|---|
| Patient | AdvanceDirective.PracticeID = Patient.PracticeID and AdvanceDirective.PatientID = Patient.PatientID |
RESTRICT if AdvanceDirective exists |
| Document | AdvanceDirective.DocumentSID = Document.DocumentSID | SET NULL if AdvanceDirective exists |
| Child Table | Join Phrase | When deleting AdvanceDirective record... |
|---|---|---|
| AdvanceDirectiveActivity | AdvanceDirectiveActivity.AdvanceDirectiveSID = AdvanceDirective.AdvanceDirectiveSID | CASCADE if AdvanceDirectiveActivity exists |