DP_USEDUDF_VW

(SQL View)
 Index Back

User Data Fields View

SELECT DP_USERDATACODE , DP_FIELDID , DP_CAPTION , DP_USEDUNUSED , DP_FIELDLENGTH , DP_FIELDTYPE FROM PS_DP_USERDATAFLDS WHERE DP_USEDUNUSED = 'Y'

SELECT DP_USERDATACODE , DP_FIELDID , DP_CAPTION FROM PS_DP_USERDATAFLDS WHERE DP_USEDUNUSED = 'Y'

# 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