elev_resultater_demo

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

cpr_nr

varchar

√

null

Navn

text

2147483647

√

null

Registreringstype

text

2147483647

√

null

skolefag

varchar

√

null

niveau

varchar

√

null

Skolefagsbetegnelse

varchar

√

null

termin

varchar

2147483647

√

null

Uddannelse

varchar

√

null

Version

varchar

√

null

Evalueringsform

varchar

2147483647

√

null

karaktertype

varchar

2147483647

√

null

fagtilknytning

varchar

2147483647

√

null

Karakterværdi

text

2147483647

√

null

karakterskala

varchar

2147483647

√

null

Karakterværdi 7trin

text

2147483647

√

null

Karakterværdi ects

text

2147483647

√

null

skolenr

varchar

2147483647

√

null

skolenavn

varchar

2147483647

√

null

frigivelsesmarkering

text

2147483647

√

null

Frit_unv

varchar

2147483647

√

null

Frit_eksam

varchar

2147483647

√

null

Medtæller eksamen

varchar

√

null

Godk medarbejder

varchar

2147483647

√

null

Merit/godskrivningstekst

varchar

100

√

null

Offentliggørelsesdato

text

2147483647

√

null

bevistekst

varchar

2147483647

√

null

evaluering

varchar

2147483647

√

null

Relationships

Close relationships within degrees of separation

View Definition

SELECT pers.cpr_nr,
    (((pers.fornavn)::text || ' '::text) || (pers.efternavn)::text) AS "Navn",
    'Anden skole'::text AS "Registreringstype",
    akm.skolefag,
    akm.niveau,
    skfa.kort_betegnelse AS "Skolefagsbetegnelse",
    akm.termin,
    cosa.cosa_formal AS "Uddannelse",
    udd.version AS "Version",
    ef.evalueringsform AS "Evalueringsform",
    kt.karaktertype,
    akm.fagtilknytning,
    ltrim((akm.karakterverdi)::text, ' '::text) AS "Karakterværdi",
    kask.karakterskala,
    ltrim((akm.kar_verdi_7trin)::text, ' '::text) AS "Karakterværdi 7trin",
    ltrim((akm.kar_verdi_ects)::text, ' '::text) AS "Karakterværdi ects",
    skol.dsnr AS skolenr,
    skol.navn AS skolenavn,
    'J'::text AS frigivelsesmarkering,
    akm.undervisning AS "Frit_unv",
    akm.eksamen AS "Frit_eksam",
    akm.medteller_eksamen AS "Medtæller eksamen",
    NULL::character varying AS "Godk medarbejder",
    akm.godskrivningstekst AS "Merit/godskrivningstekst",
    NULL::text AS "Offentliggørelsesdato",
    akm.bevistekst,
    akm.evaluering
   FROM easycdata.personer pers,
    easycdata.uddannelser udd,
    easycdata.cosa_formal cosa,
    easycdata.skoler skol,
    (((((easycdata.andre_karakterer_meritter akm
     LEFT JOIN easycdata.resultatformer rf ON ((akm.refo_id = rf.refo_id)))
     LEFT JOIN easycdata.karakterskala kask ON ((rf.kask_id = kask.kask_id)))
     LEFT JOIN easycdata.evalueringsformer ef ON ((rf.evfo_id = ef.evfo_id)))
     LEFT JOIN easycdata.karaktertype kt ON ((rf.ktyp_id = kt.ktyp_id)))
     LEFT JOIN easycdata.skolefag skfa ON ((((akm.skolefag)::text = (skfa.skolefag)::text) AND ((akm.niveau)::text = (skfa.niveau)::text))))
  WHERE ((akm.pers_id = pers.pers_id) AND (akm.udda_id = udd.udda_id) AND (udd.cofo_id = cosa.cofo_id) AND (akm.skol_id = skol.skol_id) AND ((pers.cpr_nr)::text >= '3200000000'::text))
