Display Name

Master Report - Absence Data Integrity Detection

Description

This process shows the data integrity violations.

Test Name

Master Report - Absence Data Integrity Detection

Test Type

D

Sensitivity

L

Usage

Version

11.13.19.10.0

Display Name

Business Unit

From Date - Required

Legislative Data Group

Legal Employer

Person Number

Test Code

To Date - Required

Parameter Name

buId

fromDate

ldgId

leId

personNumber

testCode

toDate

Description

This field holds business_unit

This field holds the from date. This field is used as a end date range for the report.

This field holds legislative_data_group.

This field holds legal_employer.

This field holds person number. You can either enter single person number or comma separated multiple person numbers or leave it null to run it for whole population.

Test code field. Leave it blank to run all tests. A test code is required if running for whole population.

This field holds the to date. This field is used as a start date range for the report.

In/Output

I

I

I

I

I

I

I

Required

false

true

false

false

false

false

true

Secured

false

false

false

false

false

false

false

Type

java.lang.String

Java.util.date

java.lang.String

java.lang.String

java.lang.String

java.lang.String

Java.util.date

Default Value

ALL_BU

ALL_LDG

ALL_LE

ALL_TESTS

Active

Y

Y

Y

Y

Y

Y

Y

Test Code

Test Code Value

Test Name

Description

ALL_TESTS

ALL_TESTS

TXN02

Absences - Update Absence - Period_Of_Service_Id

TXN02.Period_of_service null for absences.

This test retrieves absences having value of period_of_service_id as null

FF01

Absences - Update Formula_id in Entitlement Band

FF01.Invalid Formula Id (0)

This test retrieves entitlement bands with formula_id having value 0

HR05E

Absences - Delete Enrollments of Canceled Work Relationship

HR05E.Enrollment data is not deleted for canceled work relationship

This test retrieves orphan enrollments whose work-relationship has been cancelled

HR05A

Absences - Delete Absences of Canceled Work Relationship

HR05A.Absences are not deleted for canceled work relationship

This test retrieves orphan absences whose work-relationship has been cancelled

ACRL02

Absences - Delete Orphan ADJOTH/INIT entries

ACRL02.Orphan ADJ/INIT entries created when deleting enrollments

This test retrieves orphan "Other adjustments" and INIT entries in accrual table

ACRL07

Absences - Delete Orphan COVREX entries

ACRL07.Multiple Carryover expiration entries

This test retrieves orphan "COVREX" entries in accrual table

TXN05

Absences - Delete Processing Data of Withdrawn Absences

TXN05.Withdrawn absences having processing data

This test retrieves absences which have been withdrawn but still have processing data

WFM04

Absences - Delete Orphan Time Card Entries

WFM04.Timecard includes an absence record that does not exists

This test retrieves orphan time card entries with "SAVED" status

PAY01AB

Absences - Delete Calculation Card Entries - Absences

PAY01AB.Absence deleted, calculation card not removed

This test retrieves orphan calculation card entries for deleted/withdrawn absences

ACRL08

Absences - Delete Orphan FORFT entries

ACRL08.Orphan FORFT entries created when running accruals

This test retrieves orphan Forfeiture entries in accrual table

HR03E

Absences - Update Enrollments for Termination

HR03E.Absences Integration with Termination - Enrollments

This test retrieves orphan enrollments whose work-relationship has been terminated

PAY01AC

Absences - Delete Calculation Card Entries - Accruals

PAY01AC.Accruals deleted, calculation card not removed

This test retrieves orphan calculation card entries for deleted accruals

WSCH01

Absences - Update Assignment Number for Work Schedule

WSCH01.Incorrect Assignment number (schedule)

This test retrieves the schedules that have incorrect ASSIGNMENT_NUM field

ENRL08

Absences - Delete Enrollments with end date prior to start date

ENRL08.Enrollment incorrectly end dated before start date

This test retrieves the enrollments which have start date one day after end date

TXN13

Absences - Delete Absences for end dated type

TXN13.Absence present after type end date

This test retrieves the absences that are present after plan end date