os_specimen_requests_aud

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
REV BIGINT 19 √ null
REVTYPE TINYINT 3 √ null
IDENTIFIER BIGINT 19 √ null
CATALOG_ID BIGINT 19 √ null
catalogId_MOD BIT 1 √ null
CATALOG_QUERY_DEF TEXT 65535 √ null
catalogQueryDef_MOD BIT 1 √ null
REQUESTOR_ID BIGINT 19 √ null
requestor_MOD BIT 1 √ null
REQUESTOR_EMAIL_ID VARCHAR 255 √ null
requestorEmailId_MOD BIT 1 √ null
IRB_ID VARCHAR 255 √ null
irbId_MOD BIT 1 √ null
REQUEST_DATE TIMESTAMP 19 √ null
dateOfRequest_MOD BIT 1 √ null
SCREENING_STATUS VARCHAR 16 √ null
screeningStatus_MOD BIT 1 √ null
SCREENED_BY BIGINT 19 √ null
screenedBy_MOD BIT 1 √ null
SCREENING_DATE TIMESTAMP 19 √ null
dateOfScreening_MOD BIT 1 √ null
SCREENING_COMMENTS VARCHAR 255 √ null
screeningComments_MOD BIT 1 √ null
PROCESSOR_ID BIGINT 19 √ null
processedBy_MOD BIT 1 √ null
PROCESSING_DATE TIMESTAMP 19 √ null
dateOfProcessing_MOD BIT 1 √ null
CP_ID BIGINT 19 √ null
os_cp_workflows.CP_ID Implied ConstraintR
cp_MOD BIT 1 √ null
DP_ID BIGINT 19 √ null
dp_MOD BIT 1 √ null
COMMENTS VARCHAR 255 √ null
comments_MOD BIT 1 √ null
ITEMS_CRIT_JSON TEXT 65535 √ null
itemsCriteriaJson_MOD BIT 1 √ null
ACTIVITY_STATUS VARCHAR 16 √ null
activityStatus_MOD BIT 1 √ null
items_MOD BIT 1 √ null
orders_MOD BIT 1 √ null

Relationships

Close relationships within degrees of separation