EODP_INT_RECFLD

(SQL Table)
 Index Back

Maintain record Field

Internal Use only: Record which stores Reocrd Field Data Privacy mappings in Set Data Privacy Attributes page

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

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

Prompt Table: PSRECFIELDDB
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

Default Value: N

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

Default Value: N