red1.org

[Gan MH]

1. Study and analyst existing Microsoft Access System that handle college academic structure so that the new system covers all functionalities in the existing system. The college academic structure and operational is the most important part to be developed and customized in the new system.

2. The new system must have custom views and a reporting engine. The Report Engine must be able to output report in multiple formats such as PDF, MS Excel, etc. There must be a dynamic web interface for Client to customize and generate their report accordingly (fix report/pre-defined report, user request report). Client will provide all existing report templates for customization in the new system. There should be a Reporting Module that allows access to all reports in the system.

3. There will be a total migration (database, interface, output screen, etc) from existing System to the new web-enabled system. Client will provide Vendor with a MS Access Database with some sample data.

4. Proper User Requirements Study sessions need to be carried out in order to map out all gaps and analyst/define all possible system specifications. This new system will be configured and setup based on input and analysis from both parties.

5. The system must be flexible enough to support changes in subject. For example adding and/or removing of a subject in a course.

6. Training and documentations will be provided so that the system is less Vendor or individual centralized

7. For Class Time-Tabling module, classroom, students and lecturer must be unique value in the database.

8. Requirement study and changes will not be limited to only 16-days requirements study period. It will be carried out until delivery and sign-off at each progress check point.

9. All members in this project is required to register at red1.org and make use of the forum as an electronic platform for User Requirements Study, comment, demo, etc.

10. A COMBO drive is recommended to be used for backup purposes. System administrator shall perform daily data backup into CDs. When any emergency happen, there is always a one-day fall back database to recover from. Two (2) servers are recommended, one as the LIVE server and another one as backup server.

11. Windows 2000 Server is the preferable server application.

12. Change in Payment Schedule:

Down Payment – RM15,000.00
First Progress Check Point – RM15,000.00
Second Progress Check Point – RM 15,000.00
Third Progress Check Point – RM 15,000.00
End of 6 months Support Period – RM9,000.00

[Gan MH]

