...
The following is a list of fields possible for data entry.
Field | ConstraintssConstraints | Required | Notes | Validation Rules | |||
|---|---|---|---|---|---|---|---|
Last Name | 35 characters | Always | Must be at least 2 characters and less than or equal to 35 characters | ||||
Suffix | 10 characters | Never | |||||
First Name | 35 characters | Always | Must be at least 2 characters and less than or equal to 35 characters | Middle Initial | 1 character | Never | |
ID Number | 11 characters | Based on rules | Refer to [IDNo label string] field on State rule table | Remove all non-numeric items from the value; Length must be equal to value based on [SSNo[ field of the State rule table. | |||
Date of Birth | Date | Based on rules | Refer to the [BirthDate] field on the State rule tableRequired | Per Team, this is now a required field | Must be a date at least 16 17 years in the past | ||
Exam Level | Integer | Always | Refer to the [ApprovesASExam], [ApprovesBSExam],[ApprovesMSExam], [ApprovesCLExam], ]ApprovesAGExam'] fields on the State rule table | Must have a single value selected | |||
Approval Date | Date | Based on rules | Default to be populated with the current date. | ||||
Approval Expiration Date | Date | Based on rules | Default to be populated based off of the [MonthsGood] field of the state rule table. |
| |||
Internal ID Number (personal ID) | 25 characters | Never | New field which will be used by boards to identify record. This field if populated will eventually be available on score rosters. |
...