FERPA_OVRD_VW (SQL View)	Index Back
FERPA Control - Fields The FERPA_CNTL_FLD table contains the record/field pair names from which data fields can come from that are FERPA controlled. The institution deems which records/fields are under FERPA control. The record/field pairs provide the basis for allowing an individual to 'override' the FERPA control and thereby allow release of the information.

FERPA_OVRD_VW

(SQL View)

FERPA Control - Fields

The FERPA_CNTL_FLD table contains the record/field pair names from which data fields can come from that are FERPA controlled. The institution deems which records/fields are under FERPA control. The record/field pairs provide the basis for allowing an individual to 'override' the FERPA control and thereby allow release of the information.

SELECT DISTINCT EMPLID , RECNAME FROM PS_FERPA_OVERRIDE

Parent record: FERPA_CNTL_REC

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Prompt Table: PEOPLE_SRCH

2 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
Prompt Table: FERPA_CNTL_REC

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PEOPLE_SRCH
2	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN). Prompt Table: FERPA_CNTL_REC