AD_Sites

SITENUMBER

Number of the site as displayed in the user interface.

ISACTIVE

Is the site active?

Yes or No.

DISPLAYNAME

Name of the site as displayed in the user interface. (Can be NULL.)

ORGANIZATION

Sponsor organization that the site belongs to.

ADDRESS

Additional site address information. (Can be NULL.)

ZIP

ZIP Code or postal code of the site.

SITEGROUP_ID

Identifier of the site group.

INV_NUMBER

Identifier of the site.

PATIENTID_MIN

Minimum number of patients who must be assigned to the site.

PATIENTID_MAX

Maximum number of patients who can be assigned to the site.

Can be larger than the target.

PATIENTID_TARGET

Desired number of patients to be assigned to the site.

NEXTPATIENTID

Sequential Patient ID to be assigned to the next patient added to the site.

COUNTRY

Text name of the country where the site is located.

COUNTRYID

Identifier of the country where the site is located.

STATE

State or province where the site is located.

CITY

City where the site is located.

STREET

Street on which the site is located.

BUILDING

Building number of the site. (Can be NULL.)

ROOM

Room or suite number of the site.

PO_BOX

Post office box of the site.

PHONE

Phone number of the site.

TIMEZONE

Time zone of the site:

• Eastern Standard Time.
• Central Standard Time.
• Pacific Standard Time.
• Central European Standard Time.
• E. European Standard Time.
• GMT Standard Time.
• Mountain Standard Time.
• China Standard Time.
• Tokyo Standard Time.

SITECURRENCYFORMAT

Type of currency:

• U.S. dollar
• Japanese yen
• Chinese renminbi (RMB)

SITENUMBERFORMAT

Preferred number format:

• Normal (12345)
• Thousands Separator (12,345)

SITENAMESORTFORMAT

Order of first and last user and patient names:

• Firstname-Lastname
• Lastname-Firstname

DONEDATEFORMAT

Preferred date format:

• 1—Day/Month/Year:Hour:Minute:Second
• 2—Month/Day/Year Hour:Minute:Second
• 3—Year/Month/Day Hour:Minute:Second

INVESTIGATORS

Primary investigator associated with the site.

ENROLLED

Number of patients currently enrolled at the site.

SITEID

Database identifier of the site. (Can be NULL.)

LAN_ID

Identifier of the language, enabling you to filter the view by language.