Use this table to determine the FERPA status of a student by EMPLID.
| Key | Record.Fieldname | Format | XLAT | Heading Text |
|---|---|---|---|---|
| → | EMPLID - ID | Char11 | ID | |
| UM_FERPA - UM_FERPA | Char1 | UM_FERPA |
UM_FERPA - UM_FERPA Field Values
- Y = Student has indicated that no directory information be released
- N = No options selected
- P = All directory information can be released except for address (including email address)
SQL for creating PS_UM_FERPA_VW
SELECT A.EMPLID,
DECODE((SELECT COUNT(DISTINCT t.recname)
FROM sysadm.ps_ferpa_override t
WHERE t.emplid = a.emplid
AND t.recname = 'ADDR_FERPA_VW') +
(SELECT COUNT(DISTINCT t.recname)
FROM sysadm.ps_ferpa_override t
WHERE t.emplid = a.emplid
AND t.recname <> 'ADDR_FERPA_VW'),
0,
'N',
1,
'P',
'Y') "UM_FERPA"
FROM PS_HCR_PERSON_I A;
FERPA Information
- FERPA definition
- Follow this link to our FERPA page for more information, including a link to the US Department of Education website.
MaineStreet screen for student self-selection of FERPA status
