{"DATA_FRAME":"startingdf","COLUMN_NAME":"Unitid","COLUMN_TYPE":"Numeric","ACCEPTABLE_VALUES":"(relevant unitid; xxxxxx)"}
{"DATA_FRAME":"startingdf","COLUMN_NAME":"StudentId","COLUMN_TYPE":"Character or numeric","ACCEPTABLE_VALUES":"(any unique identifier for your students)"}
{"DATA_FRAME":"startingdf","COLUMN_NAME":"RaceEthnicity","COLUMN_TYPE":"Numeric","ACCEPTABLE_VALUES":"1 - Nonresident alien\n2 - Hispanic/Latino\n3 - American Indian or Alaska Native\n4 - Asian\n5 - Black or African American\n6 - Native Hawaiian or Other Pacific Islander\n7 - White\n8 - Two or more races\n9 - Race and ethnicity unknown"}
{"DATA_FRAME":"startingdf","COLUMN_NAME":"Sex","COLUMN_TYPE":"Numeric","ACCEPTABLE_VALUES":"1 - Men\n2 - Women"}
{"DATA_FRAME":"startingdf","COLUMN_NAME":"GenderDetail","COLUMN_TYPE":"Numeric","ACCEPTABLE_VALUES":"1 - Men\n2 - Women\n3 - Unknown gender\n4 - Another gender"}
{"DATA_FRAME":"startingdf","COLUMN_NAME":"DegreeLevel","COLUMN_TYPE":"Character or Numeric","ACCEPTABLE_VALUES":"1a - Postsecondary award, certificate, or diploma of \nless than 300 clock hours or\nless than 9 semester or trimester credit hours or\nless than 13 quarter credit hours\n1b - Postsecondary award, certificate, or diploma of \n300-899 clock hours or\n9-30 semester or trimester credit hours, or\n13-44 quarter credit hours\n2 - Postsecondary award, certificate,or diploma of\nat least 900 but less than 1800 clock hours or\nat least 30 but less than 60 semester or trimester credit hours or\nat least 45 but less than 90 quarter credit hours\n3 - * Associate's Degree\n4 - Postsecondary award, certificate,or diploma of \n1800 or more clock hours or\n60 or more semester or trimester credit hours or\n90 or more quarter credit hours\n5 - * Bachelor's Degree or equivalent\n6 - Postbaccalaureate Certificate\n7 - * Master's Degree\n8 - Post-Master's Certificate\n17 - * Doctor's degree - research/scholarship\n18 - * Doctor's degree - professional practice\n19 - * Doctor's degree - Other\n* Use only 3, 5, 7, 17, 18 and 19 when reporting second majors."}
{"DATA_FRAME":"startingdf","COLUMN_NAME":"MajorNumber","COLUMN_TYPE":"Numeric","ACCEPTABLE_VALUES":"1 - First Major\n2 - Second Major"}
{"DATA_FRAME":"startingdf","COLUMN_NAME":"MajorCip","COLUMN_TYPE":"Character or Numeric","ACCEPTABLE_VALUES":"xx.yyyy or XXYYYY preferred (do not mix formats!),\nx.yyy (etc) accepted"}
{"DATA_FRAME":"startingdf","COLUMN_NAME":"DistanceEd","COLUMN_TYPE":"Numeric","ACCEPTABLE_VALUES":"1 - All programs in this CIP code/award level are distance education\n2 - None of the programs in this CIP code/award level are distance education\n3 - Some programs in this CIP code/award level are distance education"}
{"DATA_FRAME":"startingdf","COLUMN_NAME":"DistanceEd31","COLUMN_TYPE":"Numeric","ACCEPTABLE_VALUES":"NULL - if DistanceEd is 1 or 2\n0 - if DistanceEd is 3 and NO programs in this CIP code/award level have a mandatory onsite component\n1 - if DistanceEd is 3 and at least one program in the CIP code/award level has a mandatory onsite component"}
{"DATA_FRAME":"startingdf","COLUMN_NAME":"DistanceEd32","COLUMN_TYPE":"Numeric","ACCEPTABLE_VALUES":"NULL- if DistanceEd is 1 or 2\n0 - if DistanceEd is 3 and NO programs in this CIP code/award level have a non-mandatory onsite component\n1 - if DistanceEd is 3 and at least one program in the CIP code/award level has a non-mandatory onsite component"}
{"DATA_FRAME":"startingdf","COLUMN_NAME":"Age","COLUMN_TYPE":"Numeric","ACCEPTABLE_VALUES":"Demical or integer ages"}
{"DATA_FRAME":"extracips","COLUMN_NAME":"Unitid","COLUMN_TYPE":"Numeric","ACCEPTABLE_VALUES":"(relevant unitid; multiple unitids per dataframe is acceptable)"}
{"DATA_FRAME":"extracips","COLUMN_NAME":"DegreeLevel","COLUMN_TYPE":"Character or Numeric","ACCEPTABLE_VALUES":"1a - Postsecondary award, certificate, or diploma of \nless than 300 clock hours or\nless than 9 semester or trimester credit hours or\nless than 13 quarter credit hours\n1b - Postsecondary award, certificate, or diploma of \n300-899 clock hours or\n9-30 semester or trimester credit hours, or\n13-44 quarter credit hours\n2 - Postsecondary award, certificate,or diploma of\nat least 900 but less than 1800 clock hours or\nat least 30 but less than 60 semester or trimester credit hours or\nat least 45 but less than 90 quarter credit hours\n3 - * Associate's Degree\n4 - Postsecondary award, certificate,or diploma of \n1800 or more clock hours or\n60 or more semester or trimester credit hours or\n90 or more quarter credit hours\n5 - * Bachelor's Degree or equivalent\n6 - Postbaccalaureate Certificate\n7 - * Master's Degree\n8 - Post-Master's Certificate\n17 - * Doctor's degree - research/scholarship\n18 - * Doctor's degree - professional practice\n19 - * Doctor's degree - Other\n* Use only 3, 5, 7, 17, 18 and 19 when reporting second majors."}
{"DATA_FRAME":"extracips","COLUMN_NAME":"DistanceEd31","COLUMN_TYPE":"Numeric","ACCEPTABLE_VALUES":"NULL - if DistanceEd is 1 or 2\n0 - if DistanceEd is 3 and NO programs in this CIP code/award level have a mandatory onsite component\n1 - if DistanceEd is 3 and at least one program in the CIP code/award level has a mandatory onsite component"}
{"DATA_FRAME":"extracips","COLUMN_NAME":"DistanceEd32","COLUMN_TYPE":"Numeric","ACCEPTABLE_VALUES":"NULL- if DistanceEd is 1 or 2\n0 - if DistanceEd is 3 and NO programs in this CIP code/award level have a non-mandatory onsite component\n1 - if DistanceEd is 3 and at least one program in the CIP code/award level has a non-mandatory onsite component"}
{"DATA_FRAME":"extracips","COLUMN_NAME":"MajorNumber","COLUMN_TYPE":"Numeric","ACCEPTABLE_VALUES":"1 - First Major\n2 - Second Major"}
{"DATA_FRAME":"extracips","COLUMN_NAME":"MajorCip","COLUMN_TYPE":"Character or Numeric","ACCEPTABLE_VALUES":"xx.xxxx preferred,\nx.xxx (etc) accepted"}
{"DATA_FRAME":"extracips","COLUMN_NAME":"RaceEthnicity","COLUMN_TYPE":"Numeric","ACCEPTABLE_VALUES":"set all values to 1"}
{"DATA_FRAME":"extracips","COLUMN_NAME":"Sex","COLUMN_TYPE":"Numeric","ACCEPTABLE_VALUES":"set all values to 1"}
{"DATA_FRAME":"extracips","COLUMN_NAME":"Count","COLUMN_TYPE":"Numeric","ACCEPTABLE_VALUES":"set all values to 0"}