D5SPEC-PersonValidationRules-031017-1224-14

Person Validation Rules
Appendix A - Person Validation Rules

Person Search
Name

Pre-Enrollment

First Name

Accepted
length of field
6

20

Validation
Required

Format

Default Value

No*

Text Field

Enter or Scan
Enrollment Code

No*

Text Field

First Name

Rules
*The Pre-enrollment field shall be required if searching by
Pre-Enrollment code
The Pre-Enrollment code shall a code consisting of 6
alpha-numeric characters.
-*The First Name field shall only be required when initiating person
enrollment.
-The system shall accept the characters specified below as valid
characters in the first name.
A-Z
a-z
Hyphen ( - )
Apostrophe ( ‘ )
Space( e.g. De Anza)
Numeric

Last Name

25

No*

Text Field

Last Name

-*The Last Name field shall only be required when initiating person
enrollment.
-The system shall accept the characters specified below as valid
characters in the last name.
A-Z
a-z
Hyphen ( - )
Apostrophe ( ‘ )
Space( e.g. De Anza)
Numeric

Identifier Type

NA

No*

Drop-Drown

(Identifier Type)

-*The Identifier Type field shall only be required when initiating
person enrollment.
-The following options shall be available in the Identifier Type drop
down list:
SSN
Alien Registration Number
Certificate of Naturalization
DoD EDIPI
Drivers License
Employment Authorization Document
Foreign ID (US Issued)
National ID (Foreign Country Issued)
Other
Passport
State ID
Taxpayer ID Number (TIN)

Identifier

Default 25; but
varies in length
per identifier

Yes

Text Field

Personal
Identifier

The Identifier field shall be required if an Identifier Type has
been selected or when initiating person enrollment
Name

SSN

Min
Length
9

Max
length
9

Values

Character
Format

Numeric

Cannot be:
000######
666######
9########
###00####
#####0000

Alien
Registration

7

10

Alphanumeric

Alpha-numeric
(AXXXXXXXXX)

Certificate of
Naturalization

1

25

Alphanumeric

Alpha-numeric

DoD EDI

10

10

Numeric

Numeric

Drivers
License

1

25

Alphanumeric

Alpha-numeric

Employment
Authorization
Document

1

25

Alphanumeric

Typical
document
contains both the
Alien
Registration
Number and a
Card number
(example has 13
alphanumeric
digits)

Foregin ID

9

9

Numeric

National ID
(Foreign
Country
Issued)

1

25

Alphanumeric

Other

1

25

Alphanumeric

Passport

6

9

Alphanumeric

State ID

1

25

Alphanumeric

Taxpayer
Identification
Number

9

9

Numeric

ranges:
900700000 to
999889999
900900000 to
999929999
900940000 to
999999999

Issuer

NA

Collectively
Required

Drop-Down

(Identifier Issuer)
The system shall make the issuer required/not required based
on the specified below issuer rules.
If the Identifier Type
selected is:

Issuer

Is Required

SSN
Populate State
List

Passport

Populate
Country List

Foreign ID

x

Temporary identifier

x

DBIDS Identifier

x

Tax Identification Number

x

Other Identifier

x

x

DOD_ED_PN_ID

x

Alien Registration Number

Yes

Acceptable
Formats

DOB

Populate State
List

Employment Authorization
Document

National ID (foreign Country
Issued)

NA

x

Drivers License

State ID

Date of Birth

Is Not
Required

Populate
Country List
x

The system shall accept the specified below dates as valid date of
birth.

MM/DD/YYYY

must be on or after 1/1/1900
must be on or before sysdate
Month values are from 01 to 12; day ranges depend on months
selected

Biographic Information
Name

Last Name

Accepted
length of
field

Validation
Required

Format

Default
Value

Rules

26

Yes

Text Field

NA

The system shall accept the characters specified below as valid characters in the
last name.
A-Z
a-z
Hyphen ( - )
Apostrophe ( ‘ )
Space( e.g. De Anza)
Numeric

Middle Name

20

No

Text Field

NA

The system shall accept the characters specified below as valid characters in the
middle name.
A-Z
a-z
Hyphen ( - )
Apostrophe ( ‘ )
Space( e.g. De Anza)
Numeric

First Name

20

Yes

Text Field

NA

