Template:FWDD-List: Difference between revisions

Revision as of 15:39, 25 February 2015

**Data Elements** (edit list)
Name	Table	Format	Definition	Type	Length	Notes
Sequence	Fortification	nnnnnnn	Acquisition Number	Numeric	7 Char
Country	Fortification	nnn	Country Abbreviation	Alpha	3 Char	From List
State	Fortification	aa	State Abbreviation	Alpha	2 Char
County	Fortification	nnn	County Code	Numeric	4 Char
Name	Fortification	aaaaa...	Fortification Name	Alpha	~255 Char
See	Fortification	nnnnnnn	Primary Fort Acquisition Number	Numeric	7 Char
Type	Fortification	aaaaa...	Type of Fortification	Alpha	~255 Char	From List
Sequence	GPS	nnnnnnn	Acquisition Number	Numeric	7 Char
Lat	GPS	aaaaaaaaaaaa	Latitude	Alpha	12 Char
Lon	GPS	aaaaaaaaaaaa	Longitude	Alpha	12 Char
Type	GPS	aaaaa...	Description	Alpha	~255 Char
Key	Type	nnnnn	Type Table Key	Int	Int
Name	Type	aaaaa...	Type Table Name	Alpha	~255 Char
Key	Country	nnnnn	Country Table Key	Int	Int
Name	Country	aaaaa...	Country Table Name	Alpha	~255 Char
Abbr	Country	aaa	Country Table Name	Alpha	3 Char
Sequence	Date	nnnnnnn	Acquisition Number	Numeric	7 Char
Year	Date	aaaa	Year	Alpha	4 Char
Month	Date	aaa	Month	Alpha	3 Char
Day	Date	aa	Day	Alpha	2 Char
DateType	Date	aaaaa...	Date Type	Alpha	~255	From List

@@ Line 7: / Line 7: @@
 {{FWDBList|Name=See|Table=Fortification|Format=nnnnnnn|Definition=Primary Fort Acquisition Number|Type=Numeric|Length=7 Char|Notes=}}
 {{FWDBList|Name=Type|Table=Fortification|Format=aaaaa...|Definition=Type of Fortification|Type=Alpha|Length=~255 Char|Notes=From List}}
+{{FWDBList|Name=Sequence|Table=GPS|Format=nnnnnnn|Definition=Acquisition Number|Type=Numeric|Length=7 Char|Notes=}}
+{{FWDBList|Name=Lat|Table=GPS|Format=aaaaaaaaaaaa|Definition=Latitude|Type=Alpha|Length=12 Char|Notes=}}
+{{FWDBList|Name=Lon|Table=GPS|Format=aaaaaaaaaaaa|Definition=Longitude|Type=Alpha|Length=12 Char||Notes=}}
+{{FWDBList|Name=Type|Table=GPS|Format=aaaaa...|Definition=Description|Type=Alpha|Length=~255 Char|Notes=}}
 {{FWDBList|Name=Key|Table=Type|Format=nnnnn|Definition=Type Table Key|Type=Int|Length=Int|Notes=}}
 {{FWDBList|Name=Name|Table=Type|Format=aaaaa...|Definition=Type Table Name|Type=Alpha|Length=~255 Char|Notes=}}
@@ Line 12: / Line 18: @@
 {{FWDBList|Name=Name|Table=Country|Format=aaaaa...|Definition=Country Table Name|Type=Alpha|Length=~255 Char|Notes=}}
 {{FWDBList|Name=Abbr|Table=Country|Format=aaa|Definition=Country Table Name|Type=Alpha|Length=3 Char|Notes=}}
 {{FWDBList|Name=Sequence|Table=Date|Format=nnnnnnn|Definition=Acquisition Number|Type=Numeric|Length=7 Char|Notes=}}
 {{FWDBList|Name=Year|Table=Date|Format=aaaa|Definition=Year|Type=Alpha|Length=4 Char|Notes=}}