EODP_COMP_REF

(SQL Table)
 Index Back

View References Page record

View Refernces Main Record used in Data Privacy Component

  • Related Language Record: EODP_CMPRF_LANG

    • # 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 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    12 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    13 EODP_SYS_FLG Character(1) VARCHAR2(1) NOT NULL System Data Flag
    A=All
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N

    14 DATA_TYPE_CD Character(1) VARCHAR2(1) NOT NULL Data Type Code
    N=Customer Data
    S=Sample Data
    Y=System Data