EODP_COMP_SYS

(SQL Table)
 Index Back

View References Page record

View Refernces Main Record used in Data Privacy Component

  • Related Language Record: EODP_CMPSYSLANG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name
    2 PNLNAME Character(30) VARCHAR2(30) NOT NULL Page Name (see PSPNLDEFN).
    3 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
    4 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
    5 LABEL_ID Character(18) VARCHAR2(18) NOT NULL LABEL_ID identifies uniquness of DB Field Labels. This field is used in PSDBFLDLABL and PSDBFLDLABLLANG.
    6 LBLTEXT Character(60) VARCHAR2(60) NOT NULL Label Text
    7 EODP_CTGRY_CD Character(6) VARCHAR2(6) NOT NULL Category Code

    Prompt Table: EODP_CTGRY_CODE

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

    Prompt Table: EODP_CLSFCN_VW

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

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

    11 EODP_SYS_LOADED Character(1) VARCHAR2(1) NOT NULL Data Privacy Framework: Field storing information as to whether System data from Staging table has been loaded to EODP_RECFIELD
    N=No
    Y=Yes