Open Text Collections Server WebtopDecorative image
View Info
GATEWAY
Field Name Compound? Writable? SQL type
Record Number RECNO false (Occurs=1) false INTEGER
Accession Number AN false (Occurs=0:1) true VARCHAR
CH Inventory Number CHNO false (Occurs=0:1) true VARCHAR
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:10) 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
Bibliographic Format BIBFORMAT true (Occurs=0:5) true ARRAY
Document Type/Format DT true (Occurs=0:4) true ARRAY
Physical Format PHYSFORMAT true (Occurs=0:5) true ARRAY
Copyright COPY false (Occurs=0:1) true VARCHAR
Location LOC true (Occurs=0:12) true ARRAY
Publication Year YEAR false (Occurs=0:1) true SMALLINT
Publication Date PDATE false (Occurs=0:1) true VARCHAR
Holdings HOLDINGS true (Occurs=0:2000) true ARRAY
Review Date REVIEW true (Occurs=0:10) true ARRAY
Review Type REVIEWTYPE true (Occurs=0:10) true ARRAY
Next Update Date NEXTUPDATE false (Occurs=0:1) true DATE
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
Display Date DISPLAY_DATE 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
Publication Source PS true (Occurs=0:20) true ARRAY
Display DNAME DISPLAY_INFODNAME 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
Order/Invoice No ORDNO false (Occurs=0:1) true VARCHAR
Contact Person CONT false (Occurs=0:1) true VARCHAR
Cost COST false (Occurs=0:1) true VARCHAR
ISBN ISBN false (Occurs=0:1) true VARCHAR
Sponsoring Organization SPO true (Occurs=0:20) true ARRAY
Grant/Contract Name GNAME false (Occurs=0:1) true VARCHAR
Grant Report REPORT false (Occurs=0:1) true VARCHAR
Priority Area Number PAREANO false (Occurs=0:1) true VARCHAR
Priority Area Title PAREA false (Occurs=0:1) true LONGVARCHAR
Grant Project Title GTITLE false (Occurs=0:1) true LONGVARCHAR
Grant/Contract Number GNO true (Occurs=0:20) true ARRAY
Fiscal Year Funded FYFUND false (Occurs=0:1) true SMALLINT
Notes NOTES true (Occurs=0:40) true ARRAY
Local Notes LNOTES true (Occurs=0:3) true ARRAY
Keywords DE true (Occurs=0:15) true ARRAY
Keyword2 KEYWORD true (Occurs=0:15) true ARRAY
Target Audience TARGET true (Occurs=0:10) true ARRAY
Category CATEGORY true (Occurs=0:10) true ARRAY
Abstract AB false (Occurs=0:1) true LONGVARCHAR
Borrower's Name BORR false (Occurs=0:1) true VARCHAR
Borrower's Telephone Number BORRTEL false (Occurs=0:1) true VARCHAR
ArticleDOI ARTICLEDOI false (Occurs=0:1) true VARCHAR
Loan Date LDATE false (Occurs=0:1) true DATE
Inhouse INHSE false (Occurs=0:1) true VARCHAR
Available AVAIL false (Occurs=0:1) true VARCHAR
Rental Cost RCOST false (Occurs=0:1) true VARCHAR
Status/Action 1 STAT1 false (Occurs=0:1) true VARCHAR
Date 1 DATE1 false (Occurs=0:1) true DATE
Status/Action 2 STAT2 false (Occurs=0:1) true VARCHAR
Date 2 DATE2 false (Occurs=0:1) true DATE
Status/Action 3 STAT3 false (Occurs=0:1) true LONGVARCHAR
Date 3 DATE3 false (Occurs=0:1) true DATE
Update UP true (Occurs=0:50) true ARRAY
Date Stamp STAMP false (Occurs=0:1) true DATE
User ID USER_ID false (Occurs=0:1) true VARCHAR
Date Email Sent DATEEMAILSENT true (Occurs=0:100) true ARRAY
Date Added ADDED false (Occurs=0:1) false DATE
AUTHORS AUTHORS false false OTHER
BASIC BASIC false false OTHER
Catalog Topics CAT_TOPIC true (Occurs=0:10) true ARRAY
Date Added DATE_ADDED false (Occurs=0:1) false DATE
Distributor ID DIST_ID false (Occurs=0:1) true VARCHAR
English Version CHNO EVCHNO false (Occurs=0:1) true VARCHAR
Grant State(s) GRANT_STATE true (Occurs=0:55) true ARRAY
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
SIMPLE_SRCH SIMPLE_SRCH false false OTHER
Spanish Version CHNO SVCHNO 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