UNION
 SELECT elev.cpr_nr,
    (((elev.fornavn)::text || ' '::text) || (elev.efternavn)::text) AS "Navn",
    'Fritagelse'::text AS "Registreringstype",
    sf.skolefag,
    sf.niveau,
    sf.kort_betegnelse AS "Skolefagsbetegnelse",
    ''::character varying AS termin,
    cosa.cosa_formal AS "Uddannelse",
    udd.version AS "Version",
    ''::character varying AS "Evalueringsform",
    ''::character varying AS karaktertype,
    ''::character varying AS fagtilknytning,
    ''::text AS "Karakterværdi",
    ''::character varying AS karakterskala,
    ''::text AS "Karakterværdi 7trin",
    ''::text AS "Karakterværdi ects",
    ''::character varying AS skolenr,
    ''::character varying AS skolenavn,
    ''::text AS frigivelsesmarkering,
    f.undervisning AS "Frit_unv",
    f.eksamen AS "Frit_eksam",
    f.medteller_eksamen AS "Medtæller eksamen",
    meda.initialer AS "Godk medarbejder",
    f.godskrivningstekst AS "Merit/godskrivningstekst",
    NULL::text AS "Offentliggørelsesdato",
    f.bevistekst,
    ''::character varying AS evaluering
   FROM easycdata.elever elev,
    easycdata.skolefag sf,
    easycdata.uddannelser udd,
    easycdata.cosa_formal cosa,
    (easycdata.fritagelser f
     LEFT JOIN easycdata.medarbejdere meda ON ((f.meda_id = meda.meda_id)))
  WHERE ((f.elev_id = elev.elev_id) AND (f.skfa_id = sf.skfa_id) AND (elev.udda_id = udd.udda_id) AND (udd.cofo_id = cosa.cofo_id) AND ((elev.cpr_nr)::text >= '3200000000'::text) AND (NOT (EXISTS ( SELECT '1'::text
           FROM easycdata.karakterer k
          WHERE (k.frit_id = f.frit_id)))) AND (NOT (EXISTS ( SELECT '1'::text
           FROM easycdata.andre_karakterer_meritter akm
          WHERE (akm.frit_id = f.frit_id)))))
UNION
 SELECT elev.cpr_nr,
    (((elev.fornavn)::text || ' '::text) || (elev.efternavn)::text) AS "Navn",
    'Karakter'::text AS "Registreringstype",
    sk.skolefag,
    sk.niveau,
    sk.kort_betegnelse AS "Skolefagsbetegnelse",
    k.termin,
    cosa.cosa_formal AS "Uddannelse",
    udd.version AS "Version",
    ef.evalueringsform AS "Evalueringsform",
    kt.karaktertype,
    k.fagtilknytning,
    ltrim((kv.karaktervardi)::text, ' '::text) AS "Karakterværdi",
    kask.karakterskala,
    ( SELECT kv7trin.karaktervardi
           FROM easycdata.karaktervardi kv7trin
          WHERE (kv7trin.kvar_id = k.kvar_id_7trin)) AS "Karakterværdi 7trin",
    ( SELECT kvects.karaktervardi
           FROM easycdata.karaktervardi kvects
          WHERE (kvects.kvar_id = k.kvar_id_ects)) AS "Karakterværdi ects",
    skol.dsnr AS skolenr,
    skol.navn AS skolenavn,
        CASE
            WHEN (fm.frig_id IS NULL) THEN 'N'::text
            ELSE 'J'::text
        END AS frigivelsesmarkering,
    ''::character varying AS "Frit_unv",
    ''::character varying AS "Frit_eksam",
    k.medteller_eksamen AS "Medtæller eksamen",
    ''::character varying AS "Godk medarbejder",
    k.merittekst AS "Merit/godskrivningstekst",
    to_char(k.offentliggorelsesdato, 'YYYY.MM.DD'::text) AS "Offentliggørelsesdato",
    ''::character varying AS bevistekst,
    k.evaluering
   FROM easycdata.elever elev,
    easycdata.skolefag sk,
    easycdata.uddannelser udd,
    easycdata.cosa_formal cosa,
    easycdata.resultatformer rf,
    easycdata.evalueringsformer ef,
    easycdata.karaktertype kt,
    easycdata.karaktervardi kv,
    easycdata.skoler skol,
    easycdata.karakterskala kask,
    (easycdata.karakterer k
     LEFT JOIN easycdata.frigivelsesmarkeringer fm ON ((k.kara_id = fm.kara_id)))
  WHERE ((k.elev_id = elev.elev_id) AND (k.skfa_id = sk.skfa_id) AND (elev.udda_id = udd.udda_id) AND (udd.cofo_id = cosa.cofo_id) AND (k.refo_id = rf.refo_id) AND (rf.evfo_id = ef.evfo_id) AND (rf.ktyp_id = kt.ktyp_id) AND (rf.kask_id = kask.kask_id) AND (k.kvar_id = kv.kvar_id) AND (k.skol_id = skol.skol_id) AND (k.frit_id IS NULL) AND ((elev.cpr_nr)::text >= '3200000000'::text))
