# GCAS Data Schema Reference

**Gujarat College Admissions System (GCAS) — 4 Excel files, ~44,500 rows total**
Version: April 2026 | Blue Machines (Apna)

This document is the authoritative reference for any agent or developer working with the GCAS Search API. It defines every column in every table, shows real data examples, and explains how the four tables relate to each other.

---

## Quick Reference: Table Overview

| Table | File | Rows | One row per… |
|---|---|---|---|
| `CollegeMaster` | `CollegeMaster_FORBOT_06042026.xlsx` | 2,506 | College (master identity record) |
| `CollegeInfrastructure` | `CollegeInfrastructure_FORBOT_06042026.xlsx` | 2,500 | College (physical facilities) |
| `CollegeIntakeMaster` | `CollegeIntakeMaster_FORBOT_06042026.xlsx` | 11,937 | Program offering at a college |
| `CutOff_2025-26` | `CutOff_2025-26_06042026.xlsx` | 27,565 | Program × merit-type cutoff |

---

## Entity Relationship Map

```
CollegeMaster (2,506 rows)
  PK: CollegeId
  FK: UniversityId
        │
        ├──── 1:1 ────► CollegeInfrastructure (2,500 rows)
        │                 FK: CollegeId, UniversityId
        │
        └──── 1:N ────► CollegeIntakeMaster (11,937 rows)
                          FK: CollegeId, UniversityId
                          PK: IntakeId
                                │
                                └── string join ──► CutOff_2025-26 (27,565 rows)
                                                      Join on: College + Program
                                                      + Shift + Medium
```

### Join Key Summary

| Join | Left | Key | Right |
|---|---|---|---|
| College identity | `CollegeMaster` | `CollegeId` (int) | `CollegeInfrastructure`, `CollegeIntakeMaster` |
| University grouping | `CollegeMaster` | `UniversityId` (int) | `CollegeInfrastructure`, `CollegeIntakeMaster` |
| Program cutoffs | `CollegeIntakeMaster` | `CollegeName` + `AdmissionName` + `ProgramShift` + `MediumName` | `CutOff_2025-26` (`College` + `Program` + `Shift` + `Medium`) |

> ⚠️ **`CutOff_2025-26` has no integer ID columns.** All joins into it must use string matching on `College`, `University`, `Program`, `Shift`, and `Medium`.

---

## Table 1: CollegeMaster

**The root reference table. Every other table joins back to this.**

### Group 1: Primary Keys & University

| Column | Type | Nullable | Description | Example |
|---|---|---|---|---|
| `CollegeId` | int | No | **Primary Key.** Unique integer per college. Consistent across all 4 tables. | `206`, `3443`, `1386` |
| `UniversityId` | int | No | **Foreign Key** to university. Shared across all tables for joins. | `25`, `13`, `1` |
| `UniversityName` | string | No | Full university name (ALL CAPS). Denormalised for convenience. | `VEER NARMAD SOUTH GUJARAT UNIVERSITY` |

### Group 2: College Identity

| Column | Type | Nullable | Description | Example |
|---|---|---|---|---|
| `CollegeName` | string | No | Official college name in English, ALL CAPS. Primary display name used in all tables. | `M. N. COLLEGE, VISNAGAR` |
| `College Name Gujarati` | string | Yes | College name in Gujarati script. Used for Gujarati-language queries. | `શ્રી એ.આર.ભટ્ટ પી.જી.સેન્ટર` |
| `AISHECode` | string | Yes | National AISHE code assigned by Ministry of Education. Format: `C-NNN`. | `C-768`, `C-556` |
| `UniversityCollegeCode` | string | Yes | Code assigned by the university to this college. | `2206002`, `0132` |
| `EstablishmentYear` | int | Yes | Year the college was founded. | `1951`, `2007`, `2018` |

### Group 3: Location

| Column | Type | Nullable | Description | Example |
|---|---|---|---|---|
| `CollegeAddress` | string | Yes | Full street address. May contain `_x000D_\n` (Excel line-break artifacts — strip when displaying). | `Jawaharlal Nehru Marg, Athwalines, Surat-395001.` |
| `Place` | string | Yes | Town or area name (more specific than district). | `Una`, `PILVAI`, `SURAT` |
| `DistrictName` | string | No | Revenue district. **Use this for district-level filtering, never TalukaName.** | `GirSomnath`, `Mehsana`, `Surat` |
| `TalukaName` | string | Yes | Sub-district taluka. Talukas are inside districts — never use as a district filter. | `Una` (inside GirSomnath), `VIJAPUR` (inside Mehsana) |
| `Pincode` | int | Yes | 6-digit postal code. | `362560`, `395001` |
| `Longitude` | string | Yes | GPS longitude as decimal degree string. | `71.02`, `72.80781337515809` |
| `Latitude` | string | Yes | GPS latitude as decimal degree string. | `20.81`, `21.18692169243461` |
| `CollegeLocationTypeName` | enum | Yes | Urban/rural classification. | `Urban`, `Rural`, `Tribal-Urban`, `Tribal-Rural` |

> ⚠️ **Taluka ≠ District.** Example: "Visnagar" is a taluka; its `DistrictName` is `Mehsana`. "Ankleshwar" is a taluka; its district is `Bharuch`. Always filter on `DistrictName`. City-to-district mapping needed for queries like "Vidyanagar" (Anand district) or "Nadiad" (Kheda district).

