(NLD) Managing the BRON Interface

This chapter provides an overview of BRON and discusses how to:

• Set up the BRON interface.

• Set up NT2 for BRON.

• Set up BRON prior education.

• Create and send the BRON file.

• Review the BRON file before sending.

• Manage BRON return file processing.

• Manage GBA data.

• Manage BRON snapshot files.

Understanding BRON

Regional Education Centre (Regionaal Opleidings Centrum or ROC) institutions must exchange data regarding students and their enrollment and exams in an electronic format with Base Register Education (Basis Register Onderwijs or BRON), a data register managed by Information Maintenance Group (Informatie Beheer Groep or IBG). Once you have set up the interface, the Dutch as a second language course (Nederlands als tweede taal or NT2), and prior education for BRON, perform the following steps to fulfill BRON requirements:

1. Create the BRON export file.

2. Review the export file before sending.

3. Send the batch file to BRON.

4. Import the BRON return file and update the export holding table.

5. Make changes to data regarding students and their enrollment and exams in your system and re-send the changes to BRON.

6. Compare GBA data with data in the application and update tables if necessary.

7. Import and review snapshot files to determine whether BRON is sending the Dutch funding council (Centrale Financien Instellingen or CFI) accurate, up to date data.

8. After you update the export holding table based on the snapshot file, re-send the export files to BRON, if necessary.

See Also

(NLD) Indicating Student Paper Information

Setting Up the BRON Interface

To set up the BRON interface, use the BRON Setup component (SAD_BR_INST_NLD).

This section discusses how to:

• Define BRON setup.

• Set up BRON by sector.

• Set up BRON programs.

Pages Used to Set Up the BRON Interface

Defining BRON Setup

Access the BRON Setup page.

Institution	Enter the institution for which you want to set up for BRON.
BRINcode	Select a BRINcode for this institution. Define BRINcodes on the BRINcode Table page. BRINcodes are allocated by the IBG. They identify schools or locations within an institution.
Location	Enter a code for this location and BRINcode. The location code is a code that has been set up by the institution to identify the delivery point. You assign the code yourself and then provide this information to BRON so BRON can recognize the delivery source within the institution. Note. An institution can have more than one delivery location.
Int Org Nbr (internal organization number)	Enter an internal organization number to identify the organization that is responsible for the delivery to BRON. This information is sent in the BRON interface, but it is not used by BRON. This is for informational purposes only.
PVE Version	Enter the PVE version of the IBG requirement document used.
Name Type	Enter the name type for the data that is delivered to BRON.
Address Type	Enter the address type for the data that is delivered to BRON.
Name Type GBA	Enter the name type for the automatic update of GBA data.
Address Type GBA	Enter the address type for the automatic update of GBA data.

Setting Up BRON by Sector

Access the BRON Setup by Sector page.

Educational Sector	Enter an educational sector. There are three educational sectors: Education, Professional Education, and VAVO. You must set up each sector. You run the BRON Delivery process for each education sector.
Start Date and End Date	Enter the start and end dates for this education sector within this institution and BRINcode. When you run the BRON Delivery process, the process will only find students who were matriculated during the dates that you enter here.
Hand Sel (handicap select)	Select how you want the BRON Delivery process to determine if students are handicapped. Select one of the following options: Attribute: Select if you want the BRON Delivery process to determine if students are handicapped by using attributes. Enter the student attribute that is used to indicate handicapped students in the Student Attribute field. Disability: Select if you want the BRON Delivery process to determine if students are handicapped by a check box on the Disability page at Workforce Administration, Personal Info, Disability, Disabilities. Studentgrp (student group): Select if you want the BRON Delivery process to determine if students are handicapped by using student groups.
Student Attribute	If you select Attribute in the Hand Sel field, enter the student attribute that is used to indicate handicapped students here.
Risk student value	Select the student attribute that you want to use to indicate when a student is at risk of being turned down for funding for a program.
Careers by Sector - Academic Career	Select the academic careers that are within this educational sector. The BRON Delivery process only sends information on students who are in the careers that you enter here.
BRON Career Selection - Acad Career	Select to link your institution's academic careers to BRON career codes. Since you can define your academic careers however you want, you must link your careers to BRON careers to share data.
BRON Career Selection - Acad Load	If you use academic load instead of career, select this option to link your institution's academic loads to BRON career codes.
BRON Load Selection - Acad Load	Link your institution's academic loads to BRON intensity values. Since you can define your academic loads however you want, you must link your loads to BRON load values to share data.

