Real Estate Institute REINZ  {FSATPR1-4}


This report provide an output file that can be sent to a 3rd party, reporting on Student information and external subject code.

REINZ cannot receive student numbers that are longer than 7 characters.

The report has two output files, namely:
A standard report displaying the user selection, second output file location and summary information on what was selected.
A text (ASCII CSV) file that can be sent to the 3rd party using client available tools.

Before the user run this report validate the following:
The user must specified what is the external subject code as followed:
External Subject is defined in option {GOPS-21} and this rule use only the following fields.
External Body 3RP
External Code Type EWR
Internal Code *1
External Code *2
Description *3
*1   The Subject Code as define in option {SACAD-14}
Rules:
Records must exist for External Body 3RP External Code Type EWR
*2    The External Subject code
Rules:
This program will convert the subject code to the external subject code and use the external subject code in the second report.
*3    The Description of the External Subject
Rules:
Only the first 30 characters of the description will be used.

To save the second output file, the following is required:
In option {BATCH-7}, query the record where the subsystem is FIN and the function is ASEN.
The following is a example, of the record, and below are instructions that must be followed.
its_man_rep/fsatpr1-4r1i1.jpg

The Directory:
The full path from the rout directory. It must be on the same server as where Integrator is operating.
Users must has access to the directory, at lease read access.
The Suffix:
It is a ASCII CSV file and ITS recommend the suffix to be "csv".

The program will create the file name as follow:  The characters "ASEN" plus the system date in the format yymmdd, a dot and then the suffix.
Example:
If the run was on 29-Jun-2009, the file name will be ASEN090629.csv
The program will save the fill as followed, using the above definition:
/its/release/owndir/nz/ASEN090629.csv
On selection of the option, the system will prompt the user with a print menu and thereafter the following:
 
User Selection

Skip  to Prompt No
Prompt Text
* an item between square brackets [ ] is the default answer
Type
&
Length
Comments
  3rd Party Report Code (up to 10 times) A4x10 <List of Values> is available and the description will display.
If a null answer is encountered the system Skip to the next prompt.
3rd Party Code or ALL   [ALL] A4 <List of Values> is available and the description will display.
  Audit Trail Record Type (up to 10 times) A2x10 <List of Values> is available and the description will display.
If a null answer is encountered the system Skip to the next prompt.
  Start and End Academic Year   [ALL] N4x2
  Start and End Process Date DD-MON-YYYY
Address Must be (P)ostal or (H)ome      [P] A1
Phone Must be Work or Home (W/H)    [H] A1
 

Sort Order Per Comments
External Subject Code and Student information
  


System Select  
No special system selection


Example: First report if student number is longer than 7 characters..

its_man_rep/fsatpr1-4r2i1.gif


Example
: First report.

its_man_rep/fsatpr1-4r3i1.gif


Example: Second report.

its_man_rep/fsatpr1-4r4i1.gif




Processing
Rules
 
  No special processing rules


See Also:


History Of Changes

Date System Version By Whom Job Description
29-Jun-2009 v01.0.0.1 Ernie van den Berg t157364 New manual.