Copy New Record into Hemis Table   {HEMIS-3}


This program was written for one specific purpose, namely to be able to add an extra record for personnel members who have more than one personnel SAPSE category in a specific HEMIS year.  The program was not intended to allow the user to add any type of additional data to any HEMIS file, although it will allow the user to insert a new record at the end of any HEMIS file.  Obviously, care must be taken when inserting a record, since inserting data in only one HEMIS file might cause that file to be out of sync with the other files.


The program inserts a new record for the year and table given as input parameters.  The record will use the reference number given as input for the “Reference number” field in the HEMIS data, and will take the “Sequence number” field to be one more than that of the last record currently in the relevant table.  Note that a NULL (empty value) is inserted in the “Field” field of the HEMIS record. 

The idea is that this option simply creates a new record with the correct values completed the year, table, column, sequence number and reference number fields and that the user can then use {HEMIS-4} to type in the correct values in the “Field” for the new record.

The following output is given to show the user what sequence number was selected for the newly inserted record and to confirm both that all column values were created and that the insert was written to the logfile.

The program runs a report as follows:
 
User Selection Prompt Text
* an item between square brackets [ ] is the default answer 		Type
&
Length		 Comments
  Enter the Calendar Year for HEMIS Data.
N4  
  Enter the Table Number to insert . N4  
  Enter the Reference Number for which a new record is inserted. A10  
 

Sort Order Per Comments
   Per column, the sequence number and column numbers inserted.
   



System Select    
   No special system selection.


Example:  of Summary Report

hemis summary




Processing
Rules		   
   No special processing rules.





See Also:



History of Changes

Date System Version By Whom Job Description
29-May-2008 v01.0.0.0 Charlene van der Schyff t145486 New manual format.
15-Jul-2008 v01.0.0.0 Magda van der Westhuizen t149068 Update manual - Language Editing.