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