### Group 4: College Type & Affiliation

| Column | Type | Nullable | Description | Example |
|---|---|---|---|---|
| `InstituteTypeForCollegeName` | enum | Yes | Broad institute classification. Full list below. | `Government College`, `Grant-In-Aid College`, `Self-Finance` |
| `SponsoringBody` | string | Yes | Trust, society, or government body managing the college. | `VIDYAMANDIR SOCIETY, SURAT` |
| `Sponsoring Body Gujarati` | string | Yes | Sponsoring body name in Gujarati. | `વિદ્યામંદિર સોસાયટી, સુરત` |
| `AffiliationTypeName` | enum | Yes | University affiliation status. | `Permanent`, `Temporary` |
| `AffiliationValidDate` | string | Yes | Affiliation valid until (dd/mm/yyyy). | `30/09/2026` |
| `IsAutonomous` | enum | Yes | Whether UGC-declared autonomous. | `Yes`, `No` |
| `Letter No. of UGC Approval` | string | Yes | UGC autonomous approval letter number. Usually null. | null |
| `UGC Approved Date` | string | Yes | Date of UGC autonomous approval. `01/01/1900` = not applicable. | `01/01/1900` |
| `Autonomous approval until date` | string | Yes | Autonomous status expiry date. | `01/01/1900` |

**All `InstituteTypeForCollegeName` values:**
`Government College` · `Grant-In-Aid College` · `Grant-In -Aid Autonomous` · `Self-Finance` · `Self Finance Autonomous` · `Constituent` · `University Department` · `FACULTY OF UNIVERSITY (MSU)` · `DIET` · `External`

> Agent mapping: students say "government" → `Government College`; "grant college" → `Grant-In-Aid College`; "private" / "self-finance" / "paid college" → `Self-Finance`. Seven types total. Students equate "government" with low fees.

### Group 5: Search Keywords (Critical for Name Resolution)

| Column | Type | Nullable | Description | Example |
|---|---|---|---|---|
| `CollegeNameSearchKeyword1` | string | Yes | First alternate/short name registered by the college. | `WADIA COLLEGE`, `A.R.Bhatt College` |
| `CollegeNameSearchKeyword2` | string | Yes | Second alternate name or abbreviation. | `WADIA WOMENS`, `ARB College` |
| `CollegeNameSearchKeyword3` | string | Yes | Third alternate name. | `WADIA COLLEGE SURAT`, `ARB` |
| `CollegeNameSearchKeyword4` | string | Yes | Fourth alternate name. | null, `A.R.Bhatt PG Center For MSW` |

> These keyword columns are used by the fuzzy name resolver. When a student says "GLS," "Kampani College," or "Wadia," the resolver checks these columns first.

### Group 6: Contact & Principal

| Column | Type | Nullable | Description | Example |
|---|---|---|---|---|
| `CollegePrincipalType` | enum | Yes | Whether principal role is permanent or interim. | `Regular`, `Incharge` |
| `PrefixName` | string | Yes | Title of the principal. | `Dr.`, `Mrs.`, `Prof.`, `Mr.` |
| `CollegePrincipalName` | string | Yes | Principal's first name. | `JAYESHKUMAR`, `JANVI` |
| `CollegePrincipalMiddleName` | string | Yes | Principal's middle name. | `NARANJI`, `BHAVIN` |
| `CollegePrincipalSurName` | string | Yes | Principal's surname. | `CHAUHAN`, `SHAH` |
| `CollegePrincipalNameFooter` | string | Yes | Full formatted principal name — use this for display. | `Prof. JAYESHKUMAR NARANJI CHAUHAN` |
| `CollegePrincipalEmail` | string | Yes | Principal's email. | `PRINCIPAL_132@VNSGU.AC.IN` |
| `CollegePrincipalMobNo` | int | Yes | Principal's mobile (10 digits). | `9328038879` |
| `College Helpline STD Code` | string | Yes | STD area code for landline helpline. | `0261`, `02875` |
| `College Helpline Number` | string | Yes | Helpline phone number (landline or mobile). | `2478061`, `7359900080` |
| `HelpCenterFromTime` | string | Yes | Help centre opens at (HH:MM). | `09:00`, `08:30` |
| `HelpCenterToTime` | string | Yes | Help centre closes at. | `02:00 PM`, `01:30 PM` |
| `Website` | string | Yes | College website URL. May be null for some colleges. Read out URL part by part; never say "dot" as "." | `https://www.wadiacollegesurat.edu.in/` |
| `CollegeIntroductoryVideo` | string | Yes | URL to introductory video. Usually null. | null |

### Group 7: Accreditation & Rankings

