GATEWAY
| 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 |
| Author Affiliation |
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 |
| Document online |
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 |
| Related Object Link |
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 |
|