En Khairin has passed me the MS Access database and I have uploaded the MDB to the FTP server ( refer to http://www.red1.org/forum/viewtopic.php?t=399 ). The existing MS Access system is a combo of Student Registration, Student Details & Profile, College Program (Internal & UPM), Report, Testimonial, etc. En Khairin will further explain and clarify the system flows in the forum.

Apart from this, En Khairin will also prepare a MS Word document whereby the entire system flow will be described on a separate module basis. The document will consist of sample screenshots together with write-ups indicating the functionalities and flows of each module. We have both agreed that the document will be delivered in phases and module basis (from next Tuesday onwards), in order to ensure the efficiency of the requirements study process. One issue is being highlighted whereby En Khairin indicated that the new system should allow querying of student record for report printing. We have agreed that such requirement should be properly documented in the forum. At the meantime, En Khairin will start to post in his requirement on the new system from time-to-time.

Due to short of time, I was not able to setup MECCA in En Khairin’s PC. However, I have passed him the necessary installers (Tomcat 5, JDK 1.5, MySQL 4.1, MySQL Query Browser and MECCA Source) and showed him the developer forum at SourceForge.net. He will try out those installers before our next trip to Cybernetics next Wednesday. In fact, I am suggesting that we shall allow En Khairin to install MECCA SIMS Portal in their new server.

I have also met En Shahidi and he was inviting us for another trip to Cybernetics College next Wednesday (4-May-05). I shall call up Cybernetic College to confirm our next trip by next Tuesday (3-May-05).

[Gan MH]

We have went through a status meeting with Shahidi and team members on 3-June-2005 (Friday). In the meeting, we clarified and made the project progress and deliverables visible to both parties. It is understood that we are beyond schedule whereby we have completely tackled the first milestone. In addition to that, we have also tackled part of the second and fourth milestones.

Khairin and team members are to test and sign-off the deliverables based on the UAT document given. They shall then feedback their comment on the UAT document or in the forum. We shall then handover and provide training on the first milestone (module setup and system configuration).

There is a new feature, "repetitive / out-of-schedule student study period" identified while implementing the first milestones. Besides, the reporting tool is ready with standard capabilities. The new feature and a reporting formatter will be implemented as a future milestone with training on customizing report layout and format.

Apart from that, we will start preparing for the next milestone, whereby specifications for other modules (class-timetabling module, DSA module, bursary module, library module, ) have to be mapped out. A meeting with individual HOD has been fixed tentatively on 8-June, to discuss and document all processes and workflows for other modules. For the library module, we will prepare the workflow for Cybernetics to verify.

Khairin has also requested a re-migration on 14-June. That should be the official system checkpoint whereby all data entry activities will be done parallel on both the new and old systems. Any data entry activity will be printed out and documented for verification purposes. We will handover the migration program and provide them with appropriate training.

Hardware specification has also been discussed. They have decided to go for DELL server package with minor upgrades in memory (2GB), COMBO Drive, etc. We will also assist and guide their LINUX expert in setting up the new system.

[Gan MH]

We have met the persons-in-charged in the meeting with Shahidi and team members on 8-June. They are Cik Rafiza of Hal Ehwal Pelajar/Co-Curriculum Department, Mohd Zaimi of Bursary Department, and Zulkefli Mansor of Class Timetabling/Scheduling Department. We have discussed on the 2nd milestone deliverables.

Cik Rafiza has handed over some materials (process flows, sample screenshots, sample data on bayaran) for DSA Modules. We will start analysis and development activities right away and it is targeted 3 weeks towards UAT activitiy.

The Library Management Module is not far from a general library management system with functionalities such as carian buku, pinjaman buku, pemulangan buku, kategori buku, kadar dendaan, dll. There are currently more than 5000 books available. We have also discuss on future integration with bar code sensor.

We shall provide training to marketing personal on the Admission module whereby the marketing team will be given an admission form to capture potential student into the system. The Academic Department will then run a vetting rule scheme to filter and register student into the college.

It is being suggested a preset rules engine for the Class Timetabling Module Rules whereby the person in charged can define rules for class room allocation. The system will then auto populate a suggested class schedule based on the pre-set rules. Workflow for class timetabling module shall be workout by En Zulkefli.

En Mohd Zaimi will workout the detailed workflow for bursary module. The potential for a student to have double/tripple financial (MARA, PTPTN, KWSP) is being highlighted. The Bulsary Module shall allow output of report by financial bodies.

[sbahrin]

Below are list of tables from the MDB files that are being migrated
to the MECCA database:

1) Migration is has been DONE

MAKLUMAT-PERIBADI PELAJAR
KOD-PROGRAM
KOD-SENARAI KURSUS
2001 - Aturan Ses


2) Needed for migration

STATUS-KURSUS-SEMASA
STATUS-KURSUS-DROP
STATUS-KURSUS-TERDAHULU

As requested by En Khairin, Sam has listed out all the table involve in the migration activities. The listing above gives a picture on which table actually requires double data entry on both the old and new system during the parallel test run, before the re-migration activity. -- Posted by Gan

[Gan MH]

Both Khairin and I agreed on 13-July-2005 as the official check point for data re-migration. The latest MS Access DB, as of 13-July-2005, is available at http://www.red1.org/barn/Cybernetics/smp2001(13July05).zip

Since Cybernetics still having heavy registration activities in this coming 2-weeks period, Kharin will re-send the database in another 2 weeks time. This time, We shall ONLY import data for newly registered students after July 13. Khairin will also note down in details if there is any other change in other tables, we shall import any specific change based on the detailed information given. After that, all new data shall be keyed-in manually.

I have provided a 1-hour training session to their webmaster, En Fikri, covering most of the Portal look-and-feel customization and configuration activities, such as CSS implementation, header-footer design, HTML Content Module, Portal Template, Module Configuration and so forth.

I have also setup the mecca-tomcat package at their new server, which runs on Windows XP environment. The Cybernetics SIMS is now accessible for the entire Local Area Network through the new server.

I have also showed all out latest development to En Khain. At the same time, I also clarified some issues on Bursary Module with En Ibrahim and En Khairin. I shall post it tonight under the Bursary Thread.

[sbahrin]

I've done the data migration from the mdb files into the MySQL cybernetics database, and create a database dump named cybernetics.sql.

