FERPA_CNTL_REC (SQL Table)	Index Back
FERPA Control - Records The FERPA_CNTL_REC table contains the record 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_CNTL_REC

(SQL Table)

FERPA Control - Records

The FERPA_CNTL_REC table contains the record 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.

Related Language Record: FRP_CNTL_REC_LN

Parent Record Of FERPA_CNTL_FLD FERPA_OVRD_VW FRP_CNTL_FLD_LN

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 MULTIPLE_ROW Character(1) VARCHAR2(1) NOT NULL Multiple Row Record
Y/N Table Edit
Default Value: N

3 DESCR Character(30) VARCHAR2(30) NOT NULL Description

4 SCC_FERPA_FLD_SEQ Number(2,0) SMALLINT NOT NULL Fluid Sequence
Default Value: 0

5 SCC_FERPA_ALLOW_EX Character(1) VARCHAR2(1) NOT NULL Allow Exceptions
Y/N Table Edit
Default Value: N

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN). Prompt Table: CC_FERPA_SEL_VW
2	MULTIPLE_ROW	Character(1)	VARCHAR2(1) NOT NULL	Multiple Row Record Y/N Table Edit Default Value: N
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
4	SCC_FERPA_FLD_SEQ	Number(2,0)	SMALLINT NOT NULL	Fluid Sequence Default Value: 0
5	SCC_FERPA_ALLOW_EX	Character(1)	VARCHAR2(1) NOT NULL	Allow Exceptions Y/N Table Edit Default Value: N