Attachment F.pdf

1.1

SBTCE DATA DICTIONARY ACT_COMP

DATE CREATED: 5/23/91

DATE LAST REVISED: 8/15/00

SOUTH CAROLINA STATE BOARD FOR TECHNICAL AND COMPREHENSIVE EDUCATION

MANAGEMENT INFORMATION SYSTEM

ELEMENT TITLE: ACT Composite Score

SUPPLIED BY: Not required by the Technical Colleges.

DEFINITION: Enhanced American College Testing (ACT) composite score used for acceptance. NOTE: All ACT scores for first-time freshmen must use or be converted to the Enhanced ACT scale.

CODES, CATEGORIES AND COMMENTS:

NOTE: This field will be used primarily in the analysis of first-time freshmen.

FIELD SPECIFICATIONS

REQUIREMENT TYPE: Mandatory - Null Allowed

DATA VALUE RANGE: 99; 99=Null

FIELD LENGTH: 2

FIELD TYPE: Numeric

ENTRY EXAMPLE: 99 (represents a Null Value)

═══════════════════════ SBTCE USE ONLY ════════════════════════

WHERE USED (File): STUDENT.STATIC

WHERE USED (Table):

WHERE USED (Tape): TAPE.STUDENTE

1.2

SBTCE DATA DICTIONARY ADMIT-DATE

DATE CREATED: 11/13/01

DATE LAST REVISED:

SOUTH CAROLINA BOARD FOR TECHNICAL AND COMPREHENSIVE EDUCATION

ELEMENT TITLE: Student Admit Date

SUPPLIED BY: Institution

DEFINITION: The date the student was admitted to the institution.

REQURIEMENT TYPE: Nulls allowed Tech Ed. and Continuing Ed. students

DATA VALUE RANGE: Valid Date or nulls

FORMAT: YYYYMMDD

FIELD LENGTH: 8

ENTRY EXAMPLE: 20000705 (represents July 5, 2000)

WHERE USED (FILE): SBTCE Student Enrollment (ES Record)

1.2

SBTCE DATA DICTIONARY ADMIT_STATUS

DATE CREATED: 11/04/97

ELEMENT TITLE: Initial Admission Status

SUPPLIED BY: Not required by the Tech Colleges.

DEFINITION: Identifies those undergraduate students reported on the completions data that had an initial status of first-time, degree seeking freshmen at the institution awarding the degree.

Note: Please see page 16.3, credit hours earned, for implementation time frame.

DATA VALUE RANGE: 9; 9=Null

FIELD LENGTH: 1

FIELD TYPE: Alphanumeric

ENTRY EXAMPLE: 9 (represents Null Value)

WHERE USED (File): STUDENT.COMPLETION

WHERE USED (Tape): TAPE.STUDENTC

1.5

SBTCE DATA DICTIONARY ADMIT_TYPE

DATE CREATED: 11/17/93

DATE LAST REVISED: 3/23/01

ELEMENT TITLE: Admission Type

DEFINITION: The type of admission provided to a degree seeking student or continuing education student upon first entering the institution. The reporting institution will continuously update this field.

R = Regular

D = Developmental

8 = Continuing Education Only

Regular: defined as those students who meet the institution's regular admission requirements and are, therefore, admitted under the regular admission program.

Developmental: defined as those students who are enrolled in two or more developmental courses.

Continuing Education: defined as those students who are enrolled in programs other than certificates, diplomas or degree and enrolled in courses above the 499 levels.

REQUIREMENT TYPE: Mandatory - Null not allowed.

DATA VALUE RANGE: R, D, 8

FIELD LENGTH: 1

ENTRY EXAMPLE: D (represents Developmental)

WHERE USED (File): STUDENT.ENROLLMENT (EE Record)

WHERE USED (Tape):

1.6

SBTCE DATA DICTIONARY ANNUAL_SAL

DATE CREATED: 04/02/97

DATE LAST REVISED: 11/18/98

ELEMENT TITLE: Annual Salary

DEFINITION: The salary/wage paid to the employee over the course of contract period. Benefits are excluded. Salary data should be submitted for all individuals reported as full-time.

DATA VALUE RANGE: 0000001 - 9999998, Null = 9999999

FIELD LENGTH: 7

ENTRY EXAMPLE: 0150000 represent the annual salary of $150,000

WHERE USED (File): FACULTY

2.1

SBTCE DATA DICTIONARY ASSGN_AREA

DATE LAST REVISED: 4/22/93

ELEMENT TITLE: Assignable Area

DEFINITION: The assignable floor area of the room, measured in assignable square feet. This is the total floor area of the room available to the assigned occupant or use. If the space is prorated, assignable area should be proportionately allocated.

CODES, CATEGORIES, AND COMMENTS:

NOTE: Procedures and criteria will be detailed in the revised CHE Facilities

Manual.

REQUIREMENT TYPE: Mandatory - Null Not Allowed

DATA VALUE RANGE: 000001-999998

FIELD LENGTH: 6

ENTRY EXAMPLE: 000980 (represents 980 assignable square feet)

WHERE USED (File): ROOM.TRANS

WHERE USED (Tape): TAPE.FACIL

2.2

SBTCE DATA DICTIONARY AWARD_AMT

DATE CREATED: 7/27/98

DATE LAST REVISED: 7/05/02

ELEMENT TITLE: Amount Awarded for State Scholarship Dollars for Scholarship LIFE, Lottery Tuition Assistance and Need-Based

SUPPLIED BY: Institutions

DEFINITION: The amount of the scholarship for the reported year and semester.

DATA VALUE RANGE: 100 - 100000

FIELD LENGTH: 8 (with 2 implied decimals)

ENTRY EXAMPLE: 100000 (implies a dollar amount of $1000)

WHERE USED (File): STUDENT.DISBURSEMENTS

WHERE USED (Tape): TAPE.STUDENTD

3.1

SBTCE DATA DICTIONARY BIRTH_DATE

DATE LAST REVISED: 2/14/96

ELEMENT TITLE: Birth Date

DEFINITION: The calendar date of birth as reported by the student.

NOTE: For any Birth Date (other than Null), the Birth Date:

1) cannot be greater than or equal to the High School Graduation Year,

2) cannot be greater than or equal to the Report Year.

NOTE: For any Birth Date (other than Null), the calculated age of the student:

3) cannot be less than 13 years of age or greater than 99 years of age.

NOTE: The age of a student for the IPEDS Fall Enrollment Part B form will be calculated using October 31 of each year.

DATA VALUE RANGE: Valid Date, 99999999; 99999999=Null

FORMAT: YYYYMMDD Year Month Day

ENTRY EXAMPLE: 19620304 (represents March 4, 1962)

WHERE USED (File): STUDENT Enrollment (EE Record)

4.1

