IRV_SITE_REVS
This view contains Site revision information.
Columns in the IRV_SITE_REVS table
IRV_SITE_REVS |
|
---|---|
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. |