Last Updated: 7/22/2025 8:42:49 PM
Intergy Version: 22.00.00.00
AdvanceDirectiveActivity
Table Definition Parent Tables Child Tables
Table Definition| Field | Datatype | Default | Null Option | Comment |
|---|---|---|---|---|
| AdvanceDirectiveSID | INTEGER | ? | MANDATORY | FK to AdvanceDirective |
| ActivityCount | INTEGER | 0 | MANDATORY | Programmatically set to the next sequential number that represents the next activity that occurred for the advancedirective |
| ActivityClass | CHARACTER(6) | OPTIONAL | This will be based on a lookup type "ADACTCLASS" | |
| EncounterSID | INTEGER | ? | MANDATORY | FK to Encounter. |
| Note | CHARACTER(500) | OPTIONAL | Exta information provided by the user about the note. | |
| ActivityUserID | INTEGER | OPTIONAL | FK to MMUserID Person who did something with the advance directive. | |
| ActivityStamp | CHARACTER(14) | OPTIONAL | Used to indicated when the activity occured. This is field is formatted like a standard intergy field. | |
| 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. |
| Parent Table | Join Phrase | When deleting parent record... |
|---|---|---|
| Encounter | AdvanceDirectiveActivity.EncounterSID = Encounter.EncounterSID | RESTRICT if AdvanceDirectiveActivity exists |
| AdvanceDirective | AdvanceDirectiveActivity.AdvanceDirectiveSID = AdvanceDirective.AdvanceDirectiveSID | CASCADE if AdvanceDirectiveActivity exists |
| Child Table | Join Phrase | When deleting AdvanceDirectiveActivity record... |
|---|