SBTCE DATA DICTIONARY BLDG_COND

DATE LAST REVISED: 8/10/99

ELEMENT TITLE: Building Condition

DEFINITION: The aggregate point total representing the physical status of the building at the time of the inventory or audit, based on the best judgement of those persons familiar with the physical characteristics and condition of the campus.

001 - 100 Range of poor to excellent

Building Condition codes will be grouped as follows:

Satisfactory Gross: 95 – 100 Building is suitable for use with normal maintenance. Any required restoration to present acceptable standards without major room use changes, alterations, or modernization is no more than

5% of the estimated replacement cost of the building. The range reported would reflect the percentage required. For example, a code of 100 means no restoration is required, while a code of 96 means 4% restoration required, and a code of 98 means 2% restoration required.

Remodeling A Gross: 76 – 94 Required restoration is less than 25% but more than 5%.

Remodeling B Gross: 51 – 75 Required restoration is more than 25% but less than 50%.

Remodeling C Gross: 26 – 50 Required restoration is more than 50% but less than 75%.

Demolition or Termination: 01 – 25 Required restorations are more than 75% of the building and building should probably be demolished.

DATA VALUE RANGE: 001-100, 999; 999=Null

FIELD LENGTH: 3

ENTRY EXAMPLE: 065 (represents an aggregate point total of 65)

WHERE USED (File): BLDG.TRANS

4.1

5.1

SBTCE DATA DICTIONARY BLDG_COST

ELEMENT TITLE: Original Building Cost

DEFINITION: The total original cost of the building to the institution. Include the cost of connecting utilities, foundations, and fixed equipment. Report to the nearest thousand dollars the original plant fund investment for this building.

DATA VALUE RANGE: 00000000001-99999999998

FIELD LENGTH: 11

ENTRY EXAMPLE: 00000125000 (represents $125,000)

6.1

SBTCE DATA DICTIONARY BLDG_IDENT

DATE LAST REVISED: 11/12/93

ELEMENT TITLE: Building Identifier

DEFINITION: The serial number, assigned by the institution, that serves to uniquely identify the building. These numbers should be consistent with those reported to the State Permanent Improvement Reporting System (SPIRS) maintained by the Division of General Services.

NOTE: The Building Identifier (i.e. 000100) must be the same for the TAPE.COURSE and

TAPE.FACIL files for any buildings owned or leased by the reporting institution. In other words, a Building Identifier found in the TAPE.COURSE file will be validated against the TAPE.FACIL file.

NOTE: If the TBA code is specified in the DAY_WEEK field of the Day/Time Meeting

Data Record for the TAPE.COURSE file, the corresponding Start Time, End Time, Building Identifier, and Room Identifier fields must be null.

NOTE: All Day/Time Meeting Data Records for the TAPE.COURSE file must contain a valid Site Identifier.

NOTE: The null value is only appropriate for courses where the DAY_WEEK field is equal to 'TBA'.

The null value is not appropriate for facilities.

DATA VALUE RANGE: Institutionally Defined (i.e. any combination of letters or numbers). NOTE: Spaces allowed between words.

ENTRY EXAMPLE: 100555

WHERE USED (File): BLDG.TRANS, ROOM.TRANS, COURSE.MEETING

WHERE USED (Tape): TAPE.FACIL, TAPE.PCEXP, TAPE.COURSE

7.1

SBTCE DATA DICTIONARY BLDG_NAME

ELEMENT TITLE: Building Name

DEFINITION: The name commonly given to the building. Usually the current institutional name for the facility assigned by institutional authorities .

numbers). NOTE: Spaces allowed between words.

FIELD LENGTH: 30

ENTRY EXAMPLE: Russell Hall

7.2

SBTCE DATA DICTIONARY CAMPUS-

ID

DATE CREATED: 11/13/01

ELEMENT TITLE: Campus Identifier

SUPPLIED BY:

DEFINITION: This field is no longer used. The Site Identification field will be used to determine a college campus.

REQURIEMENT TYPE:

DATA VALUE RANGE:

FIELD LENGTH:

FIELD TYPE:

ENTRY EXAMPLE:

WHERE USED (FILE):

7.2

SBTCE DATA DICTIONARY CERT_LIC

DATE CREATED: 5/24/99

ELEMENT TITLE: Certification/Licensure

SUPPLIED BY: Not required by the Technical Colleges.

DEFINITION: The code that identifies students in the enrollment and completions data who are education or non-education majors with an education option leading to initial certification/licensure.

NOTE: Not required by the Technical Colleges.

N = not applicable

DATA VALUE RANGE: N

ENTRY EXAMPLE: N (Not required by the Technical Colleges)

WHERE USED (File):

WHERE USED (Tape): TAPE.STUDENTE, TAPE.STUDENTC

8.1

SBTCE DATA DICTIONARY CITIZENSHIP

ELEMENT TITLE: Citizenship

DEFINITION: The code that indicates the country of the student's citizenship. NOTE:

If a student is a citizen of more than one country, the institution must report only one of the citizenships.

If the student's citizenship cannot be determined or is not available, the "XX"

UNKNOWN code may be reported. Institutions will be provided with a report indicating the number of "XX" UNKNOWN codes reported for this field.

See Appendix B, FIPS Country codes.

Note: U.S. possessions, protectorates, and territories should be treated as states and thus coded US. Includes American Samoa, Northern Mariana Islands, Baker Island, Guam, Howland Island, Johnston Atoll, Kingman Reef, Midway Islands, Puerto Rico, Virgin Islands, Wake Island, Navassa Island, Jarvis Island, Palmyra Atoll, and the

Trust Territory of the Pacific Islands.

DATA VALUE RANGE: See Appendix B, FIPS Country codes

ENTRY EXAMPLE: US (represents an United States citizen)

WHERE USED (File): STUDENT.STATIC, STUDENT.CHAR

WHERE USED (Table): TBL.COUNTRY

9.1

SBTCE DATA DICTIONARY CONST_YEAR

DATE LAST REVISED: 6/17/94

ELEMENT TITLE: Year of Construction

DEFINITION: The year the construction of the building was completed.

NOTE: If LMR_YEAR is not Null (9999), LMR_YEAR must be greater than CONST_YEAR.

DATA VALUE RANGE: Valid Year

FORMAT: YYYY Year

FIELD LENGTH: 4

ENTRY EXAMPLE: 1960

10.1

SBTCE DATA DICTIONARY CONT_HOURS

DATE LAST REVISED: 07/22/02

ELEMENT TITLE: Contact Hours per Week

DEFINITION: The number of hours this section/course is scheduled to meet within a specified time period. A standard contact hour equals 50 minutes.

NOTE: This data element should contain actual contact hours as determined by the institution.