| Column | Type | Nullable | Description | Example |
|---|---|---|---|---|
| `IsNAAC` | enum | No | Whether NAAC accredited. | `Yes`, `No` |
| `NAACGrade` | enum | Yes | NAAC grade — null if not accredited. | `A++`, `A+`, `A`, `B++`, `B+`, `B`, `C`, `D` |
| `NAACDate` | string | Yes | Date of NAAC accreditation (dd/mm/yyyy). | `09/02/2026` |
| `IsNIRF` | enum | No | Participates in NIRF (national ranking). | `Yes`, `No` |
| `NIRFRank` | float | Yes | NIRF national rank. `0.0` = participated but no rank assigned. | `0.0`, `45.0` |
| `NIRFYear` | int | Yes | Year of NIRF ranking. `0` = not applicable. | `2024`, `0` |
| `IsGSIRF` | enum | No | Ranked by Gujarat State Institutional Ranking Framework. | `Yes`, `No` |
| `GSIRFStars` | int | Yes | GSIRF star rating. `0` = not rated. | `0`, `2`, `3` |
| `GSIRFDate` | string | Yes | Date of GSIRF rating. `01/01/1900` = not applicable. | `02/12/2024` |

### Group 8: Cells & Special Programs (all `Yes` / `No`)

| Column | Description |
|---|---|
| `NCC` | National Cadet Corps unit present |
| `NSS` | National Service Scheme unit present |
| `Sports` | Sports facility or team available |
| `PlacementCell` | Placement cell exists (agent can confirm existence only — cannot answer placement stats, companies, or salary packages) |
| `SSIPCell` | Student Startup & Innovation Policy cell |
| `SCOPE` | SCOPE program (Skills & Competencies for Organizational Performance Enhancement) |
| `InnovationClub` | Innovation club present |
| `Saptadhara` | Saptadhara cultural activities program |
| `UDISHA` | UDISHA student support program |
| `Antiraggingcell` | Anti-ragging committee |

### Group 9: Staff Counts

| Column | Type | Description | Example |
|---|---|---|---|
| `IsLibrarian` | `Yes`/`No` | Full-time librarian on staff | `Yes` |
| `IsPTI` | `Yes`/`No` | Physical Training Instructor on staff | `No` |
| `NonTeachAdminStaff` | int | Count of non-teaching administrative staff | `7` |
| `NonTeachOthers` | int | Count of other non-teaching staff (peons, guards, etc.) | `6` |

### Group 10: System Fields (do not surface to users)

| Column | Description |
|---|---|
| `Error` | Internal data quality flag (`0` = no error) |
| `SubmitStatus` | `Submitted` or `Pending` — data submission status by the college |
| `UniversityChecklistID` | Internal university checklist identifier (usually null) |
| `UniversityApprovalTimeStamp` | Internal approval timestamp (usually null) |

### Full Example Rows — CollegeMaster

```json
// Example 1: NAAC A grade, Grant-in-Aid, Women's College, Surat
{
  "CollegeId": 1386,
  "UniversityId": 1,
  "UniversityName": "VEER NARMAD SOUTH GUJARAT UNIVERSITY",
  "CollegeName": "Z.F. WADIA WOMENS COLLEGE AND N.K. JHOTA COLLEGE OF COMMERCE, SURAT",
  "College Name Gujarati": "ઝેડ.એફ.વાડિયા વિમેન્સ એન્ડ એન.કે. જહોટા કોલેજ ઓફ કોમર્સ",
  "SponsoringBody": "VIDYAMANDIR SOCIETY, SURAT",
  "EstablishmentYear": 1951,
  "Place": "SURAT",
  "DistrictName": "Surat",
  "TalukaName": "CHORYASI",
  "CollegeLocationTypeName": "Urban",
  "AISHECode": "C-556",
  "Website": "https://www.wadiacollegesurat.edu.in/",
  "AffiliationTypeName": "Permanent",
  "InstituteTypeForCollegeName": "Grant-In-Aid College",
  "CollegeNameSearchKeyword1": "WADIA COLLEGE",
  "CollegeNameSearchKeyword2": "WADIA WOMENS",
  "CollegeNameSearchKeyword3": "WADIA COLLEGE SURAT",
  "IsAutonomous": "No",
  "CollegePrincipalNameFooter": "Prof. JAYESHKUMAR NARANJI CHAUHAN",
  "College Helpline STD Code": "0261",
  "College Helpline Number": "2478061",
  "HelpCenterFromTime": "09:00",
  "HelpCenterToTime": "02:00 PM",
  "IsNAAC": "Yes",
  "NAACGrade": "A",
  "NAACDate": "09/02/2026",
  "IsGSIRF": "Yes",
  "GSIRFStars": 2,
  "GSIRFDate": "02/12/2024",
  "NSS": "Yes",
  "Sports": "Yes",
  "PlacementCell": "Yes",
  "Antiraggingcell": "Yes"
}

// Example 2: Self-Finance, New college (2018), Rural
{
  "CollegeId": 206,
  "UniversityId": 25,
  "UniversityName": "BHAKTA KAVI NARSINH MEHTA UNIVERSITY",
  "CollegeName": "A.R. BHATT P.G.CENTER FOR MSW",
  "EstablishmentYear": 2018,
  "Place": "Una",
  "DistrictName": "GirSomnath",
  "TalukaName": "Una",
  "CollegeLocationTypeName": "Urban",
  "AISHECode": "C-768",
  "AffiliationTypeName": "Temporary",
  "AffiliationValidDate": "30/09/2026",
  "InstituteTypeForCollegeName": "Self-Finance",
  "IsNAAC": "No",
  "CollegePrincipalNameFooter": "Mrs. JANVI BHAVIN SHAH"
}
```

---

## Table 2: CollegeInfrastructure

**Physical infrastructure details. One row per college (1:1 with CollegeMaster).**

