Type of Data Stored PESC SIF ED Kuali Identifier A range of allowable options, A range of allowable types of Enumerated identification Allows for a range of identity based on numbers issued in ID, specific to the area of numbers as listed in NCES0140 indicators which are locally Canada and the US, such as implementation. defined in the Kuali database the US Social Security Number, etc. Date of Stored as yyyy-mm-dd Stored as yyyy-mm-dd and also Stored as yyyy-mm-dd and also DateTime field Also allows a birthday field includes birthdate verification includes birthdate verification (mm-dd) Not Stored Enumerated race types per ED Enumerated race types Ethnicity defined in the Race/Ethnicity Hispanic or Latino Flag Hispanic or Latino Flag Multiple database. Only a single Multiple ethnicities with ethnicities with percentage ethnicity can be stored percentage assignments assignments possible. possible. Large quantity of other migrant data Gender Male, female, unreported Male, female, unreported 01- Female, 02- Male Gender defined by ISO5218 Name [in addition to First, Prefix, Suffix, Composite Name Preferred Name, Prefix, Type of Alias, Nickname, Generation Title, Suffix, Type Middle, Last] All systems Name code, Composite Name, Type, allow alternate names to be Former legal name, Last name stored. at birth, Tribal or Clan name Allows for Domestic and Freeform and atomic address Freeform and atomic address Lines 1..3, City, State, Postal Postal Address International addresses areas conforming to US areas conforming to US Code, Country Core of Line1..3, City standard address. Global x, y standard address with added Internally Defined Address Domestic has and zip coordinates. country code and enumerated Type International has province, address type. postcode and country code. Telephone Number(s) Country, Area, Number, Freeform number, extension, Freeform number, extension, Country, Number, Extension, Extension type and listed status type and listed status Type Address Freeform Freeform address with Freeform address with Freeform address with enumerated type. enumerated type. internally defined type. Residency Indicator territory or country code, List of countries of residency Residency status with respect residency is flagged with status of resident, based on ISO31661/ISO31663 to the school district is flagged nonresident or unreported. country name
Type of Data Stored PESC SIF ED Kuali Identifier A range of allowable options, based on numbers issued in Canada and the US, such as the US Social Security Number, etc. A range of allowable types of ID, specific to the area of implementation. Enumerated identification numbers as listed in NCES0140 Allows for a range of identity indicators which are locally defined in the Kuali database Date of Stored as yyyy-mm-dd Also allows a birthday field (mm-dd) Stored as yyyy-mm-dd and also includes birthdate verification Stored as yyyy-mm-dd and also includes birthdate verification DateTime field Race/Ethnicity Not Stored Enumerated race types per ED Hispanic or Latino Flag Multiple ethnicities with percentage assignments possible. Enumerated race types Hispanic or Latino Flag Multiple ethnicities with percentage assignments possible. Large quantity of other migrant data Ethnicity defined in the database. Only a single ethnicity can be stored Gender Male, female, unreported Male, female, unreported 01- Female, 02- Male Gender defined by ISO5218 Name [in addition to First, Middle, Last] All systems allow alternate names to be stored. Prefix, Suffix, Composite Name Preferred Name, Prefix, Type of Name Alias, Nickname, Generation code, Composite Name, Type, Former legal name, Last name at birth, Tribal or Clan name Title, Suffix, Type Postal Address Allows for Domestic and International addresses Core of Line1..3, City Domestic has and zip International has province, postcode and country code. Freeform and atomic address areas conforming to US standard address. Global x, y coordinates. Freeform and atomic address areas conforming to US standard address with added country code and enumerated address type. Lines 1..3, City, State, Postal Code, Country Internally Defined Address Type Telephone Number(s) Country, Area, Number, Extension Freeform number, extension, type and listed status Freeform number, extension, type and listed status Country, Number, Extension, Type Address Freeform Freeform address with enumerated type. Freeform address with enumerated type. Freeform address with internally defined type. Residency Indicator territory or country code, with status of resident, nonresident or unreported. List of countries of residency based on ISO31661/ISO31663 country name Residency status with respect to the school district is flagged residency is flagged