Crosswalk data elements for 1999+ for SIS to UNC-GA to OIRP
Revision: July 29, 2011
Crosslist for SIS table PS_NC_L_ADM_09PLUS
This table contains enrollment records for all Admission files sent to UNC-GA from Summer 1 2009 to Fall 2015.
Notes
- GA variables stop with ITEM099, other variables on list were added by NCSU to facilitate analyses. These other variables were taken from the student systems as of census in the semester of the file.
- All SIS names are assigned to be consistent with SIS naming conventions and to match data items where they already exist using the same definition.
- See GA docs, Legacy system docs or OIRP docs for full definition and codebook values
- Codebook column links to OIRP SAS format for field contents, check date of publication
| Variable Name in table PS_NC_L_SDF_09PLUS | Length | UNC-GA SDF Name | NCSU SAS Dataset Field Name | Field Description | Codebook Format | Notes |
|---|---|---|---|---|---|---|
| STRM | $4 | Term Code | ||||
| EMPLID | $9 | Student ID | ||||
| NC_GA_SUBDATE | $5 | ITEM003 | SSUBDATE | Submission Date | YYYYS | |
| NC_GA_MATDATE | $5 | ITEM004 | SMATDATE | Matriculation Date | YYYYS | |
| NC_GA_ADM_STATUS | $1 | ITEM005 | SADMSTAT | Acceptance Status | $GSACCP | 1,2,3 |
| NC_GA_ENR_STATUS | $1 | ITEM006 | SENRSTAT | Enrollment Status | $GLENRST | 1,2,3,4,6 |
| NC_GA_RES_CODE | $3 | ITEM008 | SRESID | County or State of Residence (GA) | $GLRESID | GA source table |
| NC_GA_ETHNIC_CITIZ | $1 | ITEM009 | SGARACE | Race | Discontinued | |
| NC_GA_GENDER | $1 | ITEM010 | SSEX | Sex | F,M | |
| NC_GA_DOB | $8 | ITEM011 | SBYR,SBMTH,SBDAY | Birth Date | ||
| NC_GA_CITIZENSHIP | $1 | ITEM012 | SCITIZ | Citizenship | $GLCITIZ | C,R,N |
| NC_GA_DEG_INTENT | $1 | ITEM015 | SDEGI | Degree Intent | $GLDEGI | 0-9,R,P |
| NC_GA_TRAN_INST | $6 | ITEM022 | STRINST | Transfer Institution | ||
| NC_GA_DATA_EXCP | $1 | ITEM023 | SDATAEX | Data Availability Exception Code | $GLDATA | A-O, blank |
| NC_GA_TRAN_HRS | $3 | ITEM025 | STRCRHR | Transfer Credit Hours Applied to Degree | ||
| NC_GA_SAT_VERB | $3 | ITEM029 | SSATV | SAT Critical Reading (Verbal) | ||
| NC_GA_SAT_MATH | $3 | ITEM030 | SSATM | SAT Math | ||
| NC_GA_ACT | $2 | ITEM031 | SACT | ACT Composite | ||
| NC_GA_HS_PCTL | $2 | ITEM032 | SHSPCTL | High School Class Rank | percentile 01-99 | |
| NC_GA_HS_GPA | $4 | ITEM033 | SHSGPA | High School GPA | decimal 4.2 | |
| NC_GA_CEEB | $6 | ITEM036 | SCEEBA | High School CEEB Code | ||
| NC_GA_MAR_TRNSCRPT | $1 | ITEM045 | SMARTRAN | High School Transcript Review Code | $GLTRC | 6-Jan |
| NC_GA_MAR_STATUS | $1 | ITEM046 | SMARSTAT | MAR Status | $GLMARST | 0-9,H |
| NC_GA_HS_GRAD_DATE | $6 | ITEM058 | SHSGRYR,SHSMOT | High School Graduation | ||
| NC_GA_DEG_CT | $1 | ITEM068 | SSDEGCT | Second Degree Code | ||
| NC_GA_ACT_ENG | $2 | ITEM073 | SACTENG | ACT English | ||
| NC_GA_ACT_MATH | $2 | ITEM074 | SACTMATH | ACT Math | ||
| NC_GA_ACT_READ | $2 | ITEM075 | SACTREAD | ACT Reading | ||
| NC_GA_ACT_SCI | $2 | ITEM076 | SACTSCI | ACT Science Reasoning | ||
| NC_GA_HONORS | $1 | ITEM077 | SHONOR | Fresh.Perf.Placement – Honors Program | 1,2,3,9 | |
| NC_GA_PLACE_ENG | $1 | ITEM078 | SENGPLAC | Fresh.Perf.Placement – English | 1,2,3,9 | |
| NC_GA_PLACE_MATH | $1 | ITEM079 | SMAPLAC | Fresh.Perf.Placement – Math | 1,2,3,4,9 | |
| NC_GA_CIP | $12 | ITEM080 | SCIP | CIP Field of Study | ||
| NC_GA_CIP_MAJ_2 | $12 | ITEM081 | SSMCIP | Double Major CIP Code | ||
| NC_GA_MCR_CAT | $3 | ITEM087 | SMCRCAT | Minimum Course Requirements (MCR) | 12-Jan | |
| NC_GA_NAME | $23 | ITEM088 | SNAME | Student Name (A,B,C,D) | ||
| NC_GA_SAT_WRITING | $3 | ITEM089 | SSATW | SAT Writing | ||
| NC_GA_SAT_WRITE_SS | $4 | ITEM090 | SATWESS,SATWMC | SAT Writing Subscores | ||
| NC_GA_ACT_WRITING | $2 | ITEM091 | SACTWCONV | ACT Writing | ||
| NC_GA_ETHNIC_IPEDS | $1 | ITEM099 | SRACE_IPEDS | New race/ethnic summary code | 9-Jan | |
| NCSU Extensions | ||||||
| NC_NAME_INDEX | $30 | SNAME | Name | |||
| NC_CURR_ABBR | $5 | SCUR | Curriculum | |||
| NC_OUC_SCH2 | $2 | SECMJSCH | Second Major College | |||
| NC_CURR_ABBR2 | $5 | SCUR2 | Second Major Curriculum | |||
| NC_ADMIT_TYPE | $1 | SATYPE | Admit Type (New Freshman, Transfer) | |||
| NC_FATHER_EDUC | $1 | SFATHED | Father’s Education Flag | |||
| NC_MOTHER_EDUC | $1 | SMOTHED | Mother’s Education Flag | |||
| NC_HS_TYPE | $1 | SHSTYPE | High School Type | |||
| NC_HS_RANK | $5 | SHSRANK | High School Rank | |||
| NC_HS_SIZE | $5 | SHSIZE | High School Size | |||
| NC_GRE_VERBC | $3 | SGREVERB | GRE Verbal | |||
| NC_GRE_MATH | $3 | SGREMATH | GRE Math | |||
| NC_GRE_ANLY1 | $3 | SGREANAL | GRE Analytical | |||
| NC_TOEFL | $3 | STOEFL | TOEFL Score | |||
| NC_OUC | $6 | SOUC | Financial OUC | |||
| Fields from SIS | ||||||
| NC_ACAD_CAREER1 | $4 | ACAD_CAREER | Matches CIP first major | |||
| NC_ACAD_PROG1 | $5 | ACAD_PROG | ||||
| NC_ACAD_PLAN1 | $10 | ACAD_PLAN | ||||
| NC_ACAD_SUB_PLAN1 | $10 | ACAD_SUB_PLAN | ||||
| NC_ACAD_SUBP_TYPE1 | $3 | ACAD_SUBPLAN_TYPE | ||||
| NC_ACAD_CAREER2 | $4 | ACAD_CAREER | Matches CIP second major | |||
| NC_ACAD_PROG2 | $5 | ACAD_PROG | ||||
| NC_ACAD_PLAN2 | $10 | ACAD_PLAN | ||||
| NC_ACAD_SUB_PLAN2 | $10 | ACAD_SUB_PLAN | ||||
| NC_ACAD_SUBP_TYPE2 | $3 | ACAD_SUBPLAN_TYPE | ||||
| DEGREE | $8 | DEGREE | ||||