IRV_CUR_SPONSOR
This view contains the most recent information for each sponsor in the study.
Columns in the IRV_CUR_SPONSOR view
IRV_CUR_SPONSOR |
IRV_CUR_SPONSOR |
---|---|
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. |