ࡱ> TS \pmcneillh Ba==x<L;$8X@"1XArial1XArial1XArial1XArial1 XArial1$XArial1XArial1XArial1XArial"$"#,##0_);\("$"#,##0\)!"$"#,##0_);[Red]\("$"#,##0\)""$"#,##0.00_);\("$"#,##0.00\)'""$"#,##0.00_);[Red]\("$"#,##0.00\)7*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_).))_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)?,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)6+1_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_)"Yes";"Yes";"No""True";"True";"False""On";"On";"Off"],[$ -2]\ #,##0.00_);[Red]\([$ -2]\ #,##0.00\)                + ) , *    x@ @   x@ @  0@ @ 0@ @ p@ @ p@ @ x@ @ p@ @ 0@ @  @ @ p@ @   `@ @  p@ @  p@ @ * 8@ @  8@ @ p@ @   x@ @ *  x@ @ )  x@ @ *  x@ @ * 8@ @   x@ @ * (p@ @   p@ @  8@ @ x@ @  x@ @  x@ @ p@ @ ) p@ @ ) x@ @ )  p@ @   x@ @   x@ @ ) x@ @ -  `G;Logical Structure %QPhysical Structure - Module 1%bPhysical Structure - Module 2%uPhysical Structure - Module 3T Notes1..10..10..n1..nElement Structure (Name) Nesting Level Data Type OccurrenceMachine Actionable ID1..NnCube unique ID+the number of dimensions found in the nCube3the number of cells (data items) found in the nCube4the purpose for which a particular nCube was created.defines a variable as a dimension of the nCube"provides coordinate order (1,2,& n):identifies the dimensionVariable describing this dimensionWindicates that the nCube contains only a limited number of categories from the variable7provides the specific category of the variable included#the value attached to that categoryOcan be used to define a range of categories rather than listing each separatelykthe measurement features of the cell content (repeatable only for regularly bundled arrays of cell content)this is used in the case where the content of the cell is defined by a variable description, e.g., FLAG where the content is a single character flag and its definition is provided by the category labelxsum | average | count | mode | median | maximum | minimum (note this list is incomplete& percent is also a common method)/defines "what" the value in the cell representsaprovides information on implied decimals, counts in thousands etc. expressed as x1 x0.1 x100 etc.#point of origin for anchored scalesstock | flow | non-additive name dimensionQuantity cellQuantity label country language year text universe imputation clusion responseUnit analysisUnit purpose dimension rank dimensionReference variableReference cohort categoryReference categoryValue range units minimum minimumExclusive maximum maximumExclusive measure aggregationMethod measurementUnit scale origin additivity attributeThis would reference the variable that defines the attribute - we need to discuss whether this is defined as any other variable is, or whether we create a new, but similar structure to define attributes (which had been discussed in the early phases of this topic) ID(Identification of the variable reference attribute ID variableReference=This would reference the variable that defines the attribute. RecordLayout5the variable or aggregate data cell being referred toJrepeated to provide the full matrix coodinate of the cell within the nCubeFwhich coordinate in the standard matrix descriptive pattern (1,2,3& .n)Bvalue of the specific coordinate (not used if coordValRef is used)the variable ID where the coordinate value is found (for files where one of the dimensions of the matrix has a different record for each category and the value of the category is found in a specific variable, e.g., SIC codes in US County Business Patterns)!IDREF of gross record descriptionmposition of first character of the data item in fixed format OR array number of data item for delimited filesGdata item width for fixed format file, maximum width for delimited file?position of the last character of the data item in fixed format nCubeData dataItem dataItemID recordReferenceeNew container to group data from common nCubes - this allows for nCube level attributes to be defined nCubeReferenceIDREF to the nCube attribute attRef0..N1Component to provide nCube level attribute values8Reference to the attribute ID from the logical structure valuehValue of the attribute. Note: Not sure if we have to worry about pointing to a file location for this? attribute value attRefLComponent to provide nCube level attribute values - same structure as above. cubecoordinate cubeCoordinateNumber cubeCoordinateValue cubeCoordinateVariable startPosition width endPosition measureValue dataItemID$Value of the cube section measurmentString valueunique ID for the data item IE Commentsindicates the name of the variable to be used as one of the coordinates of the nCube e.g. gender (GENDER1), or age (AGE), or party affiliation (PARTYID) . I'm not sure if this note should be here describing dimensionReference or if it belong in Row 21 to describe dimensionVariable and this Row 20 should say "unique name for this particular dimension of this variable" Describes the logical structure of an n-dimensional array, in which each coordinate intersects with every other dimension at a single point. The nCube has been designed for use in the markup of aggregate data.uniquely identifies the elementFa brief unique name (often a varient of a table number) for the nCube >used to define the coordinate order (rank="1", rank="2", etc.)used when the nCube contains a limited number of categories from a particular variable, as opposed to the full range of categories7an IDREF to the actual category being used in Rindicates the actual value attached to the category that is being used in 3permits the specification of integer/real numbers. 6specifies the lowest values that are part of the range7specifies the highest values that are part of the rangeEspecify values that are immediately outside the low end of the range Especify values that are immediately outside the high end of the rangeqdefines a variable as a dimension of the nCube, and should be repeated to describe each of the cube's dimensions element used in cases where the content of the cell is defined by a variable description, e.g. for a variable which is a FLAG where the content is a single character code and it's definition is provided by the category labelSindicates the type of aggregation method used, e.g. 'sum', 'average', 'count', etc.:records the quantification unit, e.g. 'km', 'miles', etc.;1 records unit of calibration, e.g. 'x1', 'x1000';*records the base point for anchored scalesL records type of addition involved such as 'stock', 'flow', 'non-additive' This new component would identify attributes attached to a measure. For example, one might want to use a Status at this level, to identify whether the value is estimated, actual, etc. This is the same structure as above, so the same short comings apply.RQUESTION: Is there a list of possible attributes to be included or more examples? 3references the variable that defines this attribute1IDREF of the variable that defines this attribute?explains the rational for why this particular nCube was createdo see note above for Row 20& 0r is it: identifies the variable in the file describing this dimension in the special cases where the catValu (Section 4 Variable 4.3.18.1) provides the field content and the labl (Section 4 Variable 4.3.18.2) provides the code because in the file there is a physical record for each reported value of the variable for example, in County Business Patterns there is a variable for Industry Code In current Scheme it is defined as: an IDREF that points to the variable that ma<ekes up this dimension of the nCube.  FDescribes the measurement features of the cell. ( Rows 35-41 below) . value start choice end choice>could this be incorporated in the structure below rows 44& 45?Questions to SRGvalue for this variable,the number of dimensions found in this nCube4the number of cells (data items) found in this nCubeGThe actual range of values, described by attributes (Rows 26-30) below.new component to identify attributes attached to the nCube - that is, meta-data shared by the entire set of measurements for the nCube structure. e.g., if all measurements in this nCube are in 10,000 USD, you would include two attributes - one for Unit Multiplier and one for Currency3value for the variable referenced by this attributeCQUESTION FOR JAY: is it "range of values" or "range of categories"?new component to identify attributes attached to a measure, e.g., one might want to use a Status attribute at this level, to identify whether the value is estimated, actual, suppressed, etc. ._Physical Structure - Module 1 - applies to data in external fixed format files without metadatajNew container to group data from common nCubes - this allows for the definition of nCube level attributes IE COMMENTSIDREF to this nCube9Reference to this attribute ID from the logical structureQUESTIONS FOR SRG0Do we need to point to a file location for this?Value of this attribute *QUESTION FOR JAY: is this rewrite correct?%Value of the cube section measurementZQUESTION FOR JAY: which Rows is this referring to when it says "same structure as above"??5The variable or aggregate data cell being referred toUnique ID for this data itemvCoordinate for this particular item, repeated to provide the full matrix of coodinates for the cells within this nCubeOSpecifies this coordinate in the standard matrix descriptive pattern (1,2,3& .n)SGives the value of this specific coordinate (NOTE: not used if coordValRef is used)The variable ID where the coordinate value is found (for files where one of the dimensions of the matrix has a different record for each category and the value of the category is found in a specific variable, e.g., SIC codes in US County Business Patterns)mPosition of first character of the data item in fixed format OR array number of data item for delimited filesGData item width for fixed format file, maximum width for delimited fileFPosition of the last character of the data item in a fixed format file\Physical Structure - Module 2 - applies to data in external fixed format files with metadataOPhysical Structure - Module 3 - applies to files with inline data and metadataValue of this attribute. NIDREF of gross record description (NOTE FROM IE& I don't think this is correct)Ea brief unique name for the nCube (often a variant of a table number)This new component would identify attributes attached to the nCube - that is, meta-data shared by the entire set of measurements for the nCube structure. For example, if all measurements were in 10,000 USD, one may want to put an attribute for Unit Multiplier and one for Currency here. Note: This structure is probably not complete, but I wanted to just get the basic ideas out heretModule 1 is designed to describe data in an external file which does not contain any metadata in that external file.Module 2 is designed to describe data in an external file which does contain metadata in that external file (e.g. row and column headers).Module 3 is designed to describe the format where the data and all DDI metadata are contained within one single file; the structure below thus allows for the data to be inserted in-line in the metadata record. F g  o;\" ! \}Vw 8S"t%+:.70^2[ 6 cc  .A?MKiQ  dMbP?_*+%$!&CLogical - Additions IE CommentsMHP LaserJet 5Si MX4C odXXLetter DINU"4"dXX??U} } m } }  }  } $@} ($} } $ .              +q ,  ~ ?  % *s  ~ @   $t ~ @   $u  ~ @   $ !~ @   $ "~ @  #~ @  $~ @  %~ @   &~ @   '~ @   (~ @   )~ @   *~ @  +~ @  ,~ @   ( -~ @   $ .~ @   (v /~ @   $r 0~ @   $ 1~ @   (w 2~ @   (x 3~ @   (y 4~ @   - 0 5~ @  $z 6~ @  ${ 7~ @  $| 8~ @  $} 9~ @  $~ '@~ '@. '/ ' '  !B~ !@" !# 'C $Dd lpBPPPP4444444444PPPPPPPP^BBBBBh ! " # $ % & ' ( ) * + , !- ! !0~ !@ " ! # 'A $ !:~ !@! ! ! !)!& "0~ "@" "  " "$ #;~ #@# #  # #$ $<~ $@$ $  $ $$ $ %=~ %@% %  % %$ % &>~ &@& &  & &$ '?~ '@' '  ' '$ (!D~ (!@(" (!(# (' (' )!F~ )!@)" )!)# )'G )$ *!*!"!#' +!E~ +!@+" +!+# +'C +$ ,!~ ,!@ ,!,# ,' ,$8, -!>-#'$ ZZPP^^PPZZ"Z>@7  +U`ib  dMbP?_*+%# &CPhysical Structure - Module 1 MHP LaserJet 5Si MX4C odXXLetter DINU"4"dXX??U} } m } }  }  } $@} I-} } $ +             , ,111123 ) H~ ?4 R~ @   V 5 W~ @  X 5 Y~ @ [ \ 5\ Z~ @  ] 5 ^~ @    _ 5  S~ @     I 6 l~ @    p 6 d~ @  [  J 6  e~ @    K 6 f~ @  L 6 g~ @  M 6 k~ @   m 6 U~ @  N 6N h~ @ 7 O 6 i~ @  P 6 j~ @  Q 6 `~ @ [ c 5c  b~ @  ] 5 a~ @  _ 5 Bt Xp$0ZZZZhZZhZZZZZZZZhZh  !"#$%&'()* !"#$%&'()*J >@  7  .frt  dMbP?_*+%# &CPhysical Structure - Module 2 MHP LaserJet 5Si MX4C odXXLetter DINU"4"dXX??U} } m } }  }  } $@} $4} $} $ .               H~ ?  5 R~ @   V 5 W~ @  X 5 Y~ @ [ \ 5\ Z~ @  ] 5 ^~ @    _ 5  S~ @    I 6 T~ @     6 d~ @  [  J 6 e~ @    K 6 g~ @  M 6 U~ @  N 6N h~ @  O 6 i~ @  P 6 j~ @  Q 6 k~ @   m 6 U~ @  N 6N h~ @  O 6 i~ @  P 6 j~ @  Q 6 `~ @ [ c 5c b~ @  ] 5 a~ @  _ 5 Dn l p8ZZZZhZZZZZZZZZZZZZZZZh  !"#$%&'()*+,- !"#$%&'()*+,-  >@7  (9yS  dMbP?_*+%OL&CPhysical Structure - Model 3 applies to file with inline data and metadataMHP LaserJet 5Si MX4C odXXLetter DINU"4"dXX??U} } m } }  }  } $@} -} I} $ (              8 91 H~ ? 4 R~ @   V 5 W~ @  X 5 Y~ @ [ \ 5\ Z~ @  ] 5 ^~ @    _ 5  S~ @     I 6 l~ @     6 d~ @  [  J 6 e~ @    K 6 f~ @  L 6 g~ @  M 6 k~ @    6 o~ @ n  : 5 `~ @ [ c 5c b~ @  ] 6 a~ @  _ 6 Br Xp.,ZZZZhZZZZZZZ^ZZh  !"#$%&' !"#$%&' >@"""7 Oh+'0HP`t J Gager mcneillhMicrosoft Excel@G@ԙ}@՜.+,04 PXd lt|  Logical Structure Physical Structure - Module 1Physical Structure - Module 2Physical Structure - Module 3  Worksheets  !"#$%&'()*+,-./0123456789:;<=>?@ABDEFGHIJLMNOPQRRoot Entry FWorkbook؄SummaryInformation(CDocumentSummaryInformation8K