Download:
pdf |
pdfPerson 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
File Type | application/pdf |
File Modified | 2017-10-03 |
File Created | 2017-10-03 |