# PayrollAdministrationConfigurationByPayrollAdministrationId Details of a payroll administration configuration __Activity name :__ GetPayrollAdministrationConfigurationByPayrollAdministrationId Get the details of a single payroll administration configuration 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: `PayrollAdministration` ## Parameters of Table Function | Name | Data Type | Required | Default Value | Documentation | |---|:---:|:---:|:---:|---| | `payrollAdministrationId` | `guid` | ☑ | | The unique identifier of an administration | ## Columns The columns of the table `PayrollAdministrationConfigurationByPayrollAdministrationId` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `clientNumber` | `int32` | Customer Number | ☐ | The client number is a unique number for administrations that are used for payrolling. This field has no value if the administration is not used for payrolling. | | `defaults_calculateUsingWorkPattern_daysDailyRate` | `boolean` | | ☐ | Indicates whether the number of days of dailyrate should be calculated based on the workpattern. The number of days are normally calculated by the working hours. | | `defaults_calculateUsingWorkPattern_deviatingDaysAndHours` | `boolean` | | ☐ | Indication whether the deviating hours per week and deviating SV-days per period are to be automatically calculated based on the workpattern. Please note (!) that any values in the deviatingHoursPerWeek and deviatingSvDaysPerPeriod fields (of this workingHours record) will be overwritten based on this calculation if true (and endDate=NULL)! | | `defaults_calculateUsingWorkPattern_hoursBrokenPeriod` | `boolean` | | ☐ | Indicates whether the hours for the payrolling should be calculated based on the workpattern in broken periods. These are periods of in or out of service. | | `defaults_calculateUsingWorkPattern_hoursRegularPeriod` | `boolean` | | ☐ | Indicates whether the hours for the payrolling should be calculated based on the workpattern for regular periods. | | `defaults_componentSet_payrollPeriodDataCollectiveCategory_key` | `int64` | | ☐ | | | `defaults_componentSet_payrollPeriodDataCollectiveCategory_value` | `string` | | ☐ | | | `defaults_componentSet_payrollPeriodDataCollectiveComponentSet_description` | `string` | | ☐ | | | `defaults_componentSet_payrollPeriodDataCollectiveComponentSet_id` | `guid` | | ☐ | | | `defaults_componentSet_payrollPeriodDataCollectiveComponentSet_registrationLevel` | `string` | | ☐ | The level at which the set is defined. | | `defaults_componentSet_payrollPeriodDataEmployeeSelfService_description` | `string` | | ☐ | | | `defaults_componentSet_payrollPeriodDataEmployeeSelfService_id` | `guid` | | ☐ | | | `defaults_componentSet_payrollPeriodDataEmployeeSelfService_registrationLevel` | `string` | | ☐ | The level at which the set is defined. | | `defaults_componentSet_payrollPeriodDataIndividual_description` | `string` | | ☐ | | | `defaults_componentSet_payrollPeriodDataIndividual_id` | `guid` | | ☐ | | | `defaults_componentSet_payrollPeriodDataIndividual_registrationLevel` | `string` | | ☐ | The level at which the set is defined. | | `defaults_componentSet_payrollPeriodDataLeave_description` | `string` | | ☐ | | | `defaults_componentSet_payrollPeriodDataLeave_id` | `guid` | | ☐ | | | `defaults_componentSet_payrollPeriodDataLeave_registrationLevel` | `string` | | ☐ | The level at which the set is defined. | | `defaults_componentSet_payrollPeriodDataWerkkosten_description` | `string` | | ☐ | | | `defaults_componentSet_payrollPeriodDataWerkkosten_id` | `guid` | | ☐ | | | `defaults_componentSet_payrollPeriodDataWerkkosten_registrationLevel` | `string` | | ☐ | The level at which the set is defined. | | `defaults_employmentContractType_key` | `int32` | | ☐ | | | `defaults_employmentContractType_value` | `string` | | ☐ | | | `defaults_employmentDurationType_key` | `int32` | | ☐ | | | `defaults_employmentDurationType_value` | `string` | | ☐ | | | `defaults_grossWageType_key` | `int32` | | ☐ | | | `defaults_grossWageType_value` | `string(50)` | | ☐ | | | `defaults_mdvNotification` | `boolean` | | ☐ | Indicate if a Mdv (melding dienstverband) should be send. | | `defaults_netWageType_key` | `int32` | | ☐ | | | `defaults_netWageType_value` | `string(50)` | | ☐ | | | `defaults_payslipAvailableForEmployeeDay` | `int64` | | ☐ | The default day (number) of the period on which payslips will be made available for employees. | | `defaults_typeOfEmployee_key` | `int32` | | ☐ | | | `defaults_typeOfEmployee_value` | `string` | | ☐ | | | `description` | `string(50)` | Description | ☐ | Description of the administration | | `endDate` | `datetime` | End Date | ☐ | The last day the administration is active. | | `holidayAllowanceBaseForCalculation_key` | `int32` | | ☐ | | | `holidayAllowanceBaseForCalculation_value` | `string(50)` | | ☐ | | | `holidayAllowancePercentage` | `double` | Holiday Allowance Percentage | ☐ | The percentage of the holidayAllowance. | | `id` | `guid` | ID | ☐ | The unique identifier of an object (GUID/UUID) | | `payrollPeriodType_key` | `int32` | Payroll Processing Period Type Key | ☐ | | | `payrollPeriodType_value` | `string(50)` | Payroll Processing Period Type Value | ☐ | | | `startDate` | `datetime` | Start Date | ☐ | The first day the administration is active. | | `synchronize_contactInformation` | `boolean` | | ☐ | Synchronize contact information from employer to administration | | `synchronize_nameAndAddress` | `boolean` | | ☐ | Synchronize name and address information from employer to administration | | `yearEndBaseForCalculation_key` | `int32` | | ☐ | | | `yearEndBaseForCalculation_value` | `string(50)` | | ☐ | | | `yearEndPercentage` | `double` | Year-End Percentage | ☐ | The percentage of the year end bonus. |