JP2006164139A - Student ledger management method - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To provide a student ledger management method, which can uniformly manage academic grade and movement for students in a plurality of schools and link status of payment and restoration of scholarships to the information to manage them. <P>SOLUTION: A student support mechanism 1 is provided with a student ledger database 3, and an office 8 for admission procedures and a notification means 9 for notifying the student support mechanism 1 of information on admission, academic grade and movement for each student are provided for each of schools 2. The student ledger management method has a step for notifying the student support mechanism 1 of personal information created in the office 8, and a step for preparing columns for the students in the student ledger database 3, and filling school names and fiscal years into the columns for the students based on the personal information in the student support mechanism 1. In addition, the method also has a step for adding academic grades notified from schools to the columns for the students, a graduation writing step for adding graduation information notified from schools and fiscal years into the columns for the students, and a step for retrieving an arbitrary student from the student ledger database 3 to read out his/her academic grade or movement. <P>COPYRIGHT: (C)2006,JPO&NCIPI

Description

  The present invention relates to a student basic ledger management method that can collectively manage academic achievement, transfer, and graduation for students of a plurality of schools, and that can also manage the status of scholarship payment and return by linking to the information.

  Individuals such as students' names, dates of birth, addresses, etc. at schools (including 4-year and 2-year universities, high schools, compulsory education, full-time, part-time, and correspondence systems, including graduate schools and vocational schools) Information (personal information) that can be used to identify students is listed in the student register, and academic results (evaluation for each subject, number of credits acquired, special notes, etc.) and transfers (leave of absence, return to school, transfer, transfer, etc.), graduation It is generally done to add (graduation, withdrawal, death, etc.). In recent years, such a register is created as a database using a computer. Patent Document 2 and Patent Document 3 show the technology for issuing student ID cards to current students. By developing this technology, current students and graduates are able to obtain graduation certificates, transcripts, student certificates, etc. When an academic certificate is required, it is convenient to search the database with personal information and issue the academic certificate based on the read result.

  On the other hand, there are various supporters (corporates, foundations, public institutions, individuals, schools, etc.) that provide scholarships to students, and they receive scholarships upon application from students who require scholarships. Things have been done. Some scholarships do not require a return, while others require a return immediately after graduation or after a specified grace period. Scholarships are paid and returned by the supporters by creating a scholarship list. Although there is no prior art document related to this, it is convenient to create a database of the scholarship student list in the same way as the aforementioned student register list.