Setting Up BRON Programs

Access the BRON Setup Program page.

Programs not to BRON

Select LNV Programs

Setting Up NT2 for BRON

To set up NT2 for BRON, use the BRON Setup NT2 component (SAD_BR_TEST_NLD).

This section discusses how to set up NT2 for BRON.

Page Used to Set Up NT2 for BRON

Defining NT2 Setup

Access the BRON Setup NT2 page.

HEGIS Code	Enter the HEGIS code for this test.
Academic Level	Enter the academic levels for which you want to define result ranges.
NT2 Result from and NT2 Result to	Enter the grade range for each possible academic level. For example, if you select Basic User/Breakthrough (NLD) in the Academic Level field, and defined the range of 1 to 2 in these fields, then students who score a 1 or 2 in the NT2 course will be given the Basic User/Breakthrough academic level.

Setting Up BRON Prior Education

To set up BRON prior education, use the BRON Setup Prior Education component (SAD_BR_XLPE_NLD).

This chapter discusses how to define BRON prior education setup.

Page Used to Set Up BRON Prior Education

Defining BRON Prior Education Setup

Access the BRON Setup Prior Education page.

Prior Education	Select your institution's prior education codes that you want to map to BRON prior education codes.
Program Status	Select a program status for this prior education code. Your options are Completed, Failed, and Running. The system uses both the prior education code and the program status to determine the BRON prior education code.
BRON Prior Education	Select the BRON prior education code that corresponds to your institution's prior education code and program status.

Creating and Sending the BRON File

This section provides and overview and discusses how to create and send BRON files.

Understanding the BRON Delivery Process

You first run the BRON Delivery process (SRBRONNL) to create records in the BRON Export Holding table by selecting the BRON Create File check box. The records in the BRON export holding table are grouped by a unique batch number for every educational sector within an institution. After you have reviewed the file to be sent on the BRON Maintain Before Send page you send the file by running the BRON Delivery process once again and selecting the BRON Send File check box. When you send the file the batch group is frozen. Then, the next time you run the creation process the process compares the data in your system with the data you sent in the last batch to BRON. Only changes are sent in subsequent files. Each subsequent file has a higher batch number.

Page Used to Create and Send the BRON File

Creating and Sending the BRON File

Access the BRON Delivery Process page.

BRINcode	Enter a BRINcode for which to create or send the BRON file. Define BRINcode values on the BRON Setup page.
Educational Sector	Enter the educational sector for which to create or send the BRON file.
BRON Create File	Select this check box to create records in the BRON export holding table.
BRON Send File	Select this check box to send the BRON file. The File Path and Last Send fields appear.
File Path	If you selected the BRON Send File check box, enter the file path of the file that you want to send.
Last Send	Select this check box if this is the last file you are sending for the year.
Responsible	Select the responsible party for this file. Your choices are Accountant, CFI, and Institution.

Reviewing the BRON File Before Sending

This section discusses how to view the outgoing data file before sending it to BRON.

Pages Used to Review the BRON File Before Sending

Viewing the Outgoing File Data

Access the Maintain BRONBatch before send page.

Key	Click this link to view general identification data of a BRON mutation and student. This relates to the record type 305 in the BRON delivery file.
Key Ch (key change)	Click this link to view the key change information (changes in SOFI number, address, birth date, and gender). This relates to the record type 306 in the BRON delivery file.
Pers (personal)	Click this link to view the student's personal data. This relates to record type 310 in the BRON delivery file. This data is only created when there is no SOFI number or Educational number known to identify the student. BRON uses this information to track down the person in GBA.
Enroll (enrollment)	Click this link to view general information about a specific enrollment. This relates to record types 320, 325, and 330 of the BRON delivery file.
Period	Click this link to view funding codes by BRON period. This relates to record type 321 of the BRON delivery file. This is only used for BRON sector Professional Education.
BPV	Click this link to view the BPV (internship training at external organizations) data for this enrollment. This relates to record type 322 of the BRON delivery file. This is only used for BRON sector Professional Education.
Exam	Click this link to view result data belonging to the enrollment. This relates to record types 323, 326, and 331 of the BRON delivery file.
Course	Click this link to view course data belonging to this enrollment. This relates to record types 327 and 332 of the BRON delivery file. This does not apply to the BRON sector Professional Education.
NT2	Click this link to view NT2 data related to the enrollment. This relates to record type 328. This is only used for BRON sector Education.

