# DienstverbandenPerPersoon: Employments per Person - Name: `DienstverbandenPerPersoon` - Catalog: `LoketNL` - Schema: `Lists` - Label: Employments per Person ## Parameters of Table Function | Name | Data Type | Required | Default Value | Documentation | |---|:---:|:---:|:---:|---| | `personId` | `string` | ☑ | | | ## Table Columns The columns of the table `DienstverbandenPerPersoon` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `AANLEVERINGEXTERNEPARTIJ` | `int32` | External Party Delivery | ☐ | | | `AANSTELLINGTOT` | `datetime` | Appointment Until | ☐ | | | `AANSTELLINGTOT1` | `datetime` | Appointment Until 1 | ☐ | | | `AANSTELLINGTOT2` | `datetime` | Appointment Until 2 | ☐ | | | `AANSTELLINGTOT3` | `datetime` | Appointment Until 3 | ☐ | | | `AANSTELLINGTOT4` | `datetime` | Appointment Until 4 | ☐ | | | `AANSTELLINGTOT5` | `datetime` | Appointment Until 5 | ☐ | | | `AANSTELLINGTOT6` | `datetime` | Appointment Until 6 | ☐ | | | `AANVANGOPZEGTERMIJN` | `datetime` | Start of Notice Period | ☐ | | | `AARDDEELNEMERSCHAP` | `int32` | Participation Type | ☐ | | | `BASISDIENSTVERBAND` | `int32` | Base Employment | ☐ | | | `BEROEPUWV` | `int32` | Occupation UWV | ☐ | | | `CAO` | `int32` | CAO | ☐ | | | `CAOKLANTGROEPAFWIJKEND` | `int32` | CAO Customer Group Deviating | ☐ | | | `CAOOMSCHRIJVING` | `string(120)` | CAO Description | ☐ | | | `CAOUWV` | `int32` | CAO UWV | ☐ | | | `CODEUITZONDERING` | `int32` | Exception Code | ☐ | | | `COMPLETEREN` | `int32` | Complete | ☐ | | | `DATUMINDIENST` | `datetime` | Start Date of Employment | ☐ | | | `DATUMOPZEGGING` | `datetime` | Termination Date | ☐ | | | `DATUMPROFIELTOEPASSEN` | `datetime` | Apply Profile Date | ☐ | | | `DATUMUITDIENST` | `datetime` | End Date of Employment | ☐ | | | `DEELNAME55PLUS` | `int32` | Participation 55 Plus | ☐ | | | `DIENSTVERBANDID` | `int32` | Employment ID | ☐ | | | `EERSTEDAGSMELDING` | `int32` | First Day Notification | ☐ | | | `EMAILVERLOFAANVRAAG` | `int32` | Leave Request Email | ☐ | | | `ENTRYID` | `string(480)` | Entry ID | ☐ | | | `EXPORTSETID` | `int32` | Export Set ID | ☐ | | | `EXTERNID` | `guid` | External ID | ☐ | | | `HISTORISCHEDATUMINDIENST` | `datetime` | Historical Start Date of Employment | ☐ | | | `ISANONIEMEWERKNEMER` | `int32` | Is Anonmous Employee | ☐ | | | `ISDIRECTEURGROOTAANDEELHOUDER` | `int32` | Is Director Major Shareholder | ☐ | | | `ISFAMILIEVANEIGENAAR` | `int32` | Is Related to Owner | ☐ | | | `ISGEMOEDSBEZWAARDVOLKSVERZEKERING` | `int32` | Is Conscientious Objector National Insurance | ☐ | | | `ISGEMOEDSBEZWAARDWERKNEMERVERZEKERING` | `int32` | Is Conscientious Objector Employee Insurance | ☐ | | | `ISOPROEPKRACHTOFINVALKRACHT` | `int32` | Is On-Call or Substitute Worker | ☐ | | | `ISVORIGEEIGENAAR` | `int32` | Is Previous Owner | ☐ | | | `LOONMODELOMSCHRIJVING` | `string(120)` | Payroll Model Description | ☐ | | | `NAAM` | `string(240)` | Name | ☐ | | | `NAAMLOONSTROOK` | `string(240)` | Name Payslip | ☐ | | | `NUMMERINKOMSTENVERHOUDING` | `int32` | Income Relationship Number | ☐ | | | `OPZEGTERMIJNWERKGEVER` | `int32` | Employer Notice Period | ☐ | | | `OPZEGTERMIJNWERKNEMER` | `int32` | Employee Notice Period | ☐ | | | `OVERLIJDENSDATUM` | `datetime` | Date of Death | ☐ | | | `PERIODEOPZEGTERMIJN` | `int32` | Notice Period Term | ☐ | | | `PERIODESALARISPERIODIEK` | `int32` | Salary Increment Period | ☐ | | | `PERSONEELSNUMMER` | `int32` | Employee Number | ☐ | | | `PERSONEELSNUMMERVERLONING` | `int32` | Payroll Employee Number | ☐ | | | `PERSOONID` | `int32` | Person ID | ☐ | | | `PREMIEVRIJSTELLINGMARGINALEARBEID` | `int32` | Premium Exemption Marginal Labour | ☐ | | | `REDENEINDEDIENSTVERBAND` | `int32` | Reason for End of Employment | ☐ | | | `SALARISSCHAALSIGNALEREN` | `int32` | Flag Salary Scale | ☐ | | | `SOFINUMMER` | `int32` | Social Security Number | ☐ | | | `SOORTDIENSTVERBAND` | `int32` | Employment Type | ☐ | | | `SOORTOPROEPKRACHTOFINVALKRACHT` | `int32` | On-Call or Substitute Worker Type | ☐ | | | `SOORTWERKNEMER` | `int32` | Employee Type | ☐ | | | `SPECIALEINKOMSTENVERHOUDING` | `int32` | Special Income Relationship | ☐ | | | `TIJDELIJKEHEFFINGSKORTING` | `int32` | Temporary Tax Credit | ☐ | | | `VAKANTIEBONNEN` | `int32` | Holiday Vouchers | ☐ | | | `VERLONINGID` | `int32` | Payroll ID | ☐ | | | `WAARDEDEELNEMERSCHAP` | `int32` | Participation Value | ☐ | | | `WACHTGELDOUDEREGELING` | `int32` | Waiting Allowance Old Scheme | ☐ | | | `WERKKOSTENREGELINGUITSLUITING` | `int32` | Work Cost Scheme Exclusion | ☐ | | | `WERKNEMERPROFIELID` | `int32` | Employee Profile ID | ☐ | | | `ZIEKUITDIENST` | `int32` | Sick After Leaving Employment | ☐ | |