DP_IPFLD1_LNG

(SQL View)
 Index Back

IPFLDSEL 1 LNG VW

SELECT DP_POLICYSET ,DP_FIELDID ,DP_CAPTION ,DP_DATATYPE FROM PS_DP_POLFLD_SELS WHERE DP_AVAILON_INTPOI = 'Y' AND DP_FIELDID NOT IN('DP_ITEMCODE','DP_LOCATION')

SELECT DP_POLICYSET ,DP_FIELDID ,LANGUAGE_CD ,DP_CAPTION FROM PS_DP_PFLDSEL_LNG

  • Related Language Record for DP_IPFLDSEL1_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 DP_POLICYSET Character(10) VARCHAR2(10) NOT NULL DP_POLICYSET
    2 DP_FIELDID Character(24) VARCHAR2(24) NOT NULL DP_FIELDID
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DP_CAPTION Character(30) VARCHAR2(30) NOT NULL DP_CAPTION