Attachment I.pdf

Student Enrollment Transactions (EE) Record

FIELD NAME TITLE ATTRIBUTE DECIMAL

PLACES

START

POSITION

END

POSITON

DATA_TYPE Data Type 1A 2 2

INST_CODE Institution Code 6A 3 8

REPORT_YEAR Report Year 4N 0 9 12

REPORT_SEM Report Semester 2N 0 13 14

STUDENT_ID Student Identifier 9A 15 23

BIRTH_DATE Birth Date 8N 0 24 31

GENDER Gender 1A 32 32

RACE Civil Rights Racial Category 1A 33 33

CITIZENSHIP Citizenship 2A 34 35

STATE Geographic Origin/State 2A 36 37

COUNTY_ID Geographic Origin/County Identifier 2N 0 38 39

HIGH_SCHOOL High School CEEB Code 6N 0 40 45

HIGH_YEAR High School Graduation Year 4N 0 46 49

HIGH_RANK High School Rank 2N 0 50 51

UG_DEGREE Undergraduate Degree 1A 52 52

PREQ_1 Prerequisite 1 ENGLISH 1A 53 53

PREQ_2 Prerequisite 2 MATH 1A 54 54

PREQ_3 Prerequisite 3 LAB SCIENCE 1A 55 55

PREQ_4 Prerequisite 4 FOREIGN LANGUAGE 1A 56 56

PREQ_5 Prerequisite 5 ADVANCED MATH 1A 57 57

PREQ_6 Prerequisite 6 U.S. HISTORY 1A 58 58

PREQ_7 Prerequisite 7 SOCIAL STUDIES 1A 59 59

PREQ_8 Prerequisite 8 PHYSICAL EDUCATION 1A 60 60

ACT_COMP ACT Composite Score 2N 0 61 62

SAT_VERBAL SAT Verbal Score 3N 0 63 65

SAT_MATH SAT Math Score 3N 0 66 68

Student Enrollment Transactions (EE) Record (continued)

PLACES

START

POSITION

POSITON

STU_LEVEL Student Level 2N 0 69 70

REGIS_STAT Registration Status 1A 71 71

ENROLL_STAT Enrollment Status 1A 72 72

RES_CLASS Residency Classification 1A 73 73

DEG_LEVEL Degree Level 2N 0 74 75

PROG_CODE Program Code 6N 0 76 81

PROG_SUFFIX Program Suffix 3N 0 82 84

CREDIT_HRS Credit Hours Enrolled 4N 2 85 88

CUMUL_HRS Cumulative Credit Hours 5N 2 89 93

CUMUL_GPA Cumulative GPA 3N 2 94 96

ADMIT_TYPE Admission Type 1A 97 97

HIGH_GPA High School GPA 3N 2 98 100

LIFE_HRS Cumulative Credit Hours for LIFE 5N 2 101 105

LIFE_GPA Cumulative GPA for LIFE 3N 2 106 108

CERT_LIC Certification/Licensure 1A 109 109

RE_HISP Hispanic 1N 0 110 110

RE_AI_AN American Indian or Alaska Native 1N 0 111 111

RE_ASIAN Asian 1N 0 112 112

RE_BL_AF Black or African American 1N 0 113 113

RE_NH_PI Native Hawaiian or Other Pacific Islander 1N 0 114 114

RE_WHITE White 1N 0 115 115

RE_NRA Non Resident Alien 1N 0 116 116

RE_UNK Race Ethnicity Unknown 1N 0 117 117

FILL_1 Filler Field 11A 118 128

Stu dent Enrollment Transactions (ET) Record

PLACES

START

POSITION

POSITION

REC_TYPE Record Type 1A 1 1

INST_CODE Institution Code (to) 6A 3 8

REPORT_YEAR Report Year 4N 0 9 12

REPORT_SEM Report Semester 2N 0 13 14

STUDENT_ID Student Identifier 9A 15 23

TRAN_INST Transfer Institution (from) 6N 0 24 29

FILL_1 Filler Field 91A 30 120

Student Enrollment Transactions (ES) Record

