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 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
Prompt Table: FERPA_CNTL_REC |
2 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
Prompt Table: %EDITTABLE |
3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |