FERPA_CNTL_FLD(SQL Table) | 
Index Back | 
|---|---|
FERPA Control - FieldsThe 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. | 
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description | 
|---|---|---|---|---|
| 1 | Character(15) | VARCHAR2(15) NOT NULL | 
Record (Table) Name (see PSRECDEFN).
 Prompt Table: FERPA_CNTL_REC  | 
|
| 2 | Character(18) | VARCHAR2(18) NOT NULL | 
Field Name (see PSDBFIELD).
 Prompt Table: %EDITTABLE  | 
|
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |