|
1. Structure for Table NAME |
|||
|
Field Name |
Type |
Width |
Function |
|
1 SUBJ_NAME |
Character |
67 |
Name of Commentator |
|
2 ALT_NAME |
Character |
200 |
Aliases of Commentator |
|
3 BIRTHCITY |
Character |
30 |
Birthplace |
|
4 BIRTHREGIO |
Character |
30 |
Region of birthplace |
|
5 BIRTHCOUNT |
Character |
30 |
Country of birthplace |
|
6 BIAPRXDTE1 |
Character |
1 |
Accepts characters 'a'
(ante), 'p' (post), and 'c' (circa) |
|
7
BIDTENUMB1 |
Numeric |
4 |
Exact
year of birth or terminus post quem |
|
8
BIAPRXDTE2 |
Character |
1 |
Accepts characters 'a'
(ante), 'p' (post), and 'c' (circa) |
|
9 BIDTENUMB2 |
Numeric |
4 |
Terminus ante quo for birth
date |
|
10
FLAPRXDTE1 |
Character |
1 |
Accepts characters 'a'
(ante), 'p' (post), and 'c' (circa) |
|
11 FLDTENUMB1 |
Numeric |
4 |
Exact flourishing date or
terminus post quem |
|
12 FLAPRXDTE2 |
Character |
1 |
Accepts characters 'a'
(ante), 'p' (post), and 'c' (circa) |
|
13 FLDTENUMB2 |
Numeric |
4 |
Terminus ante quo for
flourishing date |
|
14 DEATHPLACE |
Character |
30 |
Place of death |
|
15 DEAPRXDTE1 |
Character |
1 |
Accepts characters 'a'
(ante), 'p' (post), and 'c' (circa) |
|
16DEDTENUMB1 |
Numeric |
4 |
Exact death date or
terminus post quem |
|
17 DEAPRXDTE2 |
Character |
1 |
Accepts characters 'a'
(ante), 'p' (post), and 'c' (circa) |
|
18 DEDTENUMB |
Numeric |
4 |
Terminus ante quo for death
date |
|
19 CLASS_LEV |
Character |
67 |
Social class |
|
20 CLASS_COMM |
Character |
67 |
Comment field for social
class |
|
21 MISC_COMME |
Character |
200 |
Comments field for
commentator table |
|
22 FAM_PROF |
Character |
30 |
Profession of the
commentator's family |
|
2. Structure for Lookup Table ALIAS |
|||
|
Field Name |
Type |
Width |
Function |
|
1 SUBJ_NAME |
Character |
67 |
Name of Commentator |
|
2 ALT_NAME |
Character |
67 |
Aliases of Commentator |
|
3. Structure for Table SENTDBF |
|||
|
Field Name |
Type |
Width |
Function |
|
1 SUBJ_NAME |
Character |
67 |
Name of Commentator |
|
2 INTEL_PROD |
Character |
67 |
Category of intellectual product |
|
3 SENT_DOCS |
Character |
67 |
Intellectual product name |
|
4 SENT_LOC |
Character |
67 |
Location of production |
|
5 SENT_COUNT |
Character |
30 |
Country of production |
|
6 SEAPRXDTE1 |
Character |
1 |
Accepts characters 'a' (ante), 'p' (post), and 'c' (circa) |
|
7 SEDTENUMB1 |
Numeric |
4 |
Exact date of production or terminus post quem |
|
8 SEAPRXDTE2 |
Character |
1 |
Accepts characters 'a' (ante), 'p' (post), and 'c' (circa) |
|
9 SEDTENUMB2 |
Numeric |
4 |
Terminus ante quo of production |
|
10 SENT_COMME |
Character |
67 |
Comment field for Intellectual Products table |
|
11 INCIPIT |
Character |
67 |
Incipit of text |
|
4. Structure for Table LECTDBF |
|||
|
Field Name |
Type |
Width |
Function |
|
1 SUBJ_NAME |
Character |
67 |
Name of Commentator |
|
2 LECTURE |
Character |
67 |
Text upon which lectures given |
|
3 FACULTY |
Character |
67 |
Faculty in which lectures given |
|
4 LECT_LOC |
Character |
67 |
Location of lectures |
|
5 LECT_COUNT |
Character |
30 |
Country of location |
|
6 LEAPRXDTE1 |
Character |
1 |
Accepts characters 'a' (ante), 'p' (post), and 'c' (circa) |
|
7 LEDTENUMB1 |
Numeric |
4 |
Exact date of lecture or terminus post quem |
|
8 LEAPRXDTE2 |
Character |
1 |
Accepts characters 'a' (ante), 'p' (post), and 'c' (circa) |
|
9 LEDTENUMB2 |
Numeric |
4 |
Terminus ante quo of lecture |
|
10 LECT_COMME |
Character |
67 |
Comment field for lectures table |
|
5. Structure for Table EDUDBF |
|||
|
Field Name |
Type |
Width |
Function |
|
1 SUBJ_NAME |
Character |
67 |
Name of Commentator |
|
2 EDU_LEVEL |
Character |
67 |
Educational level attained |
|
3 EDU_LOC |
Character |
67 |
Location of educational attainment |
|
4 EDU_FACULT |
Character |
30 |
Faculty/School in which educational attainment attained |
|
5 EDU_COUNTR |
Character |
30 |
Country of location |
|
6 EDAPRXDTE1 |
Character |
1 |
Accepts characters 'a' (ante), 'p' (post), and 'c' (circa) |
|
7 EDDTENUMB1 |
Numeric |
4 |
Exact date of attainment or terminus post quem |
|
8 EDAPRXDTE2 |
Character |
1 |
Accepts characters 'a' (ante), 'p' (post), and 'c' (circa) |
|
9 EDDTENUMB2 |
Numeric |
4 |
Terminus ante quo for date of attainment |
|
10 EDAPRXDTE3 |
Character |
1 |
Accepts characters 'a' (ante), 'p' (post), and 'c' (circa) |
|
11 EDDTENUMB3 |
Numeric |
4 |
Exact terminal date for educational level or terminus post quem |
|
12 EDAPRXDTE4 |
Character |
1 |
Accepts characters 'a' (ante), 'p' (post), and 'c' (circa) |
|
13 EDDTENUMB4 |
Numeric |
4 |
Terminus ante quo for terminal date of attainment |
|
14 EDU_YEARS |
Numeric |
2 |
Number of years in this educational level |
|
15 EDU_COMMEN |
Character |
67 |
Comment field for educational table |
|
6. Structure for Table ECCDBF |
|||
|
Field Name |
Type |
Width |
Function |
|
1 SUBJ_NAME |
Character |
67 |
Name of Commentator |
|
2 ECC_RANK |
Character |
30 |
Ecclesiastical rank |
|
3 ECC_LOC |
Character |
67 |
Location of ecclesiastical position |
|
4 ECC_COUNTR |
Character |
30 |
Country of ecclesiastical position |
|
5 ECAPRXDTE1 |
Character |
1 |
Accepts characters 'a' (ante), 'p' (post), and 'c' (circa) |
|
6 ECDTENUMB1 |
Numeric |
4 |
Exact date of attaining ecclesiastic rank or terminus post quem |
|
7 ECAPRXDTE2 |
Character |
1 |
Accepts characters 'a' (ante), 'p' (post), and 'c' (circa) |
|
8 ECDTENUMB2 |
Numeric |
4 |
Terminus ante quo for attainment of ecclesiastical rank |
|
9 ECAPRXDTE3 |
Character |
1 |
Accepts characters 'a' (ante), 'p' (post), and 'c' (circa) |
|
10 ECDTENUMB3 |
Numeric |
4 |
Exact terminal date ecclesiastical rank or terminus post quem |
|
11 ECAPRXDTE4 |
Character |
1 |
Accepts characters 'a' (ante), 'p' (post), and 'c' (circa) |
|
12 ECDTENUMB4 |
Numeric |
4 |
Terminus ante quo for terminal date of ecclesiastical rank |
|
13 ECC_COMMEN |
Character |
67 |
Comment field for ecclesiastical table |
|
7. Structure for Table ORDDBF |
|||
|
Field Name |
Type |
Width |
Function |
|
1 SUBJ_NAME |
Character |
67 |
Name of Commentator |
|
2 OR_LEVEL |
Character |
30 |
Religious order |
|
3 OR_LOC |
Character |
67 |
Location of entrance into order |
|
4 OR_COUNTRY |
Character |
30 |
Country of location |
|
5 ORAPRXDTE1 |
Character |
1 |
Accepts characters 'a' (ante), 'p' (post), and 'c' (circa) |
|
6 ORDTENUMB1 |
Numeric |
4 |
Exact date of entrance into Order or terminus post quem |
|
7 ORAPRXDTE2 |
Character |
1 |
Accepts characters 'a' (ante), 'p' (post), and 'c' (circa) |
|
8 ORDTENUMB2 |
Numeric |
4 |
Terminus ante quo of entrance into Order |
|
9 OR_COMMENT |
Character |
67 |
Comment field for Orders table |
|
8. Structure for Table PRODBF |
|||
|
Field Name |
Type |
Width |
Function |
|
1 SUBJ_NAME |
Character |
67 |
Name of Commentator |
|
2 PRO_CAREER |
Character |
67 |
Professional position |
|
3 PRO_LOC |
Character |
67 |
Location of attaining professional position |
|
4 PRO_COUNTR |
Character |
30 |
Country of location |
|
5 PRAPRXDTE1 |
Character |
1 |
Accepts characters 'a' (ante), 'p' (post), and 'c' (circa) |
|
6 PRDTENUMB1 |
Numeric |
4 |
Exact date of attaining professional position or terminus post quem |
|
7 PRAPRXDTE2 |
Character |
1 |
Accepts characters 'a' (ante), 'p' (post), and 'c' (circa) |
|
8 PRDTENUMB2 |
Numeric |
4 |
Terminus ante quo for attainment of professional position |
|
9 PRAPRXDTE3 |
Character |
1 |
Accepts characters 'a' (ante), 'p' (post), and 'c' (circa) |
|
10 PRDTENUMB3 |
Numeric |
4 |
Exact terminal date of professional position or terminus post quem |
|
11 PRAPRXDTE4 |
Character |
1 |
Accepts characters 'a' (ante), 'p' (post), and 'c' (circa) |
|
12 PRDTENUMB4 |
Numeric |
4 |
Terminus ante quo for terminal date of professional position |
|
13 PRO_COMMEN |
Character |
67 |
Comment field for professional table |
|
9. Structure for Table RELADBF |
|||
|
Field Name |
Type |
Width |
Function |
|
1 SUBJ_NAME |
Character |
67 |
Name of Commentator |
|
2 INTEL_RELA |
Character |
67 |
Category of relationship between commentator and other individual |
|
3 RELA_NAME |
Character |
67 |
Name of related individual |
|
4 RELA_NAME_BIRTHCITY |
Character |
50 |
Birth city of Related
Individual |
|
5 RELA_NAME_BIRTHCOUNTR |
Character |
50 |
Birth country of Related
Individual |
|
6 RELA_LOC |
Character |
67 |
Location of relationship |
|
7 RELA_COUNT |
Character |
30 |
Country of location |
|
8 REAPRXDTE1 |
Character |
1 |
Accepts characters 'a' (ante), 'p' (post), and 'c' (circa) |
|
9 REDTENUMB1 |
Numeric |
4 |
Exact date of intellectual relationship or terminus post quem |
|
10 REAPRXDTE2 |
Character |
1 |
Accepts characters 'a' (ante), 'p' (post), and 'c' (circa) |
|
11 REDTENUMB2 |
Numeric |
4 |
Terminus ante quo of intellectual relationship |
|
12 RELA_COMME |
Character |
67 |
Comment field for Orders table |
|
10. Structure for Table VOYDBF |
|||
|
Field Name |
Type |
Width |
Function |
|
1 SUBJ_NAME |
Character |
67 |
Name of Commentator |
|
2 VOY_PURPOS |
Character |
67 |
Purpose of geographical movement |
|
3 VOY_LOC |
Character |
67 |
Destination |
|
4 VOY_COUNTR |
Character |
30 |
Country of destination |
|
5 VOY_YEARS |
Numeric |
2 |
Duration of sojourn |
|
6 VOAPRXDTE1 |
Character |
1 |
Accepts characters 'a' (ante), 'p' (post), and 'c' (circa) |
|
7 VODTENUMB1 |
Numeric |
4 |
Exact date of departure or terminus post quem |
|
8 VOAPRXDTE2 |
Character |
1 |
Accepts characters 'a' (ante), 'p' (post), and 'c' (circa) |
|
9 VODTENUMB2 |
Numeric |
4 |
Terminus ante quo of departure date |
|
10 VOAPRXDTE3 |
Character |
1 |
Accepts characters 'a' (ante), 'p' (post), and 'c' (circa) |
|
11 VODTENUMB3 |
Numeric |
4 |
Exact date of arrival at destination or terminus post quem |
|
12 VOAPRXDTE4 |
Character |
1 |
Accepts characters 'a' (ante), 'p' (post), and 'c' (circa) |
|
13 VODTENUMB4 |
Numeric |
4 |
Terminus ante quo of arrival date |
|
14 VOY_COMMEN |
Character |
67 |
Comment field for Voyages table |
|
15 DEP_LOC |
Character |
67 |
Departure point of voyage |
|
16 DEP_COUNTR |
Character |
30 |
Country of departure |
|
11. Structure for Table BIBLIDBF |
|||
|
Field Name |
Type |
Width |
Function |
|
1 SUBJ_NAME |
Character |
67 |
Name of Commentator |
|
2 NOTES |
Memo |
10 |
Memo field collecting bibliography |