The system shall accept the characters specified below as valid characters in the
first name.
A-Z
a-z
Hyphen ( - )
Apostrophe ( ‘ )
Space( e.g. De Anza)
Numeric

Suffix

NA

No

Drop-down

Select

The following options shall be available in the 'Suffix' drop down list:
(blank)
I
II
Jr
Sr
III
IV
V

Date of Birth

NA

Yes

Acceptable
Formats:

NA

must be on or after 1/1/1900
must be on or before sysdate
Month values are from 01 to 12; day ranges depend on months selected

MM/DD/YYYY

Gender

NA

No

Drop-down

The system shall accept the specified below dates as valid date of birth.

Unknown

The drop-down options shall include the following:
Male
Female
Unknown

Citizenship

NA

Yes

Drop-down

Select
AFGHANISTAN
AKROTIRI
ALBANIA
ALGERIA
AMERICAN SAMOA
ANDORRA
ANGOLA
ANGUILLA
ANTARCTICA
ANTIGUA AND BARBUDA
ARGENTINA
ARMENIA
ARUBA
ASHMORE AND CARTIER ISLANDS
AUSTRALIA
AUSTRIA
AZERBAIJAN
BAHAMAS, THE
BAHRAIN
BAKER ISLAND
BANGLADESH
BARBADOS
BASSAS DA INDIA
BELARUS
BELGIUM
BELIZE
BENIN
BERMUDA
BHUTAN
BOLIVIA
BONAIRE, SINT EUSTATIUS, AND SABA
BOSNIA AND HERZEGOVINA
BOTSWANA
BOUVET ISLAND

BRAZIL
BRITISH INDIAN OCEAN TERRITORY
BRUNEI
BULGARIA
BURKINA FASO
BURMA
BURUNDI
CABO VERDE
CAMBODIA
CAMEROON
CANADA
CAYMAN ISLANDS
CENTRAL AFRICAN REPUBLIC
CHAD
CHILE
CHINA
CHRISTMAS ISLAND
CLIPPERTON ISLAND
COCOS (KEELING) ISLANDS
COLOMBIA
COMOROS
CONGO (BRAZZAVILLE)
CONGO (KINSHASA)
COOK ISLANDS
CORAL SEA ISLANDS
COSTA RICA
CROATIA
CUBA
CURACAO
CYPRUS
CZECH REPUBLIC
DENMARK
DHEKELIA
DIEGO GARCIA
DJIBOUTI
DOMINICA
DOMINICAN REPUBLIC
ECUADOR
EGYPT
EL SALVADOR
ENTITY 6
EQUATORIAL GUINEA
ERITREA
ESTONIA
ETHIOPIA
EUROPA ISLAND
FALKLAND ISLANDS (ISLAS MALVINAS)
FAROE ISLANDS
FIJI
FINLAND
FRANCE
FRENCH GUIANA
FRENCH POLYNESIA
FRENCH SOUTHERN AND ANTARCTIC LANDS
GABON
GAMBIA, THE
GAZA STRIP
GEORGIA
GERMANY
GHANA
GIBRALTAR
GLORIOSO ISLANDS
GREECE
GREENLAND
GRENADA
GUADELOUPE
GUAM
GUANTANAMO BAY NAVAL BASE
GUATEMALA
GUERNSEY
GUINEA
GUINEA-BISSAU
GUYANA
HAITI
HEARD ISLAND AND MCDONALD ISLANDS
HONDURAS
HONG KONG
HOWLAND ISLAND
HUNGARY
ICELAND
INDIA
INDONESIA
IRAN

IRAQ
IRELAND
ISLE OF MAN
ISRAEL
ITALY
IVORY COAST
JAMAICA
JAN MAYEN
JAPAN
JARVIS ISLAND
JERSEY
JOHNSTON ATOLL
JORDAN
JUAN DE NOVA ISLAND
KAZAKHSTAN
KENYA
KINGMAN REEF
KIRIBATI
KOREA, NORTH
KOREA, SOUTH
KOSOVO
KUWAIT
KYRGYZSTAN
LAOS
LATVIA
LEBANON
LESOTHO
LIBERIA
LIBYA
LIECHTENSTEIN
LITHUANIA
LUXEMBOURG
MACAU
MACEDONIA
MADAGASCAR
MALAWI
MALAYSIA
MALDIVES
MALI
MALTA
MARSHALL ISLANDS
MARTINIQUE
MAURITANIA
MAURITIUS
MAYOTTE
MEXICO
MICRONESIA, FEDERATED STATES OF
MIDWAY ISLANDS
MOLDOVA
MONACO
MONGOLIA
MONTENEGRO
MONTSERRAT
MOROCCO
MOZAMBIQUE
NAMIBIA
NAURU
NAVASSA ISLAND
NEPAL
NETHERLANDS
NEW CALEDONIA
NEW ZEALAND
NICARAGUA
NIGER
NIGERIA
NIUE
NORFOLK ISLAND
NORTHERN MARIANA ISLANDS
NORWAY
OMAN
PAKISTAN
PALAU
PALMYRA ATOLL
PANAMA
PAPUA NEW GUINEA
PARACEL ISLANDS
PARAGUAY
PERU
PHILIPPINES
PITCAIRN ISLANDS
POLAND
PORTUGAL
PUERTO RICO

QATAR
REUNION
ROMANIA
RUSSIA
RWANDA
SAINT BARTHELEMY
SAINT HELENA, ASCENSION, AND TRISTAN DA CUNHA
SAINT KITTS AND NEVIS
SAINT LUCIA
SAINT MARTIN
SAINT PIERRE AND MIQUELON
SAINT VINCENT AND THE GRENADINES
SAMOA
SAN MARINO
SAO TOME AND PRINCIPE
SAUDI ARABIA
SENEGAL
SERBIA
SEYCHELLES
SIERRA LEONE
SINGAPORE
SINT MAARTEN
SLOVAKIA
SLOVENIA
SOLOMON ISLANDS
SOMALIA
SOUTH AFRICA
SOUTH GEORGIA AND SOUTH SANDWICH ISLANDS
SOUTH SUDAN
SPAIN
SPRATLY ISLANDS
SRI LANKA
SUDAN
SURINAME
SVALBARD
SWAZILAND
SWEDEN
SWITZERLAND
SYRIA
TAIWAN
TAJIKISTAN
TANZANIA
THAILAND
TIMOR-LESTE
TOGO
TOKELAU
TONGA
TRINIDAD AND TOBAGO
TROMELIN ISLAND
TUNISIA
TURKEY
TURKMENISTAN
TURKS AND CAICOS ISLANDS
TUVALU
UGANDA
UKRAINE
UNITED ARAB EMIRATES
UNITED KINGDOM
UNITED STATES
UNKNOWN
URUGUAY
UZBEKISTAN
VANUATU
VATICAN CITY
VENEZUELA
VIETNAM
VIRGIN ISLANDS, BRITISH
VIRGIN ISLANDS, U.S.
WAKE ISLAND
WALLIS AND FUTUNA
WEST BANK
WESTERN SAHARA
YEMEN
ZAMBIA
ZIMBABWE

Eye Color

NA

No

Drop Down

Unknown

The drop-down options shall include the following:
Brown
Green
Blue
Hazel
Black
Gray
Violet
Other

Hair Color

NA

No

Drop-down

Unknown

The drop-down options shall include the following:
Blonde
Brown
Black
Gray
Red
White
Silver
Auburn
N/A
Other

Height (ft.)
and (in)

NA

Weight (lbs.)

NA

No

Text Field

0
The system shall display height as feet and inches.
The system shall store height in total inches.
The system shall accept the specified below height in feet and inches as valid
height
Feet must be >=1 and <=8
Inches must be >=0 and <=11
The maximum height the system will accept shall be 8 ft. and 3 in.

No

Text Field

NA
Must be >= than 0 and <=999

Identifier
Type

NA

Yes

Drop-down

(Identifier
Type)

U.S Citizen
Primary Identifier
(Authoritative)

Secondary Identifier (Non-authoritativ
e)

SSN

State ID

Taxpayer ID Number (ITIN)

Drivers License

Certificate of Naturalization

Passport

Non-U.S Citizen
Primary Identifier (Authoratitive
)

Secondary Identiifer (Non-authoritativ
e)

Foreign ID (US Issued)

Drivers License

Alien Registration Number

Employment Authorization Document

Taxpayer ID Number (ITIN)
National ID (Foreign Country
Issued)
SSN
Passport