PLACES

START

POSITION

INST_CODE Institution Code 6A 3 8

REPORT_YEAR Report Year 4N 0 9 12

REPORT_SEM Report Semester 2N 0 13 14

STUDENT_ID Student Identifier 9A 15 23

DEGREE Degree (Student Major, Curriculum code) 6N 0 24 29

PREV_DEGREE Previous Degree Earned 1A 30 30

ADMIT_DATE Student Admit Date 8N 0 31 38

FIRST_TERM Student First Term at Enrolled Institution 1A 39 39

TRANSFER_CREDIT Student Transfer Credit 5N 2 40 44

VISA Student Visa 2A 45 46

GOAL_1 Student Goal One 2A 47 48

GOAL_2 Student Goal Two 2A 49 50

UPD_GOAL_1 Student Updated Goal One 2A 51 52

UPD_GOAL_2 Student Updated Goal Two 2A 53 54

COLLEAGUE_SCT_ID Colleague/SCT ID 10A 55 64

STUD_LAST_NAME Student Last Name 30A 65 94

STUD_FIRST_NAME Student First Name 30A 95 124

STUD_MIDDLE_INIT Student Middle Initial 1A 125 125

Student Enrollment Transactions (EA) Record

PLACES

START

POSITION

INST_CODE Institution Code 6A 3 8

REPORT_YEAR Report Year 4N 0 9 12

REPORT_SEM Report Semester 2N 0 13 14

STUDENT_ID Student Identifier 9A 15 23

COURSE_SYMBL Course Symbol 5A 24 28

COURSE_NBR Course Number 5A 29 33

SECT_IDENT Section Identifier 3A 34 36

COURSE_SESSION Course Session 2A 37 38

COURSE_GRADE Course Grade 2A 39 40

LEC_CONTACT Lecture Contact Hours 6N 2 41 46

LAB_CONTACT Lab Contact Hours 6N 2 47 52

NBR_WEEKS Course Number of Weeks 2N 53 54

WITHDRAW_DATE Withdrawal Date 8N 0 55 62

NONFUND_REASON Non-fundable Reason 2A 63 64

TXT_APPREN_FLAG_TECH Tech ED Apprenticeship Indicator 1A 65 65

Student Disbursement Transactions (ED, EE, EF, EJ, EN, and ET) Record

PLACES

START

POSITION

INST_CODE Institution Code 6A 3 8

REPORT_YEAR Report Year 4N 0 9 12

REPORT_SEM Report Semester 2N 0 13 14

STUDENT_ID Student Identifier 9A 15 23

AWARD_AMT Amount Disbursed/Awarded 8N 2 24 31

CST_ATTEND Cost of Attendance 6N 0 32 37

EXP_FAM_CONT Expected Family Contribution 6N 0 38 43

GIFT_AID Gift Aid 6N 0 44 49

CST_PER Cost of Attendance Reporting Period 1A 50 50

EXP_PER Expected Family Contribution Reporting Pe 1A 51 51

GIFT_PER Gift Aid Reporting Period 1A 52 52

FILL_1 Filler Field 6A 53 58

Student Disbursement Transactions (EX) Record – Effective Fall 2019

PLACES

START

POSITION

INST_CODE Institution Code 6A 3 8

REPORT_YEAR Report Year 4N 0 9 12

REPORT_SEM Report Semester 2N 0 13 14

STUDENT_ID Student Identifier 9A 15 23

MARITAL_STAT Marital Status 1A 24 24

HI_ED_LEV_FATH Highest Ed Level Father 1A 0 25 25

HI_ED_LEV_MOTH Highest Ed Level Mother 1A 0 26 26

HISCHL_DIP_GED High School Diploma or GED 1A 0 27 27

ADJ_GROSS_INC Adjusted Gross Income 7N 0 28 34

FILLER1 FILLER 1A 0 35 35

NUM_IN_HOUSHLD Number in Household 2N 0 36 37

NUM_IN_COLLEGE Number in College 1N 0 38 38

AMT_PELL_AWARD PELL Award-Financial Aid 10A 2 39 48

