Metadata Element Character Lengths

COLNAME COLTYPE WIDTH
ACCESS_LIMITATION VARCHAR2 30
ACCESS_LIMITATION_OTHER VARCHAR2 100
ACCESS_LIMITATION_REL_DATE DATE
AUTHOR_EMAILS VARCHAR2 2000
AUTHORS VARCHAR2 2000
AVAILABILITY VARCHAR2 250
CLASSIFICATION_LEVEL_FORM VARCHAR2 50
CLASSIFICATION_LEVEL_PROD VARCHAR2 50
CONFERENCE_INFORMATION VARCHAR2 2000
CONFERENCE_PRODUCT_TYPE VARCHAR2 2
CONTACT_EMAIL VARCHAR2 100
CONTACT_NAME VARCHAR2 250
CONTACT_ORG VARCHAR2 250
CONTACT_PHONE VARCHAR2 30
COPYRIGHT_RESTRICTION VARCHAR2 1
COPYRIGHT_RESTRICTION_LIST VARCHAR2 60
DESCRIPTION LONG
DOE_CONTRACT_NOS VARCHAR2 240
FILE_FORMAT VARCHAR2 15
FILE_FORMAT_VERSION VARCHAR2 20
FILE_NAME VARCHAR2 255
FORMAT_ADDITIONAL VARCHAR2 300
FORMAT_COLOR VARCHAR2 1
FORMAT_GRAPHICS VARCHAR2 1
FORMAT_MACHINE_COMPATABILITY VARCHAR2 50
FORMAT_OPERATING_SYSTEM VARCHAR2 15
FORMAT_OTHER VARCHAR2 200
FORMAT_QUANTITY VARCHAR2 30
FORMAT_SOUND VARCHAR2 1
INPUT_CODE VARCHAR2 8
JOURNAL_ISSUE VARCHAR2 80
JOURNAL_NAME VARCHAR2 250
JOURNAL_SERIAL_ID VARCHAR2 40
JOURNAL_TYPE VARCHAR2 2
JOURNAL_VOLUME VARCHAR2 68
KEYWORDS VARCHAR2 650
LANGUAGE VARCHAR2 25
MD_FILE_SEQ NUMBER 22, 0
MEDIUM_CODE VARCHAR2 2
MODULE_PROC_CODE VARCHAR2 6
OPENNET_ACCESSION_NO VARCHAR2 15
OPENNET_ADDRESSEE VARCHAR2 100
OPENNET_DECLASS_DATE DATE
OPENNET_DECLASS_STATUS VARCHAR2 1
OPENNET_DOCUMENT_KEYWORDS VARCHAR2 300
OPENNET_DOCUMENT_LOCATION VARCHAR2 1000
OPENNET_DOCUMENT_TYPE VARCHAR2 3
OPENNET_FIELDOFFICE_ACRONYM VARCHAR2 3
ORIGINATING_RESEARCH_ORG VARCHAR2 1000
OTHER_IDENTIFYING_NOS VARCHAR2 240
OTHER_REPORT_TYPE VARCHAR2 80
PATENT_ASSIGNEE VARCHAR2 500
PATENT_FILE_DATE DATE
PATENT_PRIORITY_DATE DATE
PRODUCT_SIZE VARCHAR2 30
PRODUCT_TYPE VARCHAR2 2
PROTECTED_DATA_CRADA VARCHAR2 1
PROTECTED_DATA_DESC VARCHAR2 80
PUBLICATION_DATE DATE
PUBLISHER_INFORMATION VARCHAR2 400
RD_PROJECT_IDS VARCHAR2 240
RECORD_STATUS VARCHAR2 2
RELEASE_OTHER VARCHAR2 100
RELEASED_BY VARCHAR2 250
RELEASED_BY_EMAIL VARCHAR2 100
RELEASED_BY_PHONE VARCHAR2 30
RELEASED_DATE DATE
RELEASING_OFFICIAL_AUTH VARCHAR2 1
REPORT_NOS VARCHAR2 240
REPORT_PERIOD_END_DATE DATE
REPORT_PERIOD_START_DATE DATE
REPORT_TYPE VARCHAR2 20
SITE_INPUT_CODE VARCHAR2 10
SITE_URL VARCHAR2 500
SPECIAL_HANDLING VARCHAR2 80
SPONSOR_ORG VARCHAR2 1000
SUBJECT_CATEGORY_CODE VARCHAR2 1000
TITLE VARCHAR2 1000
TRANSMISSION_MODE VARCHAR2 10
UCNI_INFORMATION VARCHAR2 80
WEB241_FT_UPLOADED VARCHAR2 1
OSTI_ID NUMBER 38,0

Return to STIP Home Page

09/16/99