### Keys

| Column | Role | Example |
|---|---|---|
| `CollegeId` | **FK → CollegeMaster.CollegeId** | `206`, `3443`, `1386` |
| `UniversityId` | **FK → CollegeMaster.UniversityId** | `25`, `13`, `1` |
| `CollegeName` | Denormalised — matches `CollegeMaster.CollegeName` | `Z.F. WADIA WOMENS COLLEGE...` |
| `UniversityName` | Denormalised — matches `CollegeMaster.UniversityName` | `VEER NARMAD SOUTH GUJARAT UNIVERSITY` |

### Group 1: Hostel

| Column | Type | Nullable | Description | Example |
|---|---|---|---|---|
| `BoysHostel` | `Yes`/`No` | No | Boys hostel available on campus. | `Yes`, `No` |
| `CapcityInBoysHostel` | int | Yes | Seats in boys hostel. Null if no hostel. | `null`, `150` |
| `GirlsHostel` | `Yes`/`No` | No | Girls hostel available on campus. | `Yes`, `No` |
| `CapcityInGirlsHostel` | int | Yes | Seats in girls hostel. Null if no hostel. | `null`, `200` |

> Agent note: Return the correct hostel field based on student gender. If gender unknown, share both. Agent cannot answer hostel capacity details, room availability, or booking process.

### Group 2: Core Facilities (all `Yes` / `No`)

| Column | Description |
|---|---|
| `OwnCampus` | College owns its campus building (not rented) |
| `Playground` | Outdoor playground / sports ground |
| `Auditorium` | Auditorium or seminar hall |
| `Library` | Library present on campus (Yes/No only — cannot answer book count or digital resources) |
| `Laboratory` | Science or research laboratory |
| `Gymnasium` | Gym / fitness centre |
| `DrikingWaterFacility` | Drinking water facility (source data has this typo — keep as-is) |
| `ComputerLab` | Computer laboratory (relevant for BCA, BSc IT, BSc CS) |
| `CWDC` | Complaint and Women Development Cell |
| `CampusWifi` | Campus-wide WiFi connectivity |
| `Parkingfac` | Parking facility (abbreviated in source) |
| `Canteen` | Canteen / cafeteria on campus |
| `TransportationFacility` | College-arranged transport — Yes/No only, cannot provide routes, timings, or fares |
| `HealthCentre` | On-campus health centre / dispensary |

### Group 3: Campus Dimensions

| Column | Type | Nullable | Description | Example |
|---|---|---|---|---|
| `CampusArea` | string (decimal) | Yes | Total campus area in **acres**. May be blank. | `0.6177`, `6153.92`, `1.426539` |
| `BuiltupArea` | string (decimal) | Yes | Built-up construction area in **sq. metres**. | `3004.32`, `5280.94`, `2394.27` |
| `FireNOCNo` | string | Yes | Fire safety NOC certificate number. Null if not obtained. | `FSCA/O/CFOSMC/2024/00048754/R1` |

### Group 4: Accessibility & Disabled Facilities

| Column | Type | Description | Example |
|---|---|---|---|
| `Ramps` | `Yes`/`No` | Wheelchair-accessible ramps | `Yes` |
| `Lift` | `Yes`/`No` | Elevator / lift on campus | `No` |
| `WashroomforDisabled` | `Yes`/`No` | Accessible washroom for disabled persons | `Yes` |
| `Signages` | `Yes`/`No` | Accessibility signage (Braille, directional) | `No` |
| `Wheelchairs` | `Yes`/`No` | Wheelchairs available for student use | `Yes` |
| `ScribesForExam` | `Yes`/`No` | Scribes available for PwBD students in exams | `No` |
| `NoOfToiletGirls` | int | Number of girls' toilet units | `3`, `10` |
| `NoOfToiletBoys` | int | Number of boys' toilet units | `3`, `10` |
| `NoOfToiletDisabledGirls` | int | Accessible toilet units for disabled girls | `1`, `0` |
| `NoOfToiletDisabledBoys` | int | Accessible toilet units for disabled boys | `3`, `0` |

> ⚠️ **PwBD gating rule:** Surface accessibility columns (`Ramps`, `Lift`, `Wheelchairs`, `WashroomforDisabled`, `Signages`, `ScribesForExam`) **only** when the student identifies as PwBD (divyang) or explicitly asks about accessibility. Do not proactively dump accessibility data.

### Full Example Rows — CollegeInfrastructure