FILLER2 FILLER 10A 49 58

TITIV_LOANS_SUB Title IV Loans Subsidized 10N 2 59 68

TITIV_LOANS_UNSUB Title IV Loans Unsubsidized 10N 2 69 78

FAM_CONT Expected Family Contribution 6N 0 79 84

OTHR_STATE_AID Other State Aid 10N 2 85 94

VET_BEN_TYPE Veteran’s Benefits Type 2A 95 96

VET_BEN_AMT Veteran’s Benefits Amount 10N 2 97 106

OTHR_FED_AID Other Federal Aid 10N 2 107 116

LOAN_AMT_NON_TITIV Loan Amount Non-Title IV 10N 2 117 126

PRIV_SCHOL Private Scholarships 10N 2 127 136

COL_WRK_STUDY College Work Study 10N 2 137 146

STUD_EMP_BYCOL Student Employed By College 1A 147 147

Student Disbursement Transactions (EX) Record (cont.)

PLACES

START

POSITION

TUITION Tuition 12N 148 159

STUDENT_DEPENDECY Student Dependency 1A 160 160

FILLER3 FILLER 1A 161 161

Student Disbursement Transactions (EZ) Record

PLACES

START

POSITION

INST_CODE Institution Code 6A 3 8

REPORT_YEAR Report Year 4N 0 9 12

REPORT_SEM Report Semester 2N 0 13 14

STUDENT_ID Student Identifier 9A 15 23

AWARD_AMT Amount Disbursed/Awarded 8N 2 24 31

HIGH_SCHOOL High School CEEB Code 6N 0 32 37

HIGH_YEAR High School Graduation Year 4N 0 38 41

GED_HOMESCHOOL_ASSOCIATION GED Home School Association 6N 0 42 47

Student Disbursement Transactions (EW) Record

PLACES

START

POSITION

INST_CODE Institution Code 6A 3 8

REPORT_YEAR Report Year 4N 0 9 12

REPORT_SEM Report Semester 2N 0 13 14

STUDENT_ID Student Identifier 9A 15 23

PROGRAM_CODE Program Code 6A 24 29

INCOME Income Flag 1N 30 30

BOOKS_AMT Books Amount Disbursed 8N 2 31 38

AWARD_AMT Amount Disbursed/Awarded 8N 2 39 46

Student Enrollment Transactions (I) Record

PLACES

START

POSITION

INST_CODE Institution Code 6A 2 7

REPORT_YEAR Report Year 4N 0 8 11

REPORT_SEM Report Semester 2N 0 12 13

STUDENT_ID_OLD Old Student Identifier 9A 14 22

STUDENT_ID_NEW New Student Identifier 9A 23 31

FILL_1 Filler Field 10A 32 41

Course Transactions (CE) Record

PLACES

START

POSITION

INST_CODE Institution Code 6A 3 8

COURSE_SYMBL Course Symbol 5A 9 13

COURSE_NBR Course Number 5A 14 18

SECT_IDENT Section Identifier 3A 19 21

REPORT_YEAR Report Year 4N 0 22 25

REPORT_SEM Report Semester 2N 0 26 27

ENROLL_TYPE Enrollment Type 1A 28 28

COUR_CREDIT Course Credit Hours 4N 2 29 32

COUR_ENROLL Course Enrollment 4N 0 33 36

START_DATE Starting Date 8N 0 37 44

END_DATE Ending Date 8N 0 45 52

FILL_1 Filler Field 38A 53 90

Course Transactions (CS) Record

PLACES

START

POSITION

INST_CODE Institution Code 6A 3 8

COURSE_SYMBL Course Symbol 5A 9 13

COURSE_NBR Course Number 5A 14 18

SECT_IDENT Section Identifier 3A 19 21

REPORT_YEAR Report Year 4N 0 22 25

REPORT_SEM Report Semester 2N 0 26 27

ORGAN_UNIT Organizational Unit 6A 28 33

PROG_CODE Program Code 6N 0 34 39

PROG_SUFFIX Program Suffix 3N 0 40 42