Managing BRON Return File Processing

This section discusses how to:

• Import the BRON return file.

• View the BRON return file.

• Run the BRON report.

Understanding BRON Return File Processing

When you send mutations to BRON, BRON performs a detailed functional check to ensure that the mutations are complete and valid. BRON can approve, approve with signal, or reject mutations. Every week—normally— BRON sends institutions a file showing the data it has received and whether the mutations were accepted or rejected.

You send mutations to BRON in batch. Because BRON processes these mutations separately, some mutations take longer than others. Consequently, BRON sends return files that contain individual mutations that then must be matched to the batch file in the export holding table. So the BRON Return process (SRBRONNL.sqr) imports the data return files into a return holding table and then matches the individual mutation records to the existing records in the export holding table. The process then updates the export holding table with data from the return file. The process updates the status of the mutation to accepted or rejected, and populates any signals that are attached to the file and the rejection reason, if applicable.

After you run the BRON Return process, use the BRON Return File Inq page to view rejected mutations. Correct the data in your system and create a new delivery file.

You can also generate a report to view the number of BRON file mutations that BRON received from your institution sorted by status and showing rejection reasons, if applicable.

Pages Used to Manage the BRON Return File Processing

Importing the BRON Return File

Access the BRON Return Process page.

BRINcode	Enter the BRINcode for which you want to import return files. Define BRINcode values on the BRON Setup page.
Educational Sector	Enter the educational sector for which you want to import return files.
File Path	Enter the file path of the return file. You must enter a file path.
File Name	Enter the file name of the return file. You must enter a file name.

Viewing the BRON Return File

Access the BRON Return File Inquiry page.

Key	Click this link to view general identification data of a BRON mutation and student. This relates to the record type 405 in the BRON return file. The record is identical to the send 305 record.
Key Ch (key change)	Click this link to view key changes (SOFI number, address, birth date, gender). This relates to the record type 406 in the BRON return file
Pers (personal)	Click this link to view personal data of a student as found in GBA. This relates to record type 410 in the BRON return file. If the mutation is rejected by BRON the content of this record is the same as in the 310 record of the delivery.
GBA	Click this link to view additional GBA information. This record is shown when a student is found in the GBA system. This relates to the record type 411 in the BRON return file.
Enroll (enrollment)	Click this link to view general information about a specific enrollment. This relates to record types 420, 425, and 430 of the BRON return file.
Period	Click this link to view funding code information by BRON period. This relates to record type 421 of the BRON return file. This is only used for BRON sector Professional Education.
BPV	Click this link to view BPV information data for this enrollment. This relates to record type 422 of the BRON return file. This only applies to the BRON sector professional education.
Exam	Click this link to view result data belonging to the enrollment. This relates to record types 423, 426, and 431 of the BRON return file.
Course	Click this link to view course data belonging to this enrollment. This relates to record types 427 and 432 of the BRON return file. This does not apply to the BRON sector Professional Education.
NT2	Click this link to view NT2 data related to the enrollment. This relates to record type 428.
Errors	Click this link to view BRON errors and signals belonging to this mutation. This relates to record type 499.

Running the BRON Report

Access the BRON Report page.

BRINcode	Enter the BRINcode for which you want to run the reports. The reports will only display information for this BRINcode. Define BRINcode values on the BRON Setup page.
Educational Sector	Enter the educational sector for which you want to run the reports. The reports will only display information for this educational sector.
Creation Date From	Enter the date from which you want to run the report. For example, if you enter 09/01/2004, only files created on or after that date will be included in the report.
Last Sequence Nbr (last sequence number)	Enter the last sequence number to narrow the report by sequence number.
Record Status	Select a record status to narrow the report by status. Your options are: Approved, Created, Rejected, and Sent. For example, if you select Rejected the report will only list files that were marked as rejected.

Managing GBA Data

This section provides an overview and discusses how to process GBA data.

Understanding GBA Data

BRON compares the personal data that your institution sends to them with the data in the municipal basis administration (Gemeentelijke Basis Administratie or GBA). If the data that BRON has is different from the data that GBA has, BRON updates their records with the GBA data. The updated personal data from GBA is included in the return file that BRON sends to you. You must run the Process GBA Data process to compare the personal data in the return holding table to the personal data in application tables. The Process GBA Data process stores differences in the Maintain GBA Data table. Use the Maintain GBA Data page to accept or reject the GBA data. Data that has been accepted can then be posted to application tables.

