CMP_OPT_REQ_FLD

(SQL Table)
 Index Back

RC Dflt Opt - Prereq Fields Tb

Rate Code Defaulting Options - Prerequisite Fields Table

  • Related Language Record: CMP_OPT_REQFLDL

    • # 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: CMP_OPT_REC_VW

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

    Prompt Table: CMP_OPT_FLD_VW

    3 CMP_PROMPT_FIELD Character(18) VARCHAR2(18) NOT NULL Name of Prompt Field

    Prompt Table: CMP_OPT_VALUE_V

    4 FIELDLABEL Character(30) VARCHAR2(30) NOT NULL Field Label

    Default Value: PSDBFLDLABL_VW.SHORTNAME

    5 CMP_RECORD_FIELD Character(18) VARCHAR2(18) NOT NULL Name of related Record Field

    Prompt Table: CMP_OPT_FLD2_VW