holdplacering_revisionsspors


Columns

Column Type Size Nulls Auto Default Children Parents Comments
hprev_id int8 19 null
cpr_nr varchar 11 √ null
cosa_formal varchar 4 √ null
versionsnummer varchar 4 √ null
aktivitet varchar 12 √ null
startdato timestamp 22 √ null
slutdato timestamp 22 √ null
opropdtid timestamp 22 √ null
opropdinit varchar 30 √ null
opdinit varchar 30 √ null
opdtid timestamp 22 √ null
opdmod varchar 4 √ null
rate int2 5 √ null
hopl_id int8 19 √ null
ae_rekvirent varchar 4 √ null
holdident varchar 8 √ null
opropdmod varchar 4 √ null
operation varchar 1 √ null
oprindelse varchar 1 √ null
oprettet_i_elevplan varchar 1 √ null
ose_projekt varchar 10 √ null
ose_ansvar varchar 10 √ null
ose_formal varchar 10 √ null
ose_art varchar 10 √ null
eisp_aftale_startdato timestamp 22 √ null
eisp_aftale_type varchar 5 √ null
skoleforlob varchar 12 √ null
fritekst varchar 200 √ null
placeringstype varchar 1 √ null
tilskud varchar 1 √ null
gennemfort varchar 1 √ null
kursiststatus varchar 1 √ null
indskrivningsform varchar 4 √ null
lrst_se_nr varchar 8 √ null
lrst_lobenummer int2 5 √ null
logi varchar 1 √ null
akasse varchar 1 √ null
betaler varchar 3 √ null
lrst_id_betal int8 19 √ null
lrst_betal_se_nr varchar 8 √ null
lrst_betal_lobenummer int2 5 √ null
transportbesver varchar 1 √ null
uddannelse_efter_skolegang varchar 1 √ null
uddannelsesbaggrund varchar 200 √ null
uddannelse_anvendt_5_ar varchar 1 √ null
lon_under_kursus varchar 1 √ null
information_sendes_til varchar 20 √ null
informationskanal varchar 10 √ null
sms_onskes varchar 1 √ null
mobilnr varchar 16 √ null
email varchar 100 √ null
hjelpemidler varchar 4000 √ null
navngiven varchar 1 √ null
reserveret_af varchar 100 √ null
opkrevet varchar 1 √ null
hopl_guid varchar 32 √ null

Indexes

Constraint Name Type Sort Column(s)
hprev_pk Primary key Asc hprev_id
hprev_cpr_nr_cosa_formal_idx Performance Asc/Asc cpr_nr + cosa_formal
hprev_hopl_id_idx Performance Asc hopl_id

Check Constraints

Constraint Name Constraint
holdplacering_revisionsspors_uddannelse_anvendt_5_ar_check (((uddannelse_anvendt_5_ar)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
holdplacering_revisionsspors_check7 (('OPERATION' IS NOT NULL))
holdplacering_revisionsspors_eisp_aftale_type_check (((eisp_aftale_type)::text = ANY ((ARRAY['AFPV'::character varying, 'LAND'::character varying, 'PIU'::character varying, 'SKPS'::character varying])::text[])))
holdplacering_revisionsspors_navngiven_check (((navngiven)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
holdplacering_revisionsspors_sms_onskes_check (((sms_onskes)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
holdplacering_revisionsspors_information_sendes_til_check (((information_sendes_til)::text = ANY ((ARRAY['Arbejdsgiver'::character varying, 'Kursist'::character varying])::text[])))
holdplacering_revisionsspors_check8 (('OPROPDINIT' IS NOT NULL))
holdplacering_revisionsspors_gennemfort_check (((gennemfort)::text = ANY ((ARRAY['1'::character varying, '2'::character varying, '3'::character varying])::text[])))
holdplacering_revisionsspors_check11 (('STARTDATO' IS NOT NULL))
holdplacering_revisionsspors_lon_under_kursus_check (((lon_under_kursus)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
holdplacering_revisionsspors_oprindelse_check (((oprindelse)::text = ANY ((ARRAY['A'::character varying, 'E'::character varying, 'W'::character varying])::text[])))
holdplacering_revisionsspors_kursiststatus_check (((kursiststatus)::text = ANY ((ARRAY['1'::character varying, '2'::character varying, '4'::character varying, '6'::character varying, '7'::character varying])::text[])))
holdplacering_revisionsspors_oprettet_i_elevplan_check (((oprettet_i_elevplan)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
holdplacering_revisionsspors_transportbesver_check (((transportbesver)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
holdplacering_revisionsspors_opkrevet_check (((opkrevet)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
holdplacering_revisionsspors_check6 (('OPDTID' IS NOT NULL))
holdplacering_revisionsspors_operation_check (((operation)::text = ANY ((ARRAY['-'::character varying, 'D'::character varying, 'I'::character varying, 'U'::character varying])::text[])))
holdplacering_revisionsspors_check5 (('OPDMOD' IS NOT NULL))
holdplacering_revisionsspors_check10 (('SLUTDATO' IS NOT NULL))
holdplacering_revisionsspors_check2 (('CPR_NR' IS NOT NULL))
holdplacering_revisionsspors_check3 (('HPREV_ID' IS NOT NULL))
holdplacering_revisionsspors_placeringstype_check (((placeringstype)::text = ANY ((ARRAY['A'::character varying, 'L'::character varying, 'P'::character varying, 'R'::character varying, 'S'::character varying, 'U'::character varying, 'V'::character varying])::text[])))
holdplacering_revisionsspors_betaler_check (((betaler)::text = ANY ((ARRAY['P'::character varying, 'L'::character varying, 'GVU'::character varying, 'N'::character varying])::text[])))
holdplacering_revisionsspors_tilskud_check (((tilskud)::text = ANY ((ARRAY['-'::character varying, 'J'::character varying, 'N'::character varying])::text[])))
holdplacering_revisionsspors_informationskanal_check (((informationskanal)::text = ANY ((ARRAY['E-mail'::character varying, 'Post'::character varying])::text[])))
holdplacering_revisionsspors_akasse_check (((akasse)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
holdplacering_revisionsspors_check4 (('OPDINIT' IS NOT NULL))
holdplacering_revisionsspors_check12 (('VERSIONSNUMMER' IS NOT NULL))
holdplacering_revisionsspors_check9 (('OPROPDTID' IS NOT NULL))
holdplacering_revisionsspors_uddannelse_efter_skolegang_check (((uddannelse_efter_skolegang)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
holdplacering_revisionsspors_logi_check (((logi)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
holdplacering_revisionsspors_check1 (('COSA_FORMAL' IS NOT NULL))
holdplacering_revisionsspors_check (('AKTIVITET' IS NOT NULL))

Relationships

Close relationships within degrees of separation