# 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 | | | 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 | | | 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 | Must be one of the following values: Text, LongText, DateTime, CheckBox, DropDownList, SearchList, Dynamic SearchList, RadioButton, RadioButton (Vertical), File Upload, Signature | | 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 = 2000 | | 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 | | | 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 | | OID | OID | ## DataDictionaryEntries | Name | Specification | | --- | --- | | DataDictionaryName | Row identifier (must be present) | | CodedData | Text
Maximum length = 2000 | | Ordinal | | | 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 | | OID | OID | ## UnitDictionaryEntries | Name | Specification | | --- | --- | | UnitDictionaryName | Row identifier (must be present) | | CodedUnit | Text
Maximum length = 2000 | | Ordinal | | | 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 | | OID | OID | ## CheckSteps | Name | Specification | | --- | --- | | CheckName | Row identifier (must be present) | | StepOrdinal | | | 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, SendNotification | | ActionString | Text
Maximum length = 2000 | | ActionOptions | Text
Maximum length = 2000 | | ActionScript | Text
Maximum length = 2000 | | ActionHeader | 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 | | | 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 | Must be one of the following values: C#, SQ | | 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 | ## Integrations | Name | Specification | | --- | --- | | FormOID | Cross reference to Form OID (which must exist)
Row identifier (must be present) | | FieldOID | OID
Row identifier (must be present) | | Integration | Text
Maximum length = 2000 | | IntegrationConfiguration | Text
Maximum length = 2000 | | IntegrationValue | 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 |