```json
// Example 1: Well-equipped nursing college with both hostels
{
  "CollegeId": 3443,
  "CollegeName": "V S RAVAL INST. OF NURSING (PB BSC) COLLEGE PRANTIJ",
  "BoysHostel": "Yes",
  "CapcityInBoysHostel": null,
  "GirlsHostel": "Yes",
  "CapcityInGirlsHostel": null,
  "OwnCampus": "Yes",
  "Playground": "Yes",
  "Auditorium": "Yes",
  "Library": "Yes",
  "Laboratory": "Yes",
  "ComputerLab": "Yes",
  "CWDC": "Yes",
  "CampusWifi": "Yes",
  "Canteen": "Yes",
  "TransportationFacility": "Yes",
  "HealthCentre": "Yes",
  "NoOfToiletGirls": 10,
  "NoOfToiletBoys": 10,
  "NoOfToiletDisabledGirls": 1,
  "NoOfToiletDisabledBoys": 10,
  "FireNOCNo": "FSCA/RFOGN/2024/00085076",
  "CampusArea": "6153.92",
  "BuiltupArea": "5280.94",
  "Wheelchairs": "Yes",
  "WashroomforDisabled": "Yes"
}

// Example 2: Small women's college, no hostel
{
  "CollegeId": 1386,
  "CollegeName": "Z.F. WADIA WOMENS COLLEGE AND N.K. JHOTA COLLEGE OF COMMERCE, SURAT",
  "BoysHostel": "No",
  "CapcityInBoysHostel": null,
  "GirlsHostel": "No",
  "CapcityInGirlsHostel": null,
  "OwnCampus": "Yes",
  "Library": "Yes",
  "ComputerLab": "Yes",
  "CampusWifi": "Yes",
  "Canteen": "Yes",
  "CampusArea": "1.426539",
  "BuiltupArea": "2394.27",
  "NoOfToiletGirls": 4,
  "NoOfToiletBoys": 4
}
```

---

## Table 3: CollegeIntakeMaster

**One row per program offering at a college. A college with 8 programs = 8 rows. Source of truth for fees, intake seats, and program details.**

### Keys

| Column | Role | Example |
|---|---|---|
| `IntakeId` | **Primary Key** — unique row identifier | `7219`, `2325`, `9774` |
| `CollegeId` | **FK → CollegeMaster.CollegeId** | `206`, `1269`, `1386` |
| `UniversityId` | **FK → CollegeMaster.UniversityId** | `25`, `15`, `1` |
| `CourseId` | Internal course type identifier | `112`, `77` |
| `DistrictId` | Numeric district ID (joins to district lookup) | `27`, `6`, `22` |

### Group 1: Program Identity

| Column | Type | Nullable | Description | Example |
|---|---|---|---|---|
| `AdmissionName` | string | No | Full official program name. This is the primary program identifier for all filtering. | `BACHELOR OF COMMERCE`, `MASTER OF SOCIAL WORK`, `MASTER OF ARTS` |
| `CollegeProgramTypeName` | enum | No | Funding and management type of this specific program at this college. | `Government`, `Grant in Aid - Regular`, `Grant in Aid - Higher Payment`, `Self Finance`, `Autonomous` |
| `AdmissionSubTypeByUni` | enum | Yes | Program level/type as classified by the university. | `Under Graduate (Regular)`, `Post Graduate (Regular Including PG Diploma)`, `B.Ed.`, `LL.B.`, `LL.M.` |
| `AdmissionSubTypeByCollege` | enum | Yes | Program level/type as declared by college (usually same as university). | Same values as above |
| `MediumName` | enum | No | Language of instruction. | `Gujarati`, `English`, `Hindi`, `Sanskrit`, `Other` |
| `ProgramShift` | enum | No | Time slot of the program. | `Morning`, `Evening`, `Noon` |
| `EducationMode` | enum | No | Gender admissions policy for this program. | `Co-Education`, `Girls-Only`, `Boys-Only` |
| `ActiveInChoice` | enum | No | Whether open for the current admissions cycle. **Always filter on `Active` for live queries.** | `Active`, `InActive` |

**All `AdmissionSubTypeByUni` values:**
`Under Graduate (Regular)` · `Post Graduate (Regular Including PG Diploma)` · `B.Ed.` · `M.Ed.` · `LL.B.` · `LL.M.` · `M. Sc. (Nursing)` · `Post-Basic B.Sc.(Nursing)` · `Certificate` · `M.Opto` · `M.PT.` · `M.Sc(Applied Geology)` · `PG (PGDClinical)` · `Post Graduate (for BAOU)`

### Group 2: Intake (Seats)

| Column | Type | Nullable | Description | Example |
|---|---|---|---|---|
| `Intake` | int | No | Total approved seats for this program at this college. | `60`, `58`, `120` |
| `AdditionalIntake` | int | No | Extra seats under NRI / management quota. | `0`, `5`, `10` |
| `IsProgrammeIntakeApprovedPermanent` | enum | Yes | Whether intake is permanently approved vs temporary annual approval. | `Yes`, `No` |
| `Year` | string | Yes | Academic year for which intake is declared. Null if permanently approved. | `null`, `2025-2026`, `2026-2027` |

### Group 3: Fees (Annual / Per Two Semesters, in ₹)

| Column | Nullable | Description | Example |
|---|---|---|---|
| `Programme Fees for Female Student (Annual/ Two Semesters` | Yes | Annual fees for female students. | `40000`, `16500`, `14640` |
| `Programme Fees for Other than Female Student (Annual/ Two Semesters` | Yes | Annual fees for male and other students. | `40000`, `0` |
| `Programme Fees for Foreign Student (Annual/ Two Semesters` | Yes | Annual fees for foreign nationals. | `0` |
| `Programme Fees for Quota Student (Annual/ Two Semesters` | Yes | Annual fees under management/NRI quota. | `0` |

> `0` in fees typically means not declared or not applicable for that quota — not "free." Government colleges charge ₹0–₹2,000. Self-finance colleges range ₹15,000–₹150,000+. Always clarify the program when answering fee queries — a single college may have widely different fees per program.

