sosu_uddannelsesplan_demo

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

cpr_nr

varchar

√

null

Navn

text

2147483647

√

null

Udda.

varchar

√

null

Version

varchar

√

null

Uddannelse

varchar

√

null

Startdato

text

2147483647

√

null

Slutdato

text

2147483647

√

null

Type

text

2147483647

√

null

Praktiktype

text

2147483647

√

null

Skoleforløb

varchar

2147483647

√

null

Ttilskudsuger

text

2147483647

√

null

Årselevsbidrag

text

2147483647

√

null

Skolenr./CVR-nr.

text

2147483647

√

null

Lbnr.

int4

√

null

Skolenavn/Praktiksted

text

2147483647

√

null

Skoleperiode

varchar

2147483647

√

null

Periodetype

varchar

2147483647

√

null

Periodetypebetegnelse

varchar

2147483647

√

null

Relationships

Close relationships within degrees of separation

View Definition

SELECT elev.cpr_nr,
    (((elev.fornavn)::text || ' '::text) || (elev.efternavn)::text) AS "Navn",
    cofo.cosa_formal AS "Udda.",
    udda.version AS "Version",
    cofo.betegnelse AS "Uddannelse",
    to_char(elis.startdato, 'YYYY.MM.DD'::text) AS "Startdato",
    to_char(elis.slutdato, 'YYYY.MM.DD'::text) AS "Slutdato",
    'Skoleforløb'::text AS "Type",
    NULL::text AS "Praktiktype",
    skof.skoleforlob AS "Skoleforløb",
    to_char((((COALESCE(sum(sbi.bidrag), (0)::numeric) + COALESCE(sum(aebi.bidrag), (0)::numeric)) * (200)::numeric) / (5)::numeric), '90D9'::text) AS "Ttilskudsuger",
    to_char((COALESCE(sum(sbi.bidrag), (0)::numeric) + COALESCE(sum(aebi.bidrag), (0)::numeric)), '09D99999'::text) AS "Årselevsbidrag",
    NULL::text AS "Skolenr./CVR-nr.",
    NULL::integer AS "Lbnr.",
    NULL::text AS "Skolenavn/Praktiksted",
    skpe.skoleperiode AS "Skoleperiode",
    pety.periodetype AS "Periodetype",
    pety.betegnelse AS "Periodetypebetegnelse"
   FROM ((((((((easycdata.elever elev
     JOIN easycdata.uddannelser udda ON ((elev.udda_id = udda.udda_id)))
     JOIN easycdata.cosa_formal cofo ON ((udda.cofo_id = cofo.cofo_id)))
     JOIN easycdata.elev_i_skoleforlob elis ON ((elev.elev_id = elis.elev_id)))
     JOIN easycdata.skoleforlob skof ON ((elis.skof_id = skof.skof_id)))
     JOIN easycdata.skoleperioder skpe ON ((skof.skpe_id = skpe.skpe_id)))
     JOIN easycdata.periodetyper pety ON ((skpe.pety_id = pety.pety_id)))
     LEFT JOIN easycdata.sta_bidrag sbi ON ((sbi.elis_id = elis.elis_id)))
     LEFT JOIN easycdata.ae_bidrag aebi ON ((aebi.elis_id = elis.elis_id)))
  WHERE ((elev.cpr_nr)::text >= '3200000000'::text)
  GROUP BY elev.cpr_nr, (((elev.fornavn)::text || ' '::text) || (elev.efternavn)::text), cofo.cosa_formal, udda.version, cofo.betegnelse, (to_char(elis.startdato, 'YYYY.MM.DD'::text)), (to_char(elis.slutdato, 'YYYY.MM.DD'::text)), 'Skoleforløb'::text, NULL::text, skof.skoleforlob, NULL::text, NULL::integer, NULL::text, skpe.skoleperiode, pety.periodetype, pety.betegnelse
UNION
 SELECT elev.cpr_nr,
    (((elev.fornavn)::text || ' '::text) || (elev.efternavn)::text) AS "Navn",
    cofo.cosa_formal AS "Udda.",
    udda.version AS "Version",
    cofo.betegnelse AS "Uddannelse",
    to_char(eisp.startdato, 'YYYY.MM.DD'::text) AS "Startdato",
    to_char(eisp.slutdato, 'YYYY.MM.DD'::text) AS "Slutdato",
    'Skolepraktik'::text AS "Type",
    'Skolepraktik'::text AS "Praktiktype",
    NULL::text AS "Skoleforløb",
    to_char(((COALESCE(sum(aebsp.bidragsstorrelse), (0)::numeric) * (200)::numeric) / (5)::numeric), '09d9'::text) AS "Ttilskudsuger",
    to_char(COALESCE(sum(aebsp.bidragsstorrelse), (0)::numeric), '09D99999'::text) AS "Årselevsbidrag",
    NULL::text AS "Skolenr./CVR-nr.",
    NULL::integer AS "Lbnr.",
    NULL::text AS "Skolenavn/Praktiksted",
    skpe.skoleperiode AS "Skoleperiode",
    pety.periodetype AS "Periodetype",
    pety.betegnelse AS "Periodetypebetegnelse"
   FROM ((((((easycdata.elever elev
     JOIN easycdata.uddannelser udda ON ((elev.udda_id = udda.udda_id)))
     JOIN easycdata.cosa_formal cofo ON ((udda.cofo_id = cofo.cofo_id)))
     JOIN easycdata.elev_i_skolepraktik eisp ON ((eisp.elev_id = elev.elev_id)))
     JOIN easycdata.skoleperioder skpe ON ((eisp.skpe_id = skpe.skpe_id)))
     JOIN easycdata.periodetyper pety ON ((skpe.pety_id = pety.pety_id)))
     LEFT JOIN easycdata.ae_bidrag_skolepraktik aebsp ON ((aebsp.eisp_id = eisp.eisp_id)))
  WHERE ((elev.cpr_nr)::text >= '3200000000'::text)
  GROUP BY elev.cpr_nr, (((elev.fornavn)::text || ' '::text) || (elev.efternavn)::text), cofo.cosa_formal, udda.version, cofo.betegnelse, (to_char(eisp.startdato, 'YYYY.MM.DD'::text)), (to_char(eisp.slutdato, 'YYYY.MM.DD'::text)), 'Skolepraktik'::text, 'Skolepraktik'::text, NULL::text, NULL::text, NULL::integer, NULL::text, skpe.skoleperiode, pety.periodetype, pety.betegnelse
UNION
 SELECT elev.cpr_nr,
    (((elev.fornavn)::text || ' '::text) || (elev.efternavn)::text) AS "Navn",
    cofo.cosa_formal AS "Udda.",
    udda.version AS "Version",
    cofo.betegnelse AS "Uddannelse",
    to_char(eipra.startdato, 'YYYY.MM.DD'::text) AS "Startdato",
    to_char(eipra.slutdato, 'YYYY.MM.DD'::text) AS "Slutdato",
    'Praktikforløb'::text AS "Type",
    prakt.praktiktype AS "Praktiktype",
    prafo.praktikforlob AS "Skoleforløb",
    NULL::text AS "Ttilskudsuger",
    NULL::text AS "Årselevsbidrag",
    virk.cvr_nr AS "Skolenr./CVR-nr.",
    lrst.lobenummer AS "Lbnr.",
    lrst.navn AS "Skolenavn/Praktiksted",
    NULL::character varying AS "Skoleperiode",
    NULL::character varying AS "Periodetype",
    NULL::character varying AS "Periodetypebetegnelse"
   FROM (((((((easycdata.elever elev
     JOIN easycdata.uddannelser udda ON ((elev.udda_id = udda.udda_id)))
     JOIN easycdata.cosa_formal cofo ON ((udda.cofo_id = cofo.cofo_id)))
     JOIN easycdata.elev_i_praktikforlob eipra ON ((eipra.elev_id = elev.elev_id)))
     JOIN easycdata.praktikforlob prafo ON ((eipra.prafo_id = prafo.prafo_id)))
     LEFT JOIN easycdata.praktiktyper prakt ON ((prafo.prakt_id = prakt.prakt_id)))
     LEFT JOIN easycdata.leresteder lrst ON ((eipra.lrst_id = lrst.lrst_id)))
     LEFT JOIN easycdata.virksomheder virk ON ((lrst.virk_id = virk.virk_id)))
  WHERE (((prafo.type)::text = 'P'::text) AND ((elev.cpr_nr)::text >= '3200000000'::text))
  ORDER BY 6 DESC, 3, 4, 9;

Columns

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views