|
|
|
|
INF_USER_AUDIT, INF_USER_DATA, INF_USER_UPDATE columns
Column name |
Data type |
Description |
|---|---|---|
MERGE_DATETIME |
DATE |
Date and time of the latest modification to the user record. |
STATUS |
NUMBER |
Numeric code indicating the status of the record. This is set to 1 and is not changed by CIS processing. |
ENTRY_ID |
VARCHAR2(20) |
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 user 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 USER tables, the value is 1. |
CTS$REASON |
VARCHAR2(2000) |
Reason that the record was modified or deleted. |
USERDISPLAYNAME |
VARCHAR2(64) |
User name as displayed on the navigation pane in the InForm trial. |
USERDELETESTATE |
NUMBER |
Flag that indicates whether the user has been terminated:
|
USERFIRSTNAME |
VARCHAR2(127) |
First name of the user. |
USERDAYPHONE |
VARCHAR2(255) |
Daytime phone number for the user. |
USERAUTHTYPE |
VARCHAR2(32) |
Not used currently. |
USEREMAILADDRESS |
VARCHAR2(255) |
Email address of the user. |
USERSUBJECTGUID |
VARCHAR2(255) |
GUID of the user; not used currently. |
USERNAME |
VARCHAR2(255) |
Name the user enters to log on to InForm software. |
USERSTATEPROVINCE |
VARCHAR2(64) |
State or province in which the address of the user is located. |
USERPOSTALCODE |
VARCHAR2(64) |
Zip or postal code of the address of the user. |
USERIMAGEID |
VARCHAR2(36) |
GUID of the resource storing the image of the user; not used currently. |
USERHOMESCREENURL |
VARCHAR2(255) |
Local or external URL identifying the initial screen that appears when a user logs in to the InForm software. The address must include the http:// prefix and identify the server on which the file is located by name or IP address. |
USERADDRESS1 |
VARCHAR2(255) |
First line of the address of the user. |
USERADDRESS2 |
VARCHAR2(255) |
Second line of the address of the user. |
USERRESETPASSWORD |
NUMBER |
Flag indicating whether the user must reset the password when logging in to the InForm software for the first time:
|
USERCONFLICT |
NUMBER |
Not used currently. |
USERFAXNUMBER |
VARCHAR2(255) |
Fax number of the user. |
USERCITY |
VARCHAR2(127) |
City where the user is located. |
USERTITLE |
VARCHAR2(255) |
Title of the user. |
USERLASTNAME |
VARCHAR2(127) |
Last name of the user. |
USERDESCRIPTION |
VARCHAR2(255) |
Description of the user; for example, role of the user in the trial. |
USERALTPHONE |
VARCHAR2(32) |
Alternate phone number for the user. |
USERLANGID |
VARCHAR2(64) |
Preferred language of the user. English Language is the default. |
USERDATEFORMAT |
VARCHAR2(32) |
Desired date format of the user for viewable InForm pages:
|
USERBEEPER |
VARCHAR2(255) |
Beeper number of the user. |
USERACTIVESTATE |
NUMBER |
Flag indicating whether the user is active:
|
USERCOUNTRY |
VARCHAR2(127) |
Country where the user is located. |
USERTYPE |
NUMBER |
Type of user:
|
