Copy Timetable Data {SPCOPY-5}   


This facility creates Department, Program and PCS 1.1 allocation {SPOPS-1b3, 4 & 5} from the Lecturing Timetable {STIME-2} where the Space category is a classroom or a laboratory (i.e. where the Space-Use Category is 1110, 1210, 1220 and 1230).

Sequence 2 Report - {SPOPSR1-14} - Invalid Subjects in Space Inventory.


Before this facility is used, ensure that the Lecturing Timetable {STIME-2} has been created and has no significant validation errors. 


NB: For a list of valid Space Categories, please refer to Table 1 in 'DoE Building and Space Inventory and Classification Manual'.


User Selection Prompt Text
* an item between square brackets [ ] is the default answer 		Type
&
Length		 Comments
Enter the Year to Copy YYYY   Defaults to the current Reporting Year
Include Buildings Excluded from Statistical Reporting {STG6MN-1}  [Y] A1   (Y)es or (N)o 
Is this a (T)rial or (U)pdate Run?  [T] A1
 

Sort Order Per Comments
    Building, Floor and then Room  


System Select  
 
  • It picks up the Building, Floor and Room as per the Timetable Periods and Roster records, active for the input year, linked to an active Space entry for the input year in the Space Inventory with "Space-Use Category" as 1110, 1210, 1220 and 1230.
  • For the picked up Building, Floor and Room combination, it selects the Subjects to Department records for the input year for the Department Allocation in the Space Inventory - block 3.
  • For the picked up Building, Floor and Room combination, it selects the Timetable records for the input year, where subjects are found, for the PCS 1.1 Allocation in the Space Inventory - block 5.


Example:

copy Timetable data




Processing
Rules		  
 
  • The program only deletes Department, Program and PCS 1.1 Allocation for the entry to be copied, and not all Space entries up front for the input year.
  • Thereafter new records are created for the input year.
  • Errors related to the Building, are only displayed one time per Building.
  • Based on the System Operational Definition for "Ignore Building to Asset Link for Hemis", the Building validates vs a defined Asset.
  • Effective Building Year is not required for Hemis reporting anymore. The Condition code on a Building linked to an Asset is now used.
  • For the relevant Building, Floor and Room combination, an entry is created with the Program as 110 (Formal Instruction) and the Percentage as 100 for the input year for the Program Allocation in the Space Inventory - block 4.
  • The percentage allocated to each subject is calculated by adding the amount of time used by that subject, divided by the total time spent by all subjects in that Space. 
  • The offering type and class group of a given subject are not taken into consideration.
  •  The report output only displays the exceptions if any, and all the totals at the bottom.


See Also:

History of Changes

Date System Version By Whom Job Description
29-May-2008 v01.0.0.0 Charlene van der Schyff t145483 New manual format.
27-Aug-2008 v01.0.0.1 Frans Pelser t146643 HEMIS Space Reporting
20-May-2009 v01.0.0.1 Charlene van der Schyff t158347 Edit language obtained from proof read langauge Juliet Gillies. Added Image.
04-Sep-2012 v01.0.0.3 Sister Legwabe T184319 Add subheading
07-Sep-2012 v01.0.0.3 Dinong Sereko T184319 System owner proof read
15-Jan-2015 v01.0.0.5 Suretha de Kock T190131  Include reference to Sequence 2, include the additional input parameters, enhance the System Select, Processing Rules and include the latest image that reflects the additional input parameters, current reporting year and the value of the SOD in the heading of the report output.
15-Jan-2015 v01.0.0.5 Dinong Sereko T190131 System owner proof read.