DP_UDPLFLDS_VW

(SQL View)
 Index Back

User Defined PL Fields in use

user defined planning fields in use

SELECT A.DP_USERDATACODE , A.DP_PSAPPS_FIELDID , A.DP_CAPTION , A.DP_FIELDID , A.DP_USEDUNUSED , A.DP_FIELDTYPE , A.DP_USERFIELD FROM PS_DP_USERDATAFLDS A , PS_DP_USERDATACDS B WHERE A.DP_USERDATACODE = B.DP_USERDATACODE AND A.DP_USERFIELD = 'Y' AND A.DP_USEDUNUSED = 'Y' AND A.DP_FIELDTYPE = '1' AND A.DP_PSAPPS_FIELDID <> ' ' AND B.DP_MODULE = 'DP'

  • 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

    Prompt Table: DP_USERDATACDS

    2 DP_PSAPPS_FIELDID Character(18) VARCHAR2(18) NOT NULL DP_PSAPPS_FIELDID
    3 DP_CAPTION Character(30) VARCHAR2(30) NOT NULL DP_CAPTION
    4 DP_FIELDID Character(24) VARCHAR2(24) NOT NULL DP_FIELDID
    5 DP_USEDUNUSED Character(1) VARCHAR2(1) NOT NULL DP_USEDUNUSED

    Y/N Table Edit

    Default Value: N

    6 DP_FIELDTYPE Character(1) VARCHAR2(1) NOT NULL DP_FIELDTYPE
    1=Character
    2=Numeric
    7 DP_USERFIELD Character(1) VARCHAR2(1) NOT NULL DP_USERFIELD