IRV_CUR_SPONSOR

This view contains the most recent information for each sponsor in the study.

Column Name (Key indicator)	Column Description
SPONSORID (PK)	Numeric identifier for the sponsor.
SPONSORREVISIONNUMBER	Revision number for the sponsor.
SPONSORCONTACTUSERID	User identifier for the primary sponsor contact.
SPONSORNAME	Name of the sponsor.
ADDRESS1	First line of the sponsor address.
ADDRESS2	Second line of the sponsor address.
CITY	City in which the sponsor address is located.
STATE_PROVINCE	State or province in which the sponsor address is located.
ZIPCODE_POSTCODE	Sponsor zip or postal code.
COUNTRY	Country in which the sponsor address is located.
PHONE	Sponsor telephone number.
FAX	Sponsor fax number.
ALTPHONE	Sponsor alternate telephone number.
EMAILADDRESS	Email address for the sponsor.
LOGOID	Login identifier for the sponsor.
THERAPUTICAREA	Therapeutic area of the study with which the sponsor is associated.
PROGRAMNAME	Name of the study with which the sponsor is associated.
NOTE	Description of the study with which the sponsor is associated.
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.