Value

Default 25;
but varies
in length
per
identifier

Yes

Text Field

NA
Name

SSN

Min
Length
9

Max
length
9

Values

Numeric

Character Format

Cannot be:
000######
666######
9########
###00####
#####0000

Alien
Registration

7

10

Alphanumeric

Alpha-numeric (AXXXXXXXXX)

Certificate of
Naturalization

1

25

Alphanumeric

Alpha-numeric

DoD EDI

10

10

Numeric

Numeric

Drivers
License

1

25

Alphanumeric

Alpha-numeric

Employment
Authorization
Document

1

25

Alphanumeric

Typical document contains both
the Alien Registration Number
and a Card number (example has
13 alphanumeric digits)

Foregin ID

9

9

Numeric

National ID
(Foreign
Country
Issued)

1

25

Alphanumeric

Other

1

25

Alphanumeric

Passport

6

9

Alphanumeric

State ID

1

25

Alphanumeric

Taxpayer
Identification
Number

9

9

Numeric

ranges:
900700000 to 999889999
900900000 to 999929999
900940000 to 999999999

Issuer

NA

Collectively
Required

Drop-down

(Identifier
Issuer)

The system shall make the issuer required/not required based on the specified
below issuer rules.
IF Identifier Type is

Issuer
Is Required

SSN

Is Not
Required
x

Drivers License

Populate State List

Passport

Populate Country
List

Foreign ID

x

Temporary identifier

x

DBIDS Identifier

x

Tax Identification Number

x

Other Identifier

x

State ID

Populate State List

Employment Authorization
Document

x

DOD_ED_PN_ID

x

National ID (foreign Country Issued)

Populate Country
List

Alien Registration Number

x

Is Primary

NA

Yes

Check box

NA

NA

Issuance
Date

NA

Yes

Acceptable
Formats:

NA

The system shall accept the specified below dates as valid issuance date
must be on or before sysdate
Month value are from 01 to 12; day ranges depend on months selected

MM/DD/YYYY
Day Month
Year
End Date

NA

Selectively
Required

NA

NA

Must be > sysdate

Remarks

4000

No

Text Field

NA

The system shall accept all characters and spaces.

Person Contact
Name

Address 1

Accepted
length of field

45

Validation

Required

Format

Default Value

Rules

Yes

Text Field

NA

The system shall accept the characters specified below as valid
characters in the Address 1 field:
A-Z
a-z
Hyphen ( - )
Apostrophe ( ‘ )
Space

Address 2

40

No

Text Field

NA

The system shall accept the characters specified below as valid
characters in the Address 2 field:
A-Z
a-z
Hyphen ( - )
Apostrophe ( ‘ )
Space

Address Type

Yes

Drop-dow
n

NA

The options for the address types are as follows:
Home
Work
Mailing

City

28

Yes

Text Field

NA

NA

State/Province

NA

Yes

Drop-dow
n

(select a
State/Province)

The system shall allow the specified below:
IF

State

Country
selected is
Is Req
US

IsNot-Req

Populate State
List

Other than US

X
Application shall convert this field to
be a text
Field.

APO/FPO
APO/FPO (New York)
Alaska
Alabama
Arkansas
Arizona
California
Colorado
Connecticut
District of Columbia
Delaware
Florida
Georgia
Hawaii
Iowa
Idaho
Illinois
Indiana
Kansas
Kentucky
Louisiana
Massachusetts
Maryland
Maine
Michigan
Minnesota
Missouri
Mississippi
Montana
North Carolina
North Dakota
Nebraska
New Hampshire
New Jersey
New Mexico
Nevada
New York
Ohio
Oklahoma
Oregon
Pennsylvania
Rhode Island
South Carolina
South Dakota
Tennessee
Texas
Utah
Virginia
Vermont
Washington
Wisconsin
West Virginia
Wyoming
APO/FPO

18

No

Text Field

NA

NA

Postal Code

10

Yes

Text Field

NA

Must be a numeric Value

Phone
Number

14

Yes

Text Field

NA

The phone number shall be entered in the format of (___) ___-____

Type (Phone)

NA

Yes

Drop-dow
n

NA

The drop-down options shall include the following:
Home
DSN
Fax
Mobile
Work

Email Address

254

Yes

