This article covers tips and tricks and management of parent and student portal accounts used within Aeries.


Resetting parent/student passwords

If a parent or student forgets their password, they can easily reset it by clicking the Forgot Password? link from the login page. After clicking the link, the parent enters their email address and clicks Next. If the email address entered does not match an existing account, the parent will be presented with a message informing them that the email address could not be matched to an account.


At this point the parent should either create a new account (if your district is using individual account creation) or contact the school for assistance (the school would then enter the email address into Aeries to automatically generate an account). If the parent still has access to their old email account, they could reset their password using their old email address, then change their email address after logging in.



After entering their email address, the parent or student will be sent an email containing a link to reset their password. Below is an example of an email the parents or students will receive:



Having parents reset their own passwords is the typical option, however, passwords may also be reset via a Change query by a user with appropriate permissions. The password is stored in the PWA.PW field. After resetting their password in this manner, the parent can immediately log in without the need to verify an email. Changing a password to “welcome” or “changeme” will require the user to change the password the next time they log in.


Note: An option can be turned on to not allow parents or students to change their password. Check out the automated account creation article for details on this feature. Password requirements can also be defined.


Changing account type

Each portal account is tagged as either a Parent or Student. Occasionally there may be the need to change an account type from parent to student or vice versa. This may be necessary to allow the parent to access resources only available to parents (such as Data Confirmation), but they mistakenly have a student type account. This can be changed via a Change query when necessary. The account type is stored as a “P” or “S” value in the TY field of the PWA table.


Manage Parent/Student Accounts

The Manage Parent/Student Accounts form within Aeries can manage several portal account-related tasks. The user can search either by account email address or student ID number. When searching, be sure to set the appropriate Account Type and Account Status, and click Refresh. Typically, users Show All to show all accounts.


Emulating a parent account – Clicking the blue person icon next to an account will allow the current user to log in as the parent, without knowing the parent’s or student’s password. This is useful when troubleshooting account issues with parents, or when testing security setup.


Removing a student from an account - To remove a student from a parent account, click the red X on the right side of the screen. Clicking this will disassociate the student from the parent account. Note: if the student is at multiple schools, removing one school removes them all.


Removing an account - To remove an account altogether, click the red X on the left side of the screen next to the email address. This will delete the account completely.


Resending account verification email – Clicking on the envelope icon will resend the account confirmation email. This is only applicable for accounts that are still Pending.


This page also displays other PWA related information including account ID, account status, account type, last login date, and last login IP address for easy reference.


Note: Users need Administer permission to the Parent/Student Portal Accounts (PWA) security area to access this page.



It's also worth mentioning that the Student Profile Page contains any section showing any parent or student accounts linked to that student, as well as the last login date. This can be accessible by any user to see what accounts are linked to an individual student.



Database Field Information

Below is a list of common database tables and fields used with parent portal account management. These consist of the PWA table which stores parent and student portal accounts, and the PWS table which stores students associated to portal accounts.


PWA Table

PWA.AID – Account ID. Automatically assigned.

PWA.EM – Account email address. This is the username of the account.

PWA.PW – Password (hashed). Plain text is also accepted in this field.

PWA.MS – (not used)

PWA.ED – (not used)

PWA.MED – (not used)

PWA.PLC – Password Last Changed. The date and time the password was last changed. If set to NULL, the password was never changed by the user, and they may be prompted to reset it upon first login. See automated account creation for details.

PWA.PCC – Email Code/Password Change Code. Used in conjunction with the confirmation email, or reset password email.

PWA.AST – Account Status. P = Pending (did not confirm email yet) or (blank) = Confirmed

PWA.TY – Account Type. Valid values are P for Parent, or S for Student.

PWA.PID – Primary student ID. This student ID is shown first when the parent logs in. Typically, this is the first student added to their account.

PWA.LN – (not used)

PWA.FN – (not used)

PWA.LC – Login count

PWA.LIP – Last IP address

PWA.LDT – Date and time of last login

PWA.CIP – Current IP address

PWA.CDT – Date and time of current login

PWA.LPR – Date and time of last page request

PWA.CD – Creation Date.

PWA.XD – Expiration Date. If this field is populated with a date, the user will not be allowed to login after that date. The user will be presented with a message “This account has expired.” on the login page on after the date specified.

PWA.ADM – Admin Account Flag. Administrative account for testing. Accounts with this field set to 1 always see Data Confirmation, will disable emailing, and will generally be hidden in the system. This flag must be set via a CHANGE query or SQL Server query.

PWA.SLT – (not used)

PWA.FA – First Action. Used in conjunction with the School of Choice process


PWS Table

PWS.AID – Account ID. Relates to PWA table.

PWS.ID – Student ID.

PWS.AST – Used in conjunction with restricted contacts flag.

PWS.PCC – Used in conjunction with restricted contacts flag.