Previous Topic

Next Topic

Book Contents

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
Column Name (Key indicator)

IRV_CUR_SPONSOR
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.

Send Feedback