Text Field

NA

The system shall accept an email address from a user, only if the email
address matches the specified below rules:
must have 1 '@' sign

Type (Email)

NA

Yes

Drop-dow
n

NA

The drop-down options shall include the following:
Home
Work

Person Assets
Name

Weapons Weapon Type

Accepted
length of
field

Validation
Required

Format

Default Value

Rules

NA

Yes

Drop -down

NA

The drop-down options shall include the following:
Pistol
Sword
Knife
Bow
Other martial arts Weapon
Rifle
Other
Shotgun
Revolver

Weapons Serial ID

50

Yes

Text Field

NA

The System shall accept Alpha-numeric Characters

Weapons Manufacture
Name

50

Yes

Text Field

NA

The system shall accept the characters specified below as valid
characters in the Manufacture Name field:
A-Z
a-z
Hyphen ( - )
Apostrophe ( ‘ )
Space

Weapons Caliber

50

Yes

Text Field

NA

The system shall accept the characters specified below as valid
characters in the Caliber field:
A-Z
a-z
Hyphen ( - )
Apostrophe ( ‘ )
Space

Weapons Storage Location

50

Yes

Text Field

NA

The system shall accept the characters specified below as valid
characters in the Store Location field:
A-Z
a-z
Hyphen ( - )
Apostrophe ( ‘ )
Space

Weapons Armory contact

50

Yes

Text Field

NA

The system shall accept the characters specified below as valid
characters in the Armory Contact field:
A-Z
a-z
Hyphen ( - )
Apostrophe ( ‘ )
Space

Weapons Registration
Date

NA

Yes

Acceptable
Formats:

Current Date of
registration
Must be on sysdate
Month values are from 01 to 12; day ranges depend on months
selected

MM/DD/YYYY

Weapons Cleared date

NA

Yes

Acceptable
Formats:

NA
must be on or before sysdate
Month Value or from 01 to 12; day ranges depend on months
selected

MM/DD/YYYY

Weapons Notes

250

No

Text Field

NA

The system shall accept the characters specified below as valid
characters in the notes field:
A-Z
a-z
Hyphen ( - )
Apostrophe ( ‘ )
Space

Pet - Name

50

Yes

Text Field

NA

The system shall accept the characters specified below as valid
characters in the name field:
A-Z
a-z
Hyphen ( - )
Apostrophe ( ‘ )
Space

Pet - Type

NA

Yes

Drop-down

NA

The drop-down options shall include the following:
Amphibian
Bird
Cat
Dog
Horse
Livestock
Other
Rabbit
Reptile
Rodent
Unknown

Pet - Breed

50

Yes

Text Field

NA

The system shall accept the characters specified below as valid
characters in the Breed field:
A-Z
a-z
Hyphen ( - )
Apostrophe ( ‘ )
Space

Pet - License
Number
Pet - Registration
date

20

Yes

Text Field

NA

Yes

Acceptable
Formats:

Current Date of
registration

MM/DD/YYYY
Pet - Cleared
Date

Yes

Acceptable
Formats:
MM/DD/YYYY

The System shall accept alpha-numeric characters.

must be on sysdate
month values are from 01 to 12; day ranges depend on months
selected

NA
must be on or before sysdate
Month values are from 01 to 12; day ranges depend on months
selected

Pet - Notes

250

No

Text Field

NA

The system shall accept the characters specified below as valid
characters in the notes field:
A-Z
a-z
Hyphen ( - )
Apostrophe ( ‘ )
Space

Bicycles/mopeds
- Type

NA

Yes

Drop-down

NA

The drop-down options shall include the following:
Bike
Moped

Bicycles/mopeds
- Manufacture

18

Yes

Text Field

NA

The system shall accept the characters specified below as valid
characters in the Manufacture field:
A-Z
a-z
Hyphen ( - )
Apostrophe ( ‘ )
Space

Bicycles/mopeds
- Model

18

Yes

Text Field

NA

The system shall accept the characters specified below as valid
characters in the Model field:
A-Z
a-z
Hyphen ( - )
Apostrophe ( ‘ )
Space

Bicycles/mopeds
- Color

NA

Yes

Drop - drown

NA

