Page Comparison

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 charactersMiddle 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 single selected

Approval Date

DateTimeDate

Based on rules

Default to be populated with the current date.

Approval Expiration Date

DateTimeDate

Based on rules

Default to be populated based off of the [MonthsGood] field of the state rule table.

• If populated it must be after the Approval Date value (or current date)

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.

Correction

Integer

Not shown to end user, will only be populated if this is an “Edit/Update”. Values are:

1 - No

2 - Yes

CorrectionList

String

Never

Not shown to end user, will only be populated if this is an “Edit/Update”. Values are derived from the fields that have changed between the “original” and “new” approvals. Values are to be stored in a comma delimited string (no spaces)

Values are:

1 - last name changed

2 - First Name changed

3 - Middle initial

4 - SSNO

5 - Birthdate

6 - Exam Level

7 - Approval Date

8 - Approval Expiration Date