NOTE: Remedial courses such as English 100, Math 100, or Developmental courses such as Math 050, English 040 or Reading 030 etc. should be reported at full contact hours.

NOTE: TECH ED STUDENT: The CONT_HOURS MUST EQUAL TO (LEC_CONT + LAB_CONT) from the student enrollment record.

As of summer 2002, The CONT_HOURS is no longer required for Continuing Education

Records. Continuing Education will use the CONTACT_HOUR file to capture the contact hours for the course.

REQUIREMENT TYPE: Mandatory – Null Allowed for Continuing Education Only

DATA VALUE RANGE: 0001-9999;

FIELD LENGTH: 4 (with 2 implied decimals)

ENTRY EXAMPLE: 0300 (implies 3.00 contact hours)

WHERE USED (File): COURSE.STATIC

WHERE USED (Tape): TAPE.COURSE

10.2

SBTCE DATA DICTIONARY CONTACT_HOURS

DATE CREATED: 7/22/02

DATE LAST REVISED: 07/29/02

ELEMENT TITLE: Contact Hours per course for Continuing Education

DEFINITION: The total number of hours a student will receive from a continuing education course.

NOTE: This data element should contain actual contact hours as determined by the

As of summer 2002, The CONT_HOURS field is no longer required for Continuing

Education Records. Continuing Education will use the CONTACT_HOUR field to capture the contact hours for the course. This field will be reported as a nulls for teched courses.

REQUIREMENT TYPE: Mandatory – Null Allowed for Technical Education Only

DATA VALUE RANGE: 000001-999999;

FIELD LENGTH: 6 (with 2 implied decimals)

ENTRY EXAMPLE: 001300 (implies 13.00 contact hours)

10.2

SBTCE DATA DICTIONARY CONTRACT_TRM

DATE CREATED: 11/18/98

DATE LAST REVISED: 08/15/00

ELEMENT TITLE: SBTCE Faculty Contract Terms

DEFINITION: Full-time faculty members at the technical colleges are hired based on a workload stated in either contract hours or credit hours.

This will only be used in the calculation to report data for Performance

Indicator 3-B for the Technical Colleges.

1 = Credit Hours

2 = Contact Hours

9 = Null Value

Note: A null value is only valid for a part-time instructor.

REQUIREMENT TYPE: Mandatory – Null Allowed

DATA VALUE RANGE: 1,2, Null = 9

ENTRY EXAMPLE: 1 represents a faculty member whose workload has been contracted on the basis of credit hours.

10.3

SBTCE DATA DICTIONARY COST_ATTEND

DATE CREATED: 2/14/00

DATE LAST REVISED: 01/18/01

ELEMENT TITLE: Cost of Attendance

SUPPLIED BY: Not a reported field for the Technical Colleges

DEFINITION: The student's cost-of-attendance is the total amount estimated that will cost the student to attend during a period of enrollment. The financial offices at the school the student is attending are responsible for calculating the student's cost based on formulas specified by Title IV Regulations. The cost-of-attendance by include such components as tuition and fees, room (can not exceed the average cost for on campus) and board (can not exceed the least expensive 21 meals per week plan, transportation costs, and dependent care expenses.

This is to be reported for only those students receiving Palmetto Fellows scholarships.

The amount reported in the Cost of Attendance data field can be for an Academic Year or a term (i.e., Semester). The period is designated in the data field, CST_PER, described on page 10.4

When the award amount is for a credit, cost of attendance is to be reported as

999999.

Scholarship/Grant Types for Cost of Attendance:

Palmetto Fellows – Required to be reported unless a credit, then report as

999999.

LIFE – Report as 999999

Need-based – Report as 999999

DATA VALUE RANGE: 999999 = Null

ENTRY EXAMPLE: 999999

SBTCE DATA DICTIONARY COST_PER

DATE CREATED: 01/18/02

ELEMENT TITLE: Cost of Attendance Reporting Period

DEFINITION: The time period that defines the amount reported as the student’s cost-of-attendance.

A = Academic Year

T – Term (i.e., Semester)

9 – Not Applicable

When the award amount is for a credit, cost of attendance reporting period is to be reported as 9.

DATA VALUE RANGE: A, T, 9=Null/Not Applicable

11.1

SBTCE DATA DICTIONARY COUNTY_ID

ELEMENT TITLE: Geographic Origin / County Identifier

DEFINITION: A code for the county of South Carolina in which the student resided at the time of the first admission to the institution. This data element is for in-state students only. NOTE: Out-of-state students will be reported with the "96" code. Foreign students will be reported with the "97" code.

South Carolina students for which the county identifier is unknown will be reported with the "98" code.

See Appendix E, South Carolina County codes.

DATA VALUE RANGE: See Appendix E, South Carolina County codes

ENTRY EXAMPLE: 01 (represents Abbeville county)

WHERE USED (File): STUDENT.STATIC, BLDG.TRANS, COURSE.MEETING

WHERE USED (Table): TBL.SITE

12.1

SBTCE DATA DICTIONARY COUR_CREDIT

ELEMENT TITLE: Course Credit Hours

DEFINITION: The numerical credit value offered for the course\section.

NOTE: This data element should contain actual credit hours as determined by the

NOTE: Remedial courses such as English 100, Math 100, or Developmental courses such as Math 050, English 040 or Reading 030 etc. should be reported at full contact

DATA VALUE RANGE: 0000-9998

NOTE: 0000 may be valid for certain courses such as laboratories, dissertations, and theses. The 9999 code, Null, is not allowed for Remedial or Developmental courses

(COUR_LEVEL = 1).

ENTRY EXAMPLE: 0300 (implies 3.00 course credit hours)

WHERE USED (File): COURSE.ENROLL

13.1

SBTCE DATA DICTIONARY COUR_ENROLL

DATE LAST REVISED: 6/05/96

ELEMENT TITLE: Course Enrollment

DEFINITION: The total number of students enrolled in the course/section for a specific Enrollment Type (e.g. Lower Division) AND for a specific Course Credit.

NOTE: Students auditing a course/section should be excluded from the COUR_ENROLL field.

NOTE: Students taking a course/section under the South Carolina statute 59-111-15, "Tuition assistance for permanent faculty and staff", should be included in the

COUR_ENROLL field.

NOTE: The Course Enrollment can not exceed the Number of Stations for a specific

Course/Section and Room. (Warning only)

DATA VALUE RANGE: 0001-9998

ENTRY EXAMPLE: 0100 (represents 100 students enrolled)

WHERE USED (File): COURSE.ENROLL

14.1

SBTCE DATA DICTIONARY COUR_LEVEL

DATE LAST REVISED: 8/23/01

ELEMENT TITLE: Course Teaching Level Identifier

DEFINITION: Indicates the teaching level of the course/section offering. This code is institutionally determined and each course/section must be assigned to a particular level prior to enrollment considerations.

1 = Remedial

2 = Lower Division

7 = Continuing Education Courses

See following page for category descriptions

REQUIREMENT TYPE: Mandatory - Null allowed for continuing education only

DATA VALUE RANGE: 1-2, 8

ENTRY EXAMPLE: 1 (represents a Remedial teaching level)

14.1

Remedial (IPEDS): Instructional activities designed for students deficient in the general competencies necessary for a regular postsecondary curriculum and educational setting.

Remedial (SBTCE): Deliberately planned and structured activities and courses in mathematics, writing, and reading directed toward specific areas of student under preparation or inability which are not characteristic of all or most of the students in the institution, which are systematic in their approach, and which are directed toward improvement of student performance.

Lower Division: Courses offered for credit toward the first and second year of an undergraduate degree program, an associate's degree program, or a technical or vocational degree below the baccalaureate.

Courses numbered in the 100-299 range which are typically perceived as freshmen or sophomore level courses by the reporting institution, or courses applicable towards an associates degree.

Continuing Education: Courses numbered in the 500-999 range which are typically perceived as non-traditional courses by the reporting institution. Continuing

Education courses will not be reported to CHE.

15.1

SBTCE DATA DICTIONARY COURSE-GRADE

DATE CREATED: 03/31/92

DATE LAST REVISED: 08/11/01

ELEMENT TITLE: Course Grade

DEFINITION: This field is used in the Student Master record for each continuing education and technical education record to record the grade the student received for the course.

The grade field is validated only in the ending data.

Refer to appendix S for a list of valid grades.

REQURIEMENT TYPE: Mandatory - Null Not Allowed

ENTRY EXAMPLE: See appendix S

WHERE USED (FILE): SBTCE Student Enrollment (EA and EB Record)

15.1

SBTCE DATA DICTIONARY COURSE_NBR

DATE LAST REVISED: 9/18/91

ELEMENT TITLE: Course Number

DEFINITION: Code, which uniquely identifies the course/section at the reporting institution from among similar subject area offerings. For example, 101 (as in ENGL

101).

No Technical Education Course number will exceed 299. All continuing Education

Course Numbers must be greater than 499.

numbers).

