The UserEmail Data Type will contain any character information that represents a valid email address.  The max length for the UserEmail Data Type is always 64 characters.


Acceptable Data Formats

  • ASCII characters in the following format:    <local-part>@<domain>
    • local-part
      • Uppercase and lowercase Latin letters (a to z and A to Z)
      • Digits 0 to 9
      • Special Characters:  ! # $ % & ' * + - / = ? ^ _ ` { | } ~
      • Dot: .
    • domain
      • Uppercase and lowercase Latin letters (a to z and A to Z)
      • Digits 0 to 9
      • Hyphen:  -
      • Dot: .


Invalid Formats

  • Missing "@" sign
    • isiteuserATisite.com
    • isiteuser.com
  • Missing or invalid domain
    • isiteuser@isitecom
    • isiteuser@isite
  • Invalid characters
    • isiteuser(3)@isite.com
    • isiteuser<2>@isite.com
    • isite[user]@isite.com


Sample Data Specification

Field Name

Data Type

Requires Value?

Max Length

Related Table

JobName

String

Yes

32


JobCode

String

Yes

32


StartDate

Date

Yes

-


EndDate

Date

Yes

-


IsActive

Boolean

Yes

-


JobType

String

Yes

64


RequiresComment

Boolean

Yes

-


RequiresProjectManagerApproval

Boolean

Yes

-


ProjectManagerEmail

UserEmail

No

64

Users

SortGroup

Numeric

Yes

-



Page ID:8655-1042-5647