Use the cybernetics.sql to restore the database to a new location, ie. at the Cybernetics Server.
Pls. follows below instructions:

1. Copy cybernetics.sql into MySQL\bin folder.
2. Open command prompt, and go to MySQL\bin directory.
3. Execute this command:

C:\MySQL\bin>mysql cybernetics < cybernetics.sql

[Gan MH]

On 21-July-2005 (Thursday), Red1 and I again visited Cybernetics for a progress meeting. We demonstrated to Khairin all latest developments including of:

i. Integration between Pre-Registration Module and Bursary Module
ii. Fee Structure-Program Configurator that supports Compulsory and Additional Fee Charges
iii. Batch Invoicing by Program and Individual Invoicing by Semester
iv. Issue of Additional Invoice for Individual Semester
v. Integration between Invoice, Payment and Statement of Account in Bursary Module

Khairin also passed us a sample Claim Form/Statement to MARA and a sample Summary Slip from PTPTN. The claim limit as mentioned previously will not bring any issue as long as the Payment Module supports FIFO payment.

[red1]

We are setting for a progress review today or tomorrow on Bursary & Academic, another progress review on Time Table and DSA 2 weeks from now, and a final completion review end of this month.

These reviews are necesary to understand more changes required rather than set too many specs in hardcodes.

Shahidi agreed to this and setting next month as implementation to live.

[Gan MH]

The items below show the technical agenda for progress meeting dated August 11, 2005.

1. To demonstrate how the Bursary Module will adapt into CICT daily business operations.
2. Fee Structure Setup, Registering Student thru to the final Payment.
3. Financial Assistance Claim/Payment Procedures, signing-off before coding.

PART I – Setup Program Fee Structure (Improved)

1. Select a Program and Setup the Fee Structure for Individual Intake Session
2. Check out Fee Structure Report to view Fee Structures of a Program for ALL Intake Sessions

PART II – Pre-Register Student through Quick Payment Window (New)

1. Select Program and Intake Session
2. Enter Simple and Relevant Information
3. Register and Print Receipt
4. Check out Invoice Window, Payment Window and Statement of Account Window to confirm credit in Student Account.

PART III – Register Student into System Permanently by Academic Department (New)

1. Retrieve Pre-Registered Student List in Student Enrolment Window
2. Select a Student from the List
3. Enter Complete Student Data and Confirm Registration
4. Check out Student Statistic Window to study Intake VS Program Statistical Information

PART IV – Invoice Newly Registered and/or Existing Student(s) (Improved)

1. New Student(s): System auto-invoice all Student(s) that pre-registered through Quick Payment Window
2. Existing Student(s): Batch Invoicing and/or Individual Invoicing
3. For Batch Invoicing: Goto Batch Create Invoice Window, Identify Selections and Generate Invoice in Batch.
4. For Individual Invoicing: Goto Create Individual Invoice Window, Select a Student and Invoice according to Individual Semester.

PART V – Receive Payment (Improved)

1. Receive Student Payment and Entered Data into System
2. Key in Amount of Payment based on FIFO basis
3. Check out Account Statement to confirm Payment credited into Student Account
4. Please refer to PART VII below to finalize Claim Payment Process Workflow

PART VI – Multiple Student Academic Account (Matric No) (New POC)

1. Register the same Student in two (2) different Program of Study
2. Check out Payment Window to Identify this Particular Student has two (2) different Academic Account (Matric No)

PART VII – Finalizing New Specifications for Financial Assistance Claim/Payment Workflow

1. Financial Assistance informs claim amount available based on Program, Intake, and Study Session
2. CICT generates in batch ALL Claim Statements as per amount specified by each Financial Assistance
3. CICT prints ALL generated Claim Statements and sends to individual Financial Assistance
4. Financial Assistance transfers Total Amount of Money together with a Students List Summary Slip
5. CICT updates System by generating batch Payments and Receipts according to the Summary Slip received
6. CICT prints out ALL Receipts and distributes to relative Students

