1105-xxxx SENTRY Source Identification Table

---

Overview

SourceIdent Columns
SourceIdent Col Attributes

---

Sheet 1: SourceIdent Columns

Column Name	Special Formats	Comments/Questions
SourceIdentID
Organization Name:
Organization Level 2:
Organization Level 3:
Role:		<< Supported by dropdown list - include "Publication" and "Other"
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.
E-list Choice:		<< Subscribed/Unsubscribed
E-mail address:		<< Required, if Subscribed and Active
ActiveInactive:		<< Supported by dropdown list (Yes / No) or [Check Box]
E-List EditedBy
E-List DateTimeEdited
CreatedBy
DateTimeCreated
EditedBy
DateTimeEdited

---

Sheet 2: SourceIdent Col Attributes

	Column Name	Data Type	Length	Allow Nulls	Required Field	Special Formats	Comments/Questions
	SourceIdentID	int	4	n	y
	Organization Name:	varchar		y	n
	Organization Level 2:	varchar		y	n
	Organization Level 3:	varchar		y	n
	Publication:	varchar		y	n
	RoleID:	int	4	n	y		<< Supported by dropdown list - include "Publication" and "Other"
	Explain Other:
	Title/Position:	varchar		y	n
	First Name:	varchar		y	n
	Middle Name:	varchar		y	n
	Last Name:	varchar		y	n
	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	n	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]
	E-mail address:	varchar		y	n		* Required, if Subscribed and Active
	Username:	varchar		y	n
	Default Password:	varchar		y	n		<< Generate Initial or Reset Password
	E-list Choice:	bit	1	n	y		<< Subscribed/Unsubscribed
	E-mail address:	varchar		y	n		* Required, if Subscribed and Active
	CreatedByID	int	4	n	y		UserAccountSourceID
	DateTimeCreated	smalldatetime		n	y
	EditedByID	int	4	y	y		UserAccountSourceID
	DateTimeEdited	smalldatetime		y	y