Index: main/waeup.aaue/trunk/src/waeup/aaue/interswitch/browser.py
===================================================================
--- main/waeup.aaue/trunk/src/waeup/aaue/interswitch/browser.py	(revision 17433)
+++ main/waeup.aaue/trunk/src/waeup/aaue/interswitch/browser.py	(revision 17434)
@@ -182,5 +182,26 @@
             self.redirect(self.url(self.context, '@@index'))
             return
+        student = self.student
         category = self.context.p_category
+        # To guarantee that cleared students pay both acceptance fee
+        # and school fees, the page can only be accessed
+        # for school fee payments if acceptance/clearance fee has
+        # been successfully queried/paid beforehand. This
+        # requirement applies to students in state 'cleared' and
+        # entry_session greater than 2012 only.
+        if self.context.p_category.startswith('schoolfee') and \
+            student.state == CLEARED and \
+            student.entry_session > 2012:
+            acceptance_fee_paid = False
+            for ticket in student['payments'].values():
+                if ticket.p_state == 'paid' and \
+                    ticket.p_category.startswith('clearance'):
+                    acceptance_fee_paid = True
+                    break
+            if not acceptance_fee_paid:
+                self.flash(
+                    _('Please pay acceptance fee first.'), type="danger")
+                self.redirect(self.url(self.context, '@@index'))
+                return
         # Already now it becomes an Interswitch payment. We set the net amount
         # and add the gateway amount.
@@ -190,5 +211,4 @@
             self.context.gateway_amt = GATEWAY_AMT
             self.context.r_company = u'interswitch'
-        student = self.student
         xmldict = self.xmldict
         # Provider data
Index: main/waeup.aaue/trunk/src/waeup/aaue/interswitch/tests.py
===================================================================
--- main/waeup.aaue/trunk/src/waeup/aaue/interswitch/tests.py	(revision 17433)
+++ main/waeup.aaue/trunk/src/waeup/aaue/interswitch/tests.py	(revision 17434)
@@ -261,11 +261,4 @@
         self.payment_url = self.browser.url
         self.browser.getLink("Pay via Interswitch", index=0).click()
-        #self.assertTrue(
-        #    'Please pay acceptance fee first' in self.browser.contents)
-        #acc_payment = createObject('waeup.StudentOnlinePayment')
-        #acc_payment.p_state = 'paid'
-        #acc_payment.p_category = 'clearance'
-        #self.student['payments']['xyz'] = acc_payment
-        #self.browser.getLink("Pay via Interswitch", index=0).click()
         self.assertTrue('Total Amount Authorized:'
                         in self.browser.contents)
@@ -286,4 +279,11 @@
         self.assertTrue('<span>92000.0</span>' in self.browser.contents)
         self.payment_url = self.browser.url
