Update Data in HEMIS Table {HEMIS1-6}


This program can also be useful when quering the Namibian HEMIS data that currently lies in the database.

Any records inserted with {HEMIS1-1},{HEMIS1-2}, {HEMIS1-3} and  {HEMIS1-4}  or changes made in this option will be removed if the information is again extracted later by running {HEMIS1-1}, {HEMIS1-2}, {HEMIS1-3} and  {HEMIS1-4}.

 

Field Type
&
Length
Description
Calendar Year YYYY This is the HEMIS reporting year.
Table Code N10 The Table code of the HEMIS table.
For example, to query data from the
  • Student file, Table 2001
  • Subjects data, Table 2002
  • Staff Data, Table 2003
  • Space data, Table 2004 
Column Code N3 The column number as defined for the specific element in the HEMIS table.
Reference number A10 The number according to the reference field of the table. For example, if a specific student’s data is queried in the Student file, the student number can be entered in this field.
Sequence Number N10 This is a system-generated number that simply indicates in which position the specific record is found in the HEMIS data file. For instance, if the sequence number of a student in the Student file is 100, then the student appears as the 100th student in the HEMIS data for table 2001.
Field value A80 The value for the element in the specific year, table, column and reference number combination. This field is the only field that may be updated by the user. Note that any changes made to this field will be written away to a log file.



Example:


its_man_img/hemis1-6b1p1i1.jpg




History of Changes

Date System Version By Whom Job Description
05-Jan-2016
v03.0.0.0
Mmasadi Matseke
t205367
New manual
31-Mar-2017 v04.0.0.0 Thelma Komana T220228 New manual