### Group 4: NEP Subject Baskets

| Column | Type | Nullable | Description | Example |
|---|---|---|---|---|
| `MajorBasketName` | string | Yes | Major subject under NEP choice-based credit system. | `COMMERCE`, `SOCIAL WORK`, `PSYCHOLOGY`, `ENGLISH` |
| `MinorBasketName` | string | Yes | Minor subject basket. Null if not NEP-structured. | `ECONOMICS`, null |
| `MultiBasketName` | string | Yes | Multidisciplinary subject basket. Usually null. | null |

### Group 5: Location (Denormalised)

| Column | Description | Example |
|---|---|---|
| `CollegeName` | Matches `CollegeMaster.CollegeName` | `Z.F. WADIA WOMENS COLLEGE...` |
| `UniversityName` | Matches `CollegeMaster.UniversityName` | `VEER NARMAD SOUTH GUJARAT UNIVERSITY` |
| `CollegeDistrict` | District — matches `CollegeMaster.DistrictName` | `Surat`, `GirSomnath`, `Bhavnagar` |
| `DistrictId` | Numeric district ID | `22`, `27`, `6` |

### Full Example Rows — CollegeIntakeMaster

```json
// Example 1: PG Self-Finance, Co-Education, Morning shift
{
  "IntakeId": 7219,
  "CollegeId": 206,
  "UniversityId": 25,
  "CollegeName": "A.R. BHATT P.G.CENTER FOR MSW",
  "CollegeDistrict": "GirSomnath",
  "AdmissionName": "MASTER OF SOCIAL WORK",
  "CollegeProgramTypeName": "Self Finance",
  "AdmissionSubTypeByUni": "Post Graduate (Regular Including PG Diploma)",
  "MediumName": "Gujarati",
  "Intake": 60,
  "AdditionalIntake": 0,
  "MajorBasketName": "SOCIAL WORK",
  "IsProgrammeIntakeApprovedPermanent": "Yes",
  "Programme Fees for Female Student (Annual/ Two Semesters": 40000,
  "Programme Fees for Other than Female Student (Annual/ Two Semesters": 40000,
  "ProgramShift": "Morning",
  "EducationMode": "Co-Education",
  "ActiveInChoice": "Active"
}

// Example 2: PG Girls-Only, Noon shift, fees only for female
{
  "IntakeId": 2325,
  "CollegeId": 1269,
  "CollegeName": "P.G.CENTRE OF M.A, NANDKUNVARBA MAHILA ARTS COLLEGE, PSYCHOLOGY",
  "CollegeDistrict": "Bhavnagar",
  "AdmissionName": "MASTER OF ARTS",
  "CollegeProgramTypeName": "Self Finance",
  "MediumName": "Gujarati",
  "Intake": 60,
  "MajorBasketName": "PSYCHOLOGY",
  "Programme Fees for Female Student (Annual/ Two Semesters": 16500,
  "Programme Fees for Other than Female Student (Annual/ Two Semesters": 0,
  "ProgramShift": "Noon",
  "EducationMode": "Girls-Only",
  "Year": "2025-2026",
  "ActiveInChoice": "Active"
}

// Example 3: Grant-in-Aid English medium, English literature MA
{
  "IntakeId": 9774,
  "CollegeId": 1386,
  "CollegeName": "Z.F. WADIA WOMENS COLLEGE AND N.K. JHOTA COLLEGE OF COMMERCE, SURAT",
  "CollegeDistrict": "Surat",
  "AdmissionName": "MASTER OF ARTS",
  "CollegeProgramTypeName": "Grant in Aid - Higher Payment",
  "MediumName": "English",
  "Intake": 58,
  "MajorBasketName": "ENGLISH",
  "Programme Fees for Female Student (Annual/ Two Semesters": 14640,
  "Programme Fees for Other than Female Student (Annual/ Two Semesters": 0,
  "ProgramShift": "Noon",
  "EducationMode": "Girls-Only",
  "ActiveInChoice": "Active"
}
```

---

## Table 4: CutOff_2025-26

**Admission cutoff percentiles for AY 2025-26. One row per program × merit-type combination. 27,565 rows total.**

> Cutoffs represent the last-admitted percentile from the final round of the 2025-26 admissions cycle. They change every year and are indicative only.

### Keys & Joins

**This table has no integer ID columns.** All joins use string matching:

| This column | Joins to |
|---|---|
| `College` | `CollegeMaster.CollegeName` / `CollegeIntakeMaster.CollegeName` |
| `University` | `CollegeMaster.UniversityName` |
| `Program` | `CollegeIntakeMaster.AdmissionName` |
| `Shift` | `CollegeIntakeMaster.ProgramShift` |
| `Medium` | `CollegeIntakeMaster.MediumName` |

### Columns