Note:
i. Since the Claim Amount available is the same for ALL Students Account under the same Financial Assistance, the system shall allow quick batch claiming simply by:
a. Identifying a particular Financial Assistance
b. Selecting Students of a Particular Program, Intake Session and Study Session
c. Keying in the specified Claim Amount
d. Generating Claim Statement in batch
e. Printing out ALL generated Claim Statements

ii. Since CICT receives a Total Sum of Claim Amount and a Students List Summary Slip, the system shall allow quick batch payment:
a. Identify a particular Financial Assistance
b. Select Students of a Particular Program, Intake Session and Study Session
c. Identify and Check relative Student Account in the listed according to the Students List Summary Slip
d. Confirm Payment and auto-generating of Receipts
e. Print out ALL generated Receipts

[red1]

Mr Ibrahim stressed on the importance of Part V, 2 and must be simplified for idiot input so that immediate non-hassle free payment is done on FIFO basis.
After that Gan and me brainstormed to have a consistent screen layout which Gan can do as the VM is separate from the coding in Velocity 3-tier system.
We will also use color background to denote the importance or category of user, i.e. pinkish for clerk, bluish for Kharin, greyish for Finance Director.
Ibrahim request us to finish the core registration & payment process latest for live use by this Aug 24 during their next intake. He said that we can mop up small details when the users provide feedback during actual use.

I have resolved the logic on paper of the Direct FIFO action and am ready to code them this morning.

[Gan MH]

The important items in order for Bursary Module to GO LIVE on August 28, 2005 are:

1. Pre-Registration DONE
2. Auto-Creation of Invoices DONE
3. Ability to Create Invoice to Financial Assistance
4. Payment and Receipt FIFO and simplification in Progress
5. Reports
- Receipt Amount by Receipt No. and Date
- Invoiced Amount by Invoice No. and Date
- Details of Payment by Sponsor and Cash
- Details of Outstanding by Sponsor and Cash

Gan, pls post screenshots of reports and any VM for easy reference

[Gan MH]

I have put all screenshots onto paper. Now I am transferring it into html pages. Currently I am doing Khairin's View in Bursary Module. Once I finish, I shall publish those screenshots in parts.

[Gan MH]

En Khairin is ok with the screen designs. He also made some personal opinions on those screens. He will assist us in clarifying any further change on those screen designs with En Ibrahim. Further changes on Interface Designs can easily be done after deployment, once the workflow and fuctionalities being agreed.

Due to viruses and spywares attacked, I have to reinstall MECCA SIMS package in CICT server. I've installed anti-spyware and anti-virus in CICT server and gone through a thorough scan. Database as of 23-August-2005, has again being re-migrated. I have also gone though with Encik Fikri on system backup activities.

Due to serious virus attack, En Khairin has re-formatted CICT server on September 23, 2005. I also managed to assist him, though the use of Yahoo Messenger, setting up the MECCA package and Tomcat JVM.

[Gan MH]

En Khairin and I were trying to setup the academic module. We found new change need to be made to the Academic Session module. There are only 2 main Intake Sessions (May and November) at CICT. Students coming in during other Intake Session (February, August, etc) are actually following the same study path for main Intake Session.

Example:

SEM 1 - May 05/06
SEM 2 - August 05/06
SEM 3 - November 05/06
SEM 4 - February 06/07
SEM 5 - May 06/07
SEM 6 - August 06/07

The study path above is incorrect. August 05/06, February 06/07 and August 06/07 are special Intake Sessions. The correct study path should be:

SEM 1 - May 05/06
SEM 2 - November 05/06
SEM 3 - May 06/07
SEM 4 - November 06/07
SEM 5 - May 07/08
SEM 6 - November 07/08

If a student coming in during August 05/06 Intake Session, his study path should then be:

SEM 1 - August 05/06 (special intake session with short semester 1)
SEM 2 - November 05/06
SEM 3 - May 06/07
SEM 4 - November 06/07
SEM 5 - May 07/08
SEM 6 - November 07/08

We then proceed to setup the Program Structure. However, we failed to do so because the system could not display CICT programs properly. I doubt this is caused by problem in database migration activity. We then continued to setup Subjects-Program Relationship and assign Subjects to Program Study Period. En Khairin will assign one of the staff to finish off these settings by tomorrow. I shall go over tomorrow to restore the database and clarify detailed specifications for Academic Module.

