erDiagram
BACKPAYITEM {
Id Guid
BackPayDate Date
EarnedDate Date
PaidFromDate Date
PaidToDate Date
}
EMPLOYEE {
Id Guid
PersonOnPayrollId Guid
Name String
PersonalReference String
StartDate Date
PaymentMethod String
}
EMPLOYEEINPAYRUN {
Id Guid
EmployeeId Guid
JobTitle String
PayRunId Guid
}
EMPLOYEEPAYRUNVALUE {
Id Guid
PayRunId Guid
PayslipItemGroupCode String
EmployeeId Guid
PayslipItemId Guid
PotType String
Discriminator String
Tag String
PayslipItemDefinitionRuleType String
Value Decimal
OccupancyId Guid
Units Decimal
Time Decimal
Rate Decimal
}
EXPENSECLAIMINPERIOD {
Id Guid
PersonRef String
PersonName String
Department String
FRN String
PayslipItem String
PaymentDate Date
CreatedDateTime DateTimeOffset
EarnedDate Date
Comments String
Units Decimal
Time Decimal
Rate Decimal
Cash Decimal
CreatedBySystemUserName String
AuthorisedBy String
ApprovalDateTime DateTimeOffset
Payroll String
}
OCCUPANCY {
Id Guid
PersonId Guid
StartDate Date
EndDate Date
}
OCCUPANCYPAYELEMENTS {
Id Guid
PayslipItemId Guid
EffectiveStartDate Date
EffectiveEndDate Date
Cash Decimal
Rate Decimal
Time Decimal
Units Decimal
Frequency String
}
PAYPERIOD {
Id Guid
PayrollId Guid
StartDate Date
EndDate Date
PayDate Date
}
PAYRUN {
Id Guid
PayPeriodId Guid
PaymentDate Date
IsMainRun Boolean
StateName String
}
PAYRUNEMPLOYEEDATASUMMARY {
Id Guid
Name String
PersonalReference String
StartDate Date
LeaveDate Date
Item String
Value Decimal
ItemId Guid
PaymentMethod String
Firstname String
Lastname String
}
PAYROLL {
Id Guid
Name String
Frequency String
}
PAYROLLSCHEMEANDBENEFIT {
Id Guid
FKPayslipItemId Guid
FKOccupancyId Guid
FKSchemeAndBenefitItemId Guid
Cash Decimal
Percentage Decimal
StartDate Date
EndDate Date
}
PAYROLLADJUSTMENT {
Id Guid
PotDefinitionId Guid
PayRunId Guid
PersonOnPayrollId Guid
OccupancyId Guid
AdjustmentTypeId String
NiCategory String
AttachmentOfEarningsReferenceNumber String
Code String
}
PAYSLIPITEMGROUP {
Code String
Name String
}
PENSION {
Name String
StartDate Date
EndDate Date
PayslipItemId Guid
PensionProvider String
Id Guid
}
PENSIONOCCUPANCY {
Id Guid
OccupancyId Guid
PersonOnPayrollId Guid
MembershipReference String
StartDate Date
EndDate Date
PensionId Guid
}
AUTOENROLMENTASSESSMENT {
PersonOnPayrollId Guid
OccupancyId Guid
PayPeriodId Guid
PensionSchemeDefinitionId Guid
StartDate Date
EndDate Date
ActionState String
AssessedAsOption String
EnrolmentOption String
DoNotEnrolOption String
EmployerRefundAmount Decimal
EmployeeRefundAmount Decimal
AssessmentOption String
Id Guid
}
PENSIONREPORTMAPPINGACCUMULATOR {
Id Guid
PayslipItemId Guid
PayslipItemName String
RelatedField String
PensionReportMappingAccumulatorId Guid
PensionReportTypeId Guid
PensionReportType String
}
PERSONONPAYROLLINPERIODUKLEGISLATION {
Id Guid
PaymentDate Date
PayrollReferenceNumber String
TaxCode String
TaxBasis Boolean
NICategory String
}
PERSONONPAYROLLPENDINGCALCULATIONTOTAL {
Id Guid
Name String
PersonOnPayrollIdCount Int32
}
RECONCILIATION {
Id Guid
Name String
PensionName String
ComparisonPayRunId Guid
IsTotal Boolean
SortOrderNumber Int32
SortOrderGroup Int32
ComparisonValue Decimal
Value Decimal
AdjustmentsValue Decimal
DifferenceValue Decimal
DifferencePercent Int32
ComparisonYTDValue Decimal
YTDValue Decimal
ItemId String
}
RECONCILIATIONEMPLOYEEPAYRUNDEPARTMENT {
Id Guid
ComparisonPayRunId Guid
Department String
}
RECONCILIATIONEMPLOYEEPAYRUNFRN {
Id Guid
ComparisonPayRunId Guid
FinanceReferenceNumber String
}
RECONCILIATIONEMPLOYEEPAYRUNITEM {
Id Guid
ComparisonPayRunId Guid
Item String
ItemId Guid
Value Decimal
ComparisonValue Decimal
}
RECONCILIATIONEMPLOYEEPAYRUNJOBTITLE {
Id Guid
ComparisonPayRunId Guid
JobTitle String
}
RECONCILIATIONEMPLOYEEPAYRUNLOCATION {
Id Guid
ComparisonPayRunId Guid
Location String
}
RECONCILIATIONEMPLOYEEPAYRUNVALUE {
Id Guid
ComparisonPayRunId Guid
SortOrderGroup Int32
SortOrderNumber Int32
ItemId Guid
Firstname String
Lastname String
PensionName String
Name String
PersonalReference String
PersonSocialSecurityNumber String
Department String
Location String
FinanceReferenceNumber String
JobTitle String
StartDate Date
LeaveDate Date
Item String
Value Decimal
ComparisonValue Decimal
AdjustmentsValue Decimal
DifferenceValue Decimal
DifferencePercent Int32
ComparisonYTDValue Decimal
YTDValue Decimal
PaymentMethod String
Payroll String
PaymentDate Date
ComparisonPaymentDate Date
}
RECONCILIATIONFRNPAYRUNITEM {
Id Guid
ComparisonPayRunId Guid
FinanceReferenceNumber String
Item String
PensionName String
Value Decimal
ComparisonValue Decimal
DifferenceValue Decimal
DifferencePercent Int32
ItemId Guid
}
RECONCILIATIONLOCATIONPAYRUNITEM {
Id Guid
ComparisonPayRunId Guid
Location String
Item String
ItemId Guid
PensionName String
SortOrderNumber Int32
SortOrderGroup Int32
Value Decimal
ComparisonValue Decimal
DifferenceValue Decimal
DifferencePercent Int32
}
EMPLOYEEPERIODVALUE {
Id Guid
PayPeriodId Guid
PayslipItemGroupCode String
EmployeeId Guid
PotType String
Discriminator String
Tag String
PayslipItemDefinitionRuleType String
Value Decimal
}
PAYPERIODVALUE {
Id Guid
PayPeriodId Guid
PayslipItemGroupCode String
PotType String
Discriminator String
Tag String
PayslipItemDefinitionRuleType String
Value Decimal
}
EMPLOYEEINPAYPERIOD {
Id Guid
EmployeeId Guid
PayPeriodId Guid
}
PAYRUNVALUE {
Id Guid
PayRunId Guid
PayslipItemGroupCode String
PotType String
Discriminator String
Tag String
PayslipItemDefinitionRuleType String
Value Decimal
LegislativeConfiguration String
}
OCCUPANCYTITLEREVISION {
Id Guid
OccupancyId Guid
Title String
StartDate Date
}
Resource_Paths {
BackPayItems URL
People URL
EmployeesInPayRun URL
EmployeePayRunValues URL
ExpenseClaimsInPeriod URL
Occupancies URL
OccupancyPayElements URL
PayPeriods URL
PayRuns URL
PayRunEmployeeDataSummaries URL
Payrolls URL
SchemeAndBenefitPayslipItems URL
PayrollAdjustments URL
PayslipItemGroups URL
Pensions URL
PensionOccupancies URL
AutoEnrolmentAssessments URL
PensionReportMappingAccumulators URL
PersonOnPayrollInPeriodUKLegislations URL
PersonOnPayrollPendingCalculationTotals URL
Reconciliations URL
ReconciliationEmployeePayRunDepartments URL
ReconciliationEmployeePayRunFrns URL
ReconciliationEmployeePayRunItems URL
ReconciliationEmployeePayRunJobTitles URL
ReconciliationEmployeePayRunLocations URL
ReconciliationEmployeePayRunValues URL
ReconciliationFrnPayRunItems URL
ReconciliationLocationPayRunItems URL
}
EMPLOYEEINPAYRUN o{--|| EMPLOYEE : Employee
EMPLOYEEINPAYRUN o{--|| PAYRUN : PayRun
EMPLOYEEPAYRUNVALUE o{--|| PAYRUN : PayRun
EMPLOYEEPAYRUNVALUE o{--|| PAYSLIPITEMGROUP : PayslipItemGroup
EMPLOYEEPAYRUNVALUE o{--|| EMPLOYEE : Employee
EMPLOYEEPAYRUNVALUE o{--|| OCCUPANCY : Occupancy
OCCUPANCY o{--|| EMPLOYEE : Employee
PAYPERIOD o{--|| PAYROLL : Payroll
PAYRUN o{--|| PAYPERIOD : PayPeriod
EMPLOYEEPERIODVALUE o{--|| PAYPERIOD : PayPeriod
EMPLOYEEPERIODVALUE o{--|| PAYSLIPITEMGROUP : PayslipItemGroup
EMPLOYEEPERIODVALUE o{--|| EMPLOYEE : Employee
PAYPERIODVALUE o{--|| PAYPERIOD : PayPeriod
PAYPERIODVALUE o{--|| PAYSLIPITEMGROUP : PayslipItemGroup
EMPLOYEEINPAYPERIOD o{--|| EMPLOYEE : Employee
EMPLOYEEINPAYPERIOD o{--|| PAYPERIOD : PayPeriod
PAYRUNVALUE o{--|| PAYRUN : PayRun
PAYRUNVALUE o{--|| PAYSLIPITEMGROUP : PayslipItemGroup
OCCUPANCYTITLEREVISION o{--|| OCCUPANCY : Occupancy
PAYROLLSCHEMEANDBENEFIT o{--|| OCCUPANCY : Occupancy
PAYROLLADJUSTMENT o{--|| OCCUPANCY : Occupancy
PAYROLLADJUSTMENT o{--|| PAYRUN : Payrun