TetiaryInstitution.xlsx

	A	B	C
1	Table	Field	Description
2	Zones	ID	Unique Identifier for Each Geographical Zone
3	Zones	Code	Short Name for Zone
4	Zones	Zone	Name of Zone
5	States	ID	Unique Identifier for each state
6	States	StateShort	Short Name for State
7	States	State	Name of State
8	States	ZoneID	ID of zone the state belongs to
9	Study Centers	ID	Unique Identifier for each Campus/Study Center Location & Program
10	Study Centers	StateID	ID of State where Study Center is located
11	Study Centers	Study Center	Name of Study Center
12	Study Centers	ProgramID	ID of Program type being run in the campus
13	Study Centers	Status	Indicates if the campus is active or not
14	Study Centers	State	The state where the study center is located
15	Academic Sessions	ID	Unique Identifier for each session
16	Academic Sessions	Session	Name of Session
17	Academic Sessions	Year	Year of Session
18	Academic Sessions	Status	Identifies if Session is in progress or completed
19	Semesters	ID	Unique Identifier for each Semester Session
20	Semesters	AcademicSessionID	ID of Academic Session the semester belongs to
21	Semesters	Semester	ID of Semester Name
22	Semesters	Status	Indicates if Semester is currently running or completed
23	Specializations	id	Unique Identifier for Course Discipline/Specialization
24	Specializations	Specialization	Name of Specialization
25	Specializations	Practical	Indicates if the specialization involves practicals or not
26	Specializations	ProgrammeID	Identifies type of degree or program
27	Specializations	status	Indicates if the specialization is active or not
28	Programmes	ID	Unique Identifier for each Programme
29	Programmes	Programme Name	Name of Programme
30	FeeTypes	ID	Unique Identifier for type of fees charged
31	FeeTypes	FeeType	Name of fee
32	Admissions	id	Unique Identifier for each Admission record
33	Admissions	applicant_id	ID of the applicant
34	Admissions	programme_id	ID of the programme the applicant is putting in for
35	Admissions	specialization_id	ID of the specialization the applicant is putting in for
36	Admissions	entry_year	Admission Year
37	Admissions	entry_type	Indicates if applicant is coming in as a Fresher or Direct Entry to an advanced level
38	Admissions	Program Duration	Length of the programme
39	Admissions	Admission Status	Indicates the virdict of the admission
40	Admissions	Remarks	Comments especially when admission is not granted
41	Admissions	ApplicationState	State of the applicant
42	ApplicationFinancials	ID	Unique ID for each aplication payment record
43	ApplicationFinancials	FeesTypeID	ID for the type of payment
44	ApplicationFinancials	SemesterID	ID for the semester the payment is meant for
45	ApplicationFinancials	Amount	Amount Paid
46	ApplicationFinancials	Status	Status of the payment
47	ApplicationFinancials	Payment Advice Date	When Payment Advice was generated
48	ApplicationFinancials	ApplicantID	ID of applicant making the payment
49	ApplicationFinancials	ApplicantProgramID	ID of the program applicant is paying for
50	ApplicationFinancials	ApplicantStudyCenterID	ID of the Study center the applicant applied to
51	ApplicationFinancials	ApplicantApplicationStateID	StateID of the Applicant
52	ApplicationFinancials	TransactionStatus	System captured status of payment
53	Applicants	ID	Unique ID for each Applicant Record
54	Applicants	UserID	System User ID for applicant
55	Applicants	SemesterID	ID of semester applicant is putting in for
56	Applicants	ProgramID	ID of the program the applicant is putting in for
57	Applicants	FirstChoice	1st choice of Specialization applicant is putting in for
58	Applicants	SecondChoice	2nd choice of specialization applicant is putting in for
59	Applicants	EntryLevelType	Indicates if applicant is entering as a Fresher or Direct Entry
60	Applicants	StudyCenterID	ID of syudy center applicant is putting in for
61	Applicants	ApplicationStateID	ID of applicant's state
62	Applicants	ApplicationStatus	Status of application
63	CourseRegistration	ID	Unique Identifier for each course registration record
64	CourseRegistration	StudentID	ID of Student registering for course
65	CourseRegistration	SemesterID	ID of the semester the registration is meant for
66	CourseRegistration	RegistrationType	Indicates if theregistration is regular or a retake/carried over course
67	CourseRegistration	Day	Day of Registration
68	CourseRegistration	Month	Month of Registration
69	CourseRegistration	Year	Year of Registration
70	Students	ID	Unique ID for each student record
71	Students	ProgrammeID	ID of programme the student is running
72	Students	SpecalizationID	ID of specialization is running
73	Students	StudyCenterID	ID of Study center the student is entered for
74	Students	EntryYear	Year the student started programme
75	Students	EntryType	Indicates if student as a fresher or Direct Entry
76	Students	UserID	System User ID for student
77	Students	ApplicantID	ID of student during application
78	StudentsTransactions	ID	Unique ID for each student payment record
79	StudentsTransactions	FeeID	ID for the type of payment
80	StudentsTransactions	SemesterID	ID for the semester the payment is meant for
81	StudentsTransactions	amount	Amount Paid
82	StudentsTransactions	status	Status of the payment
83	StudentsTransactions	PaymentAdviceDate	When Payment Advice was generated
84	StudentsTransactions	StudentID	ID of student making the payment
85	StudentsTransactions	StudentProgramID	ID of the program student is paying for
86	StudentsTransactions	StudentSpecializationID	ID of the Study center the student applied to
87	StudentsTransactions	StudentStudyCenterID	StudyCenterID of the Student
88	StudentsTransactions	Transaction Status	System captured status of payment
89
90
91
92
93
94
95
96
97
98
99
100