# Eerstedagsmeldingen - Name: `Eerstedagsmeldingen` - Catalog: `LoketNL` - Schema: `Views` ## Table Columns The columns of the table `Eerstedagsmeldingen` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `edg_ENTRYID` | `string(480)` | Entry ID | ☐ | | | `vlg_AANTALDAGENBESCHIKBAARESS` | `int32` | Number of Days Available ESS | ☐ | | | `vlg_AFGENOMENPRODUCTID` | `int32` | Purchased Product ID | ☐ | | | `vlg_AFWIJKENDEDAGENURENVIAROOSTER` | `int32` | Deviating Days Hours via Schedule | ☐ | | | `vlg_BASISDIENSTVERBAND` | `int32` | Base Employment | ☐ | | | `vlg_BASISLOONEENHEID` | `int32` | Base Salary Unit | ☐ | | | `vlg_BEREKENENURENGEBROKENPERIODEVIAROOSTER` | `int32` | Calculate Hours Broken Period via Schedule | ☐ | | | `vlg_BEREKENENURENPERIODEVIAROOSTER` | `int32` | Calculate Hours Period via Schedule | ☐ | | | `vlg_BRANCHELOKET` | `int32` | Industry Desk | ☐ | | | `vlg_CAO` | `int32` | CAO | ☐ | | | `vlg_CLIENTNR` | `int32` | Client Number | ☐ | | | `vlg_CONTACTINFORMATIESYNCHRONISEREN` | `int32` | Synchronise Contact Information | ☐ | | | `vlg_DAGENDAGVERGOEDINGVIAROOSTER` | `int32` | Days Daily Allowance via Schedule | ☐ | | | `vlg_DATUMEINDE` | `datetime` | End Date | ☐ | | | `vlg_DATUMINGANG` | `datetime` | Start Date | ☐ | | | `vlg_EERSTEDAGSMELDING` | `int32` | First Day Notification | ☐ | | | `vlg_ENTRYID` | `string(480)` | Entry ID | ☐ | | | `vlg_FULLTIMEUREN` | `decimal` | Hours in Full Time | ☐ | | | `vlg_GRONDSLAGEINDEJAARSUITKERING` | `int32` | Year-End Bonus Basis | ☐ | | | `vlg_GRONDSLAGVAKANTIETOESLAG` | `int32` | Holiday Allowance Basis | ☐ | | | `vlg_NAWSYNCHRONISEREN` | `int32` | Synchronise Name and Address | ☐ | | | `vlg_NETTOLOONEENHEID` | `int32` | Net Salary Unit | ☐ | | | `vlg_OMSCHRIJVING` | `string(240)` | Description | ☐ | | | `vlg_PERCENTAGEEINDEJAARSUITKERING` | `decimal` | Year-End Bonus Percentage | ☐ | | | `vlg_PERCENTAGEVAKANTIETOESLAG` | `decimal` | Holiday Allowance Percentage | ☐ | | | `vlg_PERIODE` | `int32` | Period | ☐ | | | `vlg_SOORTDIENSTVERBAND` | `int32` | Employment Type | ☐ | | | `vlg_SOORTWERKNEMER` | `int32` | Employee Type | ☐ | | | `vlg_STANDAARDCATEGORIECODEBROWSERVARGEG` | `int32` | Default Category Code Browser Variable Data | ☐ | | | `vlg_STANDAARDEXPORTSETCODEBROWSERVARGEG` | `int32` | Default Export Set Code Browser Variable Data | ☐ | | | `vlg_STANDAARDEXPORTSETCODEVARGEGINDIVIDUEEL` | `int32` | Default Export Set Code Variable Data Individual | ☐ | | | `vlg_STANDAARDEXPORTSETWERKKOSTENREGELING` | `int32` | Default Export Set Work Cost Scheme | ☐ | | | `vlg_VERLONINGID` | `int32` | Payroll ID | ☐ | | | `vrn_CLIENTNR` | `int32` | Client Number | ☐ | | | `vrn_DATUMAANMAAKJOURNALISERING` | `datetime` | Journalising Creation Date | ☐ | | | `vrn_DATUMAFGEHANDELD` | `datetime` | Date Processed | ☐ | | | `vrn_DATUMBESCHIKBAARESS` | `datetime` | Date Available ESS | ☐ | | | `vrn_DATUMESSMAIL` | `datetime` | ESS Mail Date | ☐ | | | `vrn_DATUMOPDRACHT` | `datetime` | Assignment Date | ☐ | | | `vrn_DATUMVERLONING` | `datetime` | Payroll Date | ☐ | | | `vrn_DATUMVERWIJDERD` | `datetime` | Date Deleted | ☐ | | | `vrn_ENTRYID` | `string(480)` | Entry ID | ☐ | | | `vrn_ESSMAILVERSTUREN` | `int32` | Send ESS Mail | ☐ | | | `vrn_FOUTSIGNAALAANWEZIG` | `int32` | Has Error Signal | ☐ | | | `vrn_GEBRUIKERIDAFGEHANDELDDOOR` | `int32` | Handled By User ID | ☐ | | | `vrn_GEBRUIKERIDVERWIJDERDDOOR` | `int32` | Deleted By User ID | ☐ | | | `vrn_GEBRUIKERIDVERZOEK` | `int32` | Request User ID | ☐ | | | `vrn_PERIODE` | `int32` | Period | ☐ | | | `vrn_PERIODELOONAANGIFTE` | `string(60)` | Payroll Tax Return Period | ☐ | | | `vrn_STATUS` | `int32` | Status | ☐ | | | `vrn_TEKSTEXCASSO` | `string(240)` | Excasso Text | ☐ | | | `vrn_TEKSTSTROOK` | `string(240)` | Payslip Text | ☐ | | | `vrn_VOLGNUMMER` | `int32` | Sequence Number | ☐ | | | `vrn_VOLGNUMMERGOEDGEKEURD` | `int32` | Approval Sequence Number | ☐ | | | `vrn_WIJZEAANMAAK` | `int32` | Creation Method | ☐ | | | `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 | ☐ | |