ALS Draft Upload Specification

This page contains the specification of columns and worksheets imported from an ALS

CRFDraft

Name

Specification

DraftName

Text

Row identifier (must be present)

Minimum length = 1

Maximum length = 2000

DeleteExisting

Boolean

Must be one of the following values:

ProjectName

Text

Minimum length = 1

Maximum length = 2000

ProjectType

Must be one of the following values: Project, GlobalLibraryVolume

PrimaryFormOID

Cross reference to Form OID (which must exist)

DefaultMatrixOID

Cross reference to Matrix OID (which must exist)

ConfirmationMessage

Text

Maximum length = 4000

SignaturePrompt

Text

Maximum length = 2000

LabStandardGroup

Text

Maximum length = 2000

ReferenceLabs

Text

Maximum length = 2000

AlertLabs

Text

Maximum length = 2000

SyncOIDProject

Text

Optional (no warning if not present)

Maximum length = 2000

SyncOIDDraft

Text

Optional (no warning if not present)

Maximum length = 2000

SyncOIDProjectType

Optional (no warning if not present)

Must be one of the following values: Project, GlobalLibraryVolume

SyncOIDOriginIsVersion

Boolean

Optional (no warning if not present)

Must be one of the following values:

SourceUrlId

Optional (no warning if not present)

Maximum length = 2000

Forms

Name

Specification

OID

OID

Row identifier (must be present)

Ordinal

Integer

DraftFormName

Name

DraftFormActive

Boolean

Must be one of the following values:

HelpText

Text

Maximum length = 4000

IsTemplate

Boolean

Must be one of the following values:

IsSignatureRequired

Boolean

Must be one of the following values:

IsEproForm

Boolean

Must be one of the following values:

ViewRestrictions

Comma separated list

EntryRestrictions

Comma separated list

LogDirection

Text

Maximum length = 2000

DDEOption

Text

Maximum length = 2000

ConfirmationStyle

Text

Maximum length = 2000

LinkFolderOID

Cross reference to Folder OID (which must exist)

LinkFormOID

Cross reference to Form OID (which must exist)

DownloadedFromObjectId

Optional (no warning if not present)

Maximum length = 2000

SourceObjectId

Optional (no warning if not present)

Maximum length = 2000

SourceUrlId

Optional (no warning if not present)

Maximum length = 2000

Fields

Name

Specification

FormOID

Cross reference to Form OID (which must exist)

Row identifier (must be present)

FieldOID

OID

Row identifier (must be present)

Ordinal

Integer

DraftFieldNumber

Text

Maximum length = 50

DraftFieldName

Name

DraftFieldActive

Boolean

Must be one of the following values:

VariableOID

Text

Maximum length = 50

DataFormat

Text

Maximum length = 50

DataDictionaryName

Text

Maximum length = 2000

UnitDictionaryName

Text

Maximum length = 2000

CodingDictionary

Text

Maximum length = 2000

ControlType

Text

Maximum length = 2000

AcceptableFileExtensions

Text

Maximum length = 256

IndentLevel

Integer

PreText

Text

Maximum length = 4000

FixedUnit

Text

Maximum length = 200

HeaderText

Text

Maximum length = 200

HelpText

Text

Maximum length = 4000

SourceDocument

Boolean

Must be one of the following values:

IsLog

Boolean

Must be one of the following values:

DefaultValue

Text

Maximum length = 500

SASLabel

Text

Maximum length = 256

SASFormat

Text

Maximum length = 25

EproFormat

Text

Maximum length = 2000

IsRequired

Boolean

Must be one of the following values:

QueryFutureDate

Boolean

Must be one of the following values:

IsVisible

Boolean

Must be one of the following values:

IsTranslationRequired

Boolean

Must be one of the following values:

AnalyteName

Text

Maximum length = 2000

IsClinicalSignificance

Boolean

Must be one of the following values:

QueryNonConformance

Boolean

Must be one of the following values:

OtherVisits

Boolean

Must be one of the following values:

CanSetRecordDate

Boolean

Must be one of the following values:

CanSetDataPageDate

Boolean

Must be one of the following values:

CanSetInstanceDate

Boolean

Must be one of the following values:

CanSetSubjectDate

Boolean

Must be one of the following values:

DoesNotBreakSignature

Boolean

Must be one of the following values:

LowerRange

Text

Maximum length = 10

UpperRange

Text

Maximum length = 10

NCLowerRange

Text

Maximum length = 10

NCUpperRange

Text

Maximum length = 10

ViewRestrictions

Comma separated list

EntryRestrictions

Comma separated list

ReviewGroups

Comma separated list

IsVisualVerify

Boolean

Must be one of the following values:

FDownloadedFromObjectId

Optional (no warning if not present)

Maximum length = 2000

FSourceObjectId

Optional (no warning if not present)

Maximum length = 2000

VDownloadedFromObjectId

Optional (no warning if not present)