COUR_LEVEL Course Teaching Level

Identifier 1A 43 43

CONT_HOURS Contact Hours per Week 4N 2 44 47

START_DATE Starting Date 8N 0 48 55

END_DATE Ending Date 8N 0 56 63

METH_INSTR Method of Instruction 2N 0 64 65

DIST_LEARN Distance Learning Code 1A 66 66

FILL_1 Filler Field 24A 67 90

CONTACT_HOURS Course Contact Hours 6N 2 91 96

Course Transactions (CI) Record

PLACES

START

POSITION

INST_CODE Institution Code 6A 3 8

COURSE_SYMBL Course Symbol 5A 9 13

COURSE_NBR Course Number 5A 14 18

SECT_IDENT Section Identifier 3A 19 21

REPORT_YEAR Report Year 4N 0 22 25

REPORT_SEM Report Semester 2N 0 26 27

INSTRUCT_NO Instructor Number 9N 0 28 36

INSTRUCT_PC Instructor Teaching Percentage 3N 0 37 39

START_DATE Starting Date 8N 0 40 47

END_DATE Ending Date 8N 0 48 55

FILL_1 Filler Field 35A 56 90

Course Transactions (CM) Record

PLACES

START

POSITION

INST_CODE Institution Code 6A 3 8

COURSE_SYMBL Course Symbol 5A 9 13

COURSE_NBR Course Number 5A 14 18

SECT_IDENT Section Identifier 3A 19 21

REPORT_YEAR Report Year 4N 0 22 25

REPORT_SEM Report Semester 2N 0 26 27

DAY_WEEK Days of the Week 7A 28 34

START_TIME Start Time 4N 0 35 38

END_TIME End Time 4N 0 39 42

SITE_IDENT Site Identifier 5N 0 43 47

BLDG_IDENT Building Identifier 6A 48 53

ROOM_IDENT Room Identifier 8A 54 61

START_DATE Starting Date 8N 0 62 69

END_DATE Ending Date 8N 0 70 77

FILL_1 Filler Field 13A 78 90

Facility Transactions (AR) Record - Room

PLACES

START

POSITION

INST_CODE Institution Code 6A 3 8

BLDG_IDENT Building Identifier 6A 9 14

ROOM_IDENT Room Identifier 8A 15 22

REPORT_YEAR Report Year 4N 0 23 26

REPORT_SEM Report Semester 2N 0 27 28

ROOM_USE Room Use Code 3N 0 29 31

FUNC_USE Functional Use Code 3N 0 32 34

PROG_CODE Program Code 6N 0 35 40

PROG_SUFFIX Program Suffix 3N 0 41 43

SUITABILITY Suitability Code 2N 0 44 45

ORGAN_UNIT Organizational Unit 6A 46 51

ASSGN_AREA Assignable Area 6N 0 52 57

NBR_STATNS Number of Stations 4N 0 58 61

DISAB_ACCS Disabled Access 1A 62 62

SITE_IDENT Site Identifier 5N 0 63 67

FILL_1 Filler Field 71A 68 138

Facility Transactions (AB) Record – Building

PLACES

START

POSITION

INST_CODE Institution Code 6A 3 8

BLDG_IDENT Building Identifier 6A 9 14

REPORT_YEAR Report Year 4N 0 15 18

REPORT_SEM Report Semester 2N 0 19 20

BLDG_NAME Building Name 30A 21 50

SITE_IDENT Site Identifier 5N 0 51 55

CONST_YEAR Year of Construction 4N 0 56 59

BLDG_COST Original Building Cost 11N 0 60 70

OWNER_STAT Ownership Status 1A 71 71

TYPE_CONST Type of Construction 2N 0 72 73

LANDM_STAT Landmark Status 1A 74 74

GROSS_AREA Gross Area 7N 0 75 81

LINEAR_FT Linear Feet 7N 0 82 88

BLDG_COND Building Condition 3N 0 89 91

REHAB_EST Rehabilitation Estimate 11N 0 92 102

REPL_COST Estimated Replacement Cost 11N 0 103 113

