Password Complexity Requirements are not currently enabled for Teacher accounts.
','Aeries User, Teacher, and Parent and Student Portal accounts can have password requirements configured. Setting up these password requirements will force that User Type to update their password on a regular basis. The Aeries Admin user type is not bound by these password restrictions.
','ConfigurePasswordRequirements.aspx','','0',NULL,NULL,'0',NULL,'0',NULL,NULL,'3','1','7d172ae8-d8a9-4197-b356-f58135a14d4a' UNION ALL SELECT 38 + @vid,12 + @gid,'USRPWD','Password Policy - Users','DECLARE @status VARCHAR(15); SELECT @status = CD FROM DPT WHERE NM = ''UserPwdEnforceRules'' AND DEL = 0 AND CD = ''False'';IF NOT EXISTS( SELECT TOP 1 1 FROM DPT WHERE NM = ''UserPwdEnforceRules'' AND DEL = 0) BEGIN SET @status = ''Not Configured''; END; IF @status IS NOT NULL BEGIN SELECT @status [Status] , ''Password Complexity Requirements are not enabled for User accounts.'' [Description]; END; ELSE BEGIN SELECT CD [Status] , NM [Description] FROM DPT WHERE NM = ''UserPwdEnforceRules'' AND DEL = 0 AND CD = ''False''; END;','Status','','','Password Complexity Requirements are not currently enabled for User accounts.','Aeries User, Teacher, and Parent and Student Portal accounts can have password requirements configured. Setting up these password requirements will force that User Type to update their password on a regular basis. The Aeries Admin user type is not bound by these password restrictions.','ConfigurePasswordRequirements.aspx','','0',NULL,NULL,'0',NULL,'0',NULL,NULL,'2','1','48686b16-40e7-4f83-bcc2-7caacf5f414b' UNION ALL SELECT 39 + @vid,12 + @gid,'PWAPWD','Password Policy - Parents and Students','DECLARE @status VARCHAR(15); SELECT @status = CD FROM DPT WHERE NM = ''ParentStudentPwdEnforceRules'' AND DEL = 0 AND CD = ''False'';IF NOT EXISTS( SELECT TOP 1 1 FROM DPT WHERE NM = ''ParentStudentPwdEnforceRules'' AND DEL = 0) BEGIN SET @status = ''Not Configured''; END; IF @status IS NOT NULL BEGIN SELECT @status [Status] , ''Password Complexity Requirements are not enabled for Parent and Student accounts.'' [Description]; END; ELSE BEGIN SELECT CD [Status] , NM [Description] FROM DPT WHERE NM = ''ParentStudentPwdEnforceRules'' AND DEL = 0 AND CD = ''False''; END;','Status','','','Password Complexity Requirements are not currently enabled for Parent and Student accounts.','Aeries User, Teacher, and Parent and Student Portal accounts can have password requirements configured. Setting up these password requirements will force that User Type to update their password on a regular basis. The Aeries Admin user type is not bound by these password restrictions.','ConfigurePasswordRequirements.aspx','','0',NULL,NULL,'0',NULL,'0',NULL,NULL,'4','1','47df9aa5-8dcd-43c1-be47-9ff5f77f4ef1' UNION ALL SELECT 40 + @vid,12 + @gid,'ADMINACCT','Admin Accounts','SELECT UN [Username] , UTY [UserType] , UID [UID?] , ''This is an active Admin account.'' [Description] FROM UGN WHERE UTY LIKE ''%admin'' AND ST = 0 AND (XD IS NULL OR XD > GETDATE()) AND UTY <> ''hostedadmin'' AND DEL = 0;','Username','UserType','','The accounts listed here are active "admin" accounts. They have unrestricted access to Aeries.','Examine this list and ensure that the accounts are still needed. Disable or expire any accounts as necessary.','SecurityUsers.aspx','','0',NULL,NULL,'0',NULL,'0',NULL,NULL,'2','1','d3e8cd1c-9aa5-438f-83ac-def5215bf66a' UNION ALL SELECT 41 + @vid,12 + @gid,'UNUSEDACCT','Unused Account','SELECT UN [Username] , CONVERT(VARCHAR(10), CD, 101) [CreateDate] , UID [UID?] , ''This is an active unused account.'' [Description] FROM UGN WHERE DEL = 0 AND LC = 0 AND ST = 0 AND CD < DATEADD(MONTH, -1, GETDATE()) AND (XD IS NULL OR XD > GETDATE()) AND TY = 1;','Username','CreateDate','W','This account was created at least 30 days ago, and it has never been used.','Consider disabling this account until it is needed.','SecurityUsers.aspx','','0',NULL,NULL,'0',NULL,'0',NULL,NULL,'2','1','06694674-7ded-4d62-836e-5455ac1a1afa' UNION ALL SELECT 42 + @vid,13 + @gid,'ACSURCON','Surrogate Contact','SELECT STU.ID [StudentID],''Student '' + STU.FN + '' '' + STU.LN + '' has no Contacts with Notification Preferences enabled.'' [Description] FROM STU LEFT JOIN CON ON STU.ID = CON.PID AND CON.NP IN (''1'',''2'') AND CON.DEL = 0 WHERE STU.DEL = 0 AND STU.TG = '''' AND CON.PID IS NULL AND STU.SC = @SchoolCode AND STU.ID IN (@StudentID)','StudentID','','W','This student has no Contacts with Notification Preferences enabled. This will result in a "surrogate contact" being created in Aeries Communications using data from Student Demographics instead.','Update Contacts to include at least one record with Notification Preferences enabled.','EmergencyContacts.aspx','','1',NULL,NULL,'0',NULL,'0',NULL,NULL,'40','1','3936062f-e886-42d6-bb26-388ca10f8f1d' UNION ALL SELECT 43 + @vid,13 + @gid,'ACCORLANG','Correspondence Language Differs from STU','SELECT STU.ID [StudentID] , STU.CL [STUCL] , CON.CL [CONCL] , ''Contact '' + CON.FN + '' '' + CON.LN + '' has a different Correspondence Language than the STU record.'' [Description] FROM STU INNER JOIN CON ON STU.ID = CON.PID AND CON.NP IN(''1'', ''2'') AND CON.DEL = 0 AND CON.MU1 <> ''O'' WHERE STU.DEL = 0 AND STU.TG = '''' AND CASE CON.CL WHEN '''' THEN ''00'' ELSE CON.CL END <> STU.CL AND STU.SC = @SchoolCode AND STU.ID IN (@StudentID)','STUCL','CONCL','','The Correspondence Language on the Contact record is different than what is set on the Student record. This might mean that Aeries Communications messages are being sent in an unexpected language.','Check with the contact to ensure the setting is correct. If it is, set ''User1'' to ''O'' (Override) to clear this error.','EmergencyContacts.aspx','','1',NULL,NULL,'0',NULL,'0',NULL,NULL,'102','1','15963333-87f5-4d3c-9d23-4852c4a82d50' UNION ALL SELECT 44 + @vid,13 + @gid,'ACMISSINGNAME','Contact Missing FN or LN','SELECT STU.ID [StudentID] , CON.LN [LastName] , CON.FN [FirstName] , ''Contact '' + CON.NM + '' is missing data in FirstName or LastName fields.'' [Description] FROM STU INNER JOIN CON ON STU.ID = CON.PID AND CON.NP IN(''1'', ''2'') AND CON.DEL = 0 WHERE STU.DEL = 0 AND STU.TG = '''' AND (LTRIM(RTRIM(CON.LN)) = '''' OR LTRIM(RTRIM(CON.FN)) = '''') AND STU.SC = @SchoolCode AND STU.ID IN (@StudentID)','LastName','FirstName','E','This contact has Notification Preferences enabled, but is missing either the "First Name" or the "Last Name" on the record.','Contacts with Notification Preferences enabled are required to have "First Name" and "Last Name" populated. The "Mailing Name" is not used in Aeries Communications.','EmergencyContacts.aspx','','1',NULL,NULL,'0',NULL,'0',NULL,NULL,'62','1','cb4972b7-60ed-44b1-b3b6-ecf0f8029c45' UNION ALL SELECT 46 + @vid,13 + @gid,'ACPWANOEM','Parent Account not on CON.EM','SELECT STU.ID [StudentID] , PWA.EM [PortalAccount] , ''This Parent Portal account is linked to this student, but does not match the email address for an existing Contact.'' [Description] FROM STU INNER JOIN PWS ON STU.ID = PWS.ID AND PWS.AST = '''' INNER JOIN PWA ON PWS.AID = PWA.AID AND PWA.TY = ''P'' AND PWA.AST = '''' LEFT JOIN CON ON STU.ID = CON.PID AND PWA.EM = CON.EM AND CON.DEL = 0 WHERE STU.DEL = 0 AND PWA.DEL = 0 AND CON.PID IS NULL AND STU.SC = @SchoolCode AND STU.ID IN (@StudentID)','StudentID','PortalAccount','W','A Parent account was created without being linked to an existing Contact, or the email address in Contacts was changed while declining to update the Parent account.','Update the Contact email address for the appropriate Contact to match the email address of the Parent account, or disabled the Parent account.','EmergencyContacts.aspx','SecurityManagePWA.aspx','1',NULL,NULL,'0',NULL,'0',NULL,NULL,'85','1','7be99ad3-7816-4a3a-9cc1-4f12ef9f2189' UNION ALL SELECT 51 + @vid,14 + @gid,'ACNORESTCD','No Restricted Code for Contacts','DECLARE @status VARCHAR(15); IF NOT EXISTS( SELECT TOP 1 1 FROM COD WHERE TC = ''CON'' AND FC = ''CD'' AND DEL = 0 AND N1 = 9) BEGIN SET @status = ''Not Configured''; END; IF @status IS NOT NULL BEGIN SELECT @status [Status] , ''There is no code for CON.CD designated as ''''Restricted.'''''' [Description]; END; ELSE BEGIN SELECT CD [Status] , '''' [Description] FROM COD WHERE TC = ''ITEXISTS''; END;','Status','','E','There is no code defined in the COD table for CON.CD as a "Restricted" code.','To designate a code for CON.CD as "Restricted," change the N1 value to 9 for one of your codes.
See Limiting or Restricting Parent/Student Portal Accounts for more detail.
','UpdateCodeTable.aspx','','0',NULL,NULL,'0',NULL,'0',NULL,NULL,'6','1','596e331c-b57d-4216-817d-bceb1163e201' UNION ALL SELECT 45 + @vid,14 + @gid,'ACCONMISMATCH','Inconsistent Contact Data between Contacts','SELECT STU.ID [StudentID] , C1.PID [StuID1] , C2.PID [StuID2] , ''These two Contacts share the same email address(''+C1.EM+''), but have differing contact data in other fields.'' [Description] FROM STU INNER JOIN CON C1 ON STU.ID = C1.PID AND C1.NP IN(''1'', ''2'') AND C1.DEL = 0 INNER JOIN CON C2 ON C1.EM = C2.EM AND C2.NP IN (''1'', ''2'') AND C2.DEL = 0 AND C1.PID <> C2.PID AND C1.EM <> '''' AND C2.PID IN (SELECT ID FROM STU WHERE DEL = 0 AND TG = '''') WHERE STU.DEL = 0 AND STU.TG = '''' AND (C1.TL <> C2.TL OR C1.CP <> C2.CP OR C1.LN <> C2.LN OR C1.FN <> C2.FN);','StuID1','StuID2','W','Contact record for one student was updated, but not all copies of the same contact on other students were updated to match.','Determine the latest information and update the other Contact records accordingly.','EmergencyContacts.aspx','','1',NULL,NULL,'0',NULL,'0',NULL,NULL,'100','1','6b295272-4550-4110-8769-33a394ef70b4' UNION ALL SELECT 52 + @vid,14 + @gid,'ACSTF','Staff w/ Notification Preferences Enabled Missing CON.EM and CON.CP','select id [StaffID], id [ID?], fn + N'' '' + ln + N'' has Notification Preferences enabled, but no email nor mobile phone.'' [Description] from stf where del = 0 and tg = '''' and cp = 0 and em = '''' and np > 0;','StaffID','','E','Aeries Communications requires at least a mobile phone or an email address for staff members. Notification preferences have been enabled, but no valid contact modalities have been populated.','Add an email address (STF.EM) or a mobile phone number (STF.CP).','Staff.aspx','','1',NULL,NULL,'0',NULL,'0',NULL,NULL,'100','1','6b295272-4550-4110-8769-33a394ef70b4' SET IDENTITY_INSERT DVD OFF