EOEP_FLD_PAR_VW

(SQL View)
 Index Back

Keycode using Parent

This view extracts the record and fieldname of the application code but using the parent key code.

SELECT FLD.EOEP_APP_CD , FLD.RECNAME , FLD.FIELDNAME , FLD.LONGNAME , FLD.PROMPT_TBL , PAR.EOEP_KEY_FLD_CD FROM PS_EOEP_FLDNAME_VW FLD , PS_EOEP_FLDNAME_VW PAR WHERE FLD.FIELDNAME = PAR.FIELDNAME AND PAR.EOEP_APP_CD = ( SELECT X.EOEP_PARENT_APP FROM PS_EOEP_APP_CODE X WHERE X.EOEP_APP_CD = FLD.EOEP_APP_CD)

  • Related Language Record: EOEP_FLD_PAR_LG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EOEP_APP_CD Character(4) VARCHAR2(4) NOT NULL Transaction Code

    Prompt Table: EOEP_APPCD_VW

    2 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

    Prompt Table: PSRECDEFN

    3 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
    4 LONGNAME Character(30) VARCHAR2(30) NOT NULL Long Name
    5 PROMPT_TBL Character(15) VARCHAR2(15) NOT NULL Prompt Table

    Prompt Table: PSRECDEFN

    6 EOEP_KEY_FLD_CD Character(3) VARCHAR2(3) NOT NULL Key field code