EODP_RF_TMP

(SQL Table)
Index Back

System data tmp table

Data Privacy Framework: Stores system data for EODP_RECFIELD

# 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: PSRECDEFN

2 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

Prompt Table: PSRECFIELD
Set Control Field: RECNAME

3 EODP_CTGRY_CD Character(6) VARCHAR2(6) NOT NULL Category Code

Prompt Table: EODP_CTGRY_CODE

4 EODP_CLFNCD Number(3,0) SMALLINT NOT NULL Classification Code

Prompt Table: EODP_CLSFCN_VW

5 EODP_PERS_IDFR Character(1) VARCHAR2(1) NOT NULL Personal Identifier
A=All
N=No
Y=Yes

Y/N Table Edit

Default Value: N

6 EODP_SNSTV Character(1) VARCHAR2(1) NOT NULL Sensitive
A=All
N=No
Y=Yes

Y/N Table Edit

Default Value: N