FIELD LENGTH: 5

ENTRY EXAMPLE: 100 (represents a course number of 100)

WHERE USED (File): COURSE.STATIC, COURSE.ENROLL, COURSE.INSTRUCT, COURSE.MEETING

16.1

SBTCE DATA DICTIONARY COURSE-SESSION

DATE LAST REVISED: 11/13/01

ELEMENT TITLE: Course Session

DEFINITION: Represents institutions where mini-terms are running concurrently with the regular semester. If your institution does not offer mini-terms in conjunction with semester academic period that occurs in the same time period, this field can be loaded with blanks.

When multiple mini-terms and semesters occur in the same time period, the session field is used to indicate a specific academic period. For example, if an institution is running a sixteen-week semester and also has two eight-week mini-terms running concurrently, a unique session identifier will be assigned to each of these three academic periods. The diagram below illustrates the staggered layout of these academic periods:

| session = 001 |

| 16 week semester |

| session=002 | session=003 |

| 8 week | 8 week |

| mini-term | mini-term |

The session code is important when a student takes the same course twice within the same term. If the institution is only using a single semester session to accomplish the course offerings, the student is not eligible for funding on both occurrences of the course. However, if the student takes a course in the first 8-week mini-term, then takes the same course again in the second 8-week term, that student is fundable for both occurrences of the course. The use of the session field communicates the fact that the same occurrence of the course within the same term actually occurred in two distinct academics periods within the term.

If multiple sessions within a term are used at the institution, it should be loaded into this field. The values for this field are institutionally defined.

If the session is not used at the institution, this field should be loaded with spaces.

REQURIEMENT TYPE: Mandatory - Null Not Allowed for Technical Education Students.

DATA VALUE RANGE: 01 - 03

WHERE USED (FILE): SBTCE Student Enrollment (EA Record)

SBTCE DATA DICTIONARY COURSE_SYMBL

DATE LAST REVISED: 6/01/92

ELEMENT TITLE: Course Symbol

DEFINITION: Department or indication of area of study associated with the course/section at the reporting institution. For example, ENGL (for English), SOC

(for Sociology), RUSS (for Russian).

numbers).

FIELD LENGTH: 5

ENTRY EXAMPLE: ENGL (represents a symbol for English courses)

16.3

SBTCE DATA DICTIONARY CRED_HR_EARN

DATE LAST REVISED: 11/04/97

ELEMENT TITLE: Credit Hours Earned

SUPPLIED BY: Not Required by the Technical Colleges

DEFINITION: The total credit hours earned by the student upon awarding the degree.

Any college credits earned while in high school or any credit given toward developmental courses would be excluded. Students that were first-time entering freshmen, thus excluding transfers-in, at the awarding institution would be included. This will be reported on an annual basis on the completions record for the student and pertains only to undergraduate students only.

Time frame for implementation: Fall 96, Spring 97, and Summer 97 data for those students indicated will either be included in the completions data in the Fall of

1997 or submitted separately in January 1998. Thereafter, the data will be submitted as a part of the completions data.

NOTE: Not Required by the Technical Colleges

DATA VALUE RANGE: 00001 - 99998, 99999-Null

FIELD LENGTH: 5 (with 2 implied decimals)

ENTRY EXAMPLE: 12550 (implies 125.50 credit hours required)

16.5

SBTCE DATA DICTIONARY CRED_HR_REQ

DATE LAST REVISED: 11/04/97

ELEMENT TITLE: Credit Hours Required

DEFINITION: The total credit hours required to be awarded a degree in the enrolled program of the student.

This data is to be reported on students that were reported as first-time entering freshmen, thus excluding transfers-in, at the awarding institution. This will be reported on an annual basis on the completions record for the student and pertains only to undergraduate students.

NOTE: Not required by the Technical Colleges

Note: Please see page 16.3, credit hours earned, for implementation time frame.

DATA VALUE RANGE: 00001 - 99998, 99999-Null

ENTRY EXAMPLE: 13500 (implies 135.00 credit hours required)

17.1

SBTCE DATA DICTIONARY CREDIT_HRS

DATE LAST REVISED: 2/09/94

ELEMENT TITLE: Credit Hours Enrolled

DEFINITION: The total credit hours attempted by the student this semester at the reporting institution. Including remedial credit hours and excluding audited hours.

Continuing Education will report zeros in the credit hours enrolled.

DATA VALUE RANGE: 0000-9998

ENTRY EXAMPLE: 1250 (implies 12.5 credit hours enrolled)

WHERE USED (File): STUDENT.TRANS

18.1

SBTCE DATA DICTIONARY CREDT_TYPE

