IRV_SITE_REVS

This view contains Site revision information.

Column Name (Key indicator)	Description
SITETYPEID	InForm "thing type" ID for site.
SITEID	Site ID
SITEREV	Site revision number
ENTEREDBY	User ID who made the change
ENTEREDDATE	Date when change happened
ENTEREDREASON	Reason for the data change
TRANSACTIONID	Transaction ID of the data change
SITENAME	Site name
SITEADDRESS1	Site address 1
SITEADDRESS2	Site address 2
SITEALTPHONENUMBER	Site phone number
SITEBEEPER	Site beeper number
SITECITY	Site city
SITECONTACTUSER	Site contact user
SITECOUNTRY	Site country
SITEDATEFORMAT	Site date format code
SITEDAYPHONENUMBER	Site day time phone number
SITEEMAILADDRESS	Site email
SITEFAXNUMBER	Site fax
SITEMNEMONIC	Site mnemonic
SITEPOSTALCODE	Site postal code
SITESERVER	Site server name
SITESTATEPROVINCE	Site state (province)
SITESTUDYINITIATIONDATE	Date when study version was assigned
SITESTUDYTERMINATIONDATE	Date when study version was terminated.
SITETIMEZONE	Site time zone
CREATEDDATETIME	Date and time when the view row was created.
CREATEDBYUSERID	User ID of the user whose action resulted in the given view row being created.
MODIFIEDDATETIME	Date and time when the data in the view row was most recently updated.
MODIFIEDBYUSERID	User ID of the user whose action resulted in the most recent change to data in the given view row.