En Ibrahim might drop by his office tomorrow, therefore I might be able to go through those screen designs with him.
read by red1. U must have gone thru with Sam, since i saw u in KLCC with him yesterday evening. Tonight i hope to visit Sam to help in some codings.

[Gan MH]

I managed to demo the Bursary Module screen designs to En Ibrahim and En Khairin. We need to do some minor changes (mainly due to some process flows) but overall he seems ok with the screen designs.

We will need to change our plan. We will kick start the Academic and Registration Modules for this coming Saturday 0508 Intake Session. From there, we shall move into the Bursary Module by next week. Instead of migrating 100% to the new system, we are using 0508 short semester as the test/study case. If there is any failure to the system, we can easily trace and troubleshoot 0508 student data.

Therefore, Sam or/and Red1 need to:
1) solve the scenario as I reported in
2) add additional layer for Kharin to define available program for individual Intake Session (not all program available, only 7 active programs at the moment)

I will drop by Cybernetics tomorrow. Together with En Khairin, we will setup the Academic Module for seven (7) active programs only. On Saturday, Khairin will start keying in new student data (we will not use pre-registration module at this point, since it is integrated with Bursary Module). Next week, they will practice the entire registration process including the Pre-Registration Module.

I shall post details of our discussion later tonight.

[red1]

From yesterday's meeting we had with Mr Ibrahim and his staff, some of the changes i see i m able to try to get up this week are:

1) Special First Payment Window without MatricNo or Enrollment details. Later the student will decide on the details.
In the Enrolment module we search for such student by ICNO and select his Intake and Program, then Generate his MatricNo and create the Invoice for his active semester.

[red1]

We have set this Thursday 1pm for demo of our changes to Mr Ibrahim. This list is priotised from above post.

Gan can test the Intake_code system and Sponsor Module with Sam's guidance and Sam has to post the steps for Gan to follow.

Then priority of tasks for demo are:
1) Explain how to get Intake_Code system in Display, Reporting, Fee-structure, Program-structure. (Sam) At present cannot prove to client. Sam will do this after demo. Meanwhile we tackle reporting and display by intake_code
2) Batch Invoice Generation to follow above post and showing proper intake_code DONE -red1
3) Changes stated above that has visual impact, i.e. auto intake/date, bypass not necessary steps (red1 with Sam to advice) (Gan pls fill in which u feel are in this category)
>If selection is single result then go straight to that selection. DONE for Payment Window since its more relevant...red1
>ICNO, Name Search DONE for PreReg, Payment screens - red1
> PreReg & Payment Screens - Print Receipt showPDF directly and not thru VM DONE! Payment - using getReceiptNoDetails.vm, Pre-Reg same vm, new button. For demo still show PDF, later we direct to printer. - red1
> Default Intake Month to current month DONE with Sam's advice - red1
> Fee Structure Report to analyse by intake_code have to wait for intake code system - red1
4) Sponsor Invoice Generation - red1 solved 2 bugs, so now can generate, Gan, pls test

After demo
4) Sponsor Batch Payment (red1)
5) Invoice List report (red1)
6) Prepay Pre-registration without enrolling (red1)
7) FIFO to allow negative overpaying balances (red1)
8 ) Receipt direct print (Sam)


We have to explain to client that the after demo stuff is not vital for usage now.

We meet LRT Masjid Jamek, 11am tomorrow to have about 1 hr to test further on our notebooks before showing at 1pm.

[Gan MH]

Below are bugs in first round enhancements:

Fee structure (mecca.sis.billing.FeeStructureModule)
1. Unknown column 'i.intake_code' in 'field list' (may have to create field. click on the error line to see which table stated by codes)
Done, add field 'intake_code' in fee_structure_program table

Pre-registration noted, not vital (mecca.sis.preregistration.action.PreRegistrationMainModule)
1. If back on browser and submitt again, record duplicated *
2. Date should follow server date instead of local PC date?
3. For Name Search and IC No. Search, Enter on keyboard does not work.