Maximum length = 2000

VSourceObjectId

Optional (no warning if not present)

Maximum length = 2000

FSourceUrlId

Optional (no warning if not present)

Maximum length = 2000

VSourceUrlId

Optional (no warning if not present)

Maximum length = 2000

Folders

Name

Specification

OID

OID

Row identifier (must be present)

Ordinal

Integer

FolderName

Name

AccessDays

Integer

StartWinDays

Integer

Targetdays

Integer

EndWinDays

Integer

OverDueDays

Integer

CloseDays

Integer

ParentFolderOID

Cross reference to Folder OID (which must exist)

IsReusable

Boolean

Must be one of the following values:

DownloadedFromObjectId

Optional (no warning if not present)

Maximum length = 2000

SourceObjectId

Optional (no warning if not present)

Maximum length = 2000

SourceUrlId

Optional (no warning if not present)

Maximum length = 2000

DataDictionaries

Name

Specification

DataDictionaryName

Name

Row identifier (must be present)

DownloadedFromObjectId

Optional (no warning if not present)

Maximum length = 2000

SourceObjectId

Optional (no warning if not present)

Maximum length = 2000

SourceUrlId

Optional (no warning if not present)

Maximum length = 2000

DataDictionaryEntries

Name

Specification

DataDictionaryName

Row identifier (must be present)

CodedData

Text

Maximum length = 2000

Ordinal

Integer

UserDataString

Text

Maximum length = 2000

Specify

Boolean

Must be one of the following values:

UnitDictionaries

Name

Specification

UnitDictionaryName

Name

Row identifier (must be present)

StandardUnitName

Text

Maximum length = 2000

DownloadedFromObjectId

Optional (no warning if not present)

Maximum length = 2000

SourceObjectId

Optional (no warning if not present)

Maximum length = 2000

SourceUrlId

Optional (no warning if not present)

Maximum length = 2000

UnitDictionaryEntries

Name

Specification

UnitDictionaryName

Row identifier (must be present)

CodedUnit

Text

Maximum length = 2000

Ordinal

Integer

ConstantA

Number

ConstantB

Number

ConstantC

Number

ConstantK

Number

UnitString

Text

Maximum length = 2000

Matrices

Name

Specification

MatrixName

Name

Row identifier (must be present)

OID

OID

Addable

Boolean

Must be one of the following values:

Maximum

Text

Maximum length = 4

DownloadedFromObjectId

Optional (no warning if not present)

Maximum length = 2000

SourceObjectId

Optional (no warning if not present)

Maximum length = 2000

SourceUrlId

Optional (no warning if not present)

Maximum length = 2000

Checks

Name

Specification

CheckName

Name

Row identifier (must be present)

CheckActive

Boolean

Must be one of the following values:

BypassDuringMigration

Boolean

Must be one of the following values:

Infix

Text

Optional (no warning if not present)

Maximum length = 100000

CopySource

Text

Optional (no warning if not present)

Maximum length = 2000

NeedsRetesting

Boolean

Optional (no warning if not present)

Must be one of the following values:

RetestingReason

Text

Optional (no warning if not present)

Maximum length = 2000

DownloadedFromObjectId

Optional (no warning if not present)

Maximum length = 2000

SourceObjectId

Optional (no warning if not present)

Maximum length = 2000

SourceUrlId

Optional (no warning if not present)

Maximum length = 2000

CheckSteps

Name

Specification

CheckName

Row identifier (must be present)

StepOrdinal

Integer

CheckFunction

Text

Maximum length = 2000

StaticValue

Text

Maximum length = 2000

DataFormat

Text

Maximum length = 2000

VariableOID

Text

Maximum length = 2000

FolderOID

Cross reference to Folder OID (which must exist)

FormOID

Cross reference to Form OID (which must exist)

FieldOID

Cross reference to Field OID (which must exist)

RecordPosition

Integer

CustomFunction

LogicalRecordPosition

Text

Maximum length = 2000

Scope

Text

Maximum length = 2000

OrderBy

Text

Maximum length = 2000

FormRepeatNumber

Integer

FolderRepeatNumber

Integer

CheckActions

Name

Specification

CheckName

Row identifier (must be present)

FolderOID

Cross reference to Folder OID (which must exist)

FormOID

Cross reference to Form OID (which must exist)

FieldOID

Cross reference to Field OID (which must exist)

VariableOID

Text

Maximum length = 2000

RecordPosition

Integer

PageRepeatNumber

Integer

InstanceRepeatNumber

Integer

LogicalRecordPosition

Text

Maximum length = 2000

Scope

Text

Maximum length = 2000

OrderBy

Text

Maximum length = 2000

ActionType

