Validation Rules

Configure and manage validation rules for returns submission

Return Type

Rule Category

Status

Search Rules

Total Rules

3 new this month

Active Rules

100% of total rules

Failed Validations

156

12 this week

Success Rate

94.2%

1.5% increase

Validation Rules List

Rule ID	Rule Name	Category	Return Type	Status
VR001	Submission Deadline Returns must be submitted by the last day of the month	General	All Returns	Active
VR002	Reporting Period Reporting period must be a valid month and year	General	All Returns	Active
VR003	File Format Returns must be submitted in Excel or CSV format	General	All Returns	Active
VR004	Total Assets Total assets must be a positive number	Financial	All Returns	Active
VR005	Total Liabilities Total liabilities must be a positive number	Financial	All Returns	Active
VR006	Net Asset Value Net Asset Value must equal Total Assets minus Total Liabilities	Financial	All Returns	Active
VR007	Unit Price Unit price must be a positive number with up to 4 decimal places	Financial	All Returns	Active
VR008	Investment Income Investment income must be a valid number	Financial	All Returns	Active
VR009	Management Fees Management fees cannot exceed 2.5% of NAV	Financial	All Returns	Active
VR010	Asset Allocation Asset allocation percentages must sum to 100%	Investments	All Returns	Active
VR011	Equity Exposure Equity exposure cannot exceed 75% of portfolio	Investments	All Returns	Active
VR012	Government Securities Government securities must be at least 20% of portfolio	Investments	All Returns	Active
VR013	Single Entity Exposure Exposure to a single entity cannot exceed 5% of portfolio	Investments	All Returns	Active
VR014	Foreign Investment Foreign investments cannot exceed 25% of portfolio	Investments	All Returns	Active
VR015	Money Market Money market instruments cannot exceed 35% of portfolio	Investments	All Returns	Active
VR016	Var Limit Value at Risk (VaR) cannot exceed 3.5%	Risk_metrics	All Returns	Active
VR017	Duration Portfolio duration must be between 0 and 15 years	Risk_metrics	All Returns	Active
VR018	Liquidity Ratio Liquidity ratio must be at least 10%	Risk_metrics	All Returns	Active
VR019	Concentration Risk Sector concentration cannot exceed 20%	Risk_metrics	All Returns	Active
VR020	Returns Returns must be within reasonable range (-30% to 50%)	Performance	All Returns	Active
VR021	Tracking Error Tracking error cannot exceed 5%	Performance	All Returns	Active
VR022	Sharpe Ratio Sharpe ratio cannot be less than -3	Performance	All Returns	Active
VR023	Information Ratio Information ratio must be a valid number	Performance	All Returns	Active
VR024	Investment Breaches All investment breaches require explanation and remediation plan	Compliance	All Returns	Active
VR025	Regulatory Approvals New investment types require regulatory approval documentation	Compliance	All Returns	Active
VR026	Risk Rating Risk rating must be Low, Medium, or High	Compliance	All Returns	Active
VR027	Compliance Certification Returns require certification by Compliance Officer and CEO	Compliance	All Returns	Active
VR028	Completeness All required fields must be completed	Data_quality	All Returns	Active
VR029	Consistency Opening balances must match previous month closing balances	Data_quality	All Returns	Active
VR030	Accuracy All sub-totals must reconcile with main totals	Data_quality	All Returns	Active
VR031	Timeliness Returns must be submitted within 21 days of period end	Data_quality	All Returns	Active
VR032	Rsapin Format RSA PIN must be in valid format (PEN followed by 12 digits)	Contributor_data	All Returns	Active
VR033	Contribution Amount Contribution amount cannot be negative	Contributor_data	All Returns	Active
VR034	Employer Portion Employer portion must be 10% of total contribution	Contributor_data	All Returns	Active
VR035	Employee Portion Employee portion must be 8% of total contribution	Contributor_data	All Returns	Active
VR036	Pin Format PIN must be in format PEN followed by 12 digits	Accrued_rights	All Returns	Active
VR037	Employer Validation Employer must exist in CRS system	Accrued_rights	All Returns	Active
VR038	Amount Precision All amounts must be displayed with 2 decimal places	Accrued_rights	All Returns	Active
VR039	Variance Calculation Variance must equal received amount minus credited amount	Accrued_rights	All Returns	Active
VR040	Batch Number Format Batch/Set number must be alphanumeric and not exceed 50 characters	Accrued_rights	All Returns	Active
VR041	Date Sequence RSA credit date must not be before PFC credit date	Accrued_rights	All Returns	Active
VR042	Refund Request Date Refund request date must be in DD-Mon-YYYY format	Refund_validations	All Returns	Active
VR043	Refund Type Refund type must exist in the codebook	Refund_validations	All Returns	Active
VR044	Refund Amount Refund amount must be a positive number	Refund_validations	All Returns	Active
VR045	Refund Due Date Refund due date must be 7 days from request date	Refund_validations	All Returns	Active
VR046	Variance Validation Sum of positive and negative variances must equal total variance	Refund_validations	All Returns	Active
VR047	Records Variance Records variance must equal total records minus records refunded	Refund_validations	All Returns	Active
VR048	Contribution Status Contribution status must be either Credited or Uncredited	Contribution_validations	All Returns	Active
VR049	Sort Code Sort code must be a valid bank code	Contribution_validations	All Returns	Active
VR050	Payment Type Payment type must exist in the codebook	Contribution_validations	All Returns	Active
VR051	Credit Date Sequence Credit date must not be before received date	Contribution_validations	All Returns	Active
VR052	Uncredited Reason Reason is required for uncredited contributions	Contribution_validations	All Returns	Active
VR053	Total Reconciliation Sum of individual contributions must match total	Aggregate_validations	All Returns	Active
VR054	Mda Grouping All records must have valid MDA grouping	Aggregate_validations	All Returns	Active
VR055	Batch Uniqueness Batch number must be unique per payment type	Aggregate_validations	All Returns	Active
VR056	Monthly Totals Monthly totals must be properly aggregated	Aggregate_validations	All Returns	Active
VR057	Date Format Dates must be in DD-MON-YYYY format	Exempted_retirees	All Returns	Active
VR058	Contribution Split Contributions must follow valid employer/employee split	Exempted_retirees	All Returns	Active
VR059	Refund Calculation Refund amounts must be correctly calculated	Exempted_retirees	All Returns	Active
VR060	Investment Income Investment income must be a positive number with 2 decimal places	Exempted_retirees	All Returns	Active

60 rules