DATE CREATED: 9/18/91

ELEMENT TITLE: Credit Type Code

DEFINITION: Code designating whether or not all the students enrolled in a particular course/section will receive the same Course Credit.

F = Fixed

V = Variable

Note: Note used by SBTCE

REQUIREMENT TYPE: Calculated

DATA VALUE RANGE: F or V

ENTRY EXAMPLE: F (represents a Fixed credit type)

19.1

SBTCE DATA DICTIONARY CUMUL_GPA

DATE LAST REVISED: 8/19/91

ELEMENT TITLE: Cumulative GPA

DEFINITION: Cumulative Grade Point Average (GPA) at the reporting institution, computed from all courses completed since enrolling at the institution. Based on a four-point system.

REQUIREMENT TYPE: Mandatory - Null Allowed for Continuing education only.

DATA VALUE RANGE: 000-400

FIELD LENGTH: 3 (with 2 implied decimals)

ENTRY EXAMPLE: 400 (implies a cumulative GPA of 4.00)

20.1

SBTCE DATA DICTIONARY CUMUL_HRS

DATE CREATED: 7/19/91

DATE LAST REVISED: 10/14/93

ELEMENT TITLE: Cumulative Credit Hours

DEFINITION: Cumulative credit hours earned at the reporting institution.

NOTE: This field should not contain the attempted credit hours (CREDIT_HRS) for the current reporting semester. The CUMUL_HRS field should only contain the earned credit hours at the reporting institution as of the matriculation or freeze date.

REQUIREMENT TYPE: Mandatory - Null Allowed for Continuing Education Only.

DATA VALUE RANGE: 00000-99998

ENTRY EXAMPLE: 12550 (implies 125.5 cumulative credit hours)

21.1

SBTCE DATA DICTIONARY DATA_TYPE

DATE CREATED: 4/20/92

ELEMENT TITLE: Data Type

DEFINITION: Designates a subset of data elements within a specified record type

(REC_TYPE). NOTE: Certain data types may occur multiple times within a given record type.

CODES, CATEGORIES, COMMENTS:

For REC_TYPE = 'A'

Occurrences in Record Type

B = Building 1

R = Room 1 or more

For REC_TYPE = 'C' (Tech Ed. Only) 'A' (Continuing ED. Only)

S = Static 1

E = Enrollment 1 or more

I = Instructor 1 or more

M = Day/Time Mtg 1 or more

For REC_TYPE = 'E'

E = Enrollment Demographics 1

T = Transfer 0 or 1

S = SBTCE Enrollment Goals 1

A = SBTCE Course Enrollment 1 or more

P = SBTCE Perkins 0 or 1

F = Enrollment CE Demographics 1

C = SBTCE Continuing Educations Goals 1

B = SBTCE Continuing Education Course 1 or more

21.1

DATA VALUE RANGE: For REC_TYPE = 'A':

B, R

For REC_TYPE = 'C':

S, E, I, M

For REC_TYPE = 'E':

E, T, S, C, A, B, P

ENTRY EXAMPLE: B (represents a Building Data Record)

WHERE USED (Tape): TAPE.FACIL, TAPE.COURSE, TAPE.STUDENTE, TAPE.STUDENTC

21.2

SBTCE DATA DICTIONARY

DATE_TERM

DATE CREATED: 05/03/99

DATE LAST REVISED: 05/03/99

ELEMENT TITLE: Date of Termination

DEFINITION: The date an employee is terminated.

This data will be used to include or exclude a faculty member for reporting

IPEDS Salaries Data.

REQUIREMENT TYPE: Mandatory, Null Allowed

DATA VALUE RANGE: Valid date, 999999999 = Null

FORMAT: YYYMMDD

ENTRY EXAMPLE: 19991001 (year, month, day)

22.1

SBTCE DATA DICTIONARY DAY_WEEK

DATE LAST REVISED: 11/12/93

ELEMENT TITLE: Days of the Week

DEFINITION: The day(s) of the week this course/section is scheduled to meet.

Each day of the week will be coded as follows: M Monday; T Tuesday; W Wednesday; R

Thursday; F Friday; S Saturday; and U Sunday. Combinations of the above codes will be used to designate multiple meeting days (e.g. MWU for Monday, Wednesday, Sunday).

NOTE: When using combinations, the order of the codes will always begin with

Monday and end with Sunday AND will not contain spaces between the codes.

Similarly, a letter can not be used twice in the same code.

If a course/section does not have a set specified meeting day(s), TBA (To be

Announced) should be used.

M = Monday F = Friday

T = Tuesday S = Saturday

W = Wednesday U = Sunday

R = Thursday

Any combination of the above codes not to exceed the field length (i.e. MTWRFSU)

EOS = Every Other Saturday

NOTE: This code is to be used when a course/section meets every other Saturday.

This code was developed in conjunction with the needs of the University of South

Carolina, which may assist other institutions also.

TBA = To Be Announced

22.1

DATA VALUE RANGE: Any combination of MTWRFSU; TBA

ENTRY EXAMPLE: TR (represents a course taught on Tuesday and Thursday)

WHERE USED (File): STUDENT COURSE FILE (CM AND AM RECORD)

23.1

SBTCE DATA DICTIONARY DEG_LEVEL

DATE LAST REVISED: 08/01/02

ELEMENT TITLE: Degree Level

DEFINITION:

Enrollment: A code, which indicates a student's enrollment in a specific type of post-secondary program.

Completions: The award conferred upon the student by the institution for the successful completion of a given curriculum or program.

01 = Certificate < one year

02 = One year but < two year certificate

03 = Two year but < four year certificate

04 = Associate I creditable

14 = Non-degree seeking, Also used for Continuing Education Students

Code 13 Other, is no longer valid as of 2-25-93.

Codes 01 through 04 represent degree-seeking classifications. Degree seeking is defined as students enrolled in courses for credit that have been recognized by the institution as seeking a degree or formal award. At the undergraduate level, this is intended to include students enrolled in vocational or occupational programs.

Codes 01, 02, and 03 with their associated Program Codes do not require approval by the Commission for the technical colleges and therefore are validated against

Appendix D, IPEDS\SBTCE CIP Codes versus Appendix K, SBTCE State Program Codes.

Enrollment: Codes 01 through 04 and Code 14 must be accompanied by an approved

Program Code/Program Suffix for the reporting institution.

Note: The following correlation applies to the Student Level and the Degree Level data elements.

Tech Education Student Only:

If DEG_LEVEL = 01,02,03,04 Then STU_LEVEL must be 01 or 02

If DEG_LEVEL = 14 Then STU_LEVEL must be 05

Continuing Education Students Only:

If DEG_LEVEL = 14 STU_LEVEL must be 99

Completions: Code 14 is not valid for completion records.