| Column | Type | Nullable | Description | Example |
|---|---|---|---|---|
| `University` | string | No | University name (matches CollegeMaster) | `VEER NARMAD SOUTH GUJARAT UNIVERSITY` |
| `College` | string | No | College name (matches CollegeMaster) | `Z.F. WADIA WOMENS COLLEGE...` |
| `Program` | string | No | Program name (matches CollegeIntakeMaster.AdmissionName) | `MASTER OF COMMERCE`, `BACHELOR OF SCIENCE` |
| `MajorSubject` | string | Yes | Major subject within the program | `FINANCIAL & MANAGEMENT ACCOUNTING`, `BOTANY` |
| `Shift` | enum | No | Program time slot | `Morning`, `Evening`, `Noon` |
| `Medium` | enum | No | Language of instruction | `Gujarati`, `English`, `Hindi` |
| `EducationMode` | enum | No | Gender admissions policy | `Co-Education`, `Girls-Only`, `Boys-Only` |
| `CollegeProgramType` | enum | No | Funding type (same values as CollegeIntakeMaster.CollegeProgramTypeName) | `Government`, `Grant in Aid - Regular`, `Self Finance` |
| `MeritType` | string | No | Full descriptor of the merit list — identifies board, quota, and track. Key for selecting the correct cutoff row. | `B.COM. Gujarat State`, `B.A. - GSHSEB` |
| `TotalSeat` | int | No | Seats allotted under this merit type in the last round | `63`, `9`, `3` |

### Cutoff Score Columns (Percentile 0–100)

All six columns store the **last-admitted percentile** per category. `0.0` = no seat allotted in that category this round (not "zero percentile required").

| Column | Category |
|---|---|
| `General` | General / Open category (instate Gujarat students — default track) |
| `GeneralPH` | General — Physically Handicapped / PwBD |
| `SEBC` | Socially and Educationally Backward Classes |
| `SC` | Scheduled Caste |
| `ST` | Scheduled Tribe |
| `EWS` | Economically Weaker Section |

> **Outstate students:** Students from outside Gujarat have a separate (typically higher) cutoff track. These are stored as separate `MeritType` rows (e.g., `B.A. Board Out Side Gujarat State`). The API handles instate vs outstate via the `instate` query parameter.

### Understanding `MeritType`

`MeritType` identifies the exact merit list. One program may have many merit types:

| MeritType Pattern | Meaning |
|---|---|
| `B.COM. Gujarat State` | BCom, students from any Gujarat board (most common instate track) |
| `B.A. - GSHSEB` | BA, Gujarat Secondary and Higher Secondary Education Board students |
| `B.A. - OTHER BOARD` | BA, other boards (CBSE, ICSE, etc.) |
| `B.A. Board Out Side Gujarat State` | BA, outstate students |
| `MKBU BACHELOR OF SCIENCE (UNIVERSITY AREA` | BSc, MKBU jurisdiction instate |
| `BKNMU M.S.W PG OTHER SELF UNIVERSITY` | MSW PG, self-finance, under BKNMU |

For most student queries, filter `MeritType` for the Gujarat State instate track unless the student specifies category or outstate status.

### Full Example Rows — CutOff_2025-26

```json
// Example 1: Competitive MCom at a well-known women's college (all categories active)
{
  "University": "VEER NARMAD SOUTH GUJARAT UNIVERSITY",
  "College": "Z.F. WADIA WOMENS COLLEGE AND N.K. JHOTA COLLEGE OF COMMERCE, SURAT",
  "Program": "MASTER OF COMMERCE",
  "MajorSubject": "FINANCIAL & MANAGEMENT ACCOUNTING",
  "Shift": "Noon",
  "Medium": "Gujarati",
  "EducationMode": "Girls-Only",
  "CollegeProgramType": "Grant in Aid - Regular",
  "MeritType": "MASTER OF COMMERCE (FINANCIAL & MANAGEMENT ACCOUNTING) - GUJARATI - VNSGU",
  "TotalSeat": 63,
  "General": 62.3,
  "GeneralPH": 62.17,
  "SEBC": 60.8,
  "SC": 54.1,
  "ST": 58.8,
  "EWS": 57.0
}

// Example 2: Low-demand BSc Botany — 0.0 means no seat filled that round
{
  "University": "MAHARAJA KRISHNAKUMARSINHJI BHAVNAGAR UNIVERSITY",
  "College": "MATUSHRI RAMUBA TEJANI AND MATUSHRI SHANTABEN VIDIA SCIENCE COLLEGE",
  "Program": "BACHELOR OF SCIENCE",
  "MajorSubject": "BOTANY",
  "Shift": "Noon",
  "Medium": "Gujarati",
  "CollegeProgramType": "Self Finance",
  "MeritType": "MKBU BACHELOR OF SCIENCE (UNIVERSITY AREA",
  "TotalSeat": 9,
  "General": 0.0,
  "SEBC": 0.0,
  "SC": 0.0,
  "ST": 0.0,
  "EWS": 0.0
}
```

---

## Common Reference Values

### Universities on GCAS

