Extract Namibia Space Data into Hemis Tables {HEMIS1-4}


This program may be used to extract Space Data for reporting to the Namiba Department of Higher Education.


User Selection Prompt Text
* an item between square brackets [ ] is the default answer 		Type
&
Length		 Comments 
1 Is this a (T)rial or (U)pdate Run A1  


System
Selection		  
1 Rooms from the Shadow Space Inventory {STG6MN-2} where the Building is not Excluded {STG6MN-1}, for each Room there will be a record in the file.
2 Only rooms where the Space Use Category is between 1100 and 1999 are included.


Processing
Rules
1 Data for the "Facility Database" as required by Namibia Department of Education is extracted from the ITS Integrator Space System and written to the HEMIS Table {HEMIS1-6}
2 The data for the extract can be identified with Table Code 2004 in {HEMIS1-6}
3 Existing data for the Table Code and Reporting Year will be deleted before data from this extract run is inserterd into the table.
4 For code values where the External Conversion Code {GOPS-21} is not set-up the "untranslated code" will be extracted. External Body "NMS" is used for all Code Conversions.
5 Although the Barcode Number (SCABAR) is a non-mandatory field if this field is NULL the records will not be insert into the HEMIS table (RAUHSD)


Example:
its_man_rep/hemis1-4r1i1.jpg


Sort Order Per Comments
1   Building Code
   
2
 Floor
  
3
 Room Number
  

Information included in the file

Table Code
 Column
  Element  Data obtained from
2004
 1
 Academic Year
 The reporting year
2004 2
 HEI Name
2004 3
 HEI Code
 Translated

FROM External Code
      {GOPS-21}
WHERE External Body
     =  'HMS'
AND External Code Type
     = 'INS'
AND internal Code = Institution Code
2004 4
 Campus Name
 The Name of the Campus linked to the Building {STG6MN-3}

FROM External Code
      {GOPS-21}
WHERE External Body
       = 'HMS'
AND External Code Type
       = 'CMP'
AND internal Code = Campus Code
2004 5
 Remote Campus / Centre
  
2004 6
 Space Use Category
 Space Use Category of the Room, Translated

FROM External Code
      {GOPS-21}
WHERE External Body
       = 'HMS'
AND External Code Type
       = 'SUC'
AND internal Code = Space-Use Category
2004 7
 Functional Category
 The first Program-field
2004 8
 Area
 The percentage of the Area used for the Functional Category




Others:

To be able to query the inserted data in HEMIS-4, the following data must be inserted as per script below

INSERT INTO rpt.rbctab (rbctable,rbcrow, rbcappqual, rbcdesc1, rbcdesc2, rbcver)   values (2004,1,'1','Academic Year','04X',1);
INSERT INTO rpt.rbctab (rbctable,rbcrow, rbcappqual, rbcdesc1, rbcdesc2, rbcver)   values (2004,2,'2','HEI Name','40X',1);
INSERT INTO rpt.rbctab (rbctable,rbcrow, rbcappqual, rbcdesc1, rbcdesc2, rbcver)   values (2004,3,'3','HEI Code','04X',1);
INSERT INTO rpt.rbctab (rbctable,rbcrow, rbcappqual, rbcdesc1, rbcdesc2, rbcver)   values (2004,4,'4','Campus Name','40X',1);
INSERT INTO rpt.rbctab (rbctable,rbcrow, rbcappqual, rbcdesc1, rbcdesc2, rbcver)   values (2004,5,'5','Remote Campus / Centre','10X',1);
INSERT INTO rpt.rbctab (rbctable,rbcrow, rbcappqual, rbcdesc1, rbcdesc2, rbcver)   values (2004,6,'6','Space Use Category','60X',1);
INSERT INTO rpt.rbctab (rbctable,rbcrow, rbcappqual, rbcdesc1, rbcdesc2, rbcver)   values (2004,7,'7','Functional Category','30X',1);
INSERT INTO rpt.rbctab (rbctable,rbcrow, rbcappqual, rbcdesc1, rbcdesc2, rbcver)   values (2004,8,'8','Area','10X',1);


Procedure

History of Changes

Date System Version By Whom Job Description
24-Aug-2015
 v03.0.0.0
 Bertha Kuwane
 t205357
 New manual
05-Oct-2015
 v03.0.0.0
 Dinong Sereko
 t205357 Proof read