JP 11-259563 A Japanese Patent Laid-Open No. 10-3505 JP 2001-282935 A

  Conventionally, each school is an institution independent from other schools, and naturally, the school register list database is built for each school. Therefore, an application for issuing a certificate of educational attainment is also made to the school, and the school issues a certificate of educational attainment. Graduates who have already graduated and are in a remote area must claim their school in order to obtain an academic certificate. It is technically possible to digitize these procedures so that applications can be made and issued from a personal computer by accessing a window on the Web or from a proxy window such as a convenience store. However, in recent years, school consolidation has been accelerated as the student population has decreased. If a school disappears due to a closed school, past graduates will not be able to receive a certificate of educational attainment. This is becoming a social problem.

  In addition, since each school has owned and managed a school register list in the past, even if the above procedure is digitized, it is necessary to open an electronic contact point at each school, which is a waste of labor. Is big. As school scale shrinks as in recent years, there is a desire to reduce the cost required for the management of student lists and the issuance of academic records.

  In addition, since a school register list and educational certificate are conventionally created for each school, the educational certificate format (size of paper, format layout, and items to be written) varies from school to school. In this way, if the format of the educational certificate is mixed, it is difficult to make a comparison when collecting the educational certificate from a plurality of students and conducting a comparative examination by hiring personnel at a company.

  As described above, there are various problems in the conventional method for managing the academic achievement and transfer of students for each school. On the other hand, Patent Document 1 discloses a method for simplifying the issuance of a resident's card by registering personal information of local residents in a basic resident register for the entire country.

  However, applying the Basic Resident Register technology to the student register, it is possible to manage the academic achievements, transfers, and graduations of students from multiple schools at once. Since there is no organization that installs and manages databases, it is difficult to implement.

  In the field of resident management, based on the fact that residents move between local governments, only the code numbers, which are stable information, are managed in the Basic Resident Register regardless of the movement, and the resident's card and seal registration certificate are the destination. In the local government. On the other hand, students do not move between schools, but on the other hand, students' academic achievements, transfers, and graduations are constantly changing. It is an object of the present invention to collectively manage such changing information and unify certificates instead of being issued at each university. Because of these differences, the Basic Resident Register technology cannot be applied to the present invention.

  On the other hand, the problems related to scholarship are as follows.

  Supporters are independent of the school. Therefore, the scholarship list held by the supporter and the school register list are completely independent of each other. Even if they are the same person (that is, the same personal information), data as a scholar is recorded in the scholarship list, data as a student is recorded in the scholarship list, and the scholarship list cannot be referred to. For this reason, the supporter cannot grasp the academic achievement, and even if the scholarship is transferred or graduated, the supporter cannot grasp the change or graduation unless there is a self-report from the scholarship student. The lack of understanding of academic achievements, transfers, and graduations means that the current status of the scholars meets the prescribed scholarship payment conditions, or the current status of the scholars meets the prescribed scholarship return conditions and is eligible for return. It is not possible to know quickly and accurately whether or not. For these reasons, it is not preferable that the collection efficiency of the scholarship fund is reduced due to the delay in collecting the refund money.

  Also, in the management related to scholarship return, the current situation is that the supporter cannot grasp whether or not the person to be returned is currently in a state where it can be returned (for example, whether or not he / she is working). On the other hand, there are many people who have not found employment for a long time even after graduating from school, and it is difficult to return scholarships. For this reason, scholarship funding tends to be insufficient.

  Therefore, the object of the present invention is to solve the above problems, manage the academic achievement, transfer, and graduation of students from multiple schools at once, and link the information to manage the scholarship payment and return status. It is to provide a ledger management method.

  In order to achieve the above object, the present invention is provided with a student basic ledger database for storing student data in an independent student support organization that does not belong to any school, while enrolling in each of a plurality of schools. Admission procedure for notifying the above-mentioned student support organization of the personal information of the student prepared at the above-mentioned contact point and notifying means for notifying the above-mentioned student support organization of the entrance, academic achievement, transfer and graduation information of each student And a student registration step in which the student support organization opens the student column in the student basic ledger database based on the personal information and writes the school and the year the student entered into the student column. Based on the student's academic performance information notified from the above school, the grade entry step to add the academic performance to the student's column and the school A transfer writing step to add the student transfer information and year to the student column, a graduation writing step to add the student graduation information and year notified from the school to the student column, and optional A search step of searching the student column of the student basic ledger database to read out the academic achievement, transfer or graduation information of the student.

  The student support organization may have a step of applying for an educational certificate that accepts an application for an educational certificate, and an educational certificate issuing step of issuing an educational certificate based on the read result of the search step. .

  The student support mechanism may include a job notification step for receiving a notification of a job placement of the student and a job writing step for adding the notified job placement to the student column.

  The above-mentioned student support organization has a scholarship management database for storing scholarship student data, and the scholarship application step of notifying the student support organization of personal information about students who applied for scholarship in conjunction with the admission procedure at the above-mentioned counter, The student support organization uses the scholarship registration step to open the scholarship column in the scholarship management database based on the personal information, and the search step for the scholarship management database for the scholarship management database. A confirmation step to confirm the current status of the scholarship student (study results and transfer), and a scholarship of a predetermined amount if the current status of the scholarship meets the predetermined scholarship payment conditions each time a predetermined payment date comes A scholarship payment step to be provided.

  The above-mentioned student support organization has a return management database for storing data related to the return of scholarships, and the scholarship return conditions specified in the current situation by performing the above confirmation steps for scholars registered in the above scholarship management database The step of extracting the repayment target to extract the scholarship students satisfying the requirements (hereinafter referred to as the repayment target), the step of starting the repayment management to move the column of the repayment target from the scholarship management database to the return management database, and the above A refund request step for issuing an invoice requesting a return of a specified amount to a return target registered in the return management database at a specified time, and the refund money is received by the specified date after the invoice is issued Returned information (payment amount, non-payment period, balance of return, etc.) in the column of the subject of the return when it was not received or deposited It may have a return performance information update of step that burn them.

  Step of extracting defective return person for extracting return target person (hereinafter referred to as defective return person) whose return result has reached a predetermined defect standard based on the return result information recorded in the return management database, and its return There may be a step of writing a return failure for writing the return failure information in the column of the student (not returnable) of the student basic ledger database.

  The above student support organization has a guarantee fee management database for storing data related to guarantee fees, and guarantees based on the personal information of scholars who applied for guarantees in conjunction with the above scholarship application (hereinafter referred to as guarantee scholars). When performing the guarantee registration step to open the scholarship column in the guarantee fee management database and the above-mentioned scholarship payment step, refer to the guarantee fee management database and if the scholar is a guarantee scholar, the amount paid A guarantee fee replacement step of deducting the guarantee fee and accumulating the deduction amount in the guarantee fee management database.

  The above-mentioned student support organization is provided with a compensation right management database for storing data relating to compensation rights, and based on the return record information recorded in the return management database, the return target person who has reached the predetermined substitution repayment criteria (Hereinafter referred to as the debtor) extracting the debtor, recording the debtor column from the refund management database to the reimbursement right management database, and recording in the refund management database Transfer the remaining balance of the debtor's repatriation to the above-mentioned compensation right management database and record it as a debt amount, and the debtor in the column of the student (debtor) in the student basic ledger database. A debtor writing step of writing information indicating that the person is a creditor.

  The repayment request step for issuing an invoice for requesting repayment to the debtor registered in the above-mentioned compensation right management database at a predetermined time, and the debtor's debt amount when the repayment is received And a step of updating the repayment record information to be reduced.

  If the result of the above search step when the above step for applying for an educational certificate is performed and the student's column contains information about a bad return or debtor, cancel the above step of issuing the educational certificate You may have the step of a delivery stop.

  The present invention exhibits the following excellent effects.

  (1) Able to manage academic achievements, transfers, and graduations for students from multiple schools.

  (2) Scholarship payment and return status can be managed by linking to academic achievements, transfers and graduation information of students from multiple schools.

  Hereinafter, an embodiment of the present invention will be described in detail with reference to the accompanying drawings.

  FIG. 1 shows an outline of a student basic ledger management system using the student basic ledger management method according to the present invention.

  First, the social institutions (corporations, etc.) necessary for this student basic ledger management system and the hardware installed in each social institution will be explained.

  Necessary social institutions are supporters and schools. The supporter can implement this system by any supporter exemplified in the background art column. Here, the supporter is referred to as the student support mechanism 1. When this system is constructed in Japan, the student support organization 1 is preferably an independent administrative corporation under the control of the Ministry of Education, Culture, Sports, Science and Technology. The school can be any school illustrated in the background art column, but here, in order to simplify the explanation, only the university 2 is targeted. Although only one university 2 is written in FIG. 1, this represents one of a plurality of universities (preferably all universities are subscribed) that are subscribed to this system. The student S to be managed includes foreign students from overseas, but for the sake of simplicity, the student S is assumed to be a Japanese resident who has Japanese nationality. The member S 'is the same person as the student S.

  In the student support organization 1, a student basic ledger database 3, a scholarship management database 4, a return management database 5, a guarantee fee management database 6, and a remuneration right management database 7 are installed. Details of the stored contents (data) of these databases 3 to 7 will be described later. The guarantee fee management database 6 and the compensation right management database 7 are preferably provided in a separate management organization that is legally and economically independent from the student support organization 1.

  Although not shown in the figure, the Student Support Organization 1 provides various educational records such as a graduation certificate, a transcript, and a student certificate in a predetermined format (paper size, format layout, and written items). A printing machine capable of printing, printing various invoices such as reimbursement invoices, repayment invoices, etc., sealing these printed materials, and printing addresses is installed. Further, the student support mechanism 1 is provided with a management terminal device for the staff to manually search the databases 3 to 7 and to maintain and manage the databases 3 to 7. Furthermore, the student support mechanism 1 is provided with a communication device for performing data communication with a terminal device of each university and a terminal device of a business office described later while maintaining high security. Since these printers, management terminal devices, and communication devices can be general ones, details will not be described.

  In addition, a computer device that controls these databases 3 to 7 and executes each step of the present invention to be described later is installed in the student support mechanism 1, and a search engine for searching the databases 3 to 7 is installed in this computer device. Although installed, the computer device and the search engine have no particular characteristics and are not shown.

  Each university 2 is provided with a window 8 for applying for admission and applying for a scholarship, and a notification means 9 for notifying the student support organization 1 of various information about each student. The window 8 is a terminal device installed at a place where admission procedures are performed at each university. An electronic window for enrollment procedures on the web is also included. The notification means 9 is a terminal device installed in the management department of each university. The window 8 and the notification means 9 can also be realized by the same terminal device. The university 2 may be provided with the university-specific student register database 10 described in the background section, and may notify the student support organization 1 of various information extracted from the student register database 10. . However, for the purpose of reducing work and costs, it is preferable to configure the university 2 to access the student basic ledger database 3 of the student support organization 1 from time to time without placing the student register database 10 in the university 2. . In this case, for example, when a student card is issued at the university 2, data necessary for issuing the student card may be acquired from the student basic ledger database 3.

  Another social institution involved in the system is employment. Since people find employment at various places of employment, it is assumed here that the office 11 exists as a representative. The business establishment 11 is provided with a terminal device (not shown) for transmitting a request for issuance of an educational certificate and a notice of employment to the student support organization. The terminal device of the office 11 does not need to be equipped with special hardware and software for this system, and may be a general personal computer and communication software. This is because the procedure can be started by accessing the web page established by the Student Support Organization 1. In order to operate this system effectively, it is desirable to legislate so that the establishment 11 is obliged to obtain a graduation certificate when employing a person.

  Next, in the present system, since data input / notified in each terminal device and data recorded in each of the databases 3 to 7 have characteristics, each data will be described.

  As shown in FIG. 2, the data created at the window 8 includes admission procedures and personal information of students applying for scholarship. Personal information is information that identifies an individual student, and includes at least the name and date of birth. In addition, the student's current address, family register, dependent or guardian's name and contact information should be included in the personal information. In the admission procedure information sent from the communication means 9 to the student support organization 1, the university name (including the department, department, campus name, etc.) and the admission year are added to the personal information created at the window 8. The scholarship application information sent from the communication means 9 to the student support organization 1 is basically the same as the admission procedure information, but information related to the examination of scholarship certification such as the dependent's annual income may be added.

  As shown in FIG. 3, the data created at the university after admission includes information on academic achievement, information on transfer, and information on graduation. The academic achievement information includes at least the evaluation for each subject, the number of credits earned, and may include special matters such as award punishment. Information on academic achievement is notified to the student support mechanism 1 from the communication means 9 together with personal information when the evaluation at the end of the semester and at the end of the semester is finalized. The information on the transfer is information that represents a change in status such as a leave of absence, return to school, transfer to school, or transfer. Graduation information is information that shows changes in status such as graduation, withdrawal from school, or death. The transfer information and the graduation information are notified to the student support mechanism 1 from the communication means 9 together with the personal information at any time when the change occurs.

  Although not shown in the figure, as data to be sent from the establishment 11 to the Student Support Organization 1, data necessary for requesting the issuance of an educational certificate (personal information of the student to be employed, establishment name, etc.) and notification of where the student is employed Data (personal information, establishment name, assigned department, etc.).

  As shown in FIG. 4, the data recorded in the student basic ledger database 3 includes ID, student personal information, university name, entrance year information, academic achievement information, transfer information, graduation, etc. As well as information on employment, bad return, debtors, etc., which will be described later. During the admission procedure, registration is performed by opening a column for the student based on personal information, and at the same time the name of the university, the year of admission, etc. are written. After that, the search is performed mainly by ID or personal information, and information such as academic achievement, transfer, graduation, employment, poor return, debtor, etc. is added / updated as needed. The ID and personal information are used by being transferred to other databases described later.

  The personal information may be divided into personal unique information and attribute information. Personally-identified information is information that never changes, and includes birth date and gender (with exceptions). The attribute information is information that can change, and includes an address, name, family register, marital status, and the like.

  As shown in FIG. 5, the data recorded in the scholarship management database 4 includes the same ID, personal information, university name, and admission year as the student basic ledger database 3. When you apply for a scholarship, registration is done by opening the column for the scholarship based on your personal information. Information on scholarship payment results (payment amount, payment period, accumulated payment amount, etc.) can be added to the scholarship column in the scholarship management database 4 as needed. Since the scholarship management database 4 and the student basic ledger database 3 have columns having the same personal information, the data of the same person can be retrieved from both databases. However, it is necessary to consider that there are several people with the same family name and the same birth date. Therefore, if a link (linkage) is formed between the scholarship student column in the scholarship management database 4 and the student column in the student basic ledger database 3 at the time of registration, then any scholar in the scholarship management database 4 The student column of the student basic ledger database 3 can be easily and definitely searched. You may form a link using ID.

  As shown in FIG. 6, the data recorded in the return management database 5 includes the ID, personal information and university name, entrance year, scholarship payment results, etc. transferred from the scholarship management database 4. The scholars whose current conditions recorded in the scholarship management database 4 satisfy the prescribed scholarship return conditions will be eligible for return, and the scholarship student column in the scholarship management database 4 will be displayed in the return management database 5. Relocated as a column. Since the link between the scholarship management database 4 and the student basic ledger database 3 is maintained after the relocation, it is possible to search the student column in the student basic ledger database 3 for any return target in the return management database 5. it can. Information on invoice issuance results (billed amount, date, etc.) and return results (payment amount, non-payment period, return balance, etc.) are written in the return management database 5 column as needed.

  As shown in FIG. 7, the data recorded in the guarantee fee management database 6 includes an ID, personal information, a university name, and an entrance year. If you apply for a guarantee at the time of your scholarship application, you will be registered by opening the column for that scholarship student based on your personal information. In the guarantee fee management database 6, the amount of deduction and cumulative deduction are written as needed.

  As shown in FIG. 8, the data recorded in the recourse management database 7 includes ID, personal information and university name, entrance year, scholarship payment results, return results, etc. transferred from the return management database 5. . When the return record recorded in the return management database 5 reaches a predetermined substitution repayment standard, the return target person will thereafter become a debtor, and the column of the return target person in the return management database 5 is the reimbursement right management database 7. Will be relocated as a debtor column. Since the link between the refund management database 5 and the student basic ledger database 3 is maintained after the relocation, this link is used to store the relevant student column in the student basic ledger database 3 for any debtor in the compensation management database 7. Can be searched. Information on repayment invoice issuance results (billed amount, date, etc.) and repayment results (payment receipt date, debt amount, etc.) are written in the debtor column of the recourse right management database 7 as needed.

  In the present embodiment, the interest on the refund and the liability and the fee are omitted.

  Based on the system configuration described above, the operation of the student basic ledger management system of FIG.

  First, as a first case, a case will be described in which a student S performs admission procedures at the university 8 and does not apply for a scholarship.

  When the student S submits his / her name, date of birth, etc. to the window 8, the window 8 creates personal information based on the contents of the submission by the terminal device. The notification means 9 transmits information on the admission procedure of FIG. 2 to the student support organization 1 (admission procedure step). The student support organization 1 opens the student column in the student basic ledger database 3 based on the received personal information, and writes the school and the year the student entered into the student column as shown in FIG. As a result, student S is registered (step of student registration).

  Thereafter, as time passes, the notification means 9 of the university 2 notifies the student support organization 1 of the academic achievement information of FIG. In response to this, the student support organization 1 adds the academic achievement to the column of the student in the student basic ledger database 3 based on the notified academic achievement information of the student (the grade entry step).

  In addition, when the student S is changed, the notification means 9 of the university 2 notifies the student support mechanism 1 of information on the change of the student. In response to this, the student support mechanism 1 adds the notified change information and year of the student to the student column of the student basic ledger database 3 (transfer writing step).

  Similarly, the notification means 9 of the university 2 notifies the student support organization 1 of the graduation information of the student S when the student S graduates or withdraws. In response to this, the student support organization 1 adds the notified change information of the student and the year to the student column in the student basic ledger database 3 (graduation writing step).

  The addition of these academic achievements, transfer information, and graduation information is continuously performed while the student S is enrolled in the university 2, and is continued until graduation, withdrawal, etc., until the enrollment is completed.

  In the student support organization 1, the student column of the student basic ledger database 3 can be searched for an arbitrary student while the student S is enrolled in the university 2 or after the enrollment has ended. That is, it is possible to read out the academic achievement, transfer, and graduation information written in the student column (search step). The read academic achievements, transfers, and graduation information represent the current status of the student at that time.

  The student S who is currently enrolled or who has been enrolled in the past can issue a certificate of educational background to the Student Support Organization 1 at any time personally or through the university. Also, the establishment 11 where the student S is going to find employment can make a request for a certificate of education to the student support organization 1. FIG. 1 shows an example performed by the office 11. In response to this, the student support organization 1 accepts a request for issuance of an educational certificate (step for applying for an educational certificate). In this step, some method for certifying that the person who has issued the request for grant is the principal, but this is omitted in the present embodiment. In other steps, data security is omitted.

  In the student support mechanism 1, the search step described above is performed, and the academic achievement and transfer information of the student S is read from the student basic ledger database 3. Based on the read result, an educational certificate is printed in a predetermined format by a printing machine (not shown) and is issued (educational certificate issuance step). At this time, there are different types of academic certificate, such as a graduation certificate, a transcript, a student certificate, etc., and the contents to be filled in are different. Since necessary information is recorded, necessary information for each type may be taken out from the information and used for printing.

  In this way, the educational certificate is issued by mail to the requester (business establishment 11 in the example of FIG. 1). In addition, when a university issues a certificate of education individually as in the past, the presidential seal is stamped on the certificate of education, but in this system, the Student Support Organization 1 issues a certificate of education, so The student support organization head seal is imprinted on. In order to guarantee the authority of this seal, it is desirable that the student support organization 1 is authorized by law. The educational certificate also requires a forgery prevention measure, which is omitted in this embodiment.

  Thereafter, when the student S is employed in the business establishment 11, the business establishment 11 or the student S himself / herself notifies the student support organization 1 of the place of employment. The student support mechanism 1 inputs the notified job placement to the terminal device (step of job placement notification). Then, the student support organization 1 adds the notified job placement to the student column in the student basic ledger database 3 (step for writing job placement). When the job is added, when the search step is subsequently performed, the current situation of the student, the event of finding employment and the place of employment can be found in addition to the above-mentioned academic achievement and transfer information.

  Next, as a second case, a case where student S applies for admission procedures and scholarship at the counter 8 of the university 2 will be described. The admission procedure is the same as in the first case. At window 8, personal information created in the admission procedure is used for scholarship application. In addition, certification examination information will be created at the counter 8 for scholarship applications. The notification means 9 transmits information on the scholarship application in FIG. 2 to the student support organization 1 (scholarship application step). Based on the received scholarship application information (personal information and accreditation information), Student Support Organization 1 opens the scholarship column in the above scholarship management database (scholarship registration step). Actually, only the student S who has been certified through the certification examination becomes a scholar, but the certification examination is omitted in the present embodiment.

  At this time, preferably, the student support organization 1 forms a link between the scholarship student column in the scholarship management database 4 and the student column in the student basic ledger database 3 (linking step). Here, a link (linkage) is a one-to-one correspondence between a group of data in the scholarship management database 4 and a group of data in the student basic ledger database 3, and the other is automatically specified. It is to be decided on. Briefly, a serial number is assigned each time the student S is registered in the student basic ledger database 3, and the scholarship management database 4 can be linked by using the serial number of the student basic ledger database 3 as it is.

  After that, the Student Support Organization 1 uses the above-mentioned search steps for the scholars in the scholarship management database 4 using the personal information or links, and the current status of the scholars (study results, transfers, graduation, etc.) Can be confirmed (confirmation step). As a specific example, the student S of the name and date of birth can be confirmed on the day of confirmation, what grade or already graduated and which course unit has been acquired with which evaluation.

  The Student Support Organization 1 provides a predetermined amount of scholarship every time a predetermined payment date comes, if the current status of the scholarship student satisfies a predetermined scholarship payment condition (scholarship payment step). The scholarship payment conditions are matters determined by the Student Support Organization 1 as an artificial arrangement, and will not be described in detail. For example, if the student is absent from school, the payment will be stopped. These conditions may be converted into data in a format that can be compared with the academic achievement, transfer, and graduation information in the student basic ledger database 3.

  In this way, scholars can receive scholarships. When a scholar graduates, graduation is written as graduation information in the student's column of the student basic ledger database 3 by the above-mentioned graduation writing step. Therefore, the scholarship payment conditions are not established in the scholarship payment step, and the payment is made. Stopped.

  When a graduated graduate student finds a job, the steps for applying for an academic certificate, the step for issuing an educational certificate, and the step for notifying a place of employment are performed. Accordingly, the place of employment is written in the student column of the student basic ledger database 3. In FIG. 1, a student S who has found a job is indicated by a member of society S '.

  The student support organization 1 extracts the scholars whose current conditions satisfy the predetermined scholarship return conditions (hereinafter referred to as eligible for return) by performing the confirmation steps described above for the scholars registered in the scholarship management database 4. (Steps for extracting returnees). The scholarship return condition is a matter determined by the Student Support Organization 1 as an artificial arrangement, so it will not be described in detail. For example, graduation and employment are employed, and the job type is not a public employee or a faculty member. These conditions may be converted into data in a format that can be compared with the information on the change in the student basic ledger database 3 and the information on the place of employment.

  In the student support organization 1, the column of the person to be returned is moved from the scholarship management database 4 to the return management database 5. This effectively means that return management has started for the returnee. (Return management start step). Even if the scholarship has been stopped for scholarship due to graduation, scholars whose employment is not decided will not be extracted in the above-mentioned return target extraction step. It is not relocated to 5, but remains in the scholarship management database 4.

  The student support organization 1 issues an invoice for requesting a return of a predetermined amount to a return target person registered in the return management database 5 at a predetermined time (step for requesting a return). The invoice is delivered to the person to be returned (worker S 'in FIG. 1) by mail or the like. When the person to be returned pays to a predetermined financial institution, an event of the deposit is transmitted to the student support organization 1. In the Student Support Organization 1, after the invoice is issued, if the refund is not received by the predetermined date or when the refund is received, the return management information (payment amount, unpaid) Write the period, the remaining balance, etc.) (Return result information update step).

  When the return proceeds smoothly and the return subject returns the full amount, the return balance in the return management database 5 becomes zero. At this time, the student support organization 1 deletes the column of the return target who achieved the full refund and writes the full refund in the student column of the student basic ledger database 3.

  However, the scholarship return does not always go smoothly. Therefore, the student support organization 1 extracts a return target person (hereinafter referred to as a defective return person) whose return result has reached a predetermined defect standard based on the return result information recorded in the return management database 5 (returned return person). Bad person extraction step). The defect standard is a matter determined by the student support organization 1 as an artificial agreement, so it will not be described in detail, but technically, the defect standard may be converted into data in a format that can be compared with the return result information.

  The student support organization 1 writes the information of the return failure in the column of the student (failed return) of the student basic ledger database 3 by using the personal information about the return failure or using the link described above. Step). Since the employment base is recorded in the student basic ledger database 3, when a return failure is written, the office 11 may be notified by referring to the information on the employment place. In addition, when a poor returnee changes his / her job, if the step of applying for a certificate of educational attainment or the step of notification of employment is performed, a new job will be immediately identified. Is possible.

  Here, it is possible to take strong measures such as stopping the issuance of a certificate of educational attainment for poor returnees. That is, as a result of the search step that is performed when the step of applying for the educational certificate is performed, if the student's column contains information on the bad return or the debtor, the step of stopping the grant is executed. In the grant stop step, the student (requester) is refused to issue a certificate of educational attainment and is strongly urged to return or repay. If an educational certificate is not issued, the student will be disadvantaged for employment, etc., so it can be expected that the return or repayment will be promoted.

  In this way, it is possible to perform a more proactive reminder than a normal return request by extracting defective returnees. However, if the return is still delayed, a substitute payment from the funding source will be made for the purpose of preserving the scholarship funding source. That is, the student support organization 1 extracts a return target person (hereinafter referred to as a debtor) whose return record has reached a predetermined substitution payment standard based on the return record information recorded in the return management database 5 (hereinafter referred to as a debtor). Extraction step). The substitution repayment standard is a matter determined by the student support organization 1 as an artificial agreement, so it will not be described in detail, but technically, the substitution repayment standard may be converted into data in a format that can be compared with the return performance information.

  In the student support organization 1, the column of the debtor is transferred from the refund management database 5 to the reimbursement right management database 7 (step of application for substitute payment). At the same time, the remaining balance of the debtor recorded in the refund management database 5 is transferred to the compensation right management database 7 and recorded as a debt amount (step of executing proxy payment). The scholarship supply and return explained so far was the money in and out of the scholarship funding source, but here the substitute payment from the funding source was made separately. Therefore, the balance of the refund becomes zero and the refund is completed.

  However, on the other hand, the student support organization 1 has a right to reimburse, and the debtor is liable. The student support organization 1 writes information that the debtor is a debtor in the student (debtor) column of the student basic ledger database 3 using the personal information or the link described above (step for writing the debtor). Since the student support organization 1 becomes a right holder, it is possible to take a more proactive recovery measure than the above-mentioned reminder for poor returnees based on its legal position.

  Thereafter, the student support organization 1 issues an invoice for requesting repayment to the debtor registered in the compensation right management database 7 at a predetermined time (repayment request step). If the repayment money is received, the student support organization 1 reduces the debt amount of the debtor in the compensation right management database 7 (repayment record information update step). This step continues until the debt amount is zero.

  Subrogation is one way to conserve scholarship funding, but this system also preserves scholarship funding in another way—guaranteed. That is, in the student support organization 1, for scholarship students who applied for guarantees at the time of scholarship application (hereinafter referred to as guarantee scholars), the guarantee fee management database 6 is assigned to the guarantee scholarship column based on the personal information. (Warranty registration step). Thereafter, each time the scholarship is paid, the guarantee fee management database 6 is referred to, and if the scholar is a guarantee scholar, the prescribed guarantee fee is deducted from the amount paid and the deduction amount is deducted into the guarantee fee management database. Accumulate (step of replacement of guarantee fee).

  As a result, for guaranteed scholars, the guarantee fee is accumulated from the time the scholarship is paid until it is stopped. Guarantee scholars who have accumulated guarantee fees in this way will be accumulated even if they are eligible for return, even if the refund is not received by the due date due to the circumstances of the returnee during the scholarship return process. The refund can be withdrawn from the guarantee fee. Therefore, the return target person who provided the guarantee can be avoided from becoming a defective return person. On the other hand, the student support organization 1 will continue to proceed smoothly.

  This completes the description of the operation of the student basic ledger management system of FIG. The advantages of this system are as follows.

  Since there is a basic student ledger database for storing student data in an independent student support organization that does not belong to any school, it is designed to store student data from multiple schools (preferably all schools). Not only the simple effect of digitizing the procedures related to the issuance of books, but also the great advantage of being able to issue a certificate of educational attainment even if the school that graduated disappears due to the consolidation of the school.

  It is possible for the school to manage the school register list, issue the certificate of educational background, and reduce the expenses required for it.

  Since the Student Support Organization will issue educational certificates for all schools, it will be possible to unify the format of the educational certificate, and when conducting a comparative examination by collecting educational certificates from multiple students, such as hiring personnel at companies Makes comparisons easier.

  For the scholars in the scholarship management database, the current status of the scholars can be checked from the student basic ledger database, so whether the current status of the scholars meets the scholarship payment conditions or whether the current status of the scholars It will be possible to quickly and accurately know whether or not the scholarship return conditions have been met. As a result, the operational efficiency of the scholarship funding source is improved.

  Since the returnee and debtor's place of employment can be tracked from the Student Basic Ledger Database, it is possible to reliably make a request for return or repayment.

  Since the guarantee fee is deducted from the scholarship payment amount and stored, even if the returnee is temporarily unable to return, the return proceeds smoothly. As a result, scholarship funding sources can be preserved.

  The scholarship funding source can be preserved because the subrogation from the funding source is made separately.

  Next, in the student basic ledger management system of the present invention, the appearance of events related to scholars is shown in FIG.

  First, the applicant submits an application (# 1) to the student support organization to receive a scholarship. In response to this, the Student Support Organization will review and if OK, you will be registered as a scholar. If it is not OK, it is irrelevant to FIG. 9, and the description will be continued only in the case of OK. In normal cases, scholarships will continue to be provided (# 2) until the academic background of the scholarship expires.

  When the scholarship's academic background has expired and the scholarship has been paid, it will wait for the return to begin. If the current situation meets the specified scholarship return conditions, such as obtaining a stable income from employment, the scholar will be eligible for return. When an agreement on the return plan is obtained between the return target person and the student support organization, a return requesting action (# 3) is started in accordance with the return plan. The person to be refunded returns the specified amount by bank transfer etc. according to the refund request (# 4). If this return goes smoothly and the return expires, it will not proceed to the next step.

  If an accident (no return) occurs during return (# 5), a reminder (# 5-1) or substitute arrangement (# 5-2) is made to the return subject. If there is a return in response to the reminder, the flow returns to # 3 and # 4 again. However, if there is no response to the reminder, the process proceeds to substitute arrangements.

  Substitute payment is filed after receiving the substitute arrangement (# 6). Substitution payment is paid after examination of substitution payment (# 7). This turns the receivables into recourse rights.

  Next, a recourse right is charged (# 8). The debtor must make a payment (# 9) for the claim for recourse. If an accident occurs again (# 10), that is, if the debtor does not pay, it will be beyond the scope of the student basic ledger management system of the present invention, so no further explanation will be given.

  On the other hand, the occurrence of an accident (# 5, # 10) is fed back to the student basic ledger database (# 11). Then, when an application for a certificate of education is applied from the person (accident) or his / her agent (for example, a company seeking a certificate of employment to hire the person), it is refused (# 12 ).

  Regarding the above events # 1 to # 12, the steps executed by the student basic ledger management system of FIG. 1 are as described above.

  Next, more specific embodiments of the databases 3 to 7 will be described.

  The plurality of databases 3 to 7 described so far can be realized by one large integrated database obtained by integrating them. The integrated database is provided with a plurality of large categories of data types called masters, and a small category of data types called tables belonging to the respective masters, so that data belonging to the tables can be stored in the respective tables. .

  FIG. 10 shows the structure of all data for one student in the integrated database. In addition, since it is not the applicant's intention to comprehensively disclose all of the data actually used, only a few names are given for the master, table, and raw information (FIG. 11).

  As shown in the figure, the data of one student is divided into a plurality of masters such as an individual basic master, a class basic master, a scholarship class master, a return class basic master, and a billing history master. Of these, the scholarship master is assigned a larger category of “scholarship”. In addition, multiple masters below the return type basic master are grouped into a larger category called “return”. Each master is assigned a unique abbreviation.

  The individual basic master is divided into a plurality of tables such as individual basic information, personal address name history information, and work place information. The school basic master is divided into a plurality of tables such as school basic information and account information. Other masters are also divided into one or more tables. Each table is assigned a unique table ID.

  A single table can store a plurality of elementary information, which is the minimum unit of information. For example, as shown in FIG. 11, the table of personal basic information includes a loan type code, a scholarship class code, a scholarship year, a scholar serial number, a scholarship number CD, a scholarship class code, a scholarship kanji name, and a scholarship kana. It is possible to store more than tens of items of elementary information such as name and name for scholarship search. In addition, as shown in FIG. 12, the basic information table includes numbers such as loan type code, scholarship type code, scholarship year, scholar serial number, scholarship number CD, scholarship key number X, scholarship combination number, etc. More than ten items of elementary information can be stored. Each elementary information defines the type, the number of digits, and the like.

  As can be seen from these examples, the same raw information is not prevented from being stored redundantly in different tables.

  Various types of information described with reference to FIGS. 4 to 8 are stored in appropriate tables of the integrated database in FIG. 10 in the form of raw information in FIG. In each step of the present invention, raw information is newly added to, read from, or updated in these tables.

It is a schematic diagram of the student basic ledger management system using the student basic ledger management method of this invention. It is a data block diagram which shows the content of the data produced at the window in the student basic ledger management system of FIG. It is a data block diagram which shows the content of the data produced in a university after entrance in the student basic ledger management system of FIG. It is a data block diagram which shows the content of the data recorded on the column of one student in the student basic ledger database of FIG. FIG. 2 is a data configuration diagram showing the contents of data recorded in one scholarship column in the scholarship management database of FIG. 1. It is a data block diagram which shows the content of the data recorded on the column of one return object in the return management database of FIG. FIG. 2 is a data configuration diagram showing the contents of data recorded in one guarantee scholar column in the guarantee fee management database of FIG. 1. It is a data block diagram which shows the content of the data recorded on the column of one return object person in the compensation right management database of FIG. It is a figure which shows event generation in this invention. It is a data structure figure for one student in the integrated database used for this invention. It is the figure which gave a part of elementary information stored in the personal basic information table used for this invention. It is the figure which gave a part of elementary information stored in the student basic information table used for this invention.

Explanation of symbols

1 Student Support Organization 2 University 3 Basic Student Ledger Database 4 Scholarship Management Database 5 Return Management Database 6 Guarantee Fee Management Database 7 Reimbursement Rights Management Database

Claims (10)

  It is equipped with a basic student ledger database for storing student data in an independent student support organization that does not belong to any school. On the other hand, each school has a contact point for enrollment procedures, and each student's entrance and academic achievements. And a notification means for notifying the student support mechanism of the information on the transfer and graduation, and a step of admission procedure for notifying the student support mechanism of the student's personal information created at the window, and the individual at the student support mechanism. Based on the information, the student registration step is opened in the student basic ledger database and the student's enrollment school and school year are written in the student column, and the student's academic results notified by the school Based on the information, add the academic achievement to the student column, the grade entry step, and the student's transfer information and year notified from the school. Step of transfer writing to be added to the column, step of graduation writing to add the student's graduation information and year notified from the school to the column of the student, and the student in the student basic ledger database for any student And a retrieval step of retrieving information on the student's academic achievement, transfer, or graduation by searching the field of the student basic ledger management method.   The student support organization has a step of applying for an educational certificate to accept an application for an educational certificate, and an educational certificate issuing step of issuing an educational certificate based on the read result of the search step. The student basic ledger management method according to claim 1.   3. A job notifying step for receiving a notification of a job placement of a student at the student support mechanism, and a step of writing a job placement for adding the notified job placement to the student column. The student basic ledger management method described.   The above-mentioned student support organization has a scholarship management database for storing scholarship student data, and the scholarship application step of notifying the student support organization of personal information about students who applied for scholarship in conjunction with the admission procedure at the above-mentioned counter, The student support organization uses the scholarship registration step to open the scholarship column in the scholarship management database based on the personal information, and the search step for the scholarship management database for the scholarship management database. A confirmation step to confirm the current status of the scholarship student (study results and transfer), and a scholarship of a predetermined amount if the current status of the scholarship meets the predetermined scholarship payment conditions each time a predetermined payment date comes A student basic ledger management method according to any one of claims 1 to 3, further comprising a scholarship payment step.   The above-mentioned student support organization has a return management database for storing data related to the return of scholarships, and the current status confirmed by the above confirmation step for scholars registered in the above scholarship management database satisfies the prescribed scholarship return conditions. Steps for extracting scholarship students (hereinafter referred to as repayment targets), repayment target extraction steps, repayment management start steps for moving the repayment subject column from the scholarship management database to the return management database, and the return A refund request step for issuing a bill requesting a refund of a specified amount to a return target registered in the management database at a specified time, and the refund money will be deposited by the specified date after the invoice is issued When there was no deposit or payment, write down the return record information (payment amount, non-payment period, return balance, etc.) Student Basic Book management method according to claim 4, characterized in that it has a writing of return record information update step.   Step of extracting defective return person for extracting return target person (hereinafter referred to as defective return person) whose return result has reached a predetermined defect standard based on the return result information recorded in the return management database, and its return 6. The student basic ledger management method according to claim 5, further comprising a step of writing a bad return for writing bad return information in the column of said student (bad return) for said bad student.   The above student support organization has a guarantee fee management database for storing data related to guarantee fees, and guarantees based on the personal information of scholars who applied for guarantees in conjunction with the above scholarship application (hereinafter referred to as guarantee scholars). When performing the guarantee registration step to open the scholarship column in the guarantee fee management database and the above-mentioned scholarship payment step, refer to the guarantee fee management database and if the scholar is a guarantee scholar, the amount paid 7. The student basic ledger management method according to claim 4, further comprising a step of subtracting the guarantee fee and replacing the guarantee fee by accumulating the deduction amount in the guarantee fee management database.   The above-mentioned student support organization is provided with a compensation right management database for storing data relating to compensation rights, and based on the return record information recorded in the return management database, the return target person who has reached the predetermined substitution repayment criteria (Hereinafter referred to as the debtor) extracting the debtor, recording the debtor column from the refund management database to the reimbursement right management database, and recording in the refund management database Transfer the remaining balance of the debtor's repatriation to the above-mentioned compensation right management database and record it as a debt amount, and the debtor in the column of the student (debtor) in the student basic ledger database. And a debtor writing step for writing information indicating that the person is a debtor. Student basic ledger management method.   The repayment request step for issuing an invoice for requesting repayment to the debtor registered in the above-mentioned compensation right management database at a predetermined time, and the debtor's debt amount when the repayment is received 9. The student basic ledger management method according to claim 8, further comprising a step of updating the repayment record information to be reduced. If the result of the above search step when the step for applying for a certificate of educational record is performed and the student's column contains information on bad return or debtor, cancel the above step of issuing the certificate of educational record 9. The student basic ledger management method according to claim 6 or 8, further comprising a step of stopping delivery.

Images