# Verloven: Leaves - Name: `Verloven` - Catalog: `LoketNL` - Schema: `Views` - Label: Leaves ## Table Columns The columns of the table `Verloven` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `dvd_AANLEVERINGEXTERNEPARTIJ` | `int32` | External Party Delivery | ☐ | | | `dvd_AANSTELLINGTOT` | `datetime` | Appointment Until | ☐ | | | `dvd_AANSTELLINGTOT1` | `datetime` | Appointment Until 1 | ☐ | | | `dvd_AANSTELLINGTOT2` | `datetime` | Appointment Until 2 | ☐ | | | `dvd_AANSTELLINGTOT3` | `datetime` | Appointment Until 3 | ☐ | | | `dvd_AANSTELLINGTOT4` | `datetime` | Appointment Until 4 | ☐ | | | `dvd_AANSTELLINGTOT5` | `datetime` | Appointment Until 5 | ☐ | | | `dvd_AANSTELLINGTOT6` | `datetime` | Appointment Until 6 | ☐ | | | `dvd_AANVANGOPZEGTERMIJN` | `datetime` | Start of Notice Period | ☐ | | | `dvd_AARDDEELNEMERSCHAP` | `int32` | Participation Type | ☐ | | | `dvd_BASISDIENSTVERBAND` | `int32` | Base Employment | ☐ | | | `dvd_BEROEPUWV` | `int32` | Occupation UWV | ☐ | | | `dvd_CAO` | `int32` | CAO | ☐ | | | `dvd_CAOKLANTGROEPAFWIJKEND` | `int32` | CAO Customer Group Deviating | ☐ | | | `dvd_CAOOMSCHRIJVING` | `string(120)` | CAO Description | ☐ | | | `dvd_CAOUWV` | `int32` | CAO UWV | ☐ | | | `dvd_CODEUITZONDERING` | `int32` | Exception Code | ☐ | | | `dvd_COMPLETEREN` | `int32` | Complete | ☐ | | | `dvd_DATUMINDIENST` | `datetime` | Start Date of Employment | ☐ | | | `dvd_DATUMOPZEGGING` | `datetime` | Termination Date | ☐ | | | `dvd_DATUMPROFIELTOEPASSEN` | `datetime` | Apply Profile Date | ☐ | | | `dvd_DATUMUITDIENST` | `datetime` | End Date of Employment | ☐ | | | `dvd_DEELNAME55PLUS` | `int32` | Participation 55 Plus | ☐ | | | `dvd_DIENSTVERBANDID` | `int32` | Employment ID | ☐ | | | `dvd_EERSTEDAGSMELDING` | `int32` | First Day Notification | ☐ | | | `dvd_EMAILVERLOFAANVRAAG` | `int32` | Leave Request Email | ☐ | | | `dvd_ENTRYID` | `string(480)` | Entry ID | ☐ | | | `dvd_EXPORTSETID` | `int32` | Export Set ID | ☐ | | | `dvd_EXTERNID` | `guid` | External ID | ☐ | | | `dvd_HISTORISCHEDATUMINDIENST` | `datetime` | Historical Start Date of Employment | ☐ | | | `dvd_ISANONIEMEWERKNEMER` | `int32` | Is Anonmous Employee | ☐ | | | `dvd_ISDIRECTEURGROOTAANDEELHOUDER` | `int32` | Is Director Major Shareholder | ☐ | | | `dvd_ISFAMILIEVANEIGENAAR` | `int32` | Is Related to Owner | ☐ | | | `dvd_ISGEMOEDSBEZWAARDVOLKSVERZEKERING` | `int32` | Is Conscientious Objector National Insurance | ☐ | | | `dvd_ISGEMOEDSBEZWAARDWERKNEMERVERZEKERING` | `int32` | Is Conscientious Objector Employee Insurance | ☐ | | | `dvd_ISOPROEPKRACHTOFINVALKRACHT` | `int32` | Is On-Call or Substitute Worker | ☐ | | | `dvd_ISVORIGEEIGENAAR` | `int32` | Is Previous Owner | ☐ | | | `dvd_LOONMODELOMSCHRIJVING` | `string(120)` | Payroll Model Description | ☐ | | | `dvd_NAAM` | `string(240)` | Name | ☐ | | | `dvd_NAAMLOONSTROOK` | `string(240)` | Name Payslip | ☐ | | | `dvd_NUMMERINKOMSTENVERHOUDING` | `int32` | Income Relationship Number | ☐ | | | `dvd_OPZEGTERMIJNWERKGEVER` | `int32` | Employer Notice Period | ☐ | | | `dvd_OPZEGTERMIJNWERKNEMER` | `int32` | Employee Notice Period | ☐ | | | `dvd_OVERLIJDENSDATUM` | `datetime` | Date of Death | ☐ | | | `dvd_PERIODEOPZEGTERMIJN` | `int32` | Notice Period Term | ☐ | | | `dvd_PERIODESALARISPERIODIEK` | `int32` | Salary Increment Period | ☐ | | | `dvd_PERSONEELSNUMMER` | `int32` | Employee Number | ☐ | | | `dvd_PERSONEELSNUMMERVERLONING` | `int32` | Payroll Employee Number | ☐ | | | `dvd_PERSOONID` | `int32` | Person ID | ☐ | | | `dvd_PREMIEVRIJSTELLINGMARGINALEARBEID` | `int32` | Premium Exemption Marginal Labour | ☐ | | | `dvd_REDENEINDEDIENSTVERBAND` | `int32` | Reason for End of Employment | ☐ | | | `dvd_SALARISSCHAALSIGNALEREN` | `int32` | Flag Salary Scale | ☐ | | | `dvd_SOFINUMMER` | `int32` | Social Security Number | ☐ | | | `dvd_SOORTDIENSTVERBAND` | `int32` | Employment Type | ☐ | | | `dvd_SOORTOPROEPKRACHTOFINVALKRACHT` | `int32` | On-Call or Substitute Worker Type | ☐ | | | `dvd_SOORTWERKNEMER` | `int32` | Employee Type | ☐ | | | `dvd_SPECIALEINKOMSTENVERHOUDING` | `int32` | Special Income Relationship | ☐ | | | `dvd_TIJDELIJKEHEFFINGSKORTING` | `int32` | Temporary Tax Credit | ☐ | | | `dvd_VAKANTIEBONNEN` | `int32` | Holiday Vouchers | ☐ | | | `dvd_VERLONINGID` | `int32` | Payroll ID | ☐ | | | `dvd_WAARDEDEELNEMERSCHAP` | `int32` | Participation Value | ☐ | | | `dvd_WACHTGELDOUDEREGELING` | `int32` | Waiting Allowance Old Scheme | ☐ | | | `dvd_WERKKOSTENREGELINGUITSLUITING` | `int32` | Work Cost Scheme Exclusion | ☐ | | | `dvd_WERKNEMERPROFIELID` | `int32` | Employee Profile ID | ☐ | | | `dvd_ZIEKUITDIENST` | `int32` | Sick After Leaving Employment | ☐ | | | `psn_ACHTERNAAM` | `string(25)` | Last Name | ☐ | | | `psn_BURGERLIJKESTAAT` | `int32` | Marital Status | ☐ | | | `psn_EMAIL` | `string(100)` | Email | ☐ | | | `psn_ENTRYID` | `string(480)` | Entry ID | ☐ | | | `psn_ESSGEBRUIKERID` | `int32` | ESS User ID | ☐ | | | `psn_FAX` | `string(60)` | Fax Number | ☐ | | | `psn_GEBOORTEDATUM` | `datetime` | Date of Birth | ☐ | | | `psn_GEBOORTEPLAATS` | `string(60)` | City of Birth | ☐ | | | `psn_GEBRUIKACHTERNAAM` | `int32` | Use Last Name | ☐ | | | `psn_GESLACHT` | `int32` | Gender | ☐ | | | `psn_HUISNUMMER` | `int32` | House Number | ☐ | | | `psn_HUISNUMMERAFWIJKEND` | `int32` | Deviating House Number | ☐ | | | `psn_HUISNUMMERTOEVOEGING` | `string(4)` | House Number Addition | ☐ | | | `psn_HUISNUMMERTOEVOEGINGAFWIJKEND` | `string(4)` | Deviating House Number Addition | ☐ | | | `psn_LAND` | `int32` | Country | ☐ | | | `psn_LANDAFWIJKEND` | `int32` | Deviating Country | ☐ | | | `psn_LOCATIE` | `string(35)` | Location | ☐ | | | `psn_LOCATIEAFWIJKEND` | `string(35)` | Deviating Location | ☐ | | | `psn_MOBIEL` | `string(60)` | Mobile Phone | ☐ | | | `psn_NAAM` | `string(240)` | Name | ☐ | | | `psn_NADEREAANDUIDING` | `int32` | Further Designation | ☐ | | | `psn_NADEREAANDUIDINGAFWIJKEND` | `int32` | Deviating Further Designation | ☐ | | | `psn_NATIONALITEIT` | `int32` | Nationality | ☐ | | | `psn_NUMMERIDENTIFICATIEDOCUMENT` | `string(100)` | Number Identification Document | ☐ | | | `psn_OVERLIJDENSDATUM` | `datetime` | Date of Death | ☐ | | | `psn_PARTNERACHTERNAAM` | `string(25)` | Partner Last Name | ☐ | | | `psn_PARTNERVOORVOEGSEL` | `string(10)` | Partner Prefix | ☐ | | | `psn_PERSONEELSNUMMER` | `int32` | Employee Number | ☐ | | | `psn_PERSOONID` | `int32` | Person ID | ☐ | | | `psn_PLAATSNAAM` | `string(24)` | City | ☐ | | | `psn_PLAATSNAAMAFWIJKEND` | `string(24)` | Deviating City | ☐ | | | `psn_POSTBUSAFWIJKEND` | `int32` | Deviating Post Office Box | ☐ | | | `psn_POSTCODE` | `string(9)` | ZIP Code | ☐ | | | `psn_POSTCODEAFWIJKEND` | `string(9)` | Deviating Postal Code | ☐ | | | `psn_ROEPNAAM` | `string(28)` | Call Name | ☐ | | | `psn_SOFINUMMER` | `int32` | Social Security Number | ☐ | | | `psn_SOORTIDENTIFICATIEDOCUMENT` | `int32` | Identification Document Type | ☐ | | | `psn_STRAATNAAM` | `string(24)` | Street Name | ☐ | | | `psn_STRAATNAAMAFWIJKEND` | `string(24)` | Deviating Street Name | ☐ | | | `psn_TELEFOON` | `string(60)` | Phone | ☐ | | | `psn_TITULATUUR` | `int32` | Title | ☐ | | | `psn_VOORLETTERS` | `string(6)` | Initials | ☐ | | | `psn_VOORVOEGSEL` | `string(10)` | Prefix | ☐ | | | `vlf_AANTALEENHEDEN` | `decimal` | Number of Units | ☐ | | | `vlf_DATUMEINDE` | `datetime` | End Date | ☐ | | | `vlf_DATUMINGANG` | `datetime` | Start Date | ☐ | | | `vlf_ENTRYID` | `string(480)` | Entry ID | ☐ | | | `vlf_FACTOR` | `int32` | Factor | ☐ | | | `vlf_HERKOMST` | `int32` | Origin | ☐ | | | `vlf_OPMERKING` | `string(4000)` | Remark | ☐ | | | `vlf_SOORT` | `int32` | Type | ☐ | | | `vlf_VERLOFAANVRAAGID` | `int32` | Leave Request ID | ☐ | | | `vlf_VERLOFREGELINGID` | `int32` | Leave Scheme ID | ☐ | | | `wgr_ADMINISTRATIEKANTOORID` | `int32` | Administration Office ID | ☐ | | | `wgr_ADMINISTRATIENUMMER` | `string(30)` | Administration Number | ☐ | | | `wgr_AKTIEVEDIENSTVERBANDEN` | `int32` | Active Employments | ☐ | | | `wgr_BRANCHE` | `int32` | Industry | ☐ | | | `wgr_CONTACTPERSOONFUNCTIE` | `string(60)` | Contact Person Title | ☐ | | | `wgr_CONTACTPERSOONNAAM` | `string(240)` | Contact Person Name | ☐ | | | `wgr_CONTACTPERSOONTELEFOON` | `string(60)` | Contact Person Phone | ☐ | | | `wgr_EMAIL` | `string(60)` | Email | ☐ | | | `wgr_ENTRYID` | `string(480)` | Entry ID | ☐ | | | `wgr_ESSMAILVERSTUREN` | `int32` | Send ESS Mail | ☐ | | | `wgr_EXTERNID` | `guid` | External ID | ☐ | | | `wgr_FAX` | `string(60)` | Fax Number | ☐ | | | `wgr_GROEPCODE` | `int32` | Group Code | ☐ | | | `wgr_HUISNUMMER` | `int32` | House Number | ☐ | | | `wgr_HUISNUMMERAFWIJKEND` | `int32` | Deviating House Number | ☐ | | | `wgr_HUISNUMMERTOEVOEGING` | `string(30)` | House Number Addition | ☐ | | | `wgr_HUISNUMMERTOEVOEGINGAFWIJKEND` | `string(30)` | Deviating House Number Addition | ☐ | | | `wgr_JAARFILTER` | `int32` | Year Filter | ☐ | | | `wgr_KVKNUMMER` | `string(60)` | CoC Number | ☐ | | | `wgr_LAND` | `int32` | Country | ☐ | | | `wgr_LANDAFWIJKEND` | `int32` | Deviating Country | ☐ | | | `wgr_LOCATIE` | `string(120)` | Location | ☐ | | | `wgr_LOCATIEAFWIJKEND` | `string(120)` | Deviating Location | ☐ | | | `wgr_NAAM` | `string(120)` | Name | ☐ | | | `wgr_NADEREAANDUIDING` | `int32` | Further Designation | ☐ | | | `wgr_NADEREAANDUIDINGAFWIJKEND` | `int32` | Deviating Further Designation | ☐ | | | `wgr_ONDERDEELVANWERKGEVERID` | `int32` | Part of Employer ID | ☐ | | | `wgr_PLAATSNAAM` | `string(60)` | City | ☐ | | | `wgr_PLAATSNAAMAFWIJKEND` | `string(60)` | Deviating City | ☐ | | | `wgr_POSTBUSAFWIJKEND` | `int32` | Deviating Post Office Box | ☐ | | | `wgr_POSTCODE` | `string(30)` | ZIP Code | ☐ | | | `wgr_POSTCODEAFWIJKEND` | `string(30)` | Deviating Postal Code | ☐ | | | `wgr_PRODUCTSETID` | `int32` | Product Set ID | ☐ | | | `wgr_PROVINCIE` | `int32` | State | ☐ | | | `wgr_RECHTSVORM` | `int32` | Legal Form | ☐ | | | `wgr_SBI` | `int32` | SBI | ☐ | | | `wgr_STRAATNAAM` | `string(60)` | Street Name | ☐ | | | `wgr_STRAATNAAMAFWIJKEND` | `string(60)` | Deviating Street Name | ☐ | | | `wgr_TELEFOON` | `string(60)` | Phone | ☐ | | | `wgr_UPLOADLIMIET` | `int32` | Upload Limit | ☐ | | | `wgr_UPLOADVERBRUIK` | `decimal` | Upload Usage | ☐ | | | `wgr_URL` | `string(120)` | URL | ☐ | | | `wgr_WEBSITELOGOID` | `int32` | Website Logo ID | ☐ | | | `wgr_WERKGEVERAFBEELDINGID` | `int32` | Employer Image ID | ☐ | | | `wgr_WERKGEVERID` | `int32` | Employer ID | ☐ | | | `wgr_WIJZEVERZENDEN` | `int32` | Dispatch Method | ☐ | |