Previous Topic

Next Topic

Book Contents

Columns

Column name

Data type

Description

MERGE_DATETIME

DATE

Date and time of the latest modification to the site record.

STATUS

NUMBER

Numeric code indicating the status of the record. This is set to 1 and not changed by CIS processing.

ENTRY_ID

VARCHAR2(20)

User account of the user who entered or last modified the record. For InForm SITE tables, the account is INFORM.

The InForm user account who entered or last modified InForm data. For InForm SITE tables, the account is INFORM.

To find the name of the user who performed an operation such as validation or coding on data in Clintrial, check the job log.

ENTRY_DATETIME

DATE

Date and time at which the site record was entered in the InForm software.

CT_RECID

VARCHAR2(40)

Unique record ID assigned to the record in the Clintrial software.

DB_ID

NUMBER

Unique identifier of the Clintrial database instance. The DB_ID for EDC data is 9999.

SUBJECT_ID

NUMBER

Unique identifier automatically assigned to the subject item. For SITE tables, the value is 1.

CTS$REASON

VARCHAR2(2000)

Reason that the record was modified or deleted.

SITEFAXNUMBER

VARCHAR2(255)

Fax number of the site.

SITEDAYPHONE
NUMBER

VARCHAR2(32)

Daytime phone number of the site.

SITECOUNTRY

VARCHAR2(127)

Country in which the site is located.

SITEPOSTALCODE

VARCHAR2(64)

Zip or postal code of the site’s location.

SITECITY

VARCHAR2(127)

City in which the site is located.

DISABLED

NUMBER

Not used currently.

SITESERVER

VARCHAR2(255)

Name of the server designated as the site server. In an InForm configuration where synchronization is used, the site server is dedicated for specific activities such as randomization, screening and enrollment, and generating patient numbers.

SITETIMEZONE

VARCHAR2(64)

Time zone in which the site is located, used to convert from internal universal system time to local time.

SITEALTPHONE
NUMBER

VARCHAR2(32)

Alternate phone number for the site.

GROUPDESCRIPTION

VARCHAR2(255)

Not used currently.

SITESTUDYTERMINATION

DATE

Date that the site came off line; for example, date that the last patient was signed off and locked.

SITESTATEPROVINCE

VARCHAR2(64)

State or province in which the site is located.

SITEBEEPER

VARCHAR2(255)

Beeper number of the site.

SITEDATEFORMAT

VARCHAR2(32)

The format of the date as displayed for the site, if a format is not specified at the user level.

  • 0—Month/Day/Year
  • 1—Day/Month/Year
  • 2—Year/Month/Day

SITESTUDYINITIATIOND

DATE

Date that the site came on line. Users cannot add data for a site before the specified date.

GROUPNAME

VARCHAR2(255)

Name of the site group to which the site belongs. If no site group is specified, site name is used.

GROUPCONFLICT

NUMBER

Not used currently.

SITEMNEMONIC

VARCHAR2(32)

Abbreviated name with which to refer to the site.

SITEEMAILADDRESS

VARCHAR2(255)

Email address of the site.

SITECONTACTUSER

VARCHAR2(64)

Not used currently.

SITEADDRESS1

VARCHAR2(255)

First line of the mailing address of the site.

SITEADDRESS2

VARCHAR2(255)

Second line of the mailing address of the site.

Send Feedback