NMR-STAR dictionary: detail of ContactPerson table

NMR-STAR dictionary: database table: ContactPerson

Detailed description of the fields

_Contact_person.ID (ContactPersonID)

NMR-STAR tag name	_Contact_person.ID
Description	NMR-STAR name: _Contact_person.ID Unique identifier within the entry for the named contact person.
Database field name	ContactPersonID
SQL Database type	INTEGER
Part of primary Key	yes
Foreign Key on table, column	,
Saveframe ID	yes: This tag contains the identifier for this saveframe in the entry.
Row Index	yes: This tag contains the index of this row in the loop, which is used when the data is loaded into a database which has a relational model in which ordering doesn't matter
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	yes
Prompt	ID
Examples	?
Help text

_Contact_person.Email_address (EmailAddress)

(go to parent tag category listing)

NMR-STAR tag name	_Contact_person.Email_address
Description	NMR-STAR name: _Contact_person.Email_address Business e-mail address for the contact person.
Database field name	EmailAddress
SQL Database type	VARCHAR(127)
Part of primary Key	no
Foreign Key on table, column	,
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	yes
Prompt	E-mail address (entering the e-mail address first may populate many of the fields below)
Examples	jsmith@home_addr.gov
Help text

_Contact_person.Name_salutation (NameSalutation)

(go to parent tag category listing)

NMR-STAR tag name	_Contact_person.Name_salutation
Description	NMR-STAR name: _Contact_person.Name_salutation The salutation of the author of the deposition to whom correspondence should be addressed
Database field name	NameSalutation
SQL Database type	VARCHAR(31)
Part of primary Key	no
Foreign Key on table, column	,
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	no
Enumerations	[click for a list of enumerations] This is an open enumeration. The list of values are only suggestions. They are not enforced.
Prompt	Salutation
Examples	Dr.
Help text

_Contact_person.Given_name (GivenName)

(go to parent tag category listing)

NMR-STAR tag name	_Contact_person.Given_name
Description	NMR-STAR name: _Contact_person.Given_name The name given the contact person at birth or currently used by the author for publication purposes. Can be an initial if the author uses a second name as a full name when publishing.
Database field name	GivenName
SQL Database type	VARCHAR(31)
Part of primary Key	no
Foreign Key on table, column	,
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	yes
Prompt	Contact person's first name
Examples	John
Help text

_Contact_person.Family_name (FamilyName)

(go to parent tag category listing)

NMR-STAR tag name	_Contact_person.Family_name
Description	NMR-STAR name: _Contact_person.Family_name The family name for the contact person.
Database field name	FamilyName
SQL Database type	VARCHAR(31)
Part of primary Key	no
Foreign Key on table, column	,
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	yes
Prompt	Contact person's last name
Examples	Smith
Help text

_Contact_person.Middle_initials (MiddleInitials)

(go to parent tag category listing)

NMR-STAR tag name	_Contact_person.Middle_initials
Description	NMR-STAR name: _Contact_person.Middle_initials The initials for the contact person's middle names. A name can be used here if the contact person uses a middle name for publications.
Database field name	MiddleInitials
SQL Database type	VARCHAR(15)
Part of primary Key	no
Foreign Key on table, column	,
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	no
Prompt	Contact person's middle initials
Examples	T.L.
Help text

_Contact_person.Family_title (FamilyTitle)

(go to parent tag category listing)

NMR-STAR tag name	_Contact_person.Family_title
Description	NMR-STAR name: _Contact_person.Family_title A common family title (not a professional title).
Database field name	FamilyTitle
SQL Database type	VARCHAR(15)
Part of primary Key	no
Foreign Key on table, column	,
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	no
Enumerations	[click for a list of enumerations] This is an open enumeration. The list of values are only suggestions. They are not enforced.
Prompt	Contact person's family title (not professional title)
Examples	III
Help text

_Contact_person.Department_and_institution (DepartmentAndInstitution)

(go to parent tag category listing)

NMR-STAR tag name	_Contact_person.Department_and_institution
Description	NMR-STAR name: _Contact_person.Department_and_institution Department and institution where the contact person works.
Database field name	DepartmentAndInstitution
SQL Database type	VARCHAR(255)
Part of primary Key	no
Foreign Key on table, column	,
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	no
Prompt	Department and institution
Examples	Chemistry Dept., Rutgers Univ.
Help text

_Contact_person.Mailing_address (MailingAddress)

(go to parent tag category listing)

NMR-STAR tag name	_Contact_person.Mailing_address
Description	NMR-STAR name: _Contact_person.Mailing_address A business mailing address for the contact person.
Database field name	MailingAddress
SQL Database type	VARCHAR(255)
Part of primary Key	no
Foreign Key on table, column	,
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	no
Prompt	Mailing address
Examples	123 Hose Ln
Help text

_Contact_person.Address_1 (Address1)

(go to parent tag category listing)

NMR-STAR tag name	_Contact_person.Address_1
Description	NMR-STAR name: _Contact_person.Address_1 The mailing address of the author of the entry to whom correspondence should be addressed, line 1 of 3.
Database field name	Address1
SQL Database type	VARCHAR(127)
Part of primary Key	no
Foreign Key on table, column	,
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	yes
Prompt	Mailing address (line 1)
Examples	123 Hose Ln
Help text

_Contact_person.Address_2 (Address2)

(go to parent tag category listing)

