Processing (Reports Scheme Rule Report)

When the Generate Report Button is selected, the system will read the Fund Update records for the Selected Rule Types with an Effective Date equal or the latest Effective Date lesser than the Effective Date captured. If a Rule Type is selected, the system will find the records with a Fund Update Type equal to the Rule Type selected with an Effective Date equal or the latest Effective Date less than the Effective date captured.

The BJU1HX batch job will be run.

For each Rule Type, the information is extracted as per the table below:

Rule Type	Field	Source	Comment
Scheme Information
	Registration Date	Effective Date on JU1BU Registration Page
	De-Registration Date	De-Registration Date on JU1BU Registration Page
	Registration Number	Registration Number on JU1BU Registration Page
	Description	Description on JU1BU Registration Page
	Country	Country on JU1BK Nature of Scheme Page
	Business Unit	Business Unit on JU1BK Nature of Scheme Page
	Currency	Currency Value on JU1BK Nature of Scheme Page
	Type of Service	Type of Service Value on JU1BK Nature of Scheme Page
	Language	Language Value on JU1BK Nature of Scheme Page
	Type of Scheme	Type of Scheme Value on JU1BK Nature of Scheme Page
	Product	Product Value on JU1BK Nature of Scheme Page
	Type of Launch	Type of Launch Value on JU1BK Nature of Scheme Page
	Pooling Status	Pooling Status Value on JU1BK Nature of Scheme Page
	Launch Date	Launch Date value on JU1BK Basic Product Data
	Flexible Investment	Display Tick box on JU1BK Nature of Product Page
	Commencement Date	Commencement Date Value on JU1BK Product Details
	Tax Status	Sector value on JU1BK Nature of Product Page
	Effective Date	Effective Date value on JU1BK Product Details Page
	Sponsor	Sponsor value on JU1BK Product Details Page
	Principal Employer	Principal Employer value on JU1BK Product Details Page
	Administrator Branch	Administrator Branch value on JU1BK Basic Product Data Page
	Status	Status value on JU1BK Basic Product Data Page
Contact Persons (this will form part of Scheme Information on the report)
	Surname	Surname value on JU1CG Product Contact Person Page
	First Name	Firstname value on JU1CG Product Contact Person Page
	Title	Title value on JU1CG Product Contact Person Page
	Date of Birth	Date of Birth value on JU1CG Product Contact Person Page
	Role of Person	Role of Person value on JU1CG Product Contact Person Page
	Role of Trustee	Role of Trustee value on JU1CG Product Contact Person Page
	Employee Representative	Tick Selection box on JU1CG Product Contact Person Page
	Start Date	Start Date on JU1CG Product Contact Person Page
	End Date	End Date on JU1CG Product Contact Person Page
Employer Details
	Participating Employer	Name value on JU1BW Scheme Participating Employers Page
	Code	Code value on JU1BW Scheme Participating Employers Page
	Pay Centre	Name value on JU1DL Scheme Pay Centre List
	Pay Centre Code	Pay Centre Code on JU1DL Scheme Pay Centre List	There may be more than one pay centre associated to a Participating Employer. See example of report below. For each Participating Employer, all the pay centres must display below each other
Membership Groups
	Membership Group Type	Membership Group Type on JU1BR Scheme Membership Group List Page	Display the information for every Membership Group Type relevant to the Scheme e.g. INVESTMENT,BENEFIT and CONTRIB
	Code	Code Value on JU1BR Scheme Membership Group List Page
	Description	Description Value on JU1BR Scheme Membership Group List Page
	Start Date	Start Date Value on JU1BR Scheme Membership Group List Page
	End Date	End Date Value on JU1BR Scheme Membership Group List Page
	Default	Default Value on JU1BR Scheme Membership Group List Page
	Life Cycle	Life Cycle Value on JU1BR Scheme Membership Group List Page
	Limit	Limit Value on JU1BR Scheme Membership Group List Page
	Start Age/Yrs to NRD	Start Age/Yrs to NRD value on JU1BR Scheme Membership Group List Page
	End Age/Yrs to NRD	End Age/Yrs to NRD value on JU1BR Scheme Membership Group List Page
