Alert Variable

DepotLotExpirationAlertThreshold

List of thresholds for Depot Lot Expiration Alert. The threshold list represents when the alert should trigger, in days. For example, 180,120,0 would fire the alert once at 180, once at 120, and once at 0. Add as many threshold triggers as you like, separated by comma.

Last Updated:


GlobalRandomizationAlert

The value, if meet or exceeded, for which a "Subjects Randomized in Study Alert" will be sent via email to subscribers. This is a study wide count, not a site specific count.

Last Updated:


GlobalScreeningAlert

The value, if meet or exceeded, for which a "Subjects Screened in Study Alert" will be sent via email to subscribers. This is a study wide count, not a site specific count.

Last Updated:


Low Depot Inventory Alert Interval Days

The interval, in days, the system will send a Low Depot Inventory Alert when the threshold is crossed. For example, a value of 7 will send the low depot inventory alert every 7 days while the threshold value is crossed. Used in conjunction with Low Depot Inventory Alert Threshold

Last Updated:


Low Depot Inventory Alert Threshold

The threshold, in kit count, that will trigger a low depot inventory alert. The inventory level has to been below the threshold, and will be sent based on the Low Depot Inventory Alert Interval Days value.

Last Updated:


Low Site Inventory Alert Interval

The interval, in days, the system will send a Low Site Inventory Alert when the threshold is crossed. For example, a value of 7 will send the low site inventory alert every 7 days while the threshold value is crossed. Used in conjunction with Low Site Inventory Alert Threshold

Last Updated:


Low Site Inventory Alert Threshold

The threshold, in kit count, that will trigger a low site inventory alert. The inventory level has to been below the threshold, and will be sent based on the Low Site Inventory Alert Interval Days value.

Last Updated:


OverdueShipmentThresholds

List of thresholds for Overdue Shipments. The threshold list represents when the alert should trigger, in days. For example, 5,7,9 would fire the alert once at 5 days, once at 7 days, and once at 9 days. Add as many threshold triggers as you like, separated by comma.

Last Updated:


SiteLotExpirationAlertThreshold

List of thresholds for Site Lot Expiration Alert. The threshold list represents when the alert should trigger, in days. For example, 180,120,0 would fire the alert once at 180, once at 120, and once at 0. Add as many threshold triggers as you like, separated by comma.

Last Updated:


Code First Migration Variable

SeedSQLScripts

Add Synonyms, Views and Sprocs from Code First Migration 1 for yes, 0 for no.

Last Updated:


Default Variable

DefaultSiteRandomizationCap

Used by the Site Activity Management page to set the default value of the Randomization Cap column

Last Updated:


DefaultSiteScreengingCap

Used by the Site Activity Management Page to set the default value of the Screening Cap column

Last Updated:


Drug Variable

DepotReconciliationMaxQty

Used in Depot Reconciliation function to control the dropdown max limit

Last Updated:


DrugAckType

Type of drug order acknowledgement, can be Simple, Detailed, or TempTail

Last Updated:


InitialOnSiteActivation

Place initial order after site activation

Last Updated:


InitialOrderPatientStatusTypeID

The PatientStatusTypeID that fires the initial drug order once a subject at that site is in this status. ONLY used when "InitialOnSiteActivation" != "true"

Last Updated:


MaxQuantity

Used for manual drug & acknowledge drug orders. Drives the max quantity number displayed in the drop downs on these pages.

Last Updated:


MinimumOrderQuantity

Minimum kit quantity in each order

Last Updated:


MinQuantity

Used for manual drug & acknowledge drug orders. Drives the in quantity number displayed in the drop downs on these pages.

Last Updated:


OrderNumberLength

Length of the order number, will pad with 0s to get to the length if needed

Last Updated:


OrderStartingNumber

First order number

Last Updated:


PredictiveResupplyEXEPath

This is the local path to the PredictiveResupply.exe application that performs drug orders

Last Updated:


ResupplyIsUsingLabelGroups

Is the system and resupply using label groups? 1 for yes, 0 for no.

Last Updated:


ShipperMax

The max amount of shippers one order can have, controls the drop down at site acknowledgement

Last Updated:


ShipperMin

The min amount of shippers one order can have, controls the drop down at site acknowledgement

Last Updated:


StudyHasSecondaryLotNumber

Used in Lot Management Function. If set to 0, the secondary lot number (used by third party supplies) is not used. If set to 1, a secondary lot number is used.

Last Updated:


UsePredictiveResupply

1 for predictive, 0 for non-predictive, manual orders only.

Last Updated:


DTS Variable

LastVisitRecordID

Used for Data Transfer, not used for any configuration. This is a data placeholder.

Last Updated:


MergeEXEPath

The full path to to the Merge executable used by SQL Agent Jobs

Last Updated:


MergeIntegrationEnabled

The flag to indicate if this study processes EDC through Merge

Last Updated:


NumberOfSentDT

Used for Data Transfer, not used for any configuration. This is a data placeholder.

Last Updated:


RaveIntegrationEnabled

Rave EDC Service integration, values are(true, false)

Last Updated:


SendDrugOrdersViaFTP

Drug Order File is also sent via sFTP. 1 for yes, 0 for no.

Last Updated:


Report Variable

SubjectGraphReportEndDate

The end date on the Subject Counts by Month and Cumulative Subject Count graphs

Last Updated:


SubjectGraphReportStartDate

The start date on the Subject Counts by Month and Cumulative Subject Count graphs

Last Updated:


Study Variable

BatchReleaseApproval

