DP_ANALFLDS_LNG

(SQL View)
 Index Back

PS_ANALFLDS LNG VW

SELECT DP_PSAPPS_FIELDID , DP_CAPTION , DP_FIELDLENGTH FROM PS_DP_PSANALFIELDS WHERE DP_VALIDINDP = 'Y' AND DP_VALIDINIP = 'Y' AND (DP_FIELDTYPE = '1' OR DP_FIELDTYPE = '2')

SELECT DP_PSAPPS_FIELDID ,LANGUAGE_CD , DP_CAPTION FROM PS_DP_PSANFLDS_LNG

  • Related Language Record for DP_ANALFLDS_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 DP_PSAPPS_FIELDID Character(18) VARCHAR2(18) NOT NULL DP_PSAPPS_FIELDID
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 DP_CAPTION Character(30) VARCHAR2(30) NOT NULL DP_CAPTION