NMR-STAR tag name	_Contact_person.Address_2
Description	NMR-STAR name: _Contact_person.Address_2 The mailing address of the author of the entry to whom correspondence should be addressed, line 2 of 3.
Database field name	Address2
SQL Database type	VARCHAR(127)
Part of primary Key	no
Foreign Key on table, column	,
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	no
Prompt	Mailing address (line 2)
Examples	Chemistry Dept.
Help text

_Contact_person.Address_3 (Address3)

(go to parent tag category listing)

NMR-STAR tag name	_Contact_person.Address_3
Description	NMR-STAR name: _Contact_person.Address_3 The mailing address of the author of the entry to whom correspondence should be addressed, line 3 of 3.
Database field name	Address3
SQL Database type	VARCHAR(127)
Part of primary Key	no
Foreign Key on table, column	,
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	no
Prompt	Mailing address (line 3)
Examples	Rutgers Univ.
Help text

_Contact_person.City (City)

(go to parent tag category listing)

NMR-STAR tag name	_Contact_person.City
Description	NMR-STAR name: _Contact_person.City The city in the mailing address of the author of the entry to whom correspondence should be addresed.
Database field name	City
SQL Database type	VARCHAR(31)
Part of primary Key	no
Foreign Key on table, column	,
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	yes
Prompt	City
Examples	Piscataway
Help text

_Contact_person.State_province (StateProvince)

(go to parent tag category listing)

NMR-STAR tag name	_Contact_person.State_province
Description	NMR-STAR name: _Contact_person.State_province The state or province for the address of the contact person.
Database field name	StateProvince
SQL Database type	VARCHAR(31)
Part of primary Key	no
Foreign Key on table, column	,
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	yes
Prompt	State or province
Examples	New Jersey
Help text

_Contact_person.Country (Country)

(go to parent tag category listing)

NMR-STAR tag name	_Contact_person.Country
Description	NMR-STAR name: _Contact_person.Country The country in the mailing address of the author of the entry to whom correspondence should be addresed.
Database field name	Country
SQL Database type	VARCHAR(31)
Part of primary Key	no
Foreign Key on table, column	,
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	yes
Prompt	Country
Examples	USA
Help text

_Contact_person.Postal_code (PostalCode)

(go to parent tag category listing)

NMR-STAR tag name	_Contact_person.Postal_code
Description	NMR-STAR name: _Contact_person.Postal_code The postal code or zip code for the address of the contact person to whom correspondence should be addressed.
Database field name	PostalCode
SQL Database type	VARCHAR(31)
Part of primary Key	no
Foreign Key on table, column	,
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	no
Prompt	Postal code
Examples	8854
Help text

_Contact_person.Phone_number (PhoneNumber)

(go to parent tag category listing)

NMR-STAR tag name	_Contact_person.Phone_number
Description	NMR-STAR name: _Contact_person.Phone_number A business telephone number for the contact person.
Database field name	PhoneNumber
SQL Database type	VARCHAR(31)
Part of primary Key	no
Foreign Key on table, column	,
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	yes
Prompt	Telephone number
Examples	+1 123 456 7890
Help text

_Contact_person.FAX_number (FAXNumber)

(go to parent tag category listing)

NMR-STAR tag name	_Contact_person.FAX_number
Description	NMR-STAR name: _Contact_person.FAX_number Business FAX number for the contact person.
Database field name	FAXNumber
SQL Database type	VARCHAR(31)
Part of primary Key	no
Foreign Key on table, column	,
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	no
Prompt	FAX number
Examples	+1 123 789 4560
Help text

_Contact_person.Role (Role)

(go to parent tag category listing)

NMR-STAR tag name	_Contact_person.Role
Description	NMR-STAR name: _Contact_person.Role Select the role that best describes this person's function in the project.
Database field name	Role
SQL Database type	VARCHAR(127)
Part of primary Key	no
Foreign Key on table, column	,
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	no
Enumerations	[click for a list of enumerations] This is a closed enumeration. The list of values are the only ones allowed.
Prompt	Role of this person in the project
Examples	principal investigator
Help text

_Contact_person.Organization_type (OrganizationType)

(go to parent tag category listing)

NMR-STAR tag name	_Contact_person.Organization_type
Description	NMR-STAR name: _Contact_person.Organization_type Select the value that best describes the type of organization with which this contact person is affiliated.
Database field name	OrganizationType
SQL Database type	VARCHAR(31)
Part of primary Key	no
Foreign Key on table, column	,
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	no
Enumerations	[click for a list of enumerations] This is a closed enumeration. The list of values are the only ones allowed.
Prompt	Contact person's organization type
Examples	academic
Help text

_Contact_person.Sf_ID (SfID)

(go to parent tag category listing)

NMR-STAR tag name	_Contact_person.Sf_ID
Description	NMR-STAR name: _Contact_person.Sf_ID Pointer to '_Entry.Sf_ID'
Database field name	SfID
SQL Database type	INTEGER
Part of primary Key	no
Foreign Key on table, column	Entry, Sf_ID
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	yes This field's data is for internal use only and should be hidden in public versiond of the data.
Nulls allowed in database?	yes
Prompt	Sf ID
Examples	?
Help text

_Contact_person.Entry_ID (EntryID)

(go to parent tag category listing)

NMR-STAR tag name	_Contact_person.Entry_ID
Description	NMR-STAR name: _Contact_person.Entry_ID Pointer to '_Entry.ID'
Database field name	EntryID
SQL Database type	CHAR(12)
Part of primary Key	yes
Foreign Key on table, column	Entry, ID
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	yes
Prompt	Entry ID
Examples	?
Help text