Must be one of the following values: OpenQuery, RequireReview, RequireVerification, SetDataPointVisible, SetDataPoint, SetSecondarySubjectName, SetFormRequiresSignature, SetFolderRequiresSignature, SetSubjectRequiresSignature, SetDynamicSearchList, AddComment, AddDeviation, CustomFunction, PlaceSticky, AddForm, AddMatrix, MrgMatrix, OldMrgMatrix, SetNonconformant, SendMessage, SetTimeZero, SetTimeForward, SetSubjectStatus, SetSubjectName, UpdateFormName, UpdateFolderName, BalanceDispense, BalanceRandomize, BalanceRedispense, BalanceSubjectDeactivate, BalanceCreateSubject, BalanceRandomizeAndDispense, BalanceSubjectExclude, UniqueSubjectName, SetSiteInformation, MarkActivityComplete, IsPresent, BalancePDALUpdate

ActionString

Text

Maximum length = 2000

ActionOptions

Text

Maximum length = 2000

ActionScript

Text

Maximum length = 2000

Derivations

Name

Specification

DerivationName

Name

Row identifier (must be present)

Active

Boolean

Must be one of the following values:

FolderOID

Cross reference to Folder OID (which must exist)

FormOID

Cross reference to Form OID (which must exist)

FieldOID

Cross reference to Field OID (which must exist)

VariableOID

Text

Maximum length = 2000

RecordPosition

Integer

AllVariablesInFolders

Boolean

Must be one of the following values:

AllVariablesInFields

Boolean

Must be one of the following values:

FormRepeatNumber

Integer

FolderRepeatNumber

Integer

BypassDuringMigration

Boolean

Must be one of the following values:

CopySource

Text

Optional (no warning if not present)

Maximum length = 2000

NeedsRetesting

Boolean

Optional (no warning if not present)

Must be one of the following values:

RetestingReason

Text

Optional (no warning if not present)

Maximum length = 2000

DownloadedFromObjectId

Optional (no warning if not present)

Maximum length = 2000

SourceObjectId

Optional (no warning if not present)

Maximum length = 2000

SourceUrlId

Optional (no warning if not present)

Maximum length = 2000

DerivationSteps

Name

Specification

DerivationName

Row identifier (must be present)

StepOrdinal

Integer

DataFormat

Text

Maximum length = 2000

VariableOID

Text

Maximum length = 2000

StepValue

Text

Maximum length = 2000

StepFunction

Text

Maximum length = 2000

FolderOID

Cross reference to Folder OID (which must exist)

FormOID

Cross reference to Form OID (which must exist)

FieldOID

Cross reference to Field OID (which must exist)

CustomFunction

Text

Maximum length = 2000

RecordPosition

Integer

LogicalRecordPosition

Text

Maximum length = 2000

Scope

Text

Maximum length = 2000

OrderBy

Text

Maximum length = 2000

FormRepeatNumber

Integer

FolderRepeatNumber

Integer

LabVariableMappings

Name

Specification

GlobalVariableOID

Text

Maximum length = 2000

FormOID

Cross reference to Form OID (which must exist)

FieldOID

Cross reference to Field OID (which must exist)

FolderOID

Cross reference to Folder OID (which must exist)

LocationMethod

Text

Maximum length = 2000

CustomFunctions

Name

Specification

FunctionName

Name

Row identifier (must be present)

SourceCode

Text

Maximum length = 10000

Lang

Text

Maximum length = 2000

DownloadedFromObjectId

Optional (no warning if not present)

Maximum length = 2000

SourceObjectId

Optional (no warning if not present)

Maximum length = 2000

SourceUrlId

Optional (no warning if not present)

Maximum length = 2000

EmailAlerts

Name

Specification

UniqueId

Text

Row identifier (must be present)

Maximum length = 2000

EmailAlertType

Text

Maximum length = 2000

EffectiveDate

Text

Maximum length = 2000

DaysToTrigger

Text

Maximum length = 2000

Locale

Text

Maximum length = 2000

SubjectString

Text

Maximum length = 2000

BodyString

Text

Maximum length = 2000

ToEmailString

Text

Maximum length = 2000

CCEmailString

Text

Maximum length = 2000

BCCEmailString

Text

Maximum length = 2000

CoderConfiguration

Name

Specification

FormOID

Cross reference to Form OID (which must exist)

FieldOID

Cross reference to Field OID (which must exist)

CodingLevel

Text

Maximum length = 2000

Priority

Text

Maximum length = 2000

Locale

Text

Maximum length = 2000

IsApprovalRequired

Boolean

Must be one of the following values:

IsAutoApproval

Boolean

Must be one of the following values:

CoderSupplementalTerms

Name

Specification

FormOID

Cross reference to Form OID (which must exist)

FieldOID

Cross reference to Field OID (which must exist)

SupplementalTerm

Text

Maximum length = 2000

CoderComponentTerms

Name

Specification

FormOID

Cross reference to Form OID (which must exist)

FieldOID

Cross reference to Field OID (which must exist)

ComponentTerm

Text

Maximum length = 2000

ComponentName

Text

Maximum length = 2000