Core LMI Dim Indid

Column NameSnowflakeBig QueryDatabricksParquetComment
INDIDVARCHARSTRINGSTRINGSTRINGSIC code.
INDID_PARENTVARCHARSTRINGSTRINGSTRINGThe parent SIC code.
LEVELNUMBERBIGNUMERICDECIMALDECIMALLevel of the dimension hierarchy.
NAMEVARCHARSTRINGSTRINGSTRINGName belonging to the SIC code
ORDERIDNUMBERBIGNUMERICDECIMALDECIMALOrdering by this field will order the codes according to the hierarchy. This field is needed here since ordering by the codes themselves would not result in a proper sort.