RECNAMEPrompt Table: CC_FERPA_SEL_VW
Y/N Table Edit
Default Value: N
Y/N Table Edit
FERPA_CNTL_FLVW(SQL View) |
Index Back |
|---|---|
FERPA Control - Records ViewFERPA Control records View - used in Fluid that holds records where sequence is non-zero |
| SELECT RECNAME , MULTIPLE_ROW , DESCR , SCC_FERPA_FLD_SEQ , SCC_FERPA_ALLOW_EX FROM PS_FERPA_CNTL_REC WHERE SCC_FERPA_FLD_SEQ <> 0 |
| # | 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 |
| 5 | SCC_FERPA_ALLOW_EX | Character(1) | VARCHAR2(1) NOT NULL |
Allow Exceptions
Y/N Table Edit |