Copy Office Allocation {SPCOPY-4}  

This facility creates Department, Program and PCS 1.1 allocation {SPOPS-1b3, 4 & 5} from Personnel where the Space category is an office (i.e. where the Space-Use Category is 1310).

Sequence 2 Report - {SPOPSR1-12} - In-service Personnel with Invalid or Inactive Space.
Sequence 3 Report - {SPOPSR1-13} - Active Space Without Any In-service Personnel linked to it.


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 
 

Sort Order Per Comments
  Building, Floor and then Room  


System Select  
 
  • It picks up the Building, Floor and Room as per a Personnel Service record, active for the input year, with the FTE (Full Time Equivalent) value not equals to 0, linked to an active Space entry for the input year in the Space Inventory with "Space-Use Category" as 1310 (Office).
  • For the picked up Building, Floor and Room combination, it selects the Personnel Posts 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 Personnel PCS Detail records for the input year for the Program Allocation in the Space Inventory - block 4.
  • For the picked up Building, Floor and Room combination, it selects the Personnel Academic Timesheet records for the input year, where subjects are found, for the PCS 1.1 Allocation in the Space Inventory - block 5.


Example:

its_man_rep/spcopy-4r1i1.jpg




Processing
Rules		  
 
  • The program will only delete 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.
  • 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.
10-May-2009 v01.0.0.1 Ernie van den Berg T156945 Review the manual
20-May-2009 v01.0.0.2 Charlene van der Schyff T158347 Edit language obtained from proof read language Juliet Gillies. 
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.
02-Oct-2012 v02.0.0.0 Sister Legwabe F186084 Add additional information for clients and change screen.
22-Oct-2012 v02.0.0.0 Dinong Sereko T186084 System owner proof read.
27-Jan-2015 v02.0.0.1 Suretha de Kock T204796  Include reference to Sequence 2 and 3, include the additional input parameter, enhance the System Select, Processing Rules and include the latest image that reflects the additional input parameter, current reporting year and the value of the SOD in the heading of the report output.
27-Jan-2015 v02.0.0.1 Dinong Sereko T204796 System owner proof read.