# OtherPayrollVariablesByEmploymentId List of other payroll variables for an employment __Activity name :__ GetOtherPayrollVariablesByEmploymentId Get a list of the other payroll variables for an employment Other payroll variables are a set of infrequently used properties for the payroll (wage tax and pension) proces This is a read-only table function. The Loket.nl REST API may not support changing the data, or the Invantive UniversalSQL driver for Loket.nl REST does not support it. In the latter case, use the table NativePlatformScalarRequests to upload data to the Loket.nl REST API. - Catalog: `LoketNlRest` - Schema: `OtherPayrollVariables` ## Parameters of Table Function | Name | Data Type | Required | Default Value | Documentation | |---|:---:|:---:|:---:|---| | `employmentId` | `guid` | ☑ | | The unique identifier of the employment | ## Columns The columns of the table `OtherPayrollVariablesByEmploymentId` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `endDate` | `datetime` | End Date | ☐ | The end date of the entity. The date is up to and including. | | `id` | `guid` | ID | ☐ | The unique identifier of an object (GUID/UUID) | | `insuranceProperties_applicableForNoRiskPolicy` | `boolean` | | ☐ | Indicates if the employment is applicable for the "Looncompensatie bij ziekte (no-riskpolis)" as defined by the UWV. Please check with the UWV to determine when to set the value to true. | | `payrollProperties_applyMinimumWageVocationalLearningPathway` | `boolean` | | ☐ | Minimum wage vocational learning pathway (Minimumloon BBL) <to do> | | `payrollProperties_applyYearlyHoursNorm` | `boolean` | | ☐ | applyYearlyHoursNorm (jaarurennorm) indicates if the contract is based on a set numbers of hours per year and a set wage is payed every payroll period. | | `payrollProperties_collectiveLaborAgreementCodeHiringEmployer_endDate` | `datetime` | | ☐ | The end date of the CAO | | `payrollProperties_collectiveLaborAgreementCodeHiringEmployer_key` | `int32` | | ☐ | | | `payrollProperties_collectiveLaborAgreementCodeHiringEmployer_startDate` | `datetime` | | ☐ | The start date of the CAO | | `payrollProperties_collectiveLaborAgreementCodeHiringEmployer_value` | `string(90)` | | ☐ | | | `payrollProperties_deviatingPremiumGroup_key` | `int32` | | ☐ | | | `payrollProperties_deviatingPremiumGroup_value` | `string(50)` | | ☐ | | | `payrollProperties_incidentalIncomeDeduction_key` | `int32` | | ☐ | | | `payrollProperties_incidentalIncomeDeduction_value` | `string(50)` | | ☐ | | | `payrollProperties_occupationalDisabilityDeductionAfter2009` | `double` | | ☐ | (OccupationalDisability) Deduction after 2009 (Arbeidsgeh.krt na 2009 (tm 2009 WAO)) <to do> Up to and including 2009, the premium discount for employees with an occupational disability had to be split into a part for the WAO/WIA premium and a part for the WW-awf or UFO premium. From 2010 you no longer need to split the total amount. Loket.nl will add up the amounts entered at Arbeidsgeh.krt na 2009 (tm 2009 WAO) and Arbeidsgeh. krt (tm 2009 AWF/UFO). From 2010 it is therefore sufficient to fill Arbeidsgeh.krt na 2009 (tm 2009 WAO). From 2013 this field may no longer contain a value; the premium discount for employees with an occupational disability is determined automatically based on the indication entered in the premium discount field | | `payrollProperties_occupationalDisabilityDeductionTo2009` | `double` | | ☐ | (OccupationalDisability) Deduction to 2009 (including 2009) (Arbeidsgeh.krt (tm 2009 AWF/UFO)) Up to and including 2009, the premium discount for employees with an occupational disability had to be split into a part for the WAO/WIA premium and a part for the WW-awf or UFO premium. From 2010 you no longer need to split the total amount. Loket.nl will add up the amounts entered at Arbeidsgeh.krt na 2009 (tm 2009 WAO) and Arbeidsgeh. krt (tm 2009 AWF/UFO). From 2010 it is therefore sufficient to fill Arbeidsgeh.krt na 2009 (tm 2009 WAO). From 2013 this field may no longer contain a value; the premium discount for employees with an occupational disability is determined automatically based on the indication entered in the premium discount field | | `payrollProperties_occupationalDisabilityPremiumDiscount_key` | `int32` | | ☐ | | | `payrollProperties_occupationalDisabilityPremiumDiscount_value` | `string(80)` | | ☐ | | | `payrollProperties_phaseClassification_key` | `int32` | Phase Classification Key | ☐ | | | `payrollProperties_phaseClassification_value` | `string(60)` | Phase Classification Value | ☐ | | | `payrollProperties_terminateIncomenumberFlexibleEmployment_key` | `int32` | | ☐ | | | `payrollProperties_terminateIncomenumberFlexibleEmployment_value` | `string(50)` | | ☐ | | | `payrollProperties_wageCostBenefit_key` | `int32` | | ☐ | | | `payrollProperties_wageCostBenefit_value` | `string(50)` | | ☐ | | | `payrollProperties_wajongWithWageDispensation` | `boolean` | | ☐ | wajongWithDispensation (Wajong met loondispensatie (was Doelgroep banenafspraak)) indicates that the employer has the express premission to lower the wage of this employment (even below minimum wage). This indicator will disable the validation on minimum wage for this employment. | | `pensionProperties_annualCalculationBaseAbp` | `double` | | ☐ | annualCalculationBase (jaargrondslag voor ABP) for ABP <to do> | | `pensionProperties_applyDispensationRiskFund` | `boolean` | | ☐ | applyDispensationRiskFund (Disp. risicofonds) <to do> | | `pensionProperties_compulsoryEducationDays` | `int32` | | ☐ | compulsoryEducationDays (Aantal dagen leerplicht) <to do> | | `pensionProperties_deviatingDisabilityInsuranceActPercentageForCordares_key` | `int32` | | ☐ | | | `pensionProperties_deviatingDisabilityInsuranceActPercentageForCordares_value` | `string(50)` | | ☐ | | | `pensionProperties_leaveAbp_leaveType_key` | `int32` | | ☐ | | | `pensionProperties_leaveAbp_leaveType_value` | `string(50)` | | ☐ | | | `pensionProperties_leaveAbp_valueOfParticipationDuringLeave` | `int32` | | ☐ | valueOfParticipation (waardeDeelnemerschap) (pensioen opbouw voor ambtenaren ABP) | | `pensionProperties_occupationalPensionFund` | `int32` | | ☐ | Occupational Pension Fund (BPF-code) <to do> | | `pensionProperties_specificationOfIncomeRelationshipApg_code` | `string(4)` | | ☐ | | | `pensionProperties_specificationOfIncomeRelationshipApg_key` | `int32` | | ☐ | | | `pensionProperties_specificationOfIncomeRelationshipApg_value` | `string(75)` | | ☐ | | | `productivityPercentage` | `double` | | ☐ | productivityPercentage (Productiviteitspercentage) can be used to indicate the productivity percentage of an employment. | | `startDate` | `datetime` | Start Date | ☐ | The date on which this record starts. A (broken chain)[./#section/Data/Date-chains] is maintained with this record. |