SDF Data Element List
Revision: June 22, 2011
Crosslist for SIS table PS_NC_L_SDF_09+
This table contains enrollment records for all SDFs sent to UNC-GA from Summer 1 2009 and forward. These SDF files were all developed from SIS source data.
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 UPA docs for full definition and codebook values
- Codebook column links to UPA SAS format for field contents, check date of publication
Lewis Carson 515-6208
| 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 | 1,2,3 | ||
| NC_GA_ENR_STATUS | $1 | ITEM006 | SENRSTAT | Enrollment Status | 1,2,3,4,6 | ||
| NC_GA_RES_CODE | $3 | ITEM008 | SRESID | County or State of Residence (GA) | 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 | C,R,N | ||
| NC_GA_TEACH_FLAG | $1 | ITEM014 | STEACH | Teacher Certification | Y,N | ||
| NC_GA_DEG_INTENT | $1 | ITEM015 | SDEGI | Degree Intent | 0-9,R,P | ||
| NC_GA_WAIVE_HRS | $5 | ITEM016 | SFREEHRS | Employee Tuition Free Credit Hours | |||
| NC_GA_OVER65 | $1 | ITEM017 | SOLD | Tuition Waiver Indicator | Y,M,F,A,T,X,O | ||
| NC_GA_LEVEL | $1 | ITEM018 | SLEVEL | Class Level | 0-9 | ||
| NC_GA_RESIDENT_HRS | $5 | ITEM019 | SRESCRHR | Resident Credit Hours | |||
| NC_GA_DE_HRS | $5 | ITEM020 | SEXTCRHR | Extension Credit Hours | |||
| NC_GA_FTE | $4 | ITEM021 | SFTE | FTE (Resident Credit + Extension) | decimal 3.2 | ||
| NC_GA_TRAN_INST | $6 | ITEM022 | STRINST | Transfer Institution | |||
| NC_GA_DATA_EXCP | $1 | ITEM023 | SDATAEX | Data Availability Exception Code | A-O, blank | ||
| NC_GA_TRAN_HRS | $3 | ITEM025 | STRCRHR | Transfer Credit Hours Applied to Degree | |||
| NC_GA_HOUSING | $1 | ITEM026 | SHOUSID | Housing Code | 6-Jan | ||
| NC_GA_NCSU_HRS_PAS | $6 | ITEM027 | SNCSHRP | Total Degree Cr Hrs Earned at Your Inst | left justified | ||
| NC_GA_GPA | $5 | ITEM028 | SGAGPA | Institutional Cumulative GPA | decimal 5.3 | ||
| 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_AGI_COOP | $1 | ITEM041 | SAGICP | Ag.Inst./Co-op Student | G,C | ||
| NC_GA_MAR_TRNSCRPT | $1 | ITEM045 | SMARTRAN | High School Transcript Review Code | $GLTRC | 1-6 | |
| NC_GA_MAR_STATUS | $1 | ITEM046 | SMARSTAT | MAR Status | $GLMARST | 0-9,H | |
| NC_GA_REM_ENG | $1 | ITEM047 | SREMENG | Remedial English | 0-9 (none at NCSU) | ||
| NC_GA_REM_MATH | $1 | ITEM048 | SREMMATH | Remedial Math | 0-9 | ||
| NC_GA_REM_OTHER | $1 | ITEM049 | SREMOTH | Remedial Other | 0-9 (none at NCSU) | ||
| NC_GA_HS_GRAD_DATE | $6 | ITEM058 | SHSGRYR,SHSMOT | High School Graduation | |||
| NC_GA_ORIG_STATUS | $1 | ITEM061 | SORIGST | Original Enrollment Status | 1,2 | ||
| NC_GA_UNC_GPA | $5 | ITEM064 | SUNCGPA | UNC-GA Uniform Cumulative GPA | decimal 5.3 | ||
| NC_GA_UNC_TOT_HRS | $6 | ITEM065 | SUNCTOHR | UNC-GA Total Cr.Hrs.Taken at Your Insti. | left justified | ||
| NC_GA_CRED_HRS | $6 | ITEM066 | SCREDHRS | CrHrsNot Earned at Inst(exc.trnsfr.hrs.) | left justified | ||
| 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_JOINT_DEG | $4 | ITEM082 | SJOINT | Joint Program Code | |||
| NC_GA_REM_READ | $1 | ITEM083 | SREMREAD | Remedial Reading | |||
| NC_GA_PLACE_READ | $1 | ITEM084 | SREDPLAC | Freshman Placement - Reading | 1,2,9 | ||
| NC_GA_DE_PGM | $1 | ITEM085 | SCMAJDE | Original Major in DE Program | 1,2,3,9 | ||
| NC_GA_DE_PGM_ORIG | $1 | ITEM086 | SOMAJDE | Major in DE this term | 1,2,3,9 | ||
| NC_GA_MCR_CAT | $3 | ITEM087 | SMCRCAT | Minimum Course Requirements (MCR) | 1-12 | ||
| 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_FTE_RES_CRED | $4 | ITEM092 | SOLDFTE | FTE of Resident Credit Hours (old budget FTE) | |||
| NC_GA_MIL_HOME_RES | $3 | ITEM095 | SHOME_RESID | Out-of-state Residence if Military or Full Scholarship | |||
| NC_GA_INTER_INST | $1 | ITEM096 | SINTERINST | Interinstitutional flag | S,B,D | ||
| NC_GA_BRIDGE_PROG | $1 | ITEM097 | Participant in a Bridge Program | 1,2,3,4,5,6,7 | |||
| NC_GA_ETH_HISP | $1 | ITEM098A |
|
Hispanics of any race | Y,N | ||
| NC_GA_ETH_NATAM | $1 | ITEM098B |
|
American Indian or Alaska Native | Y,N | ||
| NC_GA_ETH_ASIAN | $1 | ITEM098C |
|
Asian | Y,N | ||
| NC_GA_ETH_AFRAM | $1 | ITEM098D |
|
Black or African American | Y,N | ||
| NC_GA_ETH_NATHAW | $1 | ITEM098E |
|
Native Hawaiian or Other Pacific Islander | Y,N | ||
| NC_GA_ETH_WHITE | $1 | ITEM098F |
|
White | Y,N | ||
| NC_GA_ETH_UNKNOWN | $1 | ITEM098G |
|
Race and Ethnicity Unknown | Y,N | ||
| NC_GA_ETHNIC_IPEDS | $1 | ITEM099 |
|
New race/ethnic summary code | 1-9 | ||
NCSU Extensions |
|||||||
| NC_NAME_INDEX | $30 | SNAME | Name | ||||
| NC_TUI_RES_CODE | $3 | SRES | Tuition Residence (NCSU) | R&R source table | |||
| NC_TUI_RATE | $1 | STUIRATE | Tuition Rate Flag | ||||
| NC_OUC_SCH | $2 | SCOLL | College | ||||
| NC_CURR_ABBR | $5 | SCUR | Curriculum | ||||
| NC_CLASS | $2 | SCLASS | Classification | ||||
| NC_OUC_SCH2 | $2 | SECMJSCH | Second Major College | ||||
| NC_CURR_ABBR2 | $5 | SCUR2 | Second Major Curriculum | ||||
| NC_PRIVACY_BLOCK | $1 | PRIVACY | Privacy Flag | ||||
| 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_TRAN_HRS | $5 | STRHRS | Transfer Hours | left justified | |||
| 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_GPA | $6 | SGPA | Cumulative GPA | decimal 5.3 | |||
| NC_HRS | $6 | SHRS | Total Hours | left justified | |||
| NC_SUSPENSION | $1 | SSUS | Suspension Code | ||||
| NC_OUC | $6 | SOUC | Financial OUC | ||||
| NC_CO_OP | $1 | SCOOP | Cooperative Education Flag | ||||
| NC_CUM_HRS_P | $5 | STOHRPAS | Cumulative Hours Passed | left justified | |||
| NC_REGULAR_TERM | $1 | SREGFILE | Regular Term Student Data File | ||||
| NC_DE_TERM | $1 | SEXTFILE | Extension (DE) Student Data File | ||||
| NC_UNITYID | $8 | SUNITY | Unity ID | ||||
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_PLAN_ORG1 | $10 | NC_PLAN_ORG | |||||
| 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 | |||||
| NC_PLAN_ORG2 | $10 | NC_PLAN_ORG | |||||
| DEGREE | $8 | DEGREE | |||||