DP_UDFLDS_VW3

(SQL View)
 Index Back

User Defined Fields in use

SELECT DP_USERDATACODE , DP_FIELDID , DP_CAPTION , DP_USEDUNUSED , DP_FIELDTYPE , DP_USERFIELD FROM PS_DP_USERDATAFLDS WHERE DP_USERDATACODE = 'TBG' AND DP_USERFIELD = 'Y' AND DP_USEDUNUSED = 'Y'

SELECT DP_USERDATACODE , DP_FIELDID , DP_CAPTION , DP_USEDUNUSED , DP_FIELDTYPE , DP_USERFIELD FROM PS_DP_USERDATAFLDS WHERE DP_USERFIELD = 'Y' AND 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

    Prompt Table: DP_USERDATACDS

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

    Y/N Table Edit

    Default Value: N

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