The following table lists the changes that have affected the database schema in this release.
Table | Field | Action | Comment/Extended Property Description |
FI.GenericTemplates | IsAllFieldsVisible | New Column | BIT NULL. New flag to control visibility of all fields in generic templates. Migration: V12/12.26-FI/000 (PR-1136) |
rar.PayGroupPayroll | RegularPayDay | New Column | TINYINT NULL. Day of the week on which the main pay run is paid. 1 = Sunday, 2 = Monday, 3 = Tuesday, 4 = Wednesday, 5 = Thursday, 6 = Friday, 7 = Saturday. Migration: V12/12.25P3.AUTax/000 |
rar.SuperEligibilityRule | MaximumQuarterlyEarnings → MaximumContributionBase | Column Renamed | DECIMAL(38,6) NOT NULL. Renamed from MaximumQuarterlyEarnings to MaximumContributionBase to reflect AU superannuation terminology. Migration: V12/12.25P3.AUTax/004 |
rar.SuperEligibilityRule | QuarterlyEarningsPayCodeGroupId → EarningsCapPayCodeGroupId | Column Renamed | INT NOT NULL. Foreign key to rar.PayCodeGroup.PayCodeGroup_id. Renamed from QuarterlyEarningsPayCodeGroupId to EarningsCapPayCodeGroupId. Migration: V12/12.25P3.AUTax/002 |
rar.SuperRateRule | IsMaximumQuarterlyEarningsExempt | Metadata Update | Extended property 'Name' corrected from 'IsMaximumQuarterlyThresholdExempt' to 'IsMaximumQuarterlyEarningsExempt'. The extended property 'Description' updated from 'Indicates if the Maximum Quarterly Threshold check should be exempted. 1 = True' to 'Indicates if the Maximum Quarterly Earnings Threshold check should be exempted. 1 = True. No column DDL change. |
rar.SuperStreamBatch | SuperPeriodId | Nullability Changed | Changed from INT NOT NULL to INT NULL. Made nullable to support the payday reporting model. Migration: V12/12.25P3.AUTax/006 (TR-5678) |
rar.SuperStreamBatch | PayDay | New Column | TINYINT NULL. Day of the week for payday reporting model. 1 = Sunday, 2 = Monday, 3 = Tuesday, 4 = Wednesday, 5 = Thursday, 6 = Friday, 7 = Saturday. Migration: V12/12.25P3.AUTax/006 (TR-5678) |
rar.SuperStreamBatch | PaymentCutOffDate | New Column | DATE NULL. Payment cut-off date for the payday reporting model. Contributions with a payment date on or before this date are included. Migration: V12/12.25P3.AUTax/006 (TR-5678) |
FI.GenericTemplateType (UDT) | IsAllFieldsVisible | UDT Modified | BIT NULL. Added to the table type definition. UDT was dropped and recreated. Migration: V12/12.26-FI/001 (PR-1136) |
rar.SuperFund | SuperPeriodHeaderId | Revert Nullability | Reverted from INT NULL back to INT NOT NULL. Backfills NULL rows with 0, drops and recreates the IX_SuperPeriodHeaderId index. No-op on production. Migration: V12/12.25P3.AUTax/007 |
[Audit] rar.PayGroupPayroll | RegularPayDay | New Column | TINYINT NULL. Mirror's main table change. Migration: V12/12.25P3.AUTax/000 (Audit ScriptRunner) |
[Audit] rar.SuperEligibilityRule | MaximumQuarterlyEarnings → MaximumContributionBase | Column Renamed | DECIMAL(38,6) NOT NULL. Mirror's main table rename. Migration: V12/12.25P3.AUTax/004 (Audit ScriptRunner) |
[Audit] rar.SuperEligibilityRule | QuarterlyEarningsPayCodeGroupId → EarningsCapPayCodeGroupId | Column Renamed | INT NOT NULL. Mirror's main table rename. Migration: V12/12.25P3.AUTax/002 (Audit ScriptRunner) |
[Audit] rar.SuperStreamBatch | SuperPeriodId | Nullability Changed | Changed from INT NOT NULL to INT NULL. Mirror's main table change. Migration: V12/12.25P3.AUTax/006 (Audit ScriptRunner) |
[Audit] rar.SuperStreamBatch | PayDay | New Column | TINYINT NULL. Mirror's main table change. Migration: V12/12.25P3.AUTax/006 (Audit ScriptRunner) |
[Audit] rar.SuperStreamBatch | PaymentCutOffDate | New Column | DATE NULL. Mirror's main table change. Migration: V12/12.25P3.AUTax/006 (Audit ScriptRunner) |