# PayrollProcessStatusByProviderId Payroll status for each administration (deprecated). __Activity name :__ GetPayrollProcessStatusByProviderId __Metadata :__ Possible options for fields of the type 'metadata' can be acquired (GET) by adding `/metadata` to the POST URL. __Defaults :__ The default value for payrollPeriod.payrollPeriodId can be acquired by adding `/defaults' to the POST URL. __Deprecated :__ This endpoint will no longer be developed. Returns an array of objects. Each object contains information about the payroll administration and the payroll processes status. 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: `PayrollProcessStatus` ## Parameters of Table Function | Name | Data Type | Required | Default Value | Documentation | |---|:---:|:---:|:---:|---| | `payrollPeriodId` | `int32` | ☐ | | The unique identifier of the payroll period to return. | | `providerId` | `guid` | ☑ | | The unique identifier of a provider | ## Columns The columns of the table `PayrollProcessStatusByProviderId` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `administrationNumber` | `string(15)` | Administration Number | ☐ | The administration number is a free field commonly used to register the debtors number. | | `cao_key` | `int32` | Collective Labour Agreement Key | ☐ | | | `cao_value` | `string(50)` | Collective Labour Agreement Value | ☐ | | | `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. | | `employerId` | `guid` | | ☐ | The unique identifier of an object (GUID/UUID) | | `employerLogo` | `string` | Employer Logo | ☐ | The location of the logo of the employer. The last part of the returned endpoint is the version of the logo this allows users to cache the image. Changing the value of the version will not influence the output. | | `groupClassification_key` | `int32` | | ☐ | | | `groupClassification_value` | `string` | | ☐ | | | `groupCode` | `int64` | Group Code | ☐ | Number (integer) used for grouping administrations. | | `hasAutomaticPayroll` | `boolean` | | ☐ | Indicates whether automatic payrolling is set | | `id` | `guid` | ID | ☐ | The unique identifier of an object (GUID/UUID) | | `loonmodel_key` | `int32` | | ☐ | | | `loonmodel_value` | `string(50)` | | ☐ | | | `name` | `string(70)` | Name | ☐ | Name of the administration | | `payrollPeriod_announcements_hasUnreadAnnouncements` | `boolean` | | ☐ | Indicates whether the administration has unread announcements | | `payrollPeriod_notifications_hasUnreadNotifications` | `boolean` | | ☐ | Indicates whether the administration has unread notifications | | `payrollPeriod_payrollPeriodId` | `int32` | | ☐ | The year and period of the payroll period | | `payrollPeriod_payrollProcess_methodOfCreation_key` | `int32` | | ☐ | The key indicating how the payroll run was created. | | `payrollPeriod_payrollProcess_methodOfCreation_value` | `string` | | ☐ | The value describing how the payroll run was created. | | `payrollPeriod_payrollProcess_status_key` | `int32` | | ☐ | | | `payrollPeriod_payrollProcess_status_value` | `string` | | ☐ | | | `payrollPeriod_periodEndDate` | `datetime` | Payroll Period End Date | ☐ | The last day of the period to which the payroll period data applies | | `payrollPeriod_periodNumber` | `int32` | Payroll Period Number | ☐ | The period (month [1 to 12] , 4 weeks [1 to 13] or week [1 to 53]) | | `payrollPeriod_periodStartDate` | `datetime` | Payroll Period Start Date | ☐ | The first day of the period to which the payroll period data applies | | `payrollPeriod_year` | `int32` | Payroll Processing Year Period | ☐ | The year of the payroll period | | `payrollPeriodType_key` | `int32` | Payroll Processing Period Type Key | ☐ | | | `payrollPeriodType_value` | `string(50)` | Payroll Processing Period Type Value | ☐ | | | `shortName` | `string(12)` | Short Name | ☐ | Shortened name of the administration |