Student Batch Invoice (mecca.sis.billing.BatchInvoiceGenerateModule)
1. Date should use date_select_read.vm? (replaced)
2. Program field in generated result shows $status.program_code (maybe didnt synch well with CVS)
re-synch and update back but still look the same

Student Individual Invoice (mecca.sis.billing.StudentInvoiceGenerateModule)
1. Date should use date_select_read.vm? (replaced)
2. Try generate invoice for sem1 > sem2 > sem1 (repeat few times), invoice numbers messed up *
3. Delete invoice shows: Table 'cybernetics.s_invoiceline' doesn't exist

Receipt and Payment (mecca.sis.payment.action.PaymentMainModule)
1. Search shows: Unable to find resource 'vtl/sis/view/payment/search_delegate.vm' (sent to CVS)
2. For Name Search and IC No. Search, Enter on keyboard does not work.
3. Creating new invoice in Student Individual Invoice module (mecca.sis.billing.StudentInvoiceGenerateModule) will create new student record in payment window. Eg: For Student A, create his sem1, sem2, sem3 invoices. Do a search in Payment window, you will see there are total of three (3) student A records. Solved, StudentInvoiceGenerateModule.java to avoid when Fees.isEmpty. Creation of Invoice also takes IntakeCode from create_invoice.vm - red1

Sponsor (mecca.sis.bursary.SponsorModule) and Invoice Sponsor (mecca.sis.bursary.SponsorInvoiceModule)
1. Gone thru and seems no bug, will tidy up VMs. (good to make this look nice, cos its sumtin new) - in general the above bugs seems ok here, except the back and submit again prereg... will do it after demo within the codes to aviod duplicate recs
re-synch-ed back, added fields 'intake_code' and 'session_id' in intake table
2. jrxml file seem not in correct format / layout (u mean u wana adjust or its a bug?)
Not sure of individual sponsor invoice format, need to ask for sample. I think one of them is listing style and another one is three (3) students per slip

[Gan MH]

After demo on 24-Oct-2005, En Ibrahim agreed the system should GO LIVE after Raya holiday around 7 or 8-Nov-2005.

We collected latest databases from Khairin. No further update until final migration and setup on the database. Here are the latest databases from Khairin:

1. MS Access DB (http://www.red1.org/barn/Cybernetics/smp2001(23August05).zip)
2. CICT server SQL DB (http://www.red1.org/barn/Cybernetics/cybernetics211005.rar)

For further data which need to be migrated from MS Access database, check out at: http://red1.org/forum/viewtopic.php?p=2788#2788


Further changes need to be done:

1) Refund module
- allow refund process data entry of individual student (refundable amount, cheque no. and confirm)
- Populating of refund list (by sponsor, by program)

2) Fee copy function, setting of a fee structure as default template - OPTIONAL

3) In receipts.jrxml, add account balance to show refundable or outstanding amount.

4) Group all setup utilities modules into one (1) Setup Section – Invoice No. Format, Receipt No. Format, Fee Structure Setup, Student-Sponsor Setup, etc - DONE

5) Group all reports into one (1) Report Section – Financial Report, Fee Structure Report, Refund Report, etc - DONE

6) Completion of Student Status module – if a student deferred, his/her intake batch remains same but study session change. Therefore, the fee structure remains but program structure change, which Khairin can add/remove subject in Student Subject module.

7) Sponsor Invoice module has to support changing amount for different student. Search for student and key-in individual student sponsor invoice amount in a different window.

8) Adjustment module to allow account personnel to audit student account, cancel receipt and re-issue a new receipt. In receipt printout, show the word “reissued again” for re-issued receipt.

9) For Student-Sponsor Setup module, identify certain group of student -> list of student without sponsor -> select student type (MARA, PTPTN, Others, Cash) -> submit. There should be a search student features to search for a particular student and modify his/her entitled sponsor.

10) Report Module
- Add selection of student type (MARA, PTPTN, Others, Cash) beside the report selection drop-down list, to view report of different student type
- Add current semester for all reports
- Preferable to add bucket analysis for Report of Outstanding Amount (30days, 60days, 90days columns for individual student)

11) Interface for creating new Intake Code

[Gan MH]

