Previous Topic

Next Topic

Book Contents

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.

Send Feedback