How do I set up i-Connect outbound parameters within Cintra iQ?

i-Connect is linked to local government pensions. It affects Colleges, Housing Co-operations etc.

 

Before you begin...

You need to set up the Local Government Pension Scheme (LGPS). It should be a banded scheme for Employee Contributions based on Salary. LGPS has different rules for different establishments.  Each LPGPS scheme will have different reporting requirements from each other. LPGS has a monthly reporting technique. 

 

i-Connect is an application which allows the different establishments to fill in data on the same standard file.  i-Connect takes the file and manipulates the data on behalf of the establishment.

 

Cintra iQ has an automated Output, which can send the file to i-Connect. The Outbound Interface allows you to produce a standard output for the establishments' reporting needs.

 

How do I setup the outbound parameters?

1. Highlight an existing Output entry in the OUT section of the Definition pane.
   Go to Cintra iQ: Tools> Interfaces> Interface Definitions
2. Click the New button. The Interface Connector dialogue window appears.
3. Enter the Interface Name.
4. Click the OK button. The Interface Connector form appears. 
5. Connection section:
   • Select Direction: Out
6. File section:
   • Type: Text Delimited
   • Delimiter:,
   • Line Delimiter: CRLF
   • Enter Post Stored Procedure: LGPS_iConnect_Monthly_2017
   • Default File Name: I-Connect
7. Click the Outbound Table button. The Interface Outbound window appears.
8. Click the Create Table based on SP button. The Outbound Table Confirmation message appears.
9. Click the Yes button. The Outbound Table Definition pane is automatically populated.
10. Right-click in the Outbound Parameters pane. A menu appears.
11. Select Insert Here. The Outbound Parameters form appears.
12. Perform the following for Main_Scheme:
    1. Enter Name: Main_Scheme
    2. Select Lookup TBname: Pension Scheme.
    3. Click the OK button. The parameter is created and appears in the Outbound Parameters pane.
13. Continue to insert the following parameters:

     

    Name	Description
    Main_Scheme_Part	Enter Name: Main_Scheme_Part Select Lookup TBname: Pension Scheme Parts Click the OK button. The parameter is created and appears in the Outbound Parameters pane.
    5050_Scheme_Part	Enter Name: 5050_Scheme_Part Select Lookup TBname: Pension Scheme Parts Click the OK button. The parameter is created and appears in the Outbound Parameters pane.
    AVC_Scheme_Part	Enter Name: AVC_Scheme_Part Select Lookup TBname: Pension Scheme Parts Click the OK button. The parameter is created and appears in the Outbound Parameters pane.
    Payroll	Enter Name: Payroll Select Lookup TBname: Payroll Click the OK button. The parameter is created and appears in the Outbound Parameters pane.
    Payroll_Period	Enter Name: Payroll_Period Select Lookup TBname: Payroll Periods Click the OK button. The parameter is created and appears in the Outbound Parameters pane.Continue to insert the following parameters:

14. Click the OK button. You are returned to the Interface Definitions window.

How do I produce an Outbound LGPS output .csv file?

1. Navigate to the Interface Definitions window.
   Go to Cintra iQ: Tools> Interfaces
2. Expand the OUT section within the Definitions pane.
3. Double-click the I-Connect definition. The Interface History window appears.
4. Click the Produce Outbound File button. The Outbound Interface Parameters form appears.
5. Select from the drop-down lists:
• Main_Scheme: (LGPS Pension Scheme)
  

    Note:

  Every Establishment should have only one LGPS scheme, otherwise the output will fail because data is held in the other scheme. The scheme can have multiple contributions, but these have to be under the one scheme.

• Main_Scheme_Part: (Main Contribution)
• 5050_Scheme_Part: (5050 Contribution)
• AVC_Scheme_Part: (AVC Contribution)
• Payroll: (Relevant Payroll)
• Payroll_Period:(Relevant Payroll Period)
6. Click the Run button. The Interface Outbound File window appears, populated with the selected Outbound data.
7. Click the Save File button to save the file in a .CSV format. 
8. Upload the file to I-Connect. 
   

     Note:

   I-Connect will filter the relevant data for the your Establishment.

How do I check the history of the LGPS output?

1. Double-click the relevant LGPS Output in the OUT section of the Definition pane. The LGPS Output's Interface History window appears.
2. Click the View Data File button. The Interface File window appears, which displays the code and the data of the previous output session.
   

     Note:

   If you need to reproduce the file, click the Output... button and select the relevant Output Destination.

What are the required outbound parameters?

• Main_Scheme
• Main_Scheme_Part
• 5050_Scheme_Part
• AVC_Scheme_Part
• Payroll
• Payroll_Period