+        self.browser.getLink("Pay via Interswitch", index=0).click()
+        self.assertTrue(
+            'Please pay acceptance fee first' in self.browser.contents)
+        acc_payment = createObject('waeup.StudentOnlinePayment')
+        acc_payment.p_state = 'paid'
+        acc_payment.p_category = 'clearance'
+        self.student['payments']['xyz'] = acc_payment
         self.browser.getLink("Pay via Interswitch", index=0).click()
         self.assertTrue(
Index: main/waeup.aaue/trunk/src/waeup/aaue/students/acceptancefees.csv
===================================================================
--- main/waeup.aaue/trunk/src/waeup/aaue/students/acceptancefees.csv	(revision 17433)
+++ main/waeup.aaue/trunk/src/waeup/aaue/students/acceptancefees.csv	(revision 17434)
@@ -1,95 +1,95 @@
-code,faculty_code,department_code,session,acceptance,matricgown,lapel
-CERT1,FAG,ANS,#2022,14000,2000,800
-BAGRANS,FAG,ANS,#2022,62400,2000,800
-BAGRCRS,FAG,CRS,#2022,62400,2000,800
-BAGREES,FAG,EES,#2022,62400,2000,800
-BAGRSOS,FAG,SOS,#2022,62400,2000,800
-BAENG,FAT,ENG,#2022,62400,2000,800
-BAFRN,FAT,FRN,#2022,62400,2000,800
-BAHIS,FAT,HIS,#2022,62400,2000,800
-BAISD,FAT,HIS,#2022,62400,2000,800
-BAMAC,FAT,MAC,#2022,62400,2000,800
-BAPHI,FAT,PHI,#2022,62400,2000,800
-BARCS,FAT,RCS,#2022,62400,2000,800
-BARST,FAT,RCS,#2022,62400,2000,800
-BATMA,FAT,TMA,#2022,62400,2000,800
-BSCANA,FBM,ANA,#2022,62400,2000,800
-BMLS,FBM,MLS,#2022,67400,2000,800
-BMLSCHMP,FBM,MLS,#2022,67400,2000,800
-BMLSHBTS,FBM,MLS,#2022,67400,2000,800
-BMLSHIST,FBM,MLS,#2022,67400,2000,800
-BMLSMMCB,FBM,MLS,#2022,67400,2000,800
-BSCNSG,FBM,NSG,#2022,67400,2000,800
-BSCPHS,FBM,PHS,#2022,62400,2000,800
-BSCPYS,FBM,PYS,#2022,62400,2000,800
-MBBS,FCS,MED,#2022,77400,2000,800
-BEDACC,FED,BED,#2022,62400,2000,800
-BEDOTM,FED,BED,#2022,62400,2000,800
-BEDSEC,FED,BED,#2022,62400,2000,800
-BEDBIO,FED,CAI,#2022,62400,2000,800
-BEDCHM,FED,CAI,#2022,62400,2000,800
-BEDCSC,FED,CAI,#2022,62400,2000,800
-BEDENG,FED,CAI,#2022,62400,2000,800
-BEDFRN,FED,CAI,#2022,62400,2000,800
-BEDMTH,FED,CAI,#2022,62400,2000,800
-BEDPHY,FED,CAI,#2022,62400,2000,800
-BEDPPE,FED,CAI,#2022,62400,2000,800
-BEDSSE,FED,CAI,#2022,62400,2000,800
-CAI,FED,CAI,#2022,62400,2000,800
-BEDEDM,FED,EFM,#2022,62400,2000,800
-BEDHIS,FED,EFM,#2022,62400,2000,800
-BEDRSE,FED,EFM,#2022,62400,2000,800
-EFM,FED,EFM,#2022,62400,2000,800
-BEDECO,FED,GAC,#2022,62400,2000,800
-BEDGAC,FED,GAC,#2022,62400,2000,800
-BEDGEO,FED,GAC,#2022,62400,2000,800
-BEDPOL,FED,GAC,#2022,62400,2000,800
-BEDHED,FED,HKH,#2022,62400,2000,800
-BEDHKE,FED,HKH,#2022,62400,2000,800
-BEDPHE,FED,HKH,#2022,62400,2000,800
-BSCLIS,FED,LIS,#2022,62400,2000,800
-BEDAGR,FED,VTE,#2022,62400,2000,800
-BEDHECO,FED,VTE,#2022,62400,2000,800
-BEDTEC,FED,VTE,#2022,62400,2000,800
-VTE,FED,VTE,#2022,62400,2000,800
-BSCARC,FES,ARC,#2022,62400,2000,800
-BSCBLD,FES,BLD,#2022,62400,2000,800
-BFA,FES,FAA,#2022,62400,2000,800
-BFAGRH,FES,FAA,#2022,62400,2000,800
-BFAPNT,FES,FAA,#2022,62400,2000,800
-BFASC,FES,FAA,#2022,62400,2000,800
-BFATD,FES,FAA,#2022,62400,2000,800
-BSCFAA,FES,FAA,#2022,62400,2000,800
-BSCGEM,FES,GEM,#2022,62400,2000,800
-BSCGRP,FES,GEM,#2022,62400,2000,800
-BENGAGE,FET,AGE,#2022,62400,2000,800
-BENGCIE,FET,CIE,#2022,62400,2000,800
-BENGELE,FET,ELE,#2022,62400,2000,800
-BENGIPE,FET,IPE,#2022,62400,2000,800
-BENGMPE,FET,IPE,#2022,62400,2000,800
-BENGPE,FET,IPE,#2022,62400,2000,800
-BENGMEE,FET,MEE,#2022,62400,2000,800
-BENGMME,FET,MME,#2022,62400,2000,800
-BSCBCH,FLS,BCH,#2022,62400,2000,800
-BSCBOT,FLS,BOT,#2022,62400,2000,800
-BSCHND,FLS,HND,#2022,62400,2000,800
-BSCMCB,FLS,MCB,#2022,62400,2000,800
-BSCPSB,FLS,PSB,#2022,62400,2000,800
-BSCZOO,FLS,ZOO,#2022,62400,2000,800
-LLB,FLW,LAW,#2022,67400,2000,800
-BSCACC,FMS,ACC,#2022,62400,2000,800
-BSCBAF,FMS,BAF,#2022,62400,2000,800
-BSCBUS,FMS,BUS,#2022,62400,2000,800
-BSCPUB,FMS,PUB,#2022,62400,2000,800
-BSCCHM,FPS,CHM,#2022,62400,2000,800
-BSCICH,FPS,CHM,#2022,62400,2000,800
-BSCCSC,FPS,CSC,#2022,62400,2000,800
-BSCIMTH,FPS,MTH,#2022,62400,2000,800
-BSCMTH,FPS,MTH,#2022,62400,2000,800
-BSCSTA,FPS,MTH,#2022,62400,2000,800
-BSCAPHY,FPS,PHY,#2022,62400,2000,800
-BSCPHY,FPS,PHY,#2022,62400,2000,800
-BSCECO,FSS,ECO,#2022,62400,2000,800
-BSCPOL,FSS,POL,#2022,62400,2000,800
-BSCPSY,FSS,PSY,#2022,62400,2000,800
-BSCSOC,FSS,SOC,#2022,62400,2000,800
+code,faculty_code,department_code,acceptance,matricgown,lapel
+CERT1,FAG,ANS,14000,2000,800
+BAGRANS,FAG,ANS,62400,2000,800
+BAGRCRS,FAG,CRS,62400,2000,800
+BAGREES,FAG,EES,62400,2000,800
+BAGRSOS,FAG,SOS,62400,2000,800
+BAENG,FAT,ENG,62400,2000,800
+BAFRN,FAT,FRN,62400,2000,800
+BAHIS,FAT,HIS,62400,2000,800
+BAISD,FAT,HIS,62400,2000,800
+BAMAC,FAT,MAC,62400,2000,800
+BAPHI,FAT,PHI,62400,2000,800
+BARCS,FAT,RCS,62400,2000,800
+BARST,FAT,RCS,62400,2000,800
+BATMA,FAT,TMA,62400,2000,800
+BSCANA,FBM,ANA,62400,2000,800
+BMLS,FBM,MLS,67400,2000,800
+BMLSCHMP,FBM,MLS,67400,2000,800
+BMLSHBTS,FBM,MLS,67400,2000,800
+BMLSHIST,FBM,MLS,67400,2000,800
+BMLSMMCB,FBM,MLS,67400,2000,800
+BSCNSG,FBM,NSG,67400,2000,800
+BSCPHS,FBM,PHS,62400,2000,800
+BSCPYS,FBM,PYS,62400,2000,800
+MBBS,FCS,MED,77400,2000,800
+BEDACC,FED,BED,62400,2000,800
+BEDOTM,FED,BED,62400,2000,800
+BEDSEC,FED,BED,62400,2000,800
+BEDBIO,FED,CAI,62400,2000,800
+BEDCHM,FED,CAI,62400,2000,800
+BEDCSC,FED,CAI,62400,2000,800
+BEDENG,FED,CAI,62400,2000,800
+BEDFRN,FED,CAI,62400,2000,800
+BEDMTH,FED,CAI,62400,2000,800
+BEDPHY,FED,CAI,62400,2000,800
+BEDPPE,FED,CAI,62400,2000,800
+BEDSSE,FED,CAI,62400,2000,800
+CAI,FED,CAI,62400,2000,800
+BEDEDM,FED,EFM,62400,2000,800
+BEDHIS,FED,EFM,62400,2000,800
+BEDRSE,FED,EFM,62400,2000,800
+EFM,FED,EFM,62400,2000,800
+BEDECO,FED,GAC,62400,2000,800
+BEDGAC,FED,GAC,62400,2000,800
+BEDGEO,FED,GAC,62400,2000,800
+BEDPOL,FED,GAC,62400,2000,800
+BEDHED,FED,HKH,62400,2000,800
+BEDHKE,FED,HKH,62400,2000,800
+BEDPHE,FED,HKH,62400,2000,800
+BSCLIS,FED,LIS,62400,2000,800
+BEDAGR,FED,VTE,62400,2000,800
+BEDHECO,FED,VTE,62400,2000,800
+BEDTEC,FED,VTE,62400,2000,800
+VTE,FED,VTE,62400,2000,800
+BSCARC,FES,ARC,62400,2000,800
+BSCBLD,FES,BLD,62400,2000,800
+BFA,FES,FAA,62400,2000,800
+BFAGRH,FES,FAA,62400,2000,800
+BFAPNT,FES,FAA,62400,2000,800
+BFASC,FES,FAA,62400,2000,800
+BFATD,FES,FAA,62400,2000,800
+BSCFAA,FES,FAA,62400,2000,800
+BSCGEM,FES,GEM,62400,2000,800
+BSCGRP,FES,GEM,62400,2000,800
+BENGAGE,FET,AGE,62400,2000,800
+BENGCIE,FET,CIE,62400,2000,800
+BENGELE,FET,ELE,62400,2000,800
+BENGIPE,FET,IPE,62400,2000,800
+BENGMPE,FET,IPE,62400,2000,800
+BENGPE,FET,IPE,62400,2000,800
+BENGMEE,FET,MEE,62400,2000,800
+BENGMME,FET,MME,62400,2000,800
+BSCBCH,FLS,BCH,62400,2000,800
+BSCBOT,FLS,BOT,62400,2000,800
+BSCHND,FLS,HND,62400,2000,800
+BSCMCB,FLS,MCB,62400,2000,800
+BSCPSB,FLS,PSB,62400,2000,800
+BSCZOO,FLS,ZOO,62400,2000,800
+LLB,FLW,LAW,67400,2000,800
+BSCACC,FMS,ACC,62400,2000,800
+BSCBAF,FMS,BAF,62400,2000,800
+BSCBUS,FMS,BUS,62400,2000,800
+BSCPUB,FMS,PUB,62400,2000,800
+BSCCHM,FPS,CHM,62400,2000,800
+BSCICH,FPS,CHM,62400,2000,800
+BSCCSC,FPS,CSC,62400,2000,800
+BSCIMTH,FPS,MTH,62400,2000,800
+BSCMTH,FPS,MTH,62400,2000,800
+BSCSTA,FPS,MTH,62400,2000,800
+BSCAPHY,FPS,PHY,62400,2000,800
+BSCPHY,FPS,PHY,62400,2000,800
+BSCECO,FSS,ECO,62400,2000,800
+BSCPOL,FSS,POL,62400,2000,800
+BSCPSY,FSS,PSY,62400,2000,800
+BSCSOC,FSS,SOC,62400,2000,800
Index: main/waeup.aaue/trunk/src/waeup/aaue/students/schoolfees.csv
===================================================================
--- main/waeup.aaue/trunk/src/waeup/aaue/students/schoolfees.csv	(revision 17433)
+++ main/waeup.aaue/trunk/src/waeup/aaue/students/schoolfees.csv	(revision 17434)
@@ -1,95 +1,95 @@
-code,faculty_code,department_code,session,tuition,edohis,union,access,notebook,sport,library,lmsplus,nuga
-CERT1,FAG,ANS,#2022,184000,16000,1000,4500,9000,3000,1000,20000,1000
-BAGRANS,FAG,ANS,#2022,184000,16000,1000,4500,9000,3000,1000,20000,1000
-BAGRCRS,FAG,CRS,#2022,184000,16000,1000,4500,9000,3000,1000,20000,1000
-BAGREES,FAG,EES,#2022,184000,16000,1000,4500,9000,3000,1000,20000,1000
-BAGRSOS,FAG,SOS,#2022,184000,16000,1000,4500,9000,3000,1000,20000,1000
-BAENG,FAT,ENG,#2022,198250,16000,1000,4500,9000,3000,1000,20000,1000
-BAFRN,FAT,FRN,#2022,198250,16000,1000,4500,9000,3000,1000,20000,1000
-BAHIS,FAT,HIS,#2022,198250,16000,1000,4500,9000,3000,1000,20000,1000
-BAISD,FAT,HIS,#2022,198250,16000,1000,4500,9000,3000,1000,20000,1000
-BAMAC,FAT,MAC,#2022,248250,16000,1000,4500,9000,3000,1000,20000,1000
-BAPHI,FAT,PHI,#2022,198250,16000,1000,4500,9000,3000,1000,20000,1000
-BARCS,FAT,RCS,#2022,198250,16000,1000,4500,9000,3000,1000,20000,1000
-BARST,FAT,RCS,#2022,198250,16000,1000,4500,9000,3000,1000,20000,1000
-BATMA,FAT,TMA,#2022,198250,16000,1000,4500,9000,3000,1000,20000,1000
-BSCANA,FBM,ANA,#2022,281000,16000,1000,4500,9000,3000,1000,20000,1000
-BMLS,FBM,MLS,#2022,554500,16000,1000,4500,9000,3000,1000,20000,1000
-BMLSCHMP,FBM,MLS,#2022,554500,16000,1000,4500,9000,3000,1000,20000,1000
-BMLSHBTS,FBM,MLS,#2022,554500,16000,1000,4500,9000,3000,1000,20000,1000
-BMLSHIST,FBM,MLS,#2022,554500,16000,1000,4500,9000,3000,1000,20000,1000
-BMLSMMCB,FBM,MLS,#2022,554500,16000,1000,4500,9000,3000,1000,20000,1000
-BSCNSG,FBM,NSG,#2022,666000,16000,1000,4500,9000,3000,1000,20000,1000
-BSCPHS,FBM,PHS,#2022,204000,16000,1000,4500,9000,3000,1000,20000,1000
-BSCPYS,FBM,PYS,#2022,204000,16000,1000,4500,9000,3000,1000,20000,1000
-MBBS,FCS,MED,#2022,786000,16000,1000,4500,9000,3000,1000,20000,1000
-BEDACC,FED,BED,#2022,214000,16000,1000,4500,9000,3000,1000,20000,1000
-BEDOTM,FED,BED,#2022,214000,16000,1000,4500,9000,3000,1000,20000,1000
-BEDSEC,FED,BED,#2022,214000,16000,1000,4500,9000,3000,1000,20000,1000
-BEDBIO,FED,CAI,#2022,214000,16000,1000,4500,9000,3000,1000,20000,1000
-BEDCHM,FED,CAI,#2022,214000,16000,1000,4500,9000,3000,1000,20000,1000
-BEDCSC,FED,CAI,#2022,214000,16000,1000,4500,9000,3000,1000,20000,1000
-BEDENG,FED,CAI,#2022,214000,16000,1000,4500,9000,3000,1000,20000,1000
-BEDFRN,FED,CAI,#2022,214000,16000,1000,4500,9000,3000,1000,20000,1000
-BEDMTH,FED,CAI,#2022,214000,16000,1000,4500,9000,3000,1000,20000,1000
-BEDPHY,FED,CAI,#2022,214000,16000,1000,4500,9000,3000,1000,20000,1000
-BEDPPE,FED,CAI,#2022,214000,16000,1000,4500,9000,3000,1000,20000,1000
-BEDSSE,FED,CAI,#2022,214000,16000,1000,4500,9000,3000,1000,20000,1000
-CAI,FED,CAI,#2022,214000,16000,1000,4500,9000,3000,1000,20000,1000
-BEDEDM,FED,EFM,#2022,214000,16000,1000,4500,9000,3000,1000,20000,1000
-BEDHIS,FED,EFM,#2022,214000,16000,1000,4500,9000,3000,1000,20000,1000
-BEDRSE,FED,EFM,#2022,214000,16000,1000,4500,9000,3000,1000,20000,1000
-EFM,FED,EFM,#2022,214000,16000,1000,4500,9000,3000,1000,20000,1000
-BEDECO,FED,GAC,#2022,214000,16000,1000,4500,9000,3000,1000,20000,1000
-BEDGAC,FED,GAC,#2022,214000,16000,1000,4500,9000,3000,1000,20000,1000
-BEDGEO,FED,GAC,#2022,214000,16000,1000,4500,9000,3000,1000,20000,1000
-BEDPOL,FED,GAC,#2022,214000,16000,1000,4500,9000,3000,1000,20000,1000
-BEDHED,FED,HKH,#2022,214000,16000,1000,4500,9000,3000,1000,20000,1000
-BEDHKE,FED,HKH,#2022,214000,16000,1000,4500,9000,3000,1000,20000,1000
-BEDPHE,FED,HKH,#2022,214000,16000,1000,4500,9000,3000,1000,20000,1000
-BSCLIS,FED,LIS,#2022,198250,16000,1000,4500,9000,3000,1000,20000,1000
-BEDAGR,FED,VTE,#2022,214000,16000,1000,4500,9000,3000,1000,20000,1000
-BEDHECO,FED,VTE,#2022,214000,16000,1000,4500,9000,3000,1000,20000,1000
-BEDTEC,FED,VTE,#2022,214000,16000,1000,4500,9000,3000,1000,20000,1000
-VTE,FED,VTE,#2022,214000,16000,1000,4500,9000,3000,1000,20000,1000
-BSCARC,FES,ARC,#2022,224500,16000,1000,4500,9000,3000,1000,20000,1000
-BSCBLD,FES,BLD,#2022,224500,16000,1000,4500,9000,3000,1000,20000,1000
-BFA,FES,FAA,#2022,198250,16000,1000,4500,9000,3000,1000,20000,1000
-BFAGRH,FES,FAA,#2022,198250,16000,1000,4500,9000,3000,1000,20000,1000
-BFAPNT,FES,FAA,#2022,198250,16000,1000,4500,9000,3000,1000,20000,1000
-BFASC,FES,FAA,#2022,198250,16000,1000,4500,9000,3000,1000,20000,1000
-BFATD,FES,FAA,#2022,198250,16000,1000,4500,9000,3000,1000,20000,1000
-BSCFAA,FES,FAA,#2022,198250,16000,1000,4500,9000,3000,1000,20000,1000
-BSCGEM,FES,GEM,#2022,198250,16000,1000,4500,9000,3000,1000,20000,1000
-BSCGRP,FES,GEM,#2022,198250,16000,1000,4500,9000,3000,1000,20000,1000
-BENGAGE,FET,AGE,#2022,312500,16000,1000,4500,9000,3000,1000,20000,1000
-BENGCIE,FET,CIE,#2022,312500,16000,1000,4500,9000,3000,1000,20000,1000
-BENGELE,FET,ELE,#2022,312500,16000,1000,4500,9000,3000,1000,20000,1000
-BENGIPE,FET,IPE,#2022,312500,16000,1000,4500,9000,3000,1000,20000,1000
-BENGMPE,FET,IPE,#2022,312500,16000,1000,4500,9000,3000,1000,20000,1000
-BENGPE,FET,IPE,#2022,312500,16000,1000,4500,9000,3000,1000,20000,1000
-BENGMEE,FET,MEE,#2022,312500,16000,1000,4500,9000,3000,1000,20000,1000
-BENGMME,FET,MME,#2022,312500,16000,1000,4500,9000,3000,1000,20000,1000
-BSCBCH,FLS,BCH,#2022,214000,16000,1000,4500,9000,3000,1000,20000,1000
-BSCBOT,FLS,BOT,#2022,214000,16000,1000,4500,9000,3000,1000,20000,1000
-BSCHND,FLS,HND,#2022,214000,16000,1000,4500,9000,3000,1000,20000,1000
-BSCMCB,FLS,MCB,#2022,224000,16000,1000,4500,9000,3000,1000,20000,1000
-BSCPSB,FLS,PSB,#2022,214000,16000,1000,4500,9000,3000,1000,20000,1000
-BSCZOO,FLS,ZOO,#2022,214000,16000,1000,4500,9000,3000,1000,20000,1000
-LLB,FLW,LAW,#2022,657500,16000,1000,4500,9000,3000,1000,20000,1000
-BSCACC,FMS,ACC,#2022,312500,16000,1000,4500,9000,3000,1000,20000,1000
-BSCBAF,FMS,BAF,#2022,202500,16000,1000,4500,9000,3000,1000,20000,1000
-BSCBUS,FMS,BUS,#2022,282500,16000,1000,4500,9000,3000,1000,20000,1000
-BSCPUB,FMS,PUB,#2022,282500,16000,1000,4500,9000,3000,1000,20000,1000
-BSCCHM,FPS,CHM,#2022,264000,16000,1000,4500,9000,3000,1000,20000,1000
-BSCICH,FPS,CHM,#2022,264000,16000,1000,4500,9000,3000,1000,20000,1000
-BSCCSC,FPS,CSC,#2022,274500,16000,1000,4500,9000,3000,1000,20000,1000
-BSCIMTH,FPS,MTH,#2022,214000,16000,1000,4500,9000,3000,1000,20000,1000
-BSCMTH,FPS,MTH,#2022,214000,16000,1000,4500,9000,3000,1000,20000,1000
-BSCSTA,FPS,MTH,#2022,214000,16000,1000,4500,9000,3000,1000,20000,1000
-BSCAPHY,FPS,PHY,#2022,214000,16000,1000,4500,9000,3000,1000,20000,1000
-BSCPHY,FPS,PHY,#2022,214000,16000,1000,4500,9000,3000,1000,20000,1000
-BSCECO,FSS,ECO,#2022,232000,16000,1000,4500,9000,3000,1000,20000,1000
-BSCPOL,FSS,POL,#2022,198250,16000,1000,4500,9000,3000,1000,20000,1000
-BSCPSY,FSS,PSY,#2022,198250,16000,1000,4500,9000,3000,1000,20000,1000
-BSCSOC,FSS,SOC,#2022,198250,16000,1000,4500,9000,3000,1000,20000,1000
+code,faculty_code,department_code,tuition,edohis,union,access,notebook,sport,library,lmsplus,nuga
+CERT1,FAG,ANS,184000,16000,1000,4500,9000,3000,1000,20000,1000
+BAGRANS,FAG,ANS,184000,16000,1000,4500,9000,3000,1000,20000,1000
+BAGRCRS,FAG,CRS,184000,16000,1000,4500,9000,3000,1000,20000,1000
+BAGREES,FAG,EES,184000,16000,1000,4500,9000,3000,1000,20000,1000
+BAGRSOS,FAG,SOS,184000,16000,1000,4500,9000,3000,1000,20000,1000
+BAENG,FAT,ENG,198250,16000,1000,4500,9000,3000,1000,20000,1000
+BAFRN,FAT,FRN,198250,16000,1000,4500,9000,3000,1000,20000,1000
+BAHIS,FAT,HIS,198250,16000,1000,4500,9000,3000,1000,20000,1000
+BAISD,FAT,HIS,198250,16000,1000,4500,9000,3000,1000,20000,1000
+BAMAC,FAT,MAC,248250,16000,1000,4500,9000,3000,1000,20000,1000
+BAPHI,FAT,PHI,198250,16000,1000,4500,9000,3000,1000,20000,1000
+BARCS,FAT,RCS,198250,16000,1000,4500,9000,3000,1000,20000,1000
+BARST,FAT,RCS,198250,16000,1000,4500,9000,3000,1000,20000,1000
+BATMA,FAT,TMA,198250,16000,1000,4500,9000,3000,1000,20000,1000
+BSCANA,FBM,ANA,281000,16000,1000,4500,9000,3000,1000,20000,1000
+BMLS,FBM,MLS,554500,16000,1000,4500,9000,3000,1000,20000,1000
+BMLSCHMP,FBM,MLS,554500,16000,1000,4500,9000,3000,1000,20000,1000
+BMLSHBTS,FBM,MLS,554500,16000,1000,4500,9000,3000,1000,20000,1000
+BMLSHIST,FBM,MLS,554500,16000,1000,4500,9000,3000,1000,20000,1000
+BMLSMMCB,FBM,MLS,554500,16000,1000,4500,9000,3000,1000,20000,1000
+BSCNSG,FBM,NSG,666000,16000,1000,4500,9000,3000,1000,20000,1000
+BSCPHS,FBM,PHS,204000,16000,1000,4500,9000,3000,1000,20000,1000
+BSCPYS,FBM,PYS,204000,16000,1000,4500,9000,3000,1000,20000,1000
+MBBS,FCS,MED,786000,16000,1000,4500,9000,3000,1000,20000,1000
+BEDACC,FED,BED,214000,16000,1000,4500,9000,3000,1000,20000,1000
+BEDOTM,FED,BED,214000,16000,1000,4500,9000,3000,1000,20000,1000
+BEDSEC,FED,BED,214000,16000,1000,4500,9000,3000,1000,20000,1000
+BEDBIO,FED,CAI,214000,16000,1000,4500,9000,3000,1000,20000,1000
+BEDCHM,FED,CAI,214000,16000,1000,4500,9000,3000,1000,20000,1000
+BEDCSC,FED,CAI,214000,16000,1000,4500,9000,3000,1000,20000,1000
+BEDENG,FED,CAI,214000,16000,1000,4500,9000,3000,1000,20000,1000
+BEDFRN,FED,CAI,214000,16000,1000,4500,9000,3000,1000,20000,1000
+BEDMTH,FED,CAI,214000,16000,1000,4500,9000,3000,1000,20000,1000
+BEDPHY,FED,CAI,214000,16000,1000,4500,9000,3000,1000,20000,1000
+BEDPPE,FED,CAI,214000,16000,1000,4500,9000,3000,1000,20000,1000
+BEDSSE,FED,CAI,214000,16000,1000,4500,9000,3000,1000,20000,1000
+CAI,FED,CAI,214000,16000,1000,4500,9000,3000,1000,20000,1000
+BEDEDM,FED,EFM,214000,16000,1000,4500,9000,3000,1000,20000,1000
+BEDHIS,FED,EFM,214000,16000,1000,4500,9000,3000,1000,20000,1000
+BEDRSE,FED,EFM,214000,16000,1000,4500,9000,3000,1000,20000,1000
+EFM,FED,EFM,214000,16000,1000,4500,9000,3000,1000,20000,1000
+BEDECO,FED,GAC,214000,16000,1000,4500,9000,3000,1000,20000,1000
+BEDGAC,FED,GAC,214000,16000,1000,4500,9000,3000,1000,20000,1000
+BEDGEO,FED,GAC,214000,16000,1000,4500,9000,3000,1000,20000,1000
+BEDPOL,FED,GAC,214000,16000,1000,4500,9000,3000,1000,20000,1000
+BEDHED,FED,HKH,214000,16000,1000,4500,9000,3000,1000,20000,1000
+BEDHKE,FED,HKH,214000,16000,1000,4500,9000,3000,1000,20000,1000
+BEDPHE,FED,HKH,214000,16000,1000,4500,9000,3000,1000,20000,1000
+BSCLIS,FED,LIS,198250,16000,1000,4500,9000,3000,1000,20000,1000
+BEDAGR,FED,VTE,214000,16000,1000,4500,9000,3000,1000,20000,1000
+BEDHECO,FED,VTE,214000,16000,1000,4500,9000,3000,1000,20000,1000
+BEDTEC,FED,VTE,214000,16000,1000,4500,9000,3000,1000,20000,1000
+VTE,FED,VTE,214000,16000,1000,4500,9000,3000,1000,20000,1000
+BSCARC,FES,ARC,224500,16000,1000,4500,9000,3000,1000,20000,1000
+BSCBLD,FES,BLD,224500,16000,1000,4500,9000,3000,1000,20000,1000
+BFA,FES,FAA,198250,16000,1000,4500,9000,3000,1000,20000,1000
+BFAGRH,FES,FAA,198250,16000,1000,4500,9000,3000,1000,20000,1000
+BFAPNT,FES,FAA,198250,16000,1000,4500,9000,3000,1000,20000,1000
+BFASC,FES,FAA,198250,16000,1000,4500,9000,3000,1000,20000,1000
+BFATD,FES,FAA,198250,16000,1000,4500,9000,3000,1000,20000,1000
+BSCFAA,FES,FAA,198250,16000,1000,4500,9000,3000,1000,20000,1000
+BSCGEM,FES,GEM,198250,16000,1000,4500,9000,3000,1000,20000,1000
+BSCGRP,FES,GEM,198250,16000,1000,4500,9000,3000,1000,20000,1000
+BENGAGE,FET,AGE,312500,16000,1000,4500,9000,3000,1000,20000,1000
+BENGCIE,FET,CIE,312500,16000,1000,4500,9000,3000,1000,20000,1000
+BENGELE,FET,ELE,312500,16000,1000,4500,9000,3000,1000,20000,1000
+BENGIPE,FET,IPE,312500,16000,1000,4500,9000,3000,1000,20000,1000
+BENGMPE,FET,IPE,312500,16000,1000,4500,9000,3000,1000,20000,1000
+BENGPE,FET,IPE,312500,16000,1000,4500,9000,3000,1000,20000,1000
+BENGMEE,FET,MEE,312500,16000,1000,4500,9000,3000,1000,20000,1000
+BENGMME,FET,MME,312500,16000,1000,4500,9000,3000,1000,20000,1000
+BSCBCH,FLS,BCH,214000,16000,1000,4500,9000,3000,1000,20000,1000
+BSCBOT,FLS,BOT,214000,16000,1000,4500,9000,3000,1000,20000,1000
+BSCHND,FLS,HND,214000,16000,1000,4500,9000,3000,1000,20000,1000
+BSCMCB,FLS,MCB,224000,16000,1000,4500,9000,3000,1000,20000,1000
+BSCPSB,FLS,PSB,214000,16000,1000,4500,9000,3000,1000,20000,1000
+BSCZOO,FLS,ZOO,214000,16000,1000,4500,9000,3000,1000,20000,1000
+LLB,FLW,LAW,657500,16000,1000,4500,9000,3000,1000,20000,1000
+BSCACC,FMS,ACC,312500,16000,1000,4500,9000,3000,1000,20000,1000
+BSCBAF,FMS,BAF,202500,16000,1000,4500,9000,3000,1000,20000,1000
+BSCBUS,FMS,BUS,282500,16000,1000,4500,9000,3000,1000,20000,1000
+BSCPUB,FMS,PUB,282500,16000,1000,4500,9000,3000,1000,20000,1000
+BSCCHM,FPS,CHM,264000,16000,1000,4500,9000,3000,1000,20000,1000
+BSCICH,FPS,CHM,264000,16000,1000,4500,9000,3000,1000,20000,1000
+BSCCSC,FPS,CSC,274500,16000,1000,4500,9000,3000,1000,20000,1000
+BSCIMTH,FPS,MTH,214000,16000,1000,4500,9000,3000,1000,20000,1000
+BSCMTH,FPS,MTH,214000,16000,1000,4500,9000,3000,1000,20000,1000
+BSCSTA,FPS,MTH,214000,16000,1000,4500,9000,3000,1000,20000,1000
+BSCAPHY,FPS,PHY,214000,16000,1000,4500,9000,3000,1000,20000,1000
+BSCPHY,FPS,PHY,214000,16000,1000,4500,9000,3000,1000,20000,1000
+BSCECO,FSS,ECO,232000,16000,1000,4500,9000,3000,1000,20000,1000
+BSCPOL,FSS,POL,198250,16000,1000,4500,9000,3000,1000,20000,1000
+BSCPSY,FSS,PSY,198250,16000,1000,4500,9000,3000,1000,20000,1000
+BSCSOC,FSS,SOC,198250,16000,1000,4500,9000,3000,1000,20000,1000