DATA VALUE RANGE: 01-04,14 NOTE: The valid DEG_LEVEL of '14' is not appropriate for completion records.

ENTRY EXAMPLE: 01 (represents a Certificate <one-year)

WHERE USED (File): STUDENT.TRANS, STUDENT.COMPL

Certificate, Less Than One Year: Requires completion of an organized program of study at the postsecondary level in less than one full time equivalent academic years or designed for completion in less than 30 credit hours, or in less than 900 contact hours.

Certificate, One Year But Less Than Two Years: Requires completion of an organized program of study at the postsecondary level in at least one, but less than two full time equivalent academic years, or designed for completion in at least 30, but less than 60 credit hours, or in at least 900 but less than 1,800 contact hours.

Certificate, Two Years But Less than Four Years: Requires completion of an organized program of study at the postsecondary level in at least two but less than four full time equivalent academic years; or designed for completion in at least 60, but less than 120 credit hours, or in at least 1,800 but less than 3,600 contact

Associate I, Creditable: An award that normally requires at least two, but less than four years of full time equivalent college work that can be used as a credit towards the award of a four-year degree.

Non-degree seeking: Students enrolled in courses for credit that have not been recognized by the institution as seeking a degree or formal award. At the undergraduate level, this is not intended to include students enrolled in vocational or Occupational programs.

23.5

SBTCE DATA DICTIONARY DEGREE

DATE CREATED: 10/18/94

DATE LAST REVISED: 01/10/96

ELEMENT TITLE: Degree

DEFINITION: An award conferred by a college, university, or other postsecondary education institution as official recognition for the successful completion of a program of studies.

DATA VALUE RANGE: Valid Degrees as defined in the SBTCE Academic Affairs Program

Inventory or a valid Continuing Education Codes, eg. 006200.

WHERE USED (File): STUDENT.COMPL , STUDENT.SBTCE.ENROLLMENT

23.8

SBTCE DATA DICTIONARY DELETE_FLG

DATE CREATED: 11/25/92

ELEMENT TITLE: Delete Flag

DEFINITION: Indicates whether a record within a Work File has been deleted or not.

A record will be deleted from the Work Files once the record has been successfully loaded into the SBTCE database.

Y = Yes

N = No

NOTE: Not used by SBTCE

DATA VALUE RANGE: Y,N

ENTRY EXAMPLE: Y

WHERE USED (File): WORK.BLDG, WORK.ROOM, WORK.PCEXP, WORK.COURSE, WORK.ENROLL, WORK.INSTRUCT, WORK.MEETING, WORK.STUDENT, WORK.TRANSFER, WORK.MAJOR, WORK.COMPL, WORK.IDENTIFIER

24.1

SBTCE DATA DICTIONARY DISAB_ACCS

DATE LAST REVISED: 8/04/94

ELEMENT TITLE: Disabled Access

DEFINITION: Indicates whether the room is barrier-free for its assigned use, normally through a simple notation for accessibility. A room is accessible if it can be reached without assistance from immediately outside of the building by a person in a wheel chair and if it has at least one accessible station. Further, for a room to be accessible, the building itself must have at least one accessible restroom.

Y = Yes

N = No

DATA VALUE RANGE: Y,N

ENTRY EXAMPLE: Y

25.1

SBTCE DATA DICTIONARY DISP_HM

DATE CREATED: 12/12/00

ELEMENT TITLE: Displaced Homemaker

DEFINITION: Represents a) an individual who has worked primarily without remuneration to care for a home or family, or b) has been dependent on the income of another family member but no longer supported by that income, or c) a parent whose youngest dependent child will become ineligible to receive assistance under Part A of Title IV of the Social Security Act not later than two (2) years after the date on which the parent applies for assistance under this title, or d) is unemployed or underemployed and is experiencing difficulty in obtaining or upgrading employment.

REQURIEMENT TYPE: Mandatory - Null Allowed

DATA VALUE RANGE: Y, N, 9

WHERE USED (FILE): SBTCE Student Enrollment (EP record)

SBTCE DATA DICTIONARY DIST_LEARN

DATE CREATED: 7/26/91

DATE LAST REVISED: 8/14/2019

ELEMENT TITLE: Distance Learning Code

DEFINITION: A code, which indicates whether, or not a course/section is transmitted electronically to the receiver site, including videocassettes.

1) Course delivered over the Internet

2) Course delivered through special high-cost facilities for site-to-site two-way audio-video (compress video)

3) Course delivered via satellite, cable TV, broadcast TV/radio, closed-circuit, video tape, CD ROMS

4) Correspondence Course

N) Course is considered delivered through “Traditional” Instruction, significant site attendance is required

Y) This is a distance education class and indicates whether or not a course/section is transmitted electronically to the receiver site, including video cassettes.

As of Fall 2007 “Y” is no longer a valid code.

Valid codes are “N”,1, 2, 3 and 4.

NOTE: Site Identifier 85000 should be used to designate Distance Education Receiver

Sites that are Unknown. This code is only valid for Day/Time Meeting Data Records in the TAPE.COURSE file.

If the SITE_IDENT = 85000, then DIST_LEARN must = Y

As of Fall 2007 “Y” is no longer a valid code. Valid codes are 1, 2, 3 and 4.

“N” is not allowed for 85000.

For Continuing Education courses only, the valid values are “Y” or “N”.

DATA VALUE RANGE: N, 1, 2, 3, 4

ENTRY EXAMPLE: N

25.2

SBTCE DATA DICTIONARY ECON_DIS

ELEMENT TITLE: Economically Disadvantaged

DEFINITION: Represents an individuals from economically disadvantaged families, including foster children.

WHERE USED (FILE): SBTCE Student Enrollment (EP Record)

25.2

SBTCE DATA DICTIONARY EMP_STATUS

DATE LAST REVISED: 04/02/97

ELEMENT TITLE: Employee Status

DEFINITION: Current employment status - full or part-time.

1 = Full-time

2 = Part-time

REQUIREMENT TYPE: Mandatory - Null NOT Allowed

DATA VALUE RANGE: 1 or 2

ENTRY EXAMPLE: 1 represents Full time employee

26.1

SBTCE DATA DICTIONARY

EMPLOY_ID

DATE LAST REVISED: 08/04/97

ELEMENT TITLE: Faculty Identifier

DEFINITION: The official number that serves to uniquely identify the Faculty.

Use the Faculty's social security number where available. Otherwise, the institution will assign a unique nine-digit number (State Identifier number) according to the following format:

Digits 1-3: SBTCE Institutional prefix: see Appendix J, SBTCE Institutional prefixes

Digits 4-9: Sequential number assigned by the institution; Range: 000000-999999

NOTE: Once an instructor is reported with either a Social Security Number or a

