| Tabelnavn | Kommentar | Data område |
|---|---|---|
| SOURCE.dbo.SOURCE_DUBU2_Contact | The contacts in DUBU holds the different types of contacts both child at risk, citizen and professionals. A contact with an SSN or Foreigner number is unique in DUBU and can be shared by several municipalities. Denne tabel er fra laget SOURCE, og er altså en CSV-fil, der kommer fra preburneren. | Udsattebørnogunge |
| Kolonne | Datatype | Kommentar |
|---|---|---|
| Created_by_ID | SOURCE_DELIMITED | |
| Created | SOURCE_DELIMITED | |
| Last_Upd_by_ID | SOURCE_DELIMITED | |
| Last_Upd | SOURCE_DELIMITED | |
| Row_ID | SOURCE_DELIMITED | |
| First_name | SOURCE_DELIMITED | |
| Last_name | SOURCE_DELIMITED | |
| Contact_Type | SOURCE_DELIMITED | |
| Description | SOURCE_DELIMITED | |
| SSN | SOURCE_DELIMITED | |
| CPR_subscription_flg | SOURCE_DELIMITED | |
| CPR_update | SOURCE_DELIMITED | |
| Foreign_number | SOURCE_DELIMITED | |
| Gender | SOURCE_DELIMITED | |
| Date_of_birth | SOURCE_DELIMITED | |
| Deceased_flg | SOURCE_DELIMITED | |
| Protected_addr | SOURCE_DELIMITED | |
| Protected_city | SOURCE_DELIMITED | |
| Protected_country | SOURCE_DELIMITED | |
| Protected_phone | SOURCE_DELIMITED | |
| PROTECTED_ZIP | SOURCE_DELIMITED | |
| Phone | SOURCE_DELIMITED | |
| EMAIL_ADDR | SOURCE_DELIMITED | |
| Native_lang | SOURCE_DELIMITED | |
| Country_of_birth | SOURCE_DELIMITED | |
| Nationality | SOURCE_DELIMITED | |
| Second_nationality | SOURCE_DELIMITED | |
| MOTHER_OF_UNBORN_CHILD_FLG | SOURCE_DELIMITED | |
| Work_ph_num | SOURCE_DELIMITED | |
| Mobile_phone | SOURCE_DELIMITED | |
| Benefit_receiver | SOURCE_DELIMITED | |
| Benefit_receiver_SSN | SOURCE_DELIMITED | |
| Day_care_other | SOURCE_DELIMITED | |
| Day_Care | SOURCE_DELIMITED | |
| School | SOURCE_DELIMITED | |
| School_year | SOURCE_DELIMITED | |
| School_type | SOURCE_DELIMITED | |
| School_typ_other | SOURCE_DELIMITED | |
| Association_work_education | SOURCE_DELIMITED | |
| Work_type | SOURCE_DELIMITED | |
| Education | SOURCE_DELIMITED | |
| Time_without_work | SOURCE_DELIMITED | |
| Comments | SOURCE_DELIMITED | |
| Marital_status_father | SOURCE_DELIMITED | |
| Marital_status_mother | SOURCE_DELIMITED | |
| Mother_Cohabitation | SOURCE_DELIMITED | |
| Father_Cohabitation | SOURCE_DELIMITED | |
| Mother_Housing | SOURCE_DELIMITED | |
| Father_Housing | SOURCE_DELIMITED | |
| Mother_Job | SOURCE_DELIMITED | |
| Father_Job | SOURCE_DELIMITED | |
| No_of_siblings | SOURCE_DELIMITED | |
| CurrentlyProcessedFileName | SOURCE_DELIMITED | Dette er en teknisk Kolonne i FLIS. Indeholder navnet på den fil, som rækken stammer fra |
| Mapping navn | Tabel rolle |
|---|---|
| Primær kilde table |