# Persons - Catalog: `Dummy` - Schema: `Demo` This is a read-only view. The Dummy API may not support changing the data or the Invantive UniversalSQL driver for Dummy does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Dummy API. ## View Columns The columns of the view `Persons` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `action_requested` | `varchar2` | | ☐ | | | `bnk_code` | `varchar2` | | ☐ | | | `bnk_id` | `int64` | | ☐ | | | `bnk_omschrijving` | `varchar2` | | ☐ | | | `cig_consolideren_vlag` | `char` | | ☐ | | | `cig_datum_rapportage` | `datetime` | | ☐ | | | `cig_id` | `int64` | | ☐ | | | `dsk_aantal_documenten_c` | `varchar2` | | ☐ | | | `dsk_aantal_documenten` | `int32` | | ☐ | | | `dsk_eerste_document_param1` | `decimal` | | ☐ | | | `dsk_eerste_document_url` | `varchar2` | | ☐ | | | `dsk_eerste_document` | `varchar2` | | ☐ | | | `dsk_id` | `int64` | | ☐ | | | `dsk_laatste_document_param1` | `decimal` | | ☐ | | | `dsk_laatste_document_url` | `varchar2` | | ☐ | | | `dsk_laatste_document` | `varchar2` | | ☐ | | | `dsk_label_nn` | `varchar2` | | ☐ | | | `dsk_meerdere_aanwezig` | `varchar2` | | ☐ | | | `dsk_ref_sleutel` | `int64` | | ☐ | | | `dsk_ref_tabel` | `varchar2` | | ☐ | | | `dsk_som_bestand_omvang_c` | `varchar2` | | ☐ | | | `gbr_aangemaakt_door` | `varchar2` | | ☑ | | | `gbr_aangemaakt_in` | `varchar2` | | ☑ | | | `gbr_aanmeld_code` | `varchar2` | | ☐ | | | `gbr_accordeur_uren_vlag` | `char` | | ☑ | | | `gbr_achternaam` | `varchar2` | | ☐ | | | `gbr_administrateur_vlag` | `char` | | ☑ | | | `gbr_adres_regel_1` | `varchar2` | | ☐ | | | `gbr_adres_regel_2` | `varchar2` | | ☐ | | | `gbr_baas_aanmeld_code` | `varchar2` | | ☐ | | | `gbr_baas_achternaam` | `varchar2` | | ☐ | | | `gbr_baas_email_adres_workflow` | `varchar2` | | ☐ | | | `gbr_baas_email_adres` | `varchar2` | | ☐ | | | `gbr_baas_functie` | `varchar2` | | ☐ | | | `gbr_baas_geslacht_ind` | `char` | | ☐ | | | `gbr_baas_id` | `int64` | | ☐ | | | `gbr_baas_initialen` | `varchar2` | | ☐ | | | `gbr_baas_naam` | `varchar2` | | ☐ | | | `gbr_baas_pasfoto_url_ult` | `varchar2` | | ☐ | | | `gbr_baas_pasfoto_url` | `varchar2` | | ☐ | | | `gbr_baas_personeelsnummer` | `varchar2` | | ☐ | | | `gbr_baas_taakhouder_vlag` | `char` | | ☐ | | | `gbr_baas_tussenvoegsel` | `varchar2` | | ☐ | | | `gbr_baas_voorletters` | `varchar2` | | ☐ | | | `gbr_baas_voornaam` | `varchar2` | | ☐ | | | `gbr_baas_werk_afdeling` | `varchar2` | | ☐ | | | `gbr_baas_werk_tel` | `varchar2` | | ☐ | | | `gbr_bedrag_intern_tarief` | `decimal` | | ☐ | | | `gbr_bedrijf_ult` | `varchar2` | | ☐ | | | `gbr_bic` | `varchar2` | | ☐ | | | `gbr_bijgewerkt_door` | `varchar2` | | ☑ | | | `gbr_bijgewerkt_in` | `varchar2` | | ☑ | | | `gbr_bijnaam` | `varchar2` | | ☐ | | | `gbr_bsn` | `varchar2` | | ☐ | | | `gbr_datum_aangemaakt` | `datetime` | | ☑ | | | `gbr_datum_bijgewerkt` | `datetime` | | ☑ | | | `gbr_datum_einde_aanmelden` | `datetime` | | ☐ | | | `gbr_datum_emailing_mag_ontv` | `datetime` | | ☐ | | | `gbr_datum_geboren` | `datetime` | | ☐ | | | `gbr_datum_getrouwd` | `datetime` | | ☐ | | | `gbr_datum_intrf_bijgewerkt` | `datetime` | | ☐ | | | `gbr_datum_intrf_geladen` | `datetime` | | ☐ | | | `gbr_datum_l_ww_wijziging` | `datetime` | | ☑ | | | `gbr_datum_laatste_review` | `datetime` | | ☐ | | | `gbr_datum_overleden` | `datetime` | | ☐ | | | `gbr_datum_start_aanmelden` | `datetime` | | ☐ | | | `gbr_datum_volgende_review` | `datetime` | | ☐ | | | `gbr_eind_werk_toestel` | `varchar2` | | ☐ | | | `gbr_email_adres_2_url` | `varchar2` | | ☐ | | | `gbr_email_adres_2` | `varchar2` | | ☐ | | | `gbr_email_adres_3_url` | `varchar2` | | ☐ | | | `gbr_email_adres_3` | `varchar2` | | ☐ | | | `gbr_email_adres_4_url` | `varchar2` | | ☐ | | | `gbr_email_adres_4` | `varchar2` | | ☐ | | | `gbr_email_adres_url` | `varchar2` | | ☐ | | | `gbr_email_adres_workflow_url` | `varchar2` | | ☐ | | | `gbr_email_adres_workflow` | `varchar2` | | ☐ | | | `gbr_email_adres` | `varchar2` | | ☐ | | | `gbr_emailing_mag_bewijs` | `varchar2` | | ☐ | | | `gbr_emailing_mag_vlag` | `char` | | ☑ | | | `gbr_facebook_adres` | `varchar2` | | ☐ | | | `gbr_fax_tel` | `varchar2` | | ☐ | | | `gbr_functie` | `varchar2` | | ☐ | | | `gbr_functiegroep` | `varchar2` | | ☐ | | | `gbr_geboorte_land` | `varchar2` | | ☐ | | | `gbr_geboorte_plaats` | `varchar2` | | ☐ | | | `gbr_geslacht_ind` | `char` | | ☑ | | | `gbr_gm_adres` | `varchar2` | | ☐ | | | `gbr_googleplus_adres` | `varchar2` | | ☐ | | | `gbr_groep_mensen_vlag` | `char` | | ☑ | | | `gbr_handtekening_url` | `varchar2` | | ☐ | | | `gbr_hobbys` | `varchar2` | | ☐ | | | `gbr_hyves_adres` | `varchar2` | | ☐ | | | `gbr_iban_nummer` | `varchar2` | | ☐ | | | `gbr_icq_adres` | `varchar2` | | ☐ | | | `gbr_id` | `int64` | | ☑ | | | `gbr_initialen` | `varchar2` | | ☐ | | | `gbr_ip_adres_lijst` | `varchar2` | | ☐ | | | `gbr_job_seq_geladen` | `int64` | | ☐ | | | `gbr_klassificatie_reeks_c` | `clob` | | ☐ | | | `gbr_klassificatie_reeks` | `clob` | | ☐ | | | `gbr_kolom_soort` | `varchar2` | | ☐ | | | `gbr_kolom1` | `varchar2` | | ☐ | | | `gbr_kolom10` | `varchar2` | | ☐ | | | `gbr_kolom2` | `varchar2` | | ☐ | | | `gbr_kolom3` | `varchar2` | | ☐ | | | `gbr_kolom4` | `varchar2` | | ☐ | | | `gbr_kolom5` | `varchar2` | | ☐ | | | `gbr_kolom6` | `varchar2` | | ☐ | | | `gbr_kolom7` | `varchar2` | | ☐ | | | `gbr_kolom8` | `varchar2` | | ☐ | | | `gbr_kolom9` | `varchar2` | | ☐ | | | `gbr_komende_verjaardag` | `datetime` | | ☐ | | | `gbr_label` | `varchar2` | | ☑ | | | `gbr_land` | `varchar2` | | ☐ | | | `gbr_ldap_gebruiker` | `varchar2` | | ☐ | | | `gbr_leeftijd` | `decimal` | | ☐ | | | `gbr_linkedin_adres` | `varchar2` | | ☐ | | | `gbr_mobiel_tel` | `varchar2` | | ☐ | | | `gbr_myspace_adres` | `varchar2` | | ☐ | | | `gbr_naam_kinderen` | `varchar2` | | ☐ | | | `gbr_naam_met_bedrijf` | `varchar2` | | ☑ | | | `gbr_naam_partner` | `varchar2` | | ☐ | | | `gbr_naam` | `varchar2` | | ☑ | | | `gbr_nationaliteit` | `varchar2` | | ☐ | | | `gbr_nc` | `varchar2` | | ☐ | | | `gbr_nk` | `varchar2` | | ☑ | | | `gbr_notities_l` | `clob` | | ☐ | | | `gbr_omvang_huishouden` | `int32` | | ☐ | | | `gbr_orig_system_group` | `varchar2` | | ☐ | | | `gbr_orig_system_reference` | `varchar2` | | ☐ | | | `gbr_overige_voornamen` | `varchar2` | | ☐ | | | `gbr_partitie` | `int64` | | ☑ | | | `gbr_pasfoto_url_ult` | `varchar2` | | ☐ | | | `gbr_pasfoto_url` | `varchar2` | | ☐ | | | `gbr_paypal_identifier` | `varchar2` | | ☐ | | | `gbr_personeelsnummer` | `varchar2` | | ☐ | | | `gbr_plaats` | `varchar2` | | ☐ | | | `gbr_plaxo_adres` | `varchar2` | | ☐ | | | `gbr_postcode` | `varchar2` | | ☐ | | | `gbr_projectontwkklr_vlag` | `char` | | ☑ | | | `gbr_provincie` | `varchar2` | | ☐ | | | `gbr_rdbms_gebruiker` | `varchar2` | | ☐ | | | `gbr_roepnaam` | `varchar2` | | ☐ | | | `gbr_rss_url` | `varchar2` | | ☐ | | | `gbr_sessie_aangemaakt` | `varchar2` | | ☑ | | | `gbr_sessie_bijgewerkt` | `varchar2` | | ☑ | | | `gbr_sip_adres` | `varchar2` | | ☐ | | | `gbr_skype_adres` | `varchar2` | | ☐ | | | `gbr_taakhouder_vlag` | `char` | | ☑ | | | `gbr_taakmelder_vlag` | `char` | | ☑ | | | `gbr_thuis_tel` | `varchar2` | | ☐ | | | `gbr_tijdschrijver_vlag` | `char` | | ☑ | | | `gbr_titels` | `varchar2` | | ☐ | | | `gbr_transactie_aangemaakt` | `int64` | | ☑ | | | `gbr_transactie_bijgewerkt` | `int64` | | ☑ | | | `gbr_tussenvoegsel` | `varchar2` | | ☐ | | | `gbr_twitter_adres` | `varchar2` | | ☐ | | | `gbr_voorkeur_email_adres` | `varchar2` | | ☐ | | | `gbr_voorletters` | `varchar2` | | ☐ | | | `gbr_voornaam` | `varchar2` | | ☐ | | | `gbr_wachtwoord` | `varchar2` | | ☐ | | | `gbr_website_url` | `varchar2` | | ☐ | | | `gbr_werk_afdeling` | `varchar2` | | ☐ | | | `gbr_werk_filiaal` | `varchar2` | | ☐ | | | `gbr_werk_kamer` | `varchar2` | | ☐ | | | `gbr_werk_tel` | `varchar2` | | ☐ | | | `gbr_werk_toestel` | `varchar2` | | ☐ | | | `gbr_xing_adres` | `varchar2` | | ☐ | | | `gbr_youtube_adres` | `varchar2` | | ☐ | | | `kpt_code` | `varchar2` | | ☐ | | | `kpt_id` | `int64` | | ☐ | | | `kpt_omschrijving` | `varchar2` | | ☐ | | | `lge_code` | `varchar2` | | ☐ | | | `lge_description_i18n` | `varchar2` | | ☐ | | | `lge_description` | `varchar2` | | ☐ | | | `lge_id` | `int64` | | ☐ | | | `lgt_id` | `int64` | | ☑ | | | `lgt_ikoon_url` | `varchar2` | | ☐ | | | `lgt_label` | `varchar2` | | ☑ | | | `lvr_adres_regel_1` | `varchar2` | | ☐ | | | `lvr_adres_regel_2` | `varchar2` | | ☐ | | | `lvr_btw_nummer` | `varchar2` | | ☐ | | | `lvr_code` | `varchar2` | | ☐ | | | `lvr_fax_tel` | `varchar2` | | ☐ | | | `lvr_id` | `int64` | | ☐ | | | `lvr_ikoon_url_ult` | `varchar2` | | ☐ | | | `lvr_ikoon_url` | `varchar2` | | ☐ | | | `lvr_klant_vlag` | `char` | | ☐ | | | `lvr_kvk_nummer` | `varchar2` | | ☐ | | | `lvr_label` | `varchar2` | | ☐ | | | `lvr_land` | `varchar2` | | ☐ | | | `lvr_logo_url` | `varchar2` | | ☐ | | | `lvr_naam_kort` | `varchar2` | | ☐ | | | `lvr_naam` | `varchar2` | | ☐ | | | `lvr_plaats` | `varchar2` | | ☐ | | | `lvr_postcode` | `varchar2` | | ☐ | | | `lvr_project_entiteit_vlag` | `char` | | ☐ | | | `lvr_pst_adres_regel_1` | `varchar2` | | ☐ | | | `lvr_pst_adres_regel_2` | `varchar2` | | ☐ | | | `lvr_pst_land` | `varchar2` | | ☐ | | | `lvr_pst_plaats` | `varchar2` | | ☐ | | | `lvr_pst_postcode` | `varchar2` | | ☐ | | | `lvr_statutaire_naam` | `varchar2` | | ☐ | | | `lvr_website_url` | `varchar2` | | ☐ | | | `lvr_werk_tel` | `varchar2` | | ☐ | | | `unt_deelbaar_vlag` | `char` | | ☐ | | | `unt_id` | `int64` | | ☐ | | | `unt_ikoon_url` | `varchar2` | | ☐ | | | `unt_kopieerbaar_vlag` | `char` | | ☐ | | | `unt_label` | `varchar2` | | ☐ | | | `unt_omschrijving` | `varchar2` | | ☐ | | | `unt_serienummer` | `varchar2` | | ☐ | | | `unt_verkoopbaar_vlag` | `char` | | ☐ | | | `unt_volledige_code` | `int64` | | ☐ | | | `unt_voorraad_vlag` | `char` | | ☐ | | | `unt_vpl_verkoopprijs_vlag` | `char` | | ☐ | | | `usr_code` | `varchar2` | | ☐ | | | `usr_id` | `int64` | | ☐ | | | `usr_logon_code` | `varchar2` | | ☐ | | | `usr_name` | `varchar2` | | ☐ | | | `ust_code` | `varchar2` | | ☐ | | | `ust_id` | `int64` | | ☐ | | | `ust_ikoon_url` | `varchar2` | | ☐ | | | `ust_omschrijving` | `varchar2` | | ☐ | | | `ust_vpl_verkoopprijs_vlag` | `char` | | ☐ | | | `wsa_code` | `varchar2` | | ☐ | | | `wsa_id` | `int64` | | ☐ | | | `wsa_omschrijving` | `varchar2` | | ☐ | |