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