forked from scieloorg/scielo-manager
-
Notifications
You must be signed in to change notification settings - Fork 0
issue_database_en
fabiobatalha edited this page Jan 10, 2012
·
12 revisions
#Issue Database
More: http://trac.scielo.org/trac/Web/wiki/SciELO_PCPrograms_Title_Manager_ISSUE
| revisado | cisis | repeatable | mandatory | database (proc) | field name (Relational Database) | data sample | description |
|---|---|---|---|---|---|---|---|
| IDENTIFY TITLE | |||||||
| X | 30 | title | title.abbrevtitle | model title | Abbreviated title | ||
| X | 35 | title | title.issn | model title | ISSN | ||
| X | 130 | title | title.title | model title | Journal title | ||
| X | 230 | title | title.alternativetitles | model title | Alternative or parallels titles | ||
| X | 930 | title | title.acronuppercase | model title | upper case acronym | ||
| X | 935 | title | title.issn | model title | upper case acronym | ||
| IDENTIFY AN ISSUE | |||||||
| X | 31 | issue | issue.volume | Volume | |||
| X | 32 | issue | issue.number | Number | |||
| 33 | issue | issue.title | Issue Title | ||||
| X | 131 | issue | issue.supl_label | Vol Suppl | |||
| X | 132 | issue | issue.supl_label | Issue Suppl | |||
| X | 41 | issue | issue.is_press_release | boolean | É fascículo de press release | ||
| X | 36 | X | issue | não será implementado, usar data de publicação para display | Sequential number | ||
| CONTROL INFO | |||||||
| X | 91 | X | issue | issue.updatedate | timestamp | Updating date | |
| 700 | X | issue | issue.recordnumber | Value must be 0 | |||
| 701 | X | issue | issue.recordindex | Value must be 1 | |||
| X | 706 | X | issue | Não de faz necessário | Value must be i | ||
| OTHER DATA | |||||||
| 42 | issue | issue.status | Status of publication (available or not) | ||||
| X | 43^t | by lang | X | issue | issue.abrevtitle | Abbreviated title for bibliographic strip | |
| X | 43^v | by lang | issue | issue.volume | Volume for bibliographic strip | ||
| X | 43^n | by lang | issue | issue.number | Number for bibliographic strip | ||
| X | 43^w | by lang | issue | issue.volsuppl | Volume supplement for bibliographic strip | ||
| X | 43^s | by lang | issue | issue.numsuppl | Number supplement for bibliographic strip | ||
| X | 43^c | by lang | X | issue | issue.pubplace | City/Place for bibliographic strip | |
| X | 43^m | by lang | issue | issue.pubmonth | Month for bibliographic strip | ||
| X | 43^y | by lang | X | issue | issue.pubyear | Year for bibliographic strip | |
| 48 | by lang | X | issue | issue.tocheader | Table of Contents | ||
| 49^c | X | issue | issue.seccode | Section Code | |||
| 49^l | X | issue | issue.seclang | Section language | |||
| 49^t | X | issue | issue.sectitle | Section Title | |||
| X | 540^t | issue | licence.code | model license | |||
| X | 540^l | issue | license.text | model license | language of the license text | ||
| 62 | issue | issue.publisher | Issue Publisher | ||||
| X | 64 | issue | issue.pubdate | timestamp | Issue Publisher | ||
| X | 65 | X | issue | issue.pubdateiso | atributo computado | Date ISO | |
| 85 | X | issue | issue.vocabulary | Controled Vocabulary | |||
| X | 97 | issue | issue.capa | ñ implementar | capa do fascículo | ||
| X | 117 | X | issue | issue.standard | choices.standard | Standard | |
| X | 122 | X | issue | issue.doccount | atributo computado | Total of documents | |
| X | 140 | issue | removed | not in use | Sponsor | ||
| X | 200 | X | issue | definir melhor o uso | Markup done |