During a school shutdown, outreach and engagement with students can be an essential function for teachers performing wellness checks. 


Aeries has a couple of solutions to assist in this function. The Aeries Visitation page and/or Aeries Custom Tables to record teacher outreach activity during this time. 


Aeries Visitation Page

The Visitation page can be used for keeping notes during wellness check correspondence. There's room for as much narrative information needed. Some districts may already use this page for other counseling functions.



A new code can be added to the CD field in the VIS table to track Wellness checks. See https://support.aeries.com/support/solutions/articles/14000065683-update-code-table  to update the code tables. 

(Note: Appropriate permissions are needed to update the code tables)


Multiple records can be added to any student the teacher/admin needs. There is a Visitation Report found on the Reports Tab. A user can select a time range to determine correspondence for a particular period of time of correspondence. 




NOTE: Appropriate permissions for this Visitation page is needed for any user, including teachers, to have access. Additionally, insure that any other information being entered by staff in the Visitation page is not confidential. Adding additional staff to this page, such as teachers, would have access to pre-existing Visitation data. 


You can find more information about the Aeries Visitation page at: https://support.aeries.com/support/solutions/articles/14000070187-counseling-and-visitations 


Create a Custom Student Wellness Check page

Going beyond built-in forms in Aeries, Aeries has a powerful tool to allow you to create your own custom page. This may be a desirable way to keep the data separate from other areas of Aeries.


The steps below will allow you to create a custom Student Wellness Check page, including a custom table that can be queried or reported upon in any fashion, just like any other table in Aeries. This is an example, and of course can be customized. Those who are self-hosted can install this themselves. If you are hosted by Aeries, our support team can quickly add this for you. Just refer them to this article.



Teachers and other users can navigate to this page and add records. In this example, it is called Student Wellness Check located under Student Data in the navigation add records.



Simple Queries can be built to report on the outreach activity. Here's an example of a basic query listing all students who have a record in this custom table.


LIST STU SCHK STU.LN STU.FN SCHK.DT SCHK.CD SCHK.CO


To install this custom table, simply run the below SQL query against your current year database. It will create the table itself, configure it as a custom table definition, and will add some default code table values. 


--Create the custom table to store the data Student Wellness Check (SCHK)
CREATE TABLE [dbo].[SCHK](
  [ID] [int] NOT NULL DEFAULT (0),
  [SQ] [smallint] NOT NULL DEFAULT (0),
  [DT] [datetime] NULL,
  [CD] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL DEFAULT (''),
  [CO] [nvarchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL DEFAULT (''),
  [DEL] [bit] NOT NULL DEFAULT (0),
  [DTS] [datetime] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCHK] WITH NOCHECK ADD 
  CONSTRAINT [PrimaryKey_SCHK] PRIMARY KEY  CLUSTERED 
  (
    [ID],
  [SQ]
  )  ON [PRIMARY] 
GO
ALTER TABLE [dbo].[SCHK]  WITH CHECK ADD  CONSTRAINT [FK_SCHK_IDN] FOREIGN KEY([ID])
REFERENCES [dbo].[IDN] ([ID])
ON UPDATE CASCADE
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[SCHK] CHECK CONSTRAINT [FK_SCHK_IDN]
GO
CREATE TRIGGER [dbo].[SCHK_update_DTS] ON [dbo].[SCHK] FOR UPDATE, INSERT AS IF EXISTS(SELECT INSERTED.DTS, DELETED.DTS FROM INSERTED, DELETED WHERE INSERTED.DTS=DELETED.DTS) OR (NOT EXISTS(SELECT DELETED.DTS FROM DELETED) AND EXISTS(SELECT INSERTED.DTS FROM INSERTED WHERE INSERTED.DTS IS NULL)) UPDATE SCHK SET SCHK.DTS = GetDate() FROM SCHK, INSERTED WHERE SCHK.ID = INSERTED.ID AND SCHK.SQ = INSERTED.SQ
GO

--Add the table and field definitions (Define Custom Tables)
INSERT [dbo].[CTD] ([TC], [NM], [NLC], [PKF], [PT], [PF], [CF], [OM], [OB], [DEL], [VW]) VALUES (N'SCHK', N'Student Wellness Check', N'Student Data', N'ID,SQ', N'STU', N'ID', N'ID', N'Many', N'DT DESC', 0, 0)
GO
INSERT [dbo].[CTF] ([TC], [FC], [SQ], [NM], [TY], [DL], [ML], [DS], [DEL]) VALUES (N'SCHK', N'CD', 2, N'Code', N'DropDown', 100, 3, 0, 0)
GO
INSERT [dbo].[CTF] ([TC], [FC], [SQ], [NM], [TY], [DL], [ML], [DS], [DEL]) VALUES (N'SCHK', N'CO', 4, N'Comment', N'Memo', 600, 5, 0, 0)
GO
INSERT [dbo].[CTF] ([TC], [FC], [SQ], [NM], [TY], [DL], [ML], [DS], [DEL]) VALUES (N'SCHK', N'DT', 1, N'Date', N'Date', 100, 0, 0, 0)
GO
INSERT [dbo].[CTF] ([TC], [FC], [SQ], [NM], [TY], [DL], [ML], [DS], [DEL]) VALUES (N'SCHK', N'NEWLINE1', 3, N'', N'', 0, 0, 0, 0)
GO

--Insert default code values to populate the dropdown (COD table)
INSERT [dbo].[COD] ([SC], [TC], [FC], [CD], [DE]) VALUES (0, N'SCHK', N'CD', N'E', N'Emailed')
GO
INSERT [dbo].[COD] ([SC], [TC], [FC], [CD], [DE]) VALUES (0, N'SCHK', N'CD', N'M', N'Mailed Letter')
GO
INSERT [dbo].[COD] ([SC], [TC], [FC], [CD], [DE]) VALUES (0, N'SCHK', N'CD', N'P', N'Phone Call')
GO
INSERT [dbo].[COD] ([SC], [TC], [FC], [CD], [DE]) VALUES (0, N'SCHK', N'CD', N'Z', N'Zoom Meeting')
GO


After running the script, the next step is to grant users permissions to this new page. You may grant the permission to the Teachers portal group to grant permissions to all teachers. Consider whether you want users to only read and insert records, or whether you want them to update and delete records as well.

 


As mentioned above, if you are self-hosted you can install this yourself. If you are hosted by Aeries, contact our support team to have this installed. In either case, if you need assistance, please contact Aeries Support.