...
Field | Constraints | Required | Notes | Validation Rules |
|---|---|---|---|---|
Last Name | 35 characters | Always | Must be at least 2 characters and less than or equal to 35 characters | |
Middle initial | 1 character | Never | ||
Suffix | 10 characters | Never | this will not be used until phase 3 | |
First Name | 35 characters | Always | Must be at least 2 characters and less than or equal to 35 characters | |
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 | Required | Per Team, this is now a required field | Must be a date at least 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. |
...