[bool 0/1] Use the batch release approval process.

Last Updated:


BlindingGroupMethod

Name of the method used to selection additional blinding kits for resupply blinding groups

Last Updated:


CohortQuestionnaireId

Cohort Managemnt dynamically adds choice to question

Last Updated:


ConciergeIntegrationEnabled

Enable sending requests to concierge

Last Updated:


CSVExportDelimiter

Delimiter for grid csv exports

Last Updated:


DataCorrectionModule

1 = Classic DCF module , 2 = Automatic DCF module

Last Updated:


DefaultSiteCohortEnrollmentCap

Default cohort randomization cap at a site

Last Updated:


DisplayTransactionDate

When 1 = Display Site Local Time Transaction Date only When 2 = Display System UTC Transaction Date only When 3 = Display both Site Local Time Transaction Date and System UTC Transaction Date

Last Updated:


EmailFromAddress

The FROM address for all Alerts and Confirmation emails

Last Updated:


EmailPrependSubjectLine

Use this key to prepend anything to the email subject line. Key is required.

Last Updated:


EmailSubjectSponsorName

SponsorName for Email Confirmations

Last Updated:


EmailSubjectStudyName

StudyName for Email Confirmation

Last Updated:


ENV

This controls the environment display on the default page.

Last Updated:


GenesisLogoUrl

Genesis Logo Url

Last Updated:


GlobalDateFormat

Format for date used throughout the system

Last Updated:


GlobalRandomizationCap

The value, if meet or exceeded, for which the randomization page will display a error message and not allow any further randomizations.

Last Updated:


GlobalScreeningCap

The value, if meet or exceeded, for which the screening page (either with or without IC) will display a error message and not allow any further screenings

Last Updated:


IsEmailPdfEnabled

Enable or Disables the email pdf attachement for confirmations.

Last Updated:


NumberOfTemperatureDecimalPlaces

Number of decimal places to allow when entering shipper temperature details

Last Updated:


OverrideDate

Override the system time for scenario based tests. Put this as "NULL" or empty to turn this off.

Last Updated:


PatientNumberIsStudyWide

true if subject number should be generated based on subject count in study, false if count should be at site level

Last Updated:


PatientStartingCount

Controls starting patient number

Last Updated:


PatientStatusCsvList

List of Patient Statuses (CSV). Based on that list, patients with that statuses will be shown on the landing page.

Last Updated:


PCIDTEnabled

Enable the PCI DT

Last Updated:


Protocol

This controls the Protocol number displayed on the front page.

Last Updated:


ProtocolId

Protocol identitfication to be used by the pooled material system

Last Updated:


RandomizationQuestionId

Question identification to be used by randomization

Last Updated:


RescreenQuestionnaireId

The Id of the rescreening questionnaire used to attach the rescreen cap check

Last Updated:


ShowSimpleAcknowledgmentQuestion

Show the temperature excursion question on simple order acknowledgment

Last Updated:


SiteInvestigatorRole

This is the site investigator role id used in confirmation pages

Last Updated:


SiteNumberLength

Site number length

Last Updated:


StudyCompletionTarget

This is the target value for total number of completed subjects in the study

Last Updated:


StudyID

ID for the study matching the Study table in auth db

Last Updated:


StudyLoginPage

Internal logic use it, please do not update.

Last Updated:


StudyLogo

Logo displayed in the study summary region, top left position of the front page.

Last Updated:


StudyName

This is the name of the study displayed on the front page and functions.

Last Updated:


StudySponsor

This controls the name of the sponsor displayed on the front page and functions.

Last Updated:


TrackPrintButton

Enable/Disable track of the print button. Values: True/False

Last Updated:


UpcomingPatientVisitWidgetInterval

Patients with projected visits between today and today + interval days are included on the widget.

Last Updated:


ZenDeskCallForDCF

1 for yes, 0 for no ( or 1 for on and 0 for off)

Last Updated:


ZenDeskChatURL

The url of the ZenDesk chat service, it should NOT include https://

Last Updated:


ZenDeskDCFCustomFields

This string is used to populate custom fields inside the ZenDesk ticket (see the "custom_fields" section in the curl example, this entire script of custom_fields should be configurable in case the fields change in zendesk we don't have to modify the code, we can modify this key.

Last Updated:


ZenDeskDCFGroupID

The group this ticket is assigned to in Zendesk

Last Updated:


ZenDeskDCFURL

The url of the API service

Last Updated:


ZenDeskDCFUserID

The email address of the user making the api call for authentication

Last Updated:


ZenDeskDCFUserToken

The token of the user making the api call for authentication

Last Updated:


Subject Variable

PatientNumberIncludeSiteId

[bool 0/1] When creating a new subject/patient number this value indicates whether the site id will be included.

Last Updated:


PatientNumberLength

Control the overall format of Subject number.

Last Updated:


PatientNumberPrefix

[string] When creating a new subject/patient number this value will be placed at the beginning of the number. (ie. "S" + SiteNumber + SubjectNumber)

Last Updated:


PatientNumberPrefixSiteSeperator

[string] When creating a new subject/patient number this value will be used as a seperator between the prefix and the site id. (ie. Seperator is "-": S + "-" SiteNumber + SubjectNumber)

Last Updated:


PatientNumberSiteSubjectNumberSeperator

[string] When creating a new subject/patient number this value will be used as a seperator between the site id and the subject number. (ie. Seperator is "*": S + SiteNumber + "*" + SubjectNumber)

Last Updated:


SubjectRole

Subject Role

Last Updated: