IRV_CUR_SITE
This view contains the most recent definition of each site (MedML Site element).
Columns in the IRV_CUR_SITE view
IRV_CUR_SITE |
IRV_CUR_SITE |
---|---|
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:
|
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. |