cat_collection_protocol_aud

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
IDENTIFIER BIGINT 19 null
REV BIGINT 19 null
os_revisions.REV FK_dyoqily0s2m061bxvxik0wou5R
REVTYPE TINYINT 3 √ null
TITLE VARCHAR 255 √ null
title_MOD BIT 1 √ null
SHORT_TITLE VARCHAR 255 √ null
shortTitle_MOD BIT 1 √ null
START_DATE DATETIME 19 √ null
startDate_MOD BIT 1 √ null
END_DATE DATETIME 19 √ null
endDate_MOD BIT 1 √ null
ACTIVITY_STATUS VARCHAR 255 √ null
activityStatus_MOD BIT 1 √ null
IRB_IDENTIFIER VARCHAR 255 √ null
irbIdentifier_MOD BIT 1 √ null
ENROLLMENT BIGINT 19 √ null
enrollment_MOD BIT 1 √ null
DESCRIPTION_URL VARCHAR 255 √ null
descriptionURL_MOD BIT 1 √ null
LABEL_FORMAT VARCHAR 255 √ null
specimenLabelFormat_MOD BIT 1 √ null
DERIV_LABEL_FORMAT VARCHAR 255 √ null
derivativeLabelFormat_MOD BIT 1 √ null
ALIQUOT_LABEL_FORMAT VARCHAR 255 √ null
aliquotLabelFormat_MOD BIT 1 √ null
PPID_FORMAT VARCHAR 255 √ null
ppidFormat_MOD BIT 1 √ null
UNSIGNED_CONSENT_DOC_URL VARCHAR 255 √ null
unsignedConsentDocumentURL_MOD BIT 1 √ null
PRINCIPAL_INVESTIGATOR_ID BIGINT 19 √ null
principalInvestigator_MOD BIT 1 √ null
coordinators_MOD BIT 1 √ null
repositories_MOD BIT 1 √ null
VISIT_NAME_FORMAT VARCHAR 255 √ null
visitNameFormat_MOD BIT 1 √ null
MANUAL_PPID_ALLOWED BIT 1 √ null
manualPpidEnabled_MOD BIT 1 √ null
MANUAL_VISIT_NAME_ALLOWED BIT 1 √ null
manualVisitNameEnabled_MOD BIT 1 √ null
MANUAL_SPEC_LABEL_ALLOWED BIT 1 √ null
manualSpecLabelEnabled_MOD BIT 1 √ null
CODE VARCHAR 32 √ null
code_MOD BIT 1 √ null
CONSENTS_WAIVED BIT 1 √ null
consentsWaived_mod BIT 1 √ null
SPMN_LABEL_PRE_PRINT_MODE VARCHAR 32 √ null
spmnLabelPrePrintMode_MOD BIT 1 √ null
spmnLabelPrintSettings_MOD BIT 1 √ null
VISIT_NAME_PRINT_MODE VARCHAR 32 √ null
visitNamePrintMode_MOD BIT 1 √ null
VISIT_NAME_PRINT_COPIES BIGINT 19 √ null
visitNamePrintCopies_MOD BIT 1 √ null
SOP_DOCUMENT_URL VARCHAR 255 √ null
sopDocumentUrl_MOD BIT 1 √ null
SOP_DOCUMENT_NAME VARCHAR 255 √ null
sopDocumentName_MOD BIT 1 √ null
CONTAINER_SEL_STRATEGY VARCHAR 32 √ null
containerSelectionStrategy_MOD BIT 1 √ null
ALIQUOTS_IN_SAME_CONT BIT 1 √ null
aliquotsInSameContainer_MOD BIT 1 √ null
EXTRACT_SPR_TEXT BIT 1 √ null
extractSprText_MOD BIT 1 √ null
BARCODING_ENABLED BIT 1 √ null
barcodingEnabled_MOD BIT 1 √ null
BULK_PART_REG_ALLOWED BIT 1 √ null
bulkPartRegEnabled_MOD BIT 1 √ null
SPECIMEN_CENTRIC BIT 1 √ null
specimenCentric_MOD BIT 1 √ null
distributionProtocols_MOD BIT 1 √ null
VISIT_COLLECTION_MODE VARCHAR 16 √ null
visitCollectionMode_MOD BIT 1 √ null
STORE_SPRS BIT 1 √ null
storeSprEnabled_MOD BIT 1 √ null
CATALOG_ID BIGINT 19 √ null
catalogId_MOD BIT 1 √ null
SPECIMEN_BARCODE_FORMAT VARCHAR 255 √ null
specimenBarcodeFormat_MOD BIT 1 √ null
CLOSE_PARENT_SPMNS BIT 1 √ null
closeParentSpecimens_MOD BIT 1 √ null
LABEL_SEQ_KEY VARCHAR 32 √ null
labelSequenceKey_MOD BIT 1 √ null
SET_QTY_TO_ZERO BIT 1 √ null
setQtyToZero_MOD BIT 1 √ null
DRAFT_MODE BIT 1 √ null
draftMode_MOD BIT 1 √ null
VISIT_CONSENTS BIT 1 √ null
visitLevelConsents_MOD BIT 1 √ null
consentTier_MOD BIT 1 √ null
ADDL_LABEL_FORMAT VARCHAR 255 √ null
additionalLabelFormat_MOD BIT 1 √ null
STORE_SITE_ACCESS_RIGHTS BIT 1 √ null
storageSiteBasedAccess_MOD BIT 1 √ null
DRAFT_DATA_ENTRY BIT 1 √ null
draftDataEntry_MOD BIT 1 √ null
EMAIL_SENDER_GROUP BIGINT 19 √ null
emailSenderGroup_MOD BIT 1 √ null
KIT_LABELS_ENABLED BIT 1 √ null
kitLabelsEnabled_MOD BIT 1 √ null
CONSENTS_SOURCE_CP_ID BIGINT 19 √ null
os_cp_workflows.CP_ID Implied ConstraintR
consentsSource_MOD BIT 1 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc/Asc IDENTIFIER + REV
FK_dyoqily0s2m061bxvxik0wou5 Performance Asc REV

Relationships

Close relationships within degrees of separation