DP_IPUDFLDSVW

(SQL View)
 Index Back

View for IP User Data Code

SELECT A.DP_USERDATACODE , A.DP_FIELDID , A.DP_CAPTION FROM PS_DP_USERDATAFLDS A ,PS_DP_USERDATACDS B WHERE A.DP_USERDATACODE = B.DP_USERDATACODE

SELECT A.DP_USERDATACODE , A.DP_FIELDID , A.DP_CAPTION FROM PS_DP_USERDATAFLDS A ,PS_DP_USERDATACDS B WHERE A.DP_USERDATACODE = B.DP_USERDATACODE AND A.DP_FIELDID NOT IN('DP_ITEMCODE','DP_LOCATION') AND A.DP_USEDUNUSED = 'Y'

  • Parent record: DP_USERDATACDS

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 DP_USERDATACODE Character(20) VARCHAR2(20) NOT NULL DP_USERDATACODE
    2 DP_FIELDID Character(24) VARCHAR2(24) NOT NULL DP_FIELDID
    3 DP_CAPTION Character(30) VARCHAR2(30) NOT NULL DP_CAPTION