Payroll_Payslips view

Column Type

User_Id

String

User

URI

Year

Integer

Period

Integer

Postgrad_Loan_Deduction

Decimal

Employer_Ni

Decimal

Student_Loan_Deduction

Decimal

Employee_Pension_Salary_Sacrifice

Decimal

Tax_Code

String

Other_Deductions

Decimal

Commission

Decimal

Frequency

String

Other_Deductions_From_Net_Pay

Decimal

Absence_Payments

Decimal

Statutory_Adoption_Pay

Decimal

Dated_On

Date

Deduction_Free_Pay

Decimal

Basic_Pay

Decimal

Week_1_Month_1_Basis

Boolean

Tax_Deducted

Decimal

Statutory_Maternity_Pay

Decimal

Statutory_Sick_Pay

Decimal

Statutory_Paternity_Pay

Decimal

Employee_Ni

Decimal

Employer_Pension

Decimal

Overtime

Decimal

Allowance

Decimal

Bonus

Decimal

Statutory_Parental_Bereavement_Pay

Decimal

Other_Payments

Decimal

Created_At

Timestamp

Employee_Pension

Decimal

Employee_Pension_Not_Under_Net_Pay

Decimal

Attachments

Decimal

Payroll_Giving

Decimal

Ni_Calc_Type

String

Additional_Statutory_Paternity_Pay

Decimal

Deductions_Subject_To_Nic_But_Not_Paye

Decimal

Other_Salary_Sacrifice_Deductions

Decimal

Ni_Letter

String

Deduct_Student_Loan

Boolean

Deduct_Postgrad_Loan

Boolean

Student_Loan_Deductions_Plan

String

Hours_Worked

Decimal

Updated_At

Timestamp

Period_Url_Id

URI

Period_Url

URI

Period_Status

String

Period_Updated_At

Timestamp

Period_Dated_On

String

Period_Employment_Allowance_Claimed

Boolean

Period_Created_At

Timestamp

Period_Employment_Allowance_Amount

Decimal

Period_Construction_Industry_Scheme_Deduction

Decimal

Period_Frequency

String