The drop-down options shall include the following:
Black
Blue
Brown
Burgundy
Copper
Cream
Dark
Blue
Gold
Green
Gray
Light Blue
Multi-Color
Maroon
No Paint
Orange
Pink
Purple
Red
Silver
Tan
Taupe
Teal
Turquoise
Two-Tone
Violet
White
Yellow
Other

Bicycles/mopeds
- Decal Number

18

Yes

Text Field

NA

The System shall accept alpha-numeric characters.

Bicycles/mopeds
- Serial ID

20

Yes

Text Field

NA

The System shall accept alpha-numeric characters.

Bicycles/mopeds
- Registration
Date

NA

Yes

Acceptable
Formats:

Current date of
registration

MM/DD/YYYY

must be on sysdate
month values from 01 to 12; day ranges depend on months selected

Bicycles/mopeds
- Cleared Date

NA

Yes

Acceptable
Formats:

NA
must be on or before sysdate
month values are from 01 to 12; day ranges depend on months
selected

MM/DD/YYYY
Bicycles/mopeds
- Notes

250

No

Text Field

NA

The system shall accept the characters specified below as valid
characters in the notes field:
A-Z
a-z
Hyphen ( - )
Apostrophe ( ‘ )
Space

Person Security Profile
Name

Accepted length of
field

Validation
Required

Format

Default
Value

Rules

Vehicle Limit

NA

Yes

Text Field

Weapon Limit

NA

Yes

Text Field

Can Sponsor DBIDS Card

NA

No

Checkbox

NA

NA

Can Sponsor Non-DoD Card

NA

No

Checkbox

NA

NA

Can Sponsor Visitor Pass

NA

No

Checkbox

NA

NA

Manage DBIDS Credentials
Name

Accepted
length of field

Validation

Required

Format

Default Value

Rules

Category

NA

Yes

Drop-down

Conveyance

The drop-down options shall include the following 'Categories' as
well as the corresponding 'Sponsor type' and DBIDS card 'Color
stripe':
Categories

Sponsor type

Color stripe

Conveyance

org

green

Emerg Esntl Civilian

org

red

Facilities Service

person

green

Facility Use

person

yellow

Foreign Civ Visitor

org

blue

Foreign Gov Civ

org

blue

Foreign Gov Contr

person

blue

Foreign Mil Depndnt

person

blue

Foreign Mil Retiree

org

blue

Foreign Military

person

blue

Long Term Visitor

org

yellow

Maintenance

org

green

Other

person

yellow

Personal Delivery

person

yellow

Personal Services

org

yellow

Privatized Housing

person

yellow

US Gov Civilian

person

green

US Gov Contractor

org

green

Volunteer

person

yellow

Issue Date

NA

yes-non-editable

Day Month Year

populated with
the date of
registration

Issue Date shall not be an editable field

Expiration Date

NA

Yes

Acceptable
Formats:

NA

NA

MM/DD/YYYY
Escort Limit

NA

No

Drop-down

NA

The drop-down options shall range from 0 - 10

Vehicle Limit

NA

No

Drop-down

NA

The drop-down options shall range from 0 - 10

Remarks

4000

No

Text Field

NA

The system shall accept all characters and spaces.

Termination
Reason

NA

Required when
terminating a
credential

Drop-down

NA

The options for the termination reasons are as follows:
Deleted - Wrong association
Expired
Lost or Stolen
Replaced by new credential
Terminated before expiration
Unconfirmed credential
Unreadable barcode

Manage Visitor Pass

Name

Accepted
length of
field

Validation

Required

Format

Default Value

Rules

Issue Date

NA

No

Day Month Year

populated with the date
of registration

Issue Date shall not be an editable field

Expiration
Date

NA

Yes

Acceptable Formats:

NA

NA

NA

The drop-down options shall include the following:

MM/DD/YYYY
Termination
Reason

NA

No

Drop-down

Deleted - wrong association
Expired
Lost or Stolen
Replaced by new credential
Terminated before expiration
Unconfirmed credential
Unreadable Barcode
Remarks

4000

No

Text Field

NA

The system shall accept all characters and spaces.

Termination
Reason

NA

Required
when
terminating a
credential

Drop Down

NA

The options for the termination reasons are as follows:
Deleted - Wrong association
Expired
Lost or Stolen
Replaced by new credential
Terminated before expiration
Unconfirmed credential
Unreadable barcode