# WerktijdenPerDienstverband: Working Hours per Employment - Name: `WerktijdenPerDienstverband` - Catalog: `LoketNL` - Schema: `Lists` - Label: Working Hours per Employment ## Parameters of Table Function | Name | Data Type | Required | Default Value | Documentation | |---|:---:|:---:|:---:|---| | `employmentId` | `string` | ☑ | | | ## Table Columns The columns of the table `WerktijdenPerDienstverband` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `AANTALURENPERWEEK` | `decimal` | Hours per Week | ☐ | | | `AFWIJKENDAANTALDAGENPERWEEK` | `decimal` | Deviating Number of Days per Week | ☐ | | | `AFWIJKENDAANTALURENPERWEEK` | `decimal` | Deviating Number of Hours per Week | ☐ | | | `AFWIJKENDEDAGENURENVIAROOSTER` | `int32` | Deviating Days Hours via Schedule | ☐ | | | `BEREKENENURENGEBROKENPERIODEVIAROOSTER` | `int32` | Calculate Hours Broken Period via Schedule | ☐ | | | `BEREKENENURENPERIODEVIAROOSTER` | `int32` | Calculate Hours Period via Schedule | ☐ | | | `BEREKENENVERLOFEENHEDENVIAROOSTER` | `int32` | Calculate Leave Units via Schedule | ☐ | | | `DAGENDAGVERGOEDINGVIAROOSTER` | `int32` | Days Daily Allowance via Schedule | ☐ | | | `DATUMEINDE` | `datetime` | End Date | ☐ | | | `DATUMINGANG` | `datetime` | Start Date | ☐ | | | `ENTRYID` | `string(480)` | Entry ID | ☐ | | | `FLEXIBELURENCONTRACT` | `int32` | Flexible Hours Contract | ☐ | | | `GEMIDDELDEDEELTIJD` | `decimal` | Average Part-Time Factor | ☐ | | | `PLOEG` | `int32` | Shift Team | ☐ | | | `PLOEGDAGLOONZW` | `int32` | Shift Team Daily Wage ZW | ☐ | | | `REGELMATIGARBEIDSPATROON` | `int32` | Regular Work Pattern | ☐ | | | `URENEVENDINSDAG` | `decimal` | Even Week Tuesday Hours | ☐ | | | `URENEVENDONDERDAG` | `decimal` | Even Week Thursday Hours | ☐ | | | `URENEVENMAANDAG` | `decimal` | Even Week Monday Hours | ☐ | | | `URENEVENVRIJDAG` | `decimal` | Even Week Friday Hours | ☐ | | | `URENEVENWOENSDAG` | `decimal` | Even Week Wednesday Hours | ☐ | | | `URENEVENZATERDAG` | `decimal` | Even Week Saturday Hours | ☐ | | | `URENEVENZONDAG` | `decimal` | Even Week Sunday Hours | ☐ | | | `URENONEVENDINSDAG` | `decimal` | Odd Week Tuesday Hours | ☐ | | | `URENONEVENDONDERDAG` | `decimal` | Odd Week Thursday Hours | ☐ | | | `URENONEVENMAANDAG` | `decimal` | Odd Week Monday Hours | ☐ | | | `URENONEVENVRIJDAG` | `decimal` | Odd Week Friday Hours | ☐ | | | `URENONEVENWOENSDAG` | `decimal` | Odd Week Wednesday Hours | ☐ | | | `URENONEVENZATERDAG` | `decimal` | Odd Week Saturday Hours | ☐ | | | `URENONEVENZONDAG` | `decimal` | Odd Week Sunday Hours | ☐ | |