1 / 1

Clinical

RU_ID: NUMBER. RANDOM_RU_ID: VARCHAR2(20). IU_ID: VARCHAR2(20). NIH_NIDA_ID: VARCHAR2(20). TISH_FIELD_ID: VARCHAR2(25). HOSPITAL_ID: VARCHAR2(25). PHARMGKB_ID: VARCHAR2(25). SSN: VARCHAR2(11). BIRTHDATE: DATE. PATIENT_FLAG: VARCHAR2(3). FAMILY_PEDIGREE_NUMBER: NUMBER(8).

melosa
Download Presentation

Clinical

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. RU_ID: NUMBER RANDOM_RU_ID: VARCHAR2(20) IU_ID: VARCHAR2(20) NIH_NIDA_ID: VARCHAR2(20) TISH_FIELD_ID: VARCHAR2(25) HOSPITAL_ID: VARCHAR2(25) PHARMGKB_ID: VARCHAR2(25) SSN: VARCHAR2(11) BIRTHDATE: DATE PATIENT_FLAG: VARCHAR2(3) FAMILY_PEDIGREE_NUMBER: NUMBER(8) ADDRESS: VARCHAR2(100) CITY: VARCHAR2(30) STATE: VARCHAR2(30) ZIPCODE: VARCHAR2(10) COUNTRY: VARCHAR2(50) PHONE: VARCHAR2(20) REFERRED_FROM: VARCHAR2(50) NOTE: VARCHAR2(1000) CREATE_DATE: DATE CREATE_USER_ID: NUMBER(5) UPDATE_DATE: DATE UPDATE_USER_ID: NUMBER(5) NIDA_SUBMITTED_DATE: DATE SOURCE_DB SOURCE_DB_ID: NUMBER(8) DB_NAME: VARCHAR2(50) SOURCE_DESC: VARCHAR2(500) BUILD_NUMBER: VARCHAR2(50) GENE_VARIANT GENE_ID: NUMBER(38) (FK) VARIANT_ID: NUMBER(38) (FK) FORM Clinical Demographic MASTER FORM_EVENT FORM_ID: NUMBER(5) SUBJECT_ID: NUMBER(38) FORM_EVENT_ID: NUMBER FORM_NAME: VARCHAR2(50) COLLECT_SITE_ID: NUMBER(3) (FK) FORM_VERSION: VARCHAR2(20) EVENT_DATE: DATE COLLECT_DATE: DATE FORM_DESC: VARCHAR2(500) FORM_ID: NUMBER(5) (FK) SEX: VARCHAR2(200) SUBJECT SUBJECT_ID: NUMBER(38) (FK) FATHER_ID: NUMBER(8) SUBJECT_ID: NUMBER(38) (FK) MOTHER_ID: NUMBER(8) ETHNICITY: VARCHAR2(20) FIRST_NAME: VARCHAR2(50) FORM_QUESTION COHORT: NUMBER(5) MIDDLE_NAME: VARCHAR2(50) RESPONSE TWIN_FLAG: VARCHAR2(200) FORM_ID: NUMBER(5) (FK) LAST_NAME: VARCHAR2(50) DEATH_FLAG: VARCHAR2(3) QUESTION_ID: NUMBER(10) (FK) QUESTION_ID: NUMBER(10) (FK) NIDA_SHARE: CHAR(1) FORM_EVENT_ID: NUMBER (FK) DISPLAY_ORDER: NUMBER(10) MARITAL_STATUS: CHAR(1) SUBJECT_ID: NUMBER(38) (FK) ADMITTING_MD: VARCHAR2(50) ANSWER1_ID: NUMBER(5) (FK) BOND1998_CATEGORY: CHAR(1) FREEFORM_ANSWER1: VARCHAR2(4000) ENTRY1_DONE: CHAR(1) QUESTION ENTRANT1_ID: NUMBER(5) (FK) ENTRY1_DONE_DATE: DATE QUESTION_ID: NUMBER(10) ENTRY1_DATE: DATE ENTRY1_DONE_USER: NUMBER(5) (FK) ANSWER2_ID: NUMBER(5) (FK) ENTRY2_DONE: CHAR(1) ANSWER_GROUP_ID: NUMBER(10) (FK) FREEFORM_ANSWER2: VARCHAR2(4000) ENTRY2_DONE_DATE: DATE QUEST_NAME: VARCHAR2(200) ENTRANT2_ID: NUMBER(5) (FK) ENTRY2_DONE_USER: NUMBER(5) (FK) QUEST_TEXT: VARCHAR(1000) ENTRY2_DATE: DATE ASI_SOURCE: VARCHAR2(20) FREEFORM: CHAR(1) VALIDATE_ANSWER_ID: NUMBER(5) VALIDATE_FREEFORM_ANSWER: VARCHAR2(4000) VALIDATOR_ID: NUMBER(5) (FK) ANSWER_GROUP VALIDATE_DATE: DATE CREATE_DATE: DATE ANSWER_GROUP_ID: NUMBER(10) CREATE_USER_ID: NUMBER(5) (FK) ANSWER_GROUP_NAME: VARCHAR2(500) UPDATE_DATE: DATE UPDATE_USER_ID: NUMBER(5) (FK) ANSWER_GROUP_DETAIL TEST ANSWER_GROUP_ID: NUMBER(10) (FK) TEST_ID: NUMBER(38) ANSWER_ID: NUMBER(5) (FK) SUBJECT_ID: NUMBER(38) (FK) TEST_DATE: DATE COLLECT_SITE ANSWER COLLECT_SITE_ID: NUMBER(3) RESULT ANSWER_ID: NUMBER(5) FACILITY: VARCHAR2(100) TEST_ID: NUMBER(38) (FK) CITY: VARCHAR2(100) ANSWER_VALUE: VARCHAR2(50) STATE: VARCHAR2(100) ENDOCRINE: VARCHAR2(50) COUNTRY: VARCHAR2(100) LEVEL: NUMBER METHOD Security Genetic FORM_SIGNOFF METHOD_ID: NUMBER(5) GENOTYPE_RESULT FORM_ID: NUMBER(5) (FK) METHOD_NAME: VARCHAR2(50) SUBJECT_ID: NUMBER(38) (FK) METHOD_DESC: VARCHAR2(500) GENOTYPE_RESULT_ID: NUMBER(38) SUBJECT_ID: NUMBER(38) (FK) USER_ID1: NUMBER(5) ENTRY1_DATE: DATE VARIANT_ID: NUMBER(38) (FK) USER_ID2: NUMBER(5) METHOD_ID: NUMBER(5) (FK) ENTRY2_DATE: DATE RESEARCHER_ID: NUMBER(5) (FK) VALIDATOR_ID: NUMBER(5) USER EXPERIMENT_DATE: DATE VALIDATE_DATE: DATE USE_FLAG: VARCHAR2(3) USER_ID: NUMBER(5) NOCHART_ID: NUMBER(5) CREATE_DATE: DATE NOCHART_DATE: DATE USER_NAME: VARCHAR2(20) CREATE_USER_ID: NUMBER(5) (FK) FIRST_NAME: VARCHAR2(30) UPDATE_DATE: DATE GENE USER_PASSWORD: VARCHAR2(50) UPDATE_USER_ID: NUMBER(5) (FK) GROUP MIDDLE_NAME: VARCHAR2(30) GENE_ID: NUMBER(38) ALLELE1: VARCHAR2(50) LAST_NAME: VARCHAR2(30) GROUP_ID: NUMBER(3) CHROMOSOME_NUMBER: VARCHAR2(10). ALLELE2: VARCHAR2(50) GENE_NAME: VARCHAR2(50) USER_EMAIL: VARCHAR2(50) GROUP_NAME: VARCHAR2(50) COMMON_NAME: VARCHAR2(500) PHONE: VARCHAR2(20) AFFILIATION: VARCHAR2(50) CHROMOSOME_START: NUMBER(10) ADDRESS: VARCHAR2(100) CHROMOSOME_STOP: NUMBER(10) VARIANT ADMIN_FLAG: VARCHAR2(3) OMIM_NUMBER: VARCHAR2(50) CREATE_DATE: DATE USER_GROUP VARIANT_ID: NUMBER(38) DB_ID: NUMBER(8) (FK) CREATE_USER_ID: NUMBER(5) NOTE: VARCHAR2(1000) USER_ID: NUMBER(5) (FK) VARIANT_NAME: VARCHAR2(100) UPDATE_DATE: DATE GROUP_ID: NUMBER(3) (FK) GENE_ID: NUMBER(38) (FK) EXON_INTRON_LOC: VARCHAR2(50) ROLE_ID: NUMBER(3) (FK) AUDIT_TABLE NUCLEOTIDE_LOC: VARCHAR2(50) UPSTREAM_SEQ: VARCHAR(50) ID: INTEGER DOWNSTREAM_SEQ: VARCHAR(50) LOG_TIMESTAMP: DATE NOTE: VARCHAR2(1000) ROLE USER_NAME: VARCHAR(20) VARIANT_TYPE: VARCHAR2(20) DBSNP_LOOKUP ROLE_ID: NUMBER(3) OBJECT_NAME: VARCHAR(20) DB_ID: NUMBER(5) ACTION: VARCHAR(20) DBSNP_ID: VARCHAR(20) ROLE_NAME: VARCHAR2(50) DATA: VARCHAR(20) VARIANT_ID: NUMBER(38) (FK) ORGANISM: VARCHAR2(100) ALLELE_VALIDS MOLECULAR_TYPE: VARCHAR2(50) ROLE_PERM PERMISSION CREATED_IN_BUILD: NUMBER VARIANT_ID: NUMBER(38) (FK) ROLE_ID: NUMBER(3) (FK) UPDATED_IN_BUILD: NUMBER PERMISSION_ID: NUMBER(3) ALLELE_ID: NUMBER(10) PERMISSION_ID: NUMBER(3) (FK) VARIATION_CLASS: VARCHAR2(50) PERMISSION_NAME: VARCHAR2(50) VALID_ALLELE_VALUE: VARCHAR(30) SEQUENCE: VARCHAR2(4000)

More Related