Income Rules
	Membership Group	Description Value for the Benefit Membership Group Type on JU1BR Scheme Membership Group List Page
	Income Type	Code Value on JU1BX Scheme Income Type List
	Calculation Type	Calculation Type Value on JU1CT Scheme Income Rule Details	There may be multiple Membership Groups with the same income type. For each Membership Group repeat the income type in the report (see example below)
	Percentage	Percentage Value on JU1CT Scheme Income Rule Details Page linked to the specific income type displayed on the report
	Amount	Amount Value on JU1CT Scheme Income Rule Details Page linked to the specific income type displayed on the report
	Inclusive	Selection Tick Box on the JU1BX Scheme Income Type Page for the specific Income Type displayed on the Report
	Optional	Optional Tick Box on the JU1BX Scheme Income Type Page for the specific Income Type displayed on the Report
	Regular	Regular Tick Box on the JU1BX Scheme Income Type Page for the specific Income Type displayed on the Report
	Scheme Income Split	Portfolio Value on the JU1CH Scheme Income Allocation List Page for the specific Income Type displayed on the Report
	Allocation %	Allocation % Value on the JU1CH Scheme Income Allocation List Page for the specific Income Type displayed on the Report
Life Cycle Rules (Part of Income Rules Update Type on the Report)
	Investment Group	Description Value on JU1BR Scheme Membership Group List Page
	Portfolio	Portfolio Code Value on JU1CH Scheme Income Allocation List Page for the specific Investment Group displayed on Report
	Allocation Percentage	Allocation % Value on the JU1CH Scheme Income Allocation List Page for the specific Investment Group displayed on the Report
Expense Rules
	Membership Group	Description Value for the Benefit Membership Group Type on JU1BR Scheme Membership Group List Page
	Expense Type	Code Value on JU1BX Scheme Expense Type Details Page
	Formula Type	Formula Type Value on JU1CT Scheme Expense Rule Details Page for specific Expense Type displayed on Report
	Formula Applied To	Formula Applied To Value on JU1CT Scheme Expense Rule Details Page for specific Expense Type displayed on Report
	Type of Scale	Type of Scale Value on JU1CT Scheme Expense Rule Details Page for specific Expense Type displayed on Report	If a sliding scale is applicable, display each row of the scale for the income type specified in the report
	Minimum	Minimum Value on JU1CT Scheme Expense Rule Details
	Maximum	Maximum Value on JU1CT Scheme Expense Rule Details
	Percentage	Percentage Value on JU1DZ Expense Rule Scale List Page for specific Expense Type displayed on Report
	Type of Factor	Type of Factor Value on JU1DZ Expense Rule Scale List Page for specific Expense Type displayed on Report
	Amount	Amount Value on JU1DZ Expense Rule Scale List Page for specific Expense Type displayed on Report
	Factor	Factor Value on JU1DZ Expense Rule Scale List Page for specific Expense Type displayed on Report
	Age	Age Value on JU1DZ Expense Rule Scale List Page for specific Expense Type displayed on Report
	To	To Value on JU1DZ Expense Rule Scale List Page for specific Expense Type displayed on Report
	Associate Rule to Income Type	Selected Global Type on JU1BY Scheme Global Type Allocation link to an Expense Type for a Rule.
	Associate Rule to Portfolio	Description of Selected Portfolio on JU1HK Portfolio Association Screen linked to an Expense Type for a Rule. Code of Selected Portfolio on JU1HK Portfolio Association Screen linked to an Expense Type for a Rule.
Service Fees
	Service Type	Service Type Value on JU1CW Scheme Service Fee Page
	Start Date	Start Date Value on JU1CW Scheme Service Fee Page
	End Date	End Date Value on JU1CW Scheme Service Fee Page
	Amount	Amount Value on JU1CW Scheme Service Fee Page
	Percentage	Percentage Value on JU1CW Scheme Service Fee Page
	Minimum Amount	Minimum Amount Value on JU1CW Scheme Service Fee Page
	Maximum Amount	Maximum Amount Value on JU1CW Scheme Service Fee Page

