PPT Slide
I.B.3. QUERY DATABASE (Background)
It is also helpful to be familiar with the AVSS Data Structure:
^FS(SiteCode, FormName, Index#, Field#)=“Data”
^FS(56,"LCA",1200056000001,"1A")="DANIEL"
^FS(56,"LCA",1200056000001,"1B")="ALBERT"
^FS(56,"LCA",1200056000001,"1C")="BOONE"
So when we query the AVSS database we will be extracting Data (DANIEL) according to the SiteCode (56), the FormName (LCA), the Index# (1200056…...), and the Field# (1A). With respect to the latter, the paper form (Birth Certificate) serves as the AVSS Data Dictionary.