| Full Name | Short Name / Acronym | Region |
|---|---|---|
| GUJARAT UNIVERSITY | GU | Ahmedabad, Gandhinagar |
| GUJARAT TECHNOLOGICAL UNIVERSITY | GTU | Engineering (BBA/BCA/B.Design only on GCAS) |
| SARDAR PATEL UNIVERSITY | SPU | Anand, Kheda, Vallabh Vidyanagar |
| SAURASHTRA UNIVERSITY | SU | Rajkot, Jamnagar, Morbi, Surendranagar, Amreli, Botad |
| VEER NARMAD SOUTH GUJARAT UNIVERSITY | VNSGU | Surat, Tapi, Navsari, Valsad |
| HEMCHANDRACHARYA NORTH GUJARAT UNIVERSITY, PATAN | HNGU | Patan, Banaskantha, Sabarkantha, Arvalli, Mahisagar |
| MAHARAJA KRISHNAKUMARSINHJI BHAVNAGAR UNIVERSITY | MKBU | Bhavnagar, Botad |
| DR. BABASAHEB AMBEDKAR OPEN UNIVERSITY | BAOU | Distance/ODL across Gujarat (open admission, no cutoffs) |
| BHAKTA KAVI NARSINH MEHTA UNIVERSITY | BKNMU | Junagadh, GirSomnath, Porbandar, Devbhumi Dwarka |
| KRANTIGURU SHYAMJI KRISHNA VERMA KUTCH UNIVERSITY | KSKVKU | Kutch |
| MAHARAJA SAYAJIRAO UNIVERSITY OF BARODA | MSU | Vadodara (each faculty = separate KB row) |
| CHILD DEVELOPMENT AND RESEARCH UNIVERSITY | CRU | Child development / teacher education |
| SANSKRIT UNIVERSITY (SSSUV) | SSSUV | Sanskrit only |
| IITE | IITE | Teacher education |

### District Name Variants (What students say vs. canonical `DistrictName`)

| Canonical | Student may say |
|---|---|
| `Ahmedabad` | Amdavad, Ahmedabad |
| `Vadodara` | Baroda, Vadodara |
| `Kutch` | Kachchh, Katch, Kutch |
| `GirSomnath` | Somnath, Gir Somnath |
| `Devbhumi Dwarka` | Dwarka |
| `Mehsana` | Mahesana |
| `Anand` | Anand (city = Anand district; Vallabh Vidyanagar is also in Anand) |
| `Kheda` | Nadiad (Nadiad is in Kheda district) |
| `Panchmahal` | Godhra |

> Talukas students may name (map to parent district): Visnagar → Mehsana; Ankleshwar → Bharuch; Kalol → Gandhinagar; Anand city → Anand district.

### Program Name Aliases

| Student says | `AdmissionName` in KB |
|---|---|
| Commerce, BCom | `BACHELOR OF COMMERCE`, `BACHELOR OF COMMERCE (HONORS)` |
| Science, BSc | `BACHELOR OF SCIENCE` |
| Arts, BA | `BACHELOR OF ARTS` |
| Law, LLB | `BACHELOR OF LAWS`, `BA LLB INTEGRATED`, `BBA LLB INTEGRATED` |
| BCA, Computer | `BACHELOR OF COMPUTER APPLICATIONS` |
| BBA | `BACHELOR OF BUSINESS ADMINISTRATION` |
| B.Ed, Teaching college | `BACHELOR OF EDUCATION` |
| MBA | `MASTER OF BUSINESS ADMINISTRATION (INTEGRATED)` (only integrated, UG-entry, in scope on GCAS) |
| MCom | `MASTER OF COMMERCE` |
| MA | `MASTER OF ARTS` |
| MSc | `MASTER OF SCIENCE` |
| Nursing | `BACHELOR OF SCIENCE (NURSING)`, `M. SC. (NURSING)` |
| Pharmacy | `BACHELOR OF PHARMACY` |

---

## Critical Notes for Agents

**1. Fees are per-program, not per-college.** A college with 8 programs may have 8 different fee structures. Never state a single fee for a college without specifying the program. If a student asks "Gujarat University ki fees kitni hai?" — ask which program.

**2. Cutoffs are per merit-type, not just per program.** The same program at one college may have 10+ cutoff rows. Default to the Gujarat State instate merit track. Ask for category (SC/ST/SEBC/EWS/General) if not specified.

**3. `0.0` in cutoffs ≠ "easy to get in."** It means no seat was allotted in that category last round — could mean zero demand or over-subscription before that category was reached.

**4. `0` in fees ≠ "free."** Means not declared, not applicable for that quota, or data is missing.

**5. Taluka ≠ District.** Always filter on `DistrictName`. Map taluka/city names to their parent district before filtering.

**6. `CollegeIntakeMaster` is the source of truth for programs and fees.** `CollegeMaster` has only college-level attributes. For fees, medium, shift, intake, mode — always go to `CollegeIntakeMaster`.

**7. MSU has multiple faculties, each its own row.** When a student says "MSU" ask which faculty (Commerce, Arts, Science, etc.) since fees and cutoffs differ per faculty.

**8. BAOU = open admission, no cutoffs.** Never use BAOU cutoff data for eligibility. Any student meeting basic eligibility can enrol.

**9. `ActiveInChoice = "InActive"` = program suspended.** Exclude from live queries unless asked about historical data.

**10. Accessibility data is PwBD-gated.** Only surface `Ramps`, `Lift`, `Wheelchairs`, `WashroomforDisabled`, `Signages`, `ScribesForExam` when the student identifies as PwBD or explicitly asks about accessibility.

**11. Placement cell ≠ placement data.** The KB only says whether a cell exists (Yes/No). Agent cannot answer placement records, company names, salary packages, or placement percentages — redirect to college website.

**12. `CutOff_2025-26` is string-joined only.** There is no `CollegeId` or `IntakeId` in this table. Joins must use `College` + `Program` + `Shift` + `Medium` with case-insensitive exact or fuzzy string matching.