Life Cycle Switching Rules
	Phasing Rule	Phasing Rule Value on JU1EG Life Cycle Switching Rules Page
	Frequency	Frequency Value on JU1EG Life Cycle Switching Rules Page
	Frequency Base Date	Frequency Base Date Value on JU1EG Life Cycle Switching Rules Page
	Switching Dates	Switching Date Value on JU1EG Life Cycle Switching Rules Page
Investments
	Portfolio Code	Port Code Value on JU1BV Scheme Portfolio List Page
	Investment Medium Code	Inv Med Code Value on JU1BV Scheme Portfolio List Page
	Portfolio	Portfolio Value on JU1BV Scheme Portfolio List Page
	Start Date	Start Date Value on JU1BV Scheme Portfolio List Page
	End Date	End Date Value on JU1BV Scheme Portfolio List Page
Accounting
Bank Accounts (part of Accounting Update Type on Report)	Account Holder	Account Holder Value on JU1CC Product Bank Account List Page
	Bank	Bank Value on JU1CC Product Bank Account List Page
	Branch	Branch Value on JU1CC Product Bank Account List Page
	Bank Code	Bank Code Value on JU1CC Product Bank Account List Page
	Account Number	Account Number Value on JU1CC Product Bank Account List Page
	Account Type	Account Type Value on JU1CC Product Bank Account List Page
	Bank Interface	Bank Interface Value on JU1CC Product Bank Account List Page
	Start Date	Start Date Value on JU1CC Product Bank Account List Page
	End Date	End Date Value on JU1CC Product Bank Account List Page
Accounting Rule Set (part of the Accounting Update Type on Report)	Code	Code Value on JU2AT Scheme Rule Set List Page
	Effective Date	Effective Date Value on JU2AT Scheme Rule Set List Page
	Description	Description Value on JU2AT Scheme Rule Set List Page
Benefit Rules
Retirement Ages (part of Benefit Rules on Report)	Membership Group	Selected Value on BADJ NRA Definition Scheme Membership Group Allocation Page
	Early	Early Value on BADI NRA Definition Maintain Page	This value must be repeated for each membership group linked
	Normal	Normal Value on BADI NRA Definition Maintain Page	This value must be repeated for each membership group linked
	Late	Late Value on BADI NRA Definition Maintain Page	This value must be repeated for each membership group linked
	Calculation Method	Date Calculation Basis selected on BADI NRA Definition Maintain Page
	Fixed Date	Fixed Date Value on BADI NRA Definition Maintain Page
Benefit Products (part of Benefit Rules on Report)	Description	Description Value on BAGA Benefit Product List Page
	Benefit Type	Benefit Value on BAGA Benefit Product List Page
	Formula Type	Formula Type Value on BAGA Benefit Product List Page
	Formula of What	Formula of What Value on BAGA Benefit Product List Page
	Percentage	Percentage Value on BAGB Scale of Benefits List Page	This value must be repeated for each Scheme Income Type
	Amount	Amount Value on BAGB Scale of Benefits List Page	This value must be repeated for each Scheme Income Type
	Multiple	Multiple Value on BAGB Scale of Benefits List Page	This value must be repeated for each Scheme Income Type
	Income Type	Scheme Income Type Value on BAGB Scale of Benefits List Page
	Maximum Benefit Amount	Maximum Benefit Amount Value on BAGA Benefit Product List Page
Benefit Packages (part of Benefit Rules on Report)	Membership Group	Membership Group Value on BADS Package/Scheme Membership Group Allocation Page
	Event	Event Value on BADQ Benefit Event List page linked to the specific membership group displayed on the report.
	Purpose	Purpose Value on BADR Package List Page
	Calculation	Calculation Value on BAGC Package/Benefit Product Allocation Page