IRV_CUR_SITE

This view contains the most recent definition of each site (MedML Site element).

Column Name (Key indicator)	Column Description
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.