HealthOfficeVisitAssoc (ver21.4.0)
This table contains the selected values from the multi-select dropdowns on the Health Office Visit page for a student's office visit.
Column Name | Initial Version | Data Type | Description |
---|---|---|---|
CodeSetID | 21.4.0 | Number(19,0) | Foreign Key value for the codeset.ID for the selected value. Required. Unique index with HealthOfficeVisitID and SelectName. |
HealthOfficeVisitAssocID | 21.4.0 | Number(19,0) | Unique Key for this record. System assigned. |
HealthOfficeVisitID | 21.4.0 | Number(19,0) | Foreign Key to the related ID for the related Health Office Visit. Required. Unique index with CodeSetID and SelectName. |
SelectName | 21.4.0 | VarChar(20) | Text string that matches the dropdown label on the Health Office Visit page. Required. Unique index with CodeSetID and HealthOfficeVisitID. |
WhenCreated | 21.4.0 | Timestamp(6) | The date and time the record was created. Defaults to system date. |
WhenModified | 21.4.0 | Timestamp(6) | The date and time the record was modified. Defaults to system date. |
WhoCreated | 21.4.0 | Varchar2(100) | The name of the person who create the record. Defaults to user. |
WhoModified | 21.4.0 | Varchar2(100) | The name of person who modified the record. Defaults to user. |