LMR_YEAR Year of Last Major Renovation 4N 0 114 117

LMR_COST Cost of Last Major Renovation 11N 0 118 128

FILL_1 Filler Field 10A 129 138

Student Completion/Graduates Transactions (F) Record

FIELD NAME TITLE ATTRIBUTE DECIMAL START END

PLACES POSITION POSITION

REC_TYPE Record Type 1A 1 1 INST_CODE Institution Code 6A 2 7

REPORT_YEAR Report Year 4N 0 8 11

REPORT_SEM Report Semester 2N 0 12 13

STUDENT_ID Student Identifier 9A 14 22

BIRTH_DATE Birth Date 8N 0 23 30

GENDER Gender 1A 31 31

RACE Civil Rights Racial Category 1A 32 32

CITIZENSHIP Citizenship 2A 33 34

PROG_CODE Program Code 6N 0 35 40

PROG_SUFFIX Program Suffix 3N 0 41 43

DEG_LEVEL Degree Level 2N 0 44 45

DEGREE Degree 6A 46 51

SITE_IDENT Site Identifier 5N 0 52 56

CRED_HR_EARN Credit Hours Earned 5N 2 57 61

CRED_HR_REQ Credit Hours Required 5N 2 62 66

ADMIT_STATUS Admit Status 1A 67 67

CERT_LIC Certification/Licensure 1A 68 68

RE_HISP Hispanic 1N 0 69 69

RE_AI_AN American Indian or Alaska Native 1N 0 70 70

RE_ASIAN Asian 1N 0 71 71

RE_BL_AF Black or African American 1N 0 72 72

RE_NH_PI Native Hawaiian or Other Pacific Islander 1N 0 73 73

RE_WHITE White 1N 0 74 74

RE_NRA Non-Resident Alien 1N 0 75 75

RE_UNK Race Ethnicity Unknown 1N 0 76 76

FILL 1 Filler Field 9A 77 85

STATE Student State 2A 86 87

Student Completion/Graduates Transactions (F) Record (continued)

PLACES POSITION POSITION

COUNTY Student County 2N 0 88 89 AWARD DATE Conferred Year/Month 6N 0 90 95

Faculty Transactions (FF) Record

PLACES POSITION POSITION

INST_CODE Institution Code 6A 3 8

REPORT_YEAR Report Year 4N 0 9 12

REPORT_SEM Report Semester 2N 0 13 14

EMPLOY_ID Faculty Identifier 9N 0 15 23

GENDER Gender 1A 24 24

RACE Civil Rights Racial Category 1A 25 25

TERM_CTRT Term Of Contract 3N 1 26 28

EMP_STATUS Employee Status 1N 0 29 29

RANK Faculty Rank 2N 0 30 31

PRIMA_RESP Primary Responsibility 2N 0 32 33

SACS_2A1 Faculty Meeting SACS Criteria 1N 0 34 34

SACS_2A2 Term Deg/Min Required Competency 1N 0 35 35

FILL_1 Filler Field 1A 36 36

HOME_CIP Home CIP 6N 0 37 42

ANNUAL_SAL Annual Salary 7N 0 43 49

TENURE Tenure 1N 0 50 50

RESTR_FUNDS Faculty/Staff paid from Restr funds 7N 0 51 57

CONTRACT_TRM SBTCE Faculty Contract Terms 1N 0 58 58

DATE_TERM Date of Termination 8N 0 59 66

DATE_HIRE Date of Hire 8N 0 67 74

RE_HISP Hispanic 1N 0 75 75

RE_AI_AN American Indian or Alaska Native 1N 0 76 76

RE_ASIAN Asian 1N 0 77 77

RE_BL_AF Black/African American 1N 0 78 78

RE_NH_PI Native Hawaiian or Other Pacific Islander 1N 0 79 79

RE_WHITE White 1N 0 80 80

RE_NRA Non-Resident Alien 1N 0 81 81

RE_UNK Race/Ethnicity Unknown 1N 0 82 82

FILL_1 Filler Field 18N 0 83 100