Open Text Collections Server WebtopDecorative image
View Info
NCWWI
Field Name Compound? Writable? SQL type
Record Number RECNO false (Occurs=1) false INTEGER
Clearinghouse Type CHTYPE true (Occurs=1:10) true ARRAY
Processing Stage STAGE false (Occurs=0:1) true VARCHAR
Stage Date STDT false (Occurs=0:1) true DATE
IPDET IPDET false (Occurs=0:1) true VARCHAR
Document Title TI false (Occurs=0:1) true LONGVARCHAR
Document Second Title TI2 true (Occurs=0:10) true ARRAY
Series Title STI false (Occurs=0:1) true LONGVARCHAR
Personal Author AU true (Occurs=0:20) true ARRAY
AD false (Occurs=0:1) true VARCHAR
Corporate Author CA true (Occurs=0:10) true ARRAY
Producer Name PNAME false (Occurs=0:1) true VARCHAR
Format FORMAT true (Occurs=0:19) true ARRAY
Language LANGUAGE true (Occurs=0:5) true ARRAY
PDF Size PDF false (Occurs=0:1) true VARCHAR
Document Type/Format DT true (Occurs=0:4) true ARRAY
Copyright COPY false (Occurs=0:1) true VARCHAR
Publication Year YEAR false (Occurs=0:1) true SMALLINT
Publication Date PDATE false (Occurs=0:1) true VARCHAR
Page Count PAGECOUNT2 false (Occurs=0:1) true SMALLINT
Pagination PAGE false (Occurs=0:1) true VARCHAR
Journal Name JN false (Occurs=0:1) true VARCHAR
Journal Volume VOL false (Occurs=0:1) true VARCHAR
Journal Issue ISSUE false (Occurs=0:1) true VARCHAR
Journal Pages PA false (Occurs=0:1) true VARCHAR
Journal Date DA false (Occurs=0:1) true VARCHAR
Length of Video-Hours HOURS false (Occurs=0:1) true VARCHAR
Length of Video-Minutes MINS false (Occurs=0:1) true VARCHAR
Display PS DISPLAY_INFOPS false (Occurs=0:1) true VARCHAR
Time Stamp TIME true (Occurs=0:500) true ARRAY
Country CO false (Occurs=0:1) true VARCHAR
Link to Printable Version (PDF) PDF_URL true (Occurs=0:3) true ARRAY
LINK true (Occurs=0:3) true ARRAY
ISBN ISBN false (Occurs=0:1) true VARCHAR
Local Notes LNOTES true (Occurs=0:3) true ARRAY
Keywords DE true (Occurs=0:30) true ARRAY
Keyword2 KEYWORD true (Occurs=0:15) true ARRAY
Abstract AB false (Occurs=0:1) true LONGVARCHAR
Article DOI ARTICLEDOI false (Occurs=0:1) true VARCHAR
Update UP true (Occurs=0:50) true ARRAY
Date Stamp STAMP false (Occurs=0:1) true DATE
Date Added ADDED false (Occurs=0:1) false DATE
AUTHORS AUTHORS false false OTHER
BASIC BASIC false false OTHER
Date Added DATE_ADDED false (Occurs=0:1) false DATE
Distributor ID DIST_ID false (Occurs=0:1) true VARCHAR
HTML_OBJECT_LINK false (Occurs=0:1) true VARCHAR
Mimetype MIMETYPE false (Occurs=0:1) true VARCHAR
Online Resource ONLINE_RESOURCE false (Occurs=0:1) false TINYINT
Send to IMS SEND_IMS false (Occurs=0:1) true VARCHAR
Titles TITLE false false OTHER
Full Text of Document DOC false (Occurs=0:1) true CLOB
Full Text of Document DM_BLOB false (Occurs=0:1) true BLOB