SITECOUNT

Always 1; indicates that the row represents one site.

SITETYPEID

Numeric identifier for the site type.

SITEID (PK)

Numeric identifier for the site.

SITEREV

Revision number for the site.

SITENAME

Name of the site.

SITEADDRESS1

First line of the site address.

SITEADDRESS2

Second line of the site address.

SITEALTPHONENUMBER

Site alternate telephone number.

SITECITY

City in which the site address is located.

SITECOUNTRY

Country in which the site address is located.

SITEDATEFORMAT

The format of the dates displayed for the site, if a format is not specified at the user level.

SITEDAYPHONENUMBER

Daytime telephone number for the site.

SITEEMAILADDRESS

Email address used for contacting the site.

SITEFAXNUMBER

Site fax number.

SITEMNEMONIC

Abbreviated name with which to refer to the site. Required.

SITEPOSTALCODE

Site postal code.

SITESERVER

Name of the server designated as the site server.

SITESTATEPROVINCE

State or province in which the site address is located.

SITESTUDYINITIATIONDATE

Date the site came online. The following date and time formats are valid:

• DD/MONTH/YYYY—25 January 1996
• HH:MM:SS (12-hour clock)—8:30:00
• HH:MM:SS (24-hour clock)—20:30:00
• MONTH/DD/YYYY/HH:MM:SS—January 25, 1996 8:30:00
• HH:MM:SS/MON/DD/YYYY —8:30:00 Jan. 25, 1996
• MM/DD/YYYY/HH:MM:SS—1/25/1996 8:30:00

SITESTUDYTERMINATIONDATE

Date the site came offline; for example, date that the last subject was signed and locked.

SITETIMEZONE

Time zone in which the site is located, used to convert from internal universal system time to local time.

CREATEDBYUSERID

User ID of the user whose action resulted in the given view row being created.

CREATEDBYDATETIME

Date and time when the view row was created.

MODIFIEDBYUSERID

User ID of the user whose action resulted in the most recent change to data in the given view row.

MODIFIEDDATETIME

Date and time when the data in the view row was most recently updated.