DP_VWFLDSE10_VW

(SQL View)
 Index Back

View of Field Sels Table

SELECT DP_FIELDID ,DP_CAPTION FROM PS_DP_FIELD_SELS WHERE (DP_FIELDID LIKE 'DP_UD0%' OR DP_FIELDID Like 'DP_UD1%' OR DP_FIELDID Like 'DP_UD2%' OR DP_FIELDID Like 'DP_UD3%' OR DP_FIELDID Like 'DP_UD4%' OR DP_FIELDID Like 'DP_UD5%' OR DP_FIELDID = 'DP_LOCATION')

SELECT DP_CONFIGVIEW , DP_FIELDID , DP_CAPTION , DP_DATATYPE FROM PS_DP_VIEWFLD_SELS WHERE DP_AVAILON_WQPURGE = 'Y'

  • Related Language Record: DP_VWFLD10_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 DP_CONFIGVIEW Character(20) VARCHAR2(20) NOT NULL DP_CONFIGVIEW
    2 DP_FIELDID Character(24) VARCHAR2(24) NOT NULL DP_FIELDID
    3 DP_CAPTION Character(30) VARCHAR2(30) NOT NULL DP_CAPTION
    4 DP_DATATYPE Character(1) VARCHAR2(1) NOT NULL DP_DATATYPE
    0=Character
    1=Long Character
    2=Number
    3=Signed Number
    4=Date