Add Role Validations

Owned by Nancy Mond
Last updated: Jan 28, 2009Version comment
2 min read

Field

Validation

Last Name

Required. Alphabetic

First Name

Required. Alphabetic (I know that PDB allows the first and last name to be the same to handle people with a single name)

Middle Name

Alphabetic

Suffix

Alphabetic

Person Id

N/A - From the database

 

 

Role Start Date

Must be a date. 

Role End Date

Must be a date.  End Date must be greater than Start Date.

Title

Max length?

Part-time %

Must be a number. Requires reference data lookup for allowable values.

 

 

Sponsor Type

Must be a valid sponsor type.  Requires reference data lookup to validate.

Sponsor

Required.  Must be a person already in the registry.  Any other requirements?

Division

Must be a valid division.  Requires reference data lookup to validate.

Department

Must be a valid department.  Requires reference data lookup to validate.

Campus

Must be a valid campus.  Requires reference data lookup to validate.

 

 

Email

Required for some roles. Max length?  Anything else?

Hide Directory Listing

N/A - Check box.

 

 

Room

Currently not represented in the data model.

Building

Currently not represented in the data model.

Mail Code

Currently not represented in the data model.

Address Line1

Max length? Required if Address Line 2, City, State, Zip or Country is specified.

Address Line2

Max length?

City

Required if Address Line 1, State, Zip or Country is specified. Max length?

State/Province/Region

Required if Address Line 1, City, Zip or Country is specified. Max length?

Zip/Postal Code

Required if Address Line 1, City, State or Country is specified. Max length?

Country

Required if Address Line 1, City, State or Zip is specified. Max length?

 

 

Phone

 

Ext

Â