State Identifier number, they MUST continue to be reported with that same identification number for the duration of their teaching career within South

Carolina institutions. This includes all situations where the instructor's identification number may change such as attaining US citizenship.

NOTE: When an instructor is hired by another South Carolina institution, it will be the responsibility of the "hiring" institution to review the instructors records to determine if the instructor was assigned a State Identifier number at a previous South Carolina institution. If so, the "hiring" institution MUST report the previously assigned State Identifier number.

To facilitate this instructor identification scheme, the SBTCE recommends that institutions provide either the Social Security number or the State Identifier number in the instructor's employment records. The State Identifier number will typically only apply to foreign instructors.

REQUIREMENT TYPE: Mandatory - Null NOT Allowed

DATA VALUE RANGE: 000000001-899999999 (Social Security Number)

FIELD LENGTH: 9

ENTRY EXAMPLE: 212334545 represent the Social Security Number of 212-33-4545

SBTCE DATA DICTIONARY END_DATE

DATE CREATED: 9/18/91

DATE LAST REVISED: 9/24/93

ELEMENT TITLE: Ending Date

DEFINITION: The calendar date on which the course/section ends.

DATA VALUE RANGE: Valid Date

FORMAT: YYYYMMDD, Year Month Day

ENTRY EXAMPLE: 19911231 (represents December 31, 1991)

27.1

SBTCE DATA DICTIONARY END_TIME

DATE LAST REVISED: 06/05/96

ELEMENT TITLE: Ending Time

DEFINITION: The time of the day, using a 24-hour clock that the course/section ends.

Example: 1600 = 4:00 p.m. If a course/section does not have a set specified ending time (such as an independent study or a dissertation), then the ending time should be reported as a null AND the Days of the Week code must be TBA (to be announced).

NOTE: The Starting Time can not be greater than or equal to the corresponding

Ending Time.

NOTE: The absolute difference between the Starting Time and the corresponding

Ending Time can not be greater than 10 hours.

(Warning Only)

NOTE: The null value is only appropriate for courses where the DAY_WEEK field is equal to 'TBA'.

DATA VALUE RANGE: 0001-2400, 9999; 9999=Null

FIELD LENGTH: 4

ENTRY EXAMPLE: 1600 (represents 4:00 pm)

WHERE USED (File): COURSE.MEETING

28.1

SBTCE DATA DICTIONARY ENROLL_STAT

DATE LAST REVISED: 12/04/92

ELEMENT TITLE: Enrollment Status

DEFINITION: The student's current enrollment status - full or part-time.

1 = Full-time

2 = Part-time

9 = Continuing education Students Only

See following page for category descriptions.

REQUIREMENT TYPE: Mandatory - Null Allowed for Continuing Education Only.

DATA VALUE RANGE: 1-2, 9

ENTRY EXAMPLE: 1 (represents a Full-time student)

28.1

Full-time: For undergraduates; a full-time student is a student enrolled for twelve or more semester's credit.

Part-time: For undergraduate students; a part-time student is a student enrolled for eleven or fewer semester credits..

NOTE: The above IPEDS definitions apply only to Fall and Spring semesters. For summer sessions, institutions will define their own credit hour limits in determining the full-time or part-time classification.

30.1

SBTCE DATA DICTIONARY ENROLL_TYPE

DATE CREATED: 4/01/92

DATE LAST REVISED: 4/13/94

ELEMENT TITLE: Enrollment Type

DEFINITION: Indicates the broad categorization of students based on their progress toward a degree or certificate. There may be multiple enrollment types for a particular course/section (i.e. Lower and Upper division students taking the same class).

NOTE: This field is a summarized version of the Student Level field. For example, the "Freshman" and "Sophomore" Student Levels are grouped together under the

Enrollment Type of "Lower Division".

Refer to the following page for additional definitions of the specified codes.

1 = Lower Division

9 = Continuing Education

REQUIREMENT TYPE: Mandatory - Null Allowed for Continuing Education Only

DATA VALUE RANGE: 1,9

ENTRY EXAMPLE: 1 (represents a Lower Division enrollment type

WHERE USED (File): COURSE.ENROLL

When aggregating Course data, use the following definitions to categorize the individual students.

Lower Division: Students enrolled at the Freshman or Sophomore level. (STU_LEVEL of 01 or 02).

30.1

SBTCE DATA DICTIONARY ENTRY_SEM

DATE CREATED: 1/10/92

DATE LAST REVISED: 9/28/93

ELEMENT TITLE: Semester Student Entered the System

DEFINITION: Indicates the first semester that the student entered the SBTCE database.

05 = Summer II July 1 - July 31

10 = Fall August 1 - December 31

20 = Spring January 1 - April 30

30 = Summer I May 1 - June 30

REQUIREMENT TYPE: SBTCE Generated

DATA VALUE RANGE: 05,10,20,30

ENTRY EXAMPLE: 20 (represents the Spring semester)

31.1

SBTCE DATA DICTIONARY ENTRY_YEAR

ELEMENT TITLE: Year Student Entered the System

DEFINITION: Indicates the first year that the student entered the SBTCE database.

NOTE: Not used by SBTCE

REQUIREMENT TYPE: SBTCE Generated

DATA VALUE RANGE: Valid Year

ENTRY EXAMPLE: 1992

32.1

SBTCE DATA DICTIONARY EXP_DEFER

DATE LAST REVISED: 6/09/92

ELEMENT TITLE: Deferred Maintenance Expenditures

SUPPLIED BY: Institution / Commission on Higher Education

DEFINITION: The amount identified by the institution that was spent to address deferred maintenance needs in a given year. This should include only projects, which reduce needs, identified in the institution's Building Quality Survey.

NOTE: This data element will be requested from the institutions after each fiscal year via a written survey. The Facilities division of the CHE will be responsible for entering this information into the CHE database.

DATA VALUE RANGE: 00000000000-99999999998

WHERE USED (Tape): TAPE.PCEXP

32.2

SBTCE DATA DICTIONARY EXP_FAM_CONT

DATE LAST REVISED: 01/18/02

ELEMENT TITLE: Expected Family Contributions

DEFINITION: The Expected Family Contributions (EFC) is a measure of how much the student and his or her family can be expected to contribute to the cost of the student's education. The EFC is calculated using information provided on the Free

Application for Federal Student Aid (FAFSA) and according to the formula specified by Title IV Regulations. The EFC is calculated by using one of three formulas:

Worksheet A is for dependent students, Worksheet B is for independent students without dependents other than spouse, and Worksheet C is for independent students with dependents other than spouse.

NOTE: This data is to be reported only for those students receiving a need based scholarship.

The amount reported in the Expected Family Contribution data field can be for an

Academic Year or a Term (i.e., Semester). The period reported is designated in the data field, EXP_PER, described on page 32.3

When the award amount is for a credit, Expected Family Contribution is to be reported as 999999.

Scholarship/Grant Types for Expected Family Contribution:

Palmetto Fellows – Report as 999999

Need-based – Required to be reported unless a credit, then report as 999999.

DATA VALUE RANGE: 000001 - 999998; 999999 = Null

ENTRY EXAMPLE: 007000 (represents $7,000 expected family contribution)

32.2

33.1

SBTCE DATA DICTIONARY EXP_PER

ELEMENT TITLE: Expected Family Contribution Reporting Period

DEFINITION: The time period that defines the amount reported as Expected Family

Contribution (EPC).

A - Academic Year

When the award amount is for a credit, Expected Family Contribution reporting period is to be reported as 9.

33.1

SBTCE DATA DICTIONARY EXP_TOTAL

ELEMENT TITLE: Total Expenditures

SUPPLIED BY: Division of General Services / Commission on Higher Education

DEFINITION: The total amount spent on repair, maintenance and renovation through

State Permanent Improvement Projects in existing square footage of a given facility during one fiscal year.

NOTE: This data element will be provided by the Division of General Services project database. It will include all relevant expenditures made to enhance or preserve an existing facility. The Facilities division of the CHE will be responsible for entering this information into the CHE database.

DATA VALUE RANGE: 00000000000-99999999998

WHERE USED (Tape): TAPE.PCEXP

34.1

SBTCE DATA DICTIONARY FILL_1

DATE CREATED: 2/15/92

ELEMENT TITLE: Filler Field

SUPPLIED BY: Not applicable

DEFINITION: This field is not currently being used. The field is included to allow for additional data element(s) at a later date.

NOTE: Allowing for this extra space in the initial design will minimize the impact of future data element additions on the institutions.

REQUIREMENT TYPE: Not applicable

DATA VALUE RANGE: Not applicable

FIELD LENGTH: Dependent on each individual file layout

Refer to the SBTCE File Layouts for applicable field length

ENTRY EXAMPLE: Not applicable

WHERE USED (File): BLDG.TRANS, ROOM.TRANS, COURSE.STATIC, COURSE.ENROLL, COURSE.INSTRUCT, COURSE.MEETING, STUDENT.STATIC, STUDENT.TRANS, STUDENT.TRANSFR, STUDENT.COMPL

WHERE USED (Tape): TAPE.FACIL, TAPE.ROOM, TAPE.COURSE, TAPE.STUDENTE, TAPE.STUDENTC, TAPE.STUDENTI

35.1

SBTCE DATA DICTIONARY FUNC_USE

ELEMENT TITLE: Functional Use

DEFINITION: Identifies the functional use of the room, such as instruction, academic support, administration, or auxiliary enterprise. Coding of a room by function allows inter-institutional comparison of space assigned by function, which is not possible if only the organizational unit name, often unique to an institution, is identified. The functional use taxonomy for this purpose is adopted from NACUBO's

Management Reporting and Accounting for Colleges, Second Edition, 1988.

See Appendix H, Functional Use codes.

NOTE: Additional information is detailed in the revised CHE Facilities Manual.

DATA VALUE RANGE: See Appendix H, Functional Use codes

FIELD LENGTH: 3

ENTRY EXAMPLE: 021 (represents Institutes and Research Centers)

WHERE USED (Table): TBL.FNUSE

36.1

SBTCE DATA DICTIONARY GENDER

ELEMENT TITLE: Gender

DEFINITION: The gender of the student.

F = Female

M = Male

9 = Continuing Education Students Only

REQUIREMENT TYPE: Mandatory - Null Allowed for Continuing Education Students Only.

DATA VALUE RANGE: F,M,9

ENTRY EXAMPLE: F (represents a Female student)

WHERE USED (File): STUDENT.STATIC, STUDENT.CHAR

WHERE USED (Table): TBL.GENDER

36.2

SBTCE DATA DICTIONARY GIFT_AID

ELEMENT TITLE: Gift Aid

SUPPLIED BY: This is not a reportable field for SBTCE.

DEFINITION: Gift aid is any source of funding (federal, state, institutional or private) that does not require the student to repay.

This is to be reported for only those students receiving Palmetto Fellows scholarships.

The amount reported in the Expected Family Contribution data field can be for an

Academic Year or a Term (i.e., Semester). The period reported is designated in the data field, EXP_PER, described on page 36.3

When the award amount is for a credit, Expected Family Contribution is to be reported as 999999.

Scholarship/Grant Types for Expected Family Contribution:

Palmetto Fellows – Report as 999999

Need-based – Required to be reported unless a credit, then report as 999999.

REQUIREMENT TYPE: Mandatory - Null Only

DATA VALUE RANGE: 999999 = Null

ENTRY EXAMPLE: 999999

36.2

37.1

SBTCE DATA DICTIONARY GIFT_PER

ELEMENT TITLE: Gift Aid Reporting Period

DEFINITION: The time period that defines the amount reported as Gift.

A = Academic Year

When the award amount is for a credit Gift Aid reporting period is to be reported as

9.

SBTCE DATA DICTIONARY GOAL_1 AND 2

ELEMENT TITLE: Student Original Goal

DEFINITION: Upon entering the institution, students may choose up to two goals that can be reported through the SBTCE system. The initial goals of the student are to be reported using this field. Note that this field should not be used to report changes in a student's goals. The field called UPD_GOAL should be used to report any changes in a student's goals.

Each goal is two characters code, defined by each SBTCE. The SBTCE Student

Master Record provides two, two byte fields that allows up to two original goals to be reported for each student.

Original goal codes apply to first-time freshman students since they will be loaded into retention cohorts.

DATA VALUE RANGE: Valid original goal code

ENTRY EXAMPLE: C1 - learn new skills to get a new job

WHERE USED (FILE): SBTCE Student Data (ES Record and not reported to

CHE)

SBTCE DATA DICTIONARY GRAD-AWARD-YR-MONTH

DATE CREATED: 08/20/93

DATE LAST REVISED: 07/07/98

ELEMENT TITLE: Graduate Award Year and Month

DEFINITION: This field represents the calendar year and month when the student award was conferred.

Reporting Period: Institutions are to report all degrees, certificates and diplomas earned between September 1 and August 31 of each year.

The Reporting Year and Reporting Semester must coincide with the Graduate award year and month.

DATA VALUE RANGE: Valid Year and Month

ENTRY EXAMPLE: 199905 Represents May of year 1999

200007 Represents July of year 2000

WHERE USED (FILE): Student Completions

SBTCE DATA DICTIONARY GROSS_AREA

DATE LAST REVISED: 11/17/93

ELEMENT TITLE: Gross Area

DEFINITION: The sum of the floor areas of the building included within the outside faces of exterior walls for all stories.