The following data is updated automatically:

• Name (PERSON_NAME)

  The system updates the last name and prefix, and uses the name type as defined on the BRON Setup page.

  Note. You must update first names manually.

• Address (ADRESSES)

  The system updates the street, house number, house number addition, city, and postal code, and uses the address type as defined on the BRON Setup page.

• Gender (PERS_DATA_EFFDT)

• SOFI-Number (PERS_NID)

• Education Number (PERS_NID)

• Birthdate (PERSON, or if incomplete, SSR_STUDENT_NLD)

Note. The system overwrites existing data if the Gender, SOFI-Number, Education Number, or Birthdate fields are updated. For effective-dated tables, the system inserts a new row with the current date as the effective date.

Pages Used to Manage GBA Data

Processing GBA Data

Access the Process GBA Data page.

BRINcode	Enter the BRINcode for which you want to process GBA data. The system will only process GBA data for this BRINcode. Define BRINcode values on the BRON Setup page.
Educational Sector	Enter the educational sector for which you want to process GBA data.
BRON Batchnumber	Enter the batch number that you want to process. This is the unique batch number assigned by BRON to identify a specific BRON return file.
Action	Select the action that you want the Process GBA Data process to perform. Select Fill GBA Interim Table to populate an interim table so you can accept or reject the personal data sent by BRON. Select Update GBA Data in PeopleSoft to post the accepted personal data to permanent application tables.
Update All	This field appears when you select Update GBA Data in PeopleSoft in the Action field. When you select this check box the GBA Data update process selects the records with status accepted or the status field empty. You might leave the status field blank if you want to process all data.
Delete Not Accepted Data	This field appears when you select Update GBA Data in PeopleSoft in the Action field. Select this check box to delete all data marked rejected. You can accept or reject data on the Maintain GBA Data page.

Managing BRON Snapshot Files

This section provides an overview and discusses how to:

• Import BRON snapshot files.

• Compare the BRON snapshot.

Understanding BRON Snapshot Files

BRON provides a snapshot file to CFI, who uses it to determine funding amounts for your institution. As a service, BRON also provides you the snapshot file that they send to CFI so that you can review it for accuracy and correct discrepancies.

A BRON snapshot file is an instantaneous photo of:

• All active enrollments on a certain census date.

• All terminated enrollments in the period of 12 months prior to the census date.

• All enrollments and results achieved that are in BRON for the calendar year of the census date and that are not part of the previous two categories.

To review and correct BRON Snapshot files:

1. Run the BRON Import Snapshot process (SAD_BR_SNAP) to import the snapshot file that BRON provides into a holding table.

2. Run the Snapshot Compare process (SRSNCPNL) to compare the data in the snapshot holding table with the data in the export holding table.

3. Review the Snapshot Compare report to determine if there are any discrepancies.

4. If you find discrepancies in the data between the snapshot and the export holding table, send a new mutation to BRON.

   At this stage, the new mutation should be accompanied by the signature of an accountant.

Pages Used to Manage BRON Snapshot Files

Importing BRON Snapshot Files

Access the Import BRON Snapshot page.

BRINcode	Enter the BRINcode for which you want to import the snapshot file. Define BRINcode values on the BRON Setup page.
Educational Sector	Enter the educational sector for which you want to import the snapshot file.
File Path	Enter the file path where the snapshot file is located.
File Name	Enter the name of the snapshot file.

Comparing the BRON Snapshot

Access the BRON Compare Snapshot page.

BRINcode	Enter the BRINcode for which you want to compare the snapshot file.
Educational Sector	Enter the educational sector for which you want to compare the snapshot file.
Creation Date	Enter the creation date. The creation date is part of the key in the snapshot file. On certain fixed dates a snapshot file is sent to the institution. The creation date is part of the identification of the snapshot file. You have to enter the creation date here so the correct snapshot file can be selected for the comparison.
Status Snapshot	Enter a snapshot status. This is also part of the key in the snapshot file and is used for identification of the snapshot file. During different moments in time several snapshot file types are sent to the institution. This status defines which snapshot file type is meant. For example, it is possible that after a correction a certain snapshot file, such as the 1st snapshot, is sent again to the institution. Because this snapshot file has a different creation date the identification stays unique.
Rebuild Compare Table	Select this check box to rebuild the entire compare table. Clear this check box to only produce a snapshot compare report. You would clear this check box when you have already created a compare table and only want to produce the snapshot compare report.