During yesterday trip to Cybernetics, we setup the latest system (as of 24-Nov-2005) in CICT server, which including of: 1) Migrated data; 2) vtl/sis folder 3) action folder; 4) mecca2.jar; and 5) reports folder.

I also showcased progress to Khairin and had a short discussion with him. After that, we proceeded with a short training session with En Zaimi at the Bursary office. A simple tutorial, downloaded from MECCA website is also handed to En Zaimi for his reference.

En Zaimi and his colleague will test run the Bursary Module, setting up fee structures, creating invoices and receipts, and providing feedback while experiencing the system with real-time bursary processes. On our side, we need to complete other gaps (from the previous meeting) within this 1-week time. Sam is to complete the migration activities, student status module; and prepare for the library module. Other parts Red1 will be looking at it.

Cybernetics is targeting the next intake on December 3, to be fully utilizing the system. So, the system MUST be ready to pre-register, invoice, accept payment and print receipt for Intake 0512 before December 3. Khairin also mentioned that Cybernetics will only invoice sponsor by next January.

[red1]

Shahidi called to set next tuesday, 2nd January, 12 noon as demo meeting with Ibrahim.
He also wanted to show a better Library System on the 15th to the Ministry for acredition. The feedback from the librarian is that its too simple and has forwarded a new workflow for us to incorporate by then. I told him we will pick up the workflow during that meeting but there may be not enuf time to incorporate that and its gud enuf from my opinion. Anyway we will try to do that.

[Gan MH]

Below show report on tasks done during our visit to Cybernetics on Jan 3, 2006

1. Transfer the latest MECCA package:
a- Mecca2.jar – DONE
b- Vtl folder – DONE
c- Action folder – DONE
d- Library folder - DONE

2. Add new field(s) to MySQL live db:
a- “Cancel” field in "student_receipt_detail" table – DONE

3. Add new data using database metadata in “fee_structure_program” table - DONE
fee_code | fee_description | fee_id
overpay | OVERPAY BALANCE | overpay
refunded | | refunded

4. Make adjustment to MECCA live settings:
a- Enable Pre-Registration window for user role “bursary_hod” view - DONE

5. Backup and keep a copy of the live MySQL db – DONE

6. Update users with updates on respective sections:
a- Khairin, overall system functionalities – DONE
b- Chief Librarian, Library Module – DONE
c- Zaimi, Bursary Module – N/A
d- Shahidi, overall progress – N/A (updated in previous meet up)
e- En Ibrahim, bursary module and overall progress – N/A (meeting postponed to Jan 9, 2006, 2.30pm)

7. Clarify specs and business rules:
a- Student Status, Khairin - DONE
b- Brought Forward Balance table for migration, Khairin – DONE
c- Library Module, Chief Librarian – DONE

[red1]

yesterday's meeting also we discussed with Khairin on the Student Status module to review the invoicing rule in it:

1) When defer do not charge for that semester.
2) During the following semester charge student according to his fee structure, not his new batch intake.
3) But his subject structure follows the new batch he joined.
4) May need to incorporate PAID field in Status table to know if student was invoiced before he defer in the middle of semester.

Khairin said that there are about 2% such cases, and we wont touch Student Status until the logic for above is done. In about a week.

[Gan MH]

Below is the report on tasks done during visit to Cybernetics on Jan 9, 2006

1. Transfer the latest MECCA package:
a- Mecca2.jar – DONE
b- Vtl folder – DONE
c- Library folder - DONE

2. Add / repair data using database metadata:
a- refunded | REFUNDED TO STUDENT | refunded in “fee_structure_program” table - DONE
b- balance | BALANCE B/F | balance in “fee_structure_program” table - DONE
c- balance | balance | balance in “session” table - DONE

3. Update users with updates on respective sections:
a- Khairin, overall system functionalities – DONE
b- Chief Librarian, Library Module – N/A
c- Zaimi, Bursary Module – DONE
d- Shahidi, overall progress – N/A
e- En Ibrahim, bursary module and overall progress – N/A (presentation postponed)

There are 2 things highlighted by Zaimi:
1- There shouldn’t be any receipt created for zero amount during pre-registration
2- Statement of Account must allow record(s) search as in the Payment Module