# Delta_T_NAW: Delta T Name and Address ## Documentation Atrea Delta T name and address data - Name: `Delta_T_NAW` - Catalog: `AfasOnline` - Schema: `GetConnector` - Label: Delta T Name and Address - Partition-specific: false - Select: true - Insert: false - Update: false - Delete: false - Select Service URL (OData-specific): `/connectors/Delta_T_NAW` - Insert Service URL (OData-specific): `/connectors/Delta_T_NAW` - Update Service URL (OData-specific): `/connectors/Delta_T_NAW` - Delete Service URL (OData-specific): `/connectors/Delta_T_NAW` - Field Selection Method (OData-specific): NotRequired ## Table Columns The columns of the table `Delta_T_NAW` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `Achternaam` | `string(80)` | Last Name | | | | `Burgerlijke_staat` | `string(100)` | Marital status | | | | `Burgerservicenr_` | `string(25)` | Citizen service number | | | | `Datum_in_dienst` | `string(8)` | Start of employment date | | | | `Datum_uit_dienst` | `string(8)` | End of employment date | | | | `Dienstbetrekking_code` | `string(20)` | Employment code | | | | `E-mail_prive` | `string(255)` | Private email | | | | `E-mail_werk` | `string(255)` | Work email | | | | `Exporteren` | `boolean` | Export employee to time registration | | | | `Functie-omschrijving` | `string(50)` | Job title description | | | | `Geboortedatum` | `string(8)` | Date of birth | | | | `Geslacht` | `string(54)` | Gender | | | | `Huisnummer` | `int32` | House number | | | | `Huisnummer_toevoeging` | `string(30)` | House number suffix | | | | `Land` | `string(3)` | Country | | | | `Mobiel_werk` | `string(255)` | Work mobile | | | | `Omschrijving` | `string(50)` | Description | | | | `Personeelsnr` | `string(15)` | Employee | | | | `Postcode` | `string(15)` | Postcode | | | | `Straat` | `string(60)` | Street | | | | `Telefoon_werk` | `string(255)` | Work phone number | | | | `Voorletters` | `string(15)` | Initials | | | | `Voornaam` | `string(50)` | First Name | | | | `Voorvoegsel` | `string(15)` | Name prefix | | | | `Woonplaats` | `string(50)` | City | | |