Attachment H.pdf
PDF 114 KB Posted
- Attached to
- ENTERPRISE RESOURCE PLANNING SYSTEM AND State and local contract opportunity
- Solicitation number
- 5400022244
- Issued by
- Charleston County, South Carolina
About this file
This is a data specification document for South Carolina's state college system that defines the file format and field requirements for student enrollment transaction records submitted by institutions. The document establishes standardized data collection protocols across multiple record types, including basic student demographic information (SSN, birth date, gender, race/ethnicity, citizenship, and state/county of origin), apprenticeship enrollment indicators, and enterprise zone participation flags. The specification details three primary transaction record types: student enrollment transactions with demographic data, continuing education records with course enrollment information including course prefix, number, section, and grade, and continuing education course records containing course-level data such as title, program code, contact hours, instructional method, distance learning indicators, enrollment counts, and occupational classification codes. All records include institution codes, report year and semester identifiers, and specific field attributes with defined start and end positions to ensure consistent data formatting across the South Carolina College System (SCS).
The document provides comprehensive field mapping with required valid values, including references to supplementary SCS lookup tables for institution codes, state and county designations, country codes, instructional methods, and Standard Occupational Classification (SOC) codes. Each field is designated with specific character length requirements and data type specifications (alphabetic, numeric, or date formats), with certain fields permitting null values designated as "9." The specification accommodates apprenticeship student tracking through dedicated flags and requires course grades specifically for apprenticeship program participants, while also capturing enterprise zone enrollment indicators and distance learning modality information to support state reporting and analysis of career and technical education outcomes.
View the file
Other files for this state and local contract opportunity
| File | Type | Posted |
|---|---|---|
| Attachment E.pdf | ||
| Amendment 1.docx | DOCX document | |
| Attachment G.pdf | ||
| Attachment D.pdf | ||
| Award Extension.doc | DOC document | |
| Attachment F.pdf | ||
| Attachment I.pdf | ||
| Attachment C.pdf | ||
| Cancellation.docx | DOCX document | |
| SCEIS Integration.pdf | ||
| Amendment 2.docx | DOCX document | |
| Attachment J.xlsx | XLSX spreadsheet | |
| Solicitation.docx | DOCX document |
Show all 13
On GovTribe
Work with this file on GovTribe
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Field Name Title Attribute
Start
Position
End
Position Valid Value txt_record_type Record Type 1A 1 1 N txt_data_type Data Type 1A 2 2 S txt_institution_code Institution Code 6A 3 8 See SCS_College Table nbr_report_year Report Year 4N 9 12 nbr_report_semester Report Semester 2N 13 14 txt_student_id Student SSN 9A 15 23 dte_birth_date Birth Date 8N 24 31 Valid Birthdate or nulls (99999999) txt_gender Gender 1N 32 32 M, F, 9 txt_re_Hisp Hispanic 1N 33 33 0, 1 txt_re_AI_AN American Indian or Alaska Native 1N 34 34 0, 1 txt_re_asian Asian 1N 35 35 0, 1 txt_re_BL_AF Black or African American 1N 36 36 0, 1 txt_re_NH_PI Native Hawaiian or Other Pacific Islander 1N 37 37 0, 1 txt_re_White White 1N 38 38 0, 1 txt_re_NRA Non-Resident Alien 1N 39 39 0, 1 txt_re_UNK Race Ethnicity Unknown 1N 40 40 0, 1 txt_state State of Origin 2A 41 42 See SCS_State Table txt_County County 2A 43 44 See SCS_County Table txt_citizenship Citizenship 2A 45 46 See SCS_Country Table txt_Company_Name Company Name 50A 47 96 txt_college_id Student College ID Number 10A 97 106 Student Id assigned by the college txt_last_name Student Last Name 57A 107 163 txt_first_name Student First Name 30A 164 193 txt_middle_name Student Middle Name 30A 194 223 txt_appren_flag Apprenticeship Indicator 1A 224 224 9=null, 1= Apprenticeship txt_enter_flag Enterprise Flag 1A 225 225 9=null, 2=Enterprise Zone
Student Enrollment Transactions (NS) Continuing Education Record --- Formerly EF
Position End Position Valid Value txt_record_type Record Type 1A 1 1 N txt_data_type Data Type 1A 2 2 B txt_institution_code Institution Code 6A 3 8 See SCS_College Table nbr_report_year Report Year 4N 9 12 nbr_report_semester Report Semester 2N 13 14 txt_student_id Student SSN 9A 15 23 txt_course_Prefix Course Prefix 5A 24 28 txt_course_nbr Course Number 5A 29 33 txt_course_section Course Section 3A 34 36 txt_course_grade Course Grade 2A 37 38 Required for Apprenticeship Students txt_apprenticeship_stud_crs_flag Apprentice Flag For Student 1A 39 39 9=null, 1=Apprenticeship
To account for Apprenticeship students enrolled in regular CE Courses
Student Enrollment Transactions (NB) Continuing Education Record -- Formerly EB
Position
End
Position Valid Value txt_record_type Record Type 1A 1 1 N txt_data_type Data Type 1A 2 2 C txt_institution_code Institution Code 6A 3 8 See SCS_College Table nbr_report_year Report Year 4N 9 12 nbr_report_semester Report Semester 2N 13 14 txt_course_Prefix Course Prefix 5A 15 19 txt_course_nbr Course Number 5A 20 24 txt_course_section Course Section 3A 25 27 txt_course_title Course Title 24N 28 51 Suggestions Only - No CAC is will be required txt_program_code Program Code 6N 52 57 Program Code for the Course txt_contact_hours Course Contact Hours 6N 58 63 Contact Hours generated by the Course txt_meth_of_inst Method of Instructon 2N 64 65 SCS_Instructional_Method Table txt_dist_learn Distance Learning 1A 66 66 Y, N txt_course_enr Course Enrollment 4N 67 70 txt_start_date Start Date 8N 71 78 txt_end_date End Date 8N 79 86 txt_enter_zone Enterprize Zone Indicator 1N 87 87 9=null, 2=Enterprise Zone txt_soc Standard Occupational Classification 6N 88 93 SCS_SOC Table
Student Enrollment Transactions (NC) Continuing Education Record -- Formerly EC
File details come from the government source that posted it. Updated .