DIC_XML_TO_DM_DICXREF
Dictionary table.This Xref table cross references Dic XML Attribute Texts to the appropriate BGS Discovery Metadata Dictionary codes. It maps BGS codes to the equivalent XML Attribute texts.Note that an XML attribute text/value can have many equivalent BGS codes.Lack of an entry, resulting in no mapping across from BGS Dictionary to XML attribute text will result in data being IGNORED when the extraction program is run. This table is critical in the picking up of XML atrribute text values from Discovery Metadata dictionary values/codes.
| No. |
Column name |
Data type |
Notes |
| 1 |
METADATA_GUIDELINES_ID |
Numeric(22) |
Primary key
|
| 2 |
XML_ENTRY_NO |
Numeric(22) |
|
| 3 |
BGS_METADATA_CODE |
Varchar(4) |
|
Sample data (rows 1 to 20 of 145)
| METADATA_GUIDELINES_ID |
XML_ENTRY_NO |
BGS_METADATA_CODE |
| 29 |
1 |
BO |
| 29 |
2 |
DI |
| 29 |
2 |
DT |
| 29 |
1 |
PA |
| 29 |
3 |
CD |
| 29 |
2 |
AC |
| 29 |
2 |
EX |
| 29 |
2 |
WD |
| 29 |
1 |
PM |
| 29 |
2 |
TP |
| 29 |
1 |
PT |
| 29 |
1 |
JL |
| 11 |
1 |
IM |
| 11 |
1 |
PT |
| 11 |
2 |
GP |
| 11 |
3 |
AT |
| 11 |
1 |
RA |
| 11 |
2 |
DG |
| 11 |
3 |
GB |
| 11 |
2 |
MD |
