Tabel information
TabelnavnKommentarData område
SOURCE.dbo.SOURCE_DUBU2_DubucaseDubucase is the case for child at risk in DUBU. The entity contains information of the case type, status, categorization and where in the case life cycle the case currently is. The relation to case primary employee is the relation to the child at risk contact. Denne tabel er fra laget SOURCE, og er altså en CSV-fil, der kommer fra preburneren.Udsattebørnogunge
Kolonne information
KolonneDatatypeKommentar
Created_by_IDSOURCE_DELIMITED
CreatedSOURCE_DELIMITED
Last_Upd_by_IDSOURCE_DELIMITED
Last_UpdSOURCE_DELIMITED
Row_IDSOURCE_DELIMITED
Case_NumberSOURCE_DELIMITED
VersionSOURCE_DELIMITED
Kassation_CodeSOURCE_DELIMITED
EnforcementSOURCE_DELIMITED
Filenet_StatusSOURCE_DELIMITED
Filenet_GUIDSOURCE_DELIMITED
Journal_num_1SOURCE_DELIMITED
FacetSOURCE_DELIMITED
Organization_IDSOURCE_DELIMITED
PrioritySOURCE_DELIMITED
Stage_DateSOURCE_DELIMITED
Case_NameSOURCE_DELIMITED
StageSOURCE_DELIMITED
StatusSOURCE_DELIMITED
Case_TypeSOURCE_DELIMITED
DescriptionSOURCE_DELIMITED
Primary_contact_IDSOURCE_DELIMITED
CASE_WORKER_IDSOURCE_DELIMITEDSagsbehandler
CurrentlyProcessedFileNameSOURCE_DELIMITEDDette er en teknisk Kolonne i FLIS. Indeholder navnet på den fil, som rækken stammer fra
Mapping som bruger tabel som kilde
Mapping navnTabel rolle
SOURCE_DSAHIST_DUBU2_DubucasePrimær kilde table