User_Number

Int

Primary Key

System Generated Sequential Number

User_LastName

String (30)

Not NULL

User’s Last Name

User_FirstName

String (20)

Not NULL

User’s First Name

User_Initial

String (60)

User’s Initial

User_Salutation

String (60)

One of “Mr.”, “Mrs.”, “Ms.”, “Dr.”, “Rev.”

User’s Title of Address

User_Organization

 String (50)

Name of User’s Organization if user is a group or collective entity

User_Title

String (30)

Position or title of person within the organization

User_StreetAddress1

String (30)

Not NULL

User’s first line of mailing address

User_StreetAddress2

String (30)

User_City

 String (30)

Not NULL

User_Province

String (30)

Not NULL

User_Country

 String (30)

Not NULL

User_PostalCode

 String (20)

Not NULL

User_HomePhone

String (20)

User_WorkPhone

 String (20)

User_Age

Int

Really only required for users under the age of majority (so we get their parent’s signature on any application)

User_IsActive

Int

Not NULL

0

0 for not active, 1 for active, 2 for declined, 3 for expired, 4 for purged

User_Since

 Time­stamp

Not NULL

Date the user applied for an account

User_IsMember

Int

Not NULL

0

0 for non-member, 1 for member

User_Status_Msg

 String (60)

Any Volunteer entered text string to describe issues concerning a user

User_UserName

String (16)

Not NULL

The system generated username for non- members, or the personalized username for members. This is only used during the account application process and NOT changed for users who upgrade to membership later.

User_InitialPassword

String (16)

Not NULL

Must be checked against the cracklib

The User requested initial password in MD5 hash encryption

User_EnteredBy

 String (16)

Not NULL

The name of the GPFN Volunteer adding the user to the system