Guardians, 55 (ver4.0.4)
This table stores information related to a students Guardian(s).
Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
Alias | 4.0.4 | Varchar(20) | Guardian's alias. |
AllowWebAccess | 4.0.4 | Number(10,0) | Indicates whether or not to allow Web Access. |
Classification | 4.0.4 | Varchar(20) | Guardian's specific classification. |
Day_Phone | 4.0.4 | Varchar(30) | Guardian's daytime phone number. |
DCID | 4.0.4 | Number(10,0) | Unique identifier for this table. Indexed. Required. |
| 4.0.4 | Varchar(80) | Guardian's Email address. | |
Evening_Phone | 4.0.4 | Varchar(30) | Guardian's evening phone number. |
FamilyID | 4.0.4 | Number(10,0) | Unique family identifier. |
Fax | 4.0.4 | Varchar(30) | Guardian's FAX number. |
First_Name | 4.0.4 | Varchar(15) | Guardian's first name. |
ID | 4.0.4 | Number(10,0) | Sequential number generated by the application, but uniqueness in the table is not guaranteed. Indexed. |
Last_Name | 4.0.4 | Varchar(20) | Guardian's last name. |
LastFirst | 4.0.4 | Varchar(35) | Concatenation of Guardian's first and last names. |
Middle_Name | 4.0.4 | Varchar(20) | Guardian's middle name. |
Relationship | 4.0.4 | Varchar(20) | Guardian's relationship to the student. |
RoleValue | 4.0.4 | Varchar(20) | Guardian's role value. |
Status | 4.0.4 | Number(10,0) | Guardian's status (the status of this relationship). |
StudentID | 4.0.4 | Number(10,0) | The internal number and ID of the associated Students record. |
Tier | 4.0.4 | Varchar(20) | Guardian's tier value. |
Web_ID | 4.0.4 | Varchar(20) | Web identifier (for Guardian access). |
WebEmail | 4.0.4 | Varchar(20) | Guardian's web-email address |
WebMailPassword | 4.0.4 | Varchar(20) | Guardian's web-email password. |
WebPassword | 4.0.4 | Varchar(20) | Guardian's password (hopefully encrypted). |