wftag
The wftag table links various identifiers with specific waveforms, for example, orid, arid, and stassid to wfid. Linkages can also be determined indirectly using sta/chanltime; however, it is more efficient to use the wftag table.
|
FIELD |
COLUMN |
STORAGE |
EXTERNAL |
CHARACTER |
DESCRIPTION |
|
NUMBER |
TYPE |
FORMAT |
POSITION |
||
|
1 |
tagname |
varchar2(8) |
a8 |
1-8 |
key (arid, arid, evid, etc.) |
|
2 |
tagid |
number(9) |
i9 |
10-18 |
tag name value |
|
3 |
wfid |
number(9) |
i9 |
20-28 |
waveform identifier |
|
4 |
Iddate |
date |
a19 |
30-48 |
load date |
|
|
|
|
|
|
|
|
Keys: |
Primary |
tagname, tagid, wfid |
|
|
|
|
Data: |
Descriptive |
tagname |
|
|
|
|
|
Administrative |
lddate |
|
|
|
NNSA Knowledge Base Core Table Schema 29