UNION
 SELECT elev.cpr_nr,
    (((elev.fornavn)::text || ' '::text) || (elev.efternavn)::text) AS "Navn",
    'Merit'::text AS "Registreringstype",
    sk.skolefag,
    sk.niveau,
    sk.kort_betegnelse AS "Skolefagsbetegnelse",
    k.termin,
    cosa.cosa_formal AS "Uddannelse",
    udd.version AS "Version",
    ef.evalueringsform AS "Evalueringsform",
    kt.karaktertype,
    k.fagtilknytning,
    ltrim((kv.karaktervardi)::text, ' '::text) AS "Karakterværdi",
    kask.karakterskala,
    ( SELECT kv7trin.karaktervardi
           FROM easycdata.karaktervardi kv7trin
          WHERE (kv7trin.kvar_id = k.kvar_id_7trin)) AS "Karakterværdi 7trin",
    ( SELECT kvects.karaktervardi
           FROM easycdata.karaktervardi kvects
          WHERE (kvects.kvar_id = k.kvar_id_ects)) AS "Karakterværdi ects",
    skol.dsnr AS skolenr,
    skol.navn AS skolenavn,
        CASE
            WHEN (fm.frig_id IS NULL) THEN 'N'::text
            ELSE 'J'::text
        END AS frigivelsesmarkering,
    f.undervisning AS "Frit_unv",
    f.eksamen AS "Frit_eksam",
    k.medteller_eksamen AS "Medtæller eksamen",
    meda.initialer AS "Godk medarbejder",
    f.godskrivningstekst AS "Merit/godskrivningstekst",
    to_char(k.offentliggorelsesdato, 'YYYY.MM.DD'::text) AS "Offentliggørelsesdato",
    ''::character varying AS bevistekst,
    k.evaluering
   FROM easycdata.elever elev,
    easycdata.skolefag sk,
    easycdata.uddannelser udd,
    easycdata.cosa_formal cosa,
    easycdata.resultatformer rf,
    easycdata.evalueringsformer ef,
    easycdata.karaktertype kt,
    easycdata.skoler skol,
    easycdata.karakterskala kask,
    (easycdata.fritagelser f
     LEFT JOIN easycdata.medarbejdere meda ON ((f.meda_id = meda.meda_id))),
    ((easycdata.karakterer k
     LEFT JOIN easycdata.karaktervardi kv ON ((k.kvar_id = kv.kvar_id)))
     LEFT JOIN easycdata.frigivelsesmarkeringer fm ON ((k.kara_id = fm.kara_id)))
  WHERE ((k.elev_id = elev.elev_id) AND (k.skfa_id = sk.skfa_id) AND (elev.udda_id = udd.udda_id) AND (udd.cofo_id = cosa.cofo_id) AND (k.refo_id = rf.refo_id) AND (rf.evfo_id = ef.evfo_id) AND (rf.ktyp_id = kt.ktyp_id) AND (rf.kask_id = kask.kask_id) AND (k.skol_id = skol.skol_id) AND (k.frit_id = f.frit_id) AND ((elev.cpr_nr)::text >= '3200000000'::text))
  ORDER BY 1, 4, 5, 11, 10, 14;

Columns

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views