1105-0087 SENTRY User Account Table

---

Overview

UserAcct Columns
UserAcct Col Attributes

---

Sheet 1: UserAcct Columns

Column Name	Special Formats	Comments/Questions
UserAccountID
Organization Name:
Organization Level 2:
Organization Level 3:
Role:		<< Supported by dropdown list
Explain Other:
Title/Position:
First Name:
Middle Name:
Last Name:
Address Line 1:
Address Line 2:
City:
State/Province/Territory:		<< Supported by dropdown list
Zip or Postal Code:
Country:		<< Supported by dropdown list (Initially: US, Canada, & Mexico) Pre-populate additions with "United States"
Contact Note:		Contact Note for things such as: best time to contact; always works x-to-y; on vacation through mm/dd/yyy, etc.
Phone Number:	Separate data entry fields: Area Code [999] Exchange [999] Number [9999]	If source identity is outside U.S. the fax number will be up to 20 numeric characters and have no special formating.
Phone Extension:		<< Separate Phone Number / Ext fields
FAX Number:	Separate data entry fields: Area Code [999] Exchange [999] Number [9999]	If source identity is outside U.S. the fax number will be up to 20 numeric characters and have no special formating.
UserFunction:		<< Supported by dropdown list & pre-populated with 'General User' for addition of new users. Dropdown list: General User; WEB Admin; User Admin; Admin, Analyst
Username:
Default Password:		<< Generate Initial or Reset Password
E-list Choice:		<< Subscribed/Unsubscribed [Check Box]
E-mail address:		* Required, if Subscribed and Active
ActiveInactive:		<< Supported by dropdown list (Yes / No) or [Check Box]
E-List EditedBy
E-List DateTimeEdited
MostRecentLogin		Date/time
Initial/Reset Password
Account Locked
CreatedBy
DateTimeCreated
EditedBy
DateTimeEdited

---

Sheet 2: UserAcct Col Attributes

Column Name	Data Type	Length	Allow Nulls	Required Field	Special Formats	Comments/Questions
UserAcctID	int	4	n	y
Organization Name:	varchar		y	y
Organization Level 2:	varchar		y	n
Organization Level 3:	varchar		y	n
RoleID:	int	4	n	y		<< Supported by dropdown list
Title/Position:	varchar		y	y
First Name:	varchar		y	y
Middle Name:	varchar		y	n
Last Name:	varchar		y	y
Address Line 1:	varchar		y	y
Address Line 2:	varchar		y	n
City:	varchar		y	y
StateID:	int	4	y	y		<< Supported by dropdown list
Zip or Postal Code:	varchar		y	y
CountryID:	int	4	y	y		<< Supported by dropdown list (Initially: US, Canada, & Mexico) Pre-populate additions with "United States"
Contact Note:	varchar		y	n		Contact Note for things such as: best time to contact; always works x-to-y; on vacation through mm/dd/yyy, etc.
Phone Number:	varchar		y	y	Separate data entry fields: Area Code [999] Exchange [999] Number [9999]
Phone Extension:	varchar		y	n		<< Separate Phone Number / Ext fields
FAX Number:	varchar		y	n	Separate data entry fields: Area Code [999] Exchange [999] Number [9999]
UserFunctionID:	int	4	n	y		<< Supported by dropdown list & pre-populated with 'General User' for addition of new users. Dropdown list: General User; Analyst, WEB Admin; User Admin; Admin
Username:	varchar		y	y
Default Password:	varchar		y	n		<< Generate Initial or Reset Password
E-list Choice:	bit	1	n	y		<< Subscribed/Unsubscribed
E-mail address:	varchar		y	*		* Required, if Subscribed and Active
ActiveInactiveID:	int	4	n	y		<< Supported by dropdown list (Yes / No)
MostRecentLogin	datetime	8	n	y
Initial/Reset Password	bit	1	n	y
Account Locked	bit	1	n	y
CreatedByID	int	4	n	y		UserAccountSourceID
DateTimeCreated	smalldatetime		n	y
EditedByID	int	4	y	y		UserAccountSourceID
DateTimeEdited	smalldatetime		y	y