DP_IPPOLFLDS_VW

(SQL View)
 Index Back

IP Field Sels View for Publish

SELECT DP_POLICYSET ,DP_FIELDID ,DP_CAPTION ,DP_DATATYPE FROM PS_DP_POLFLD_SELS WHERE DP_AVAILON_IPEXPCF = 'Y' AND DP_AVAILON_IPEXPOF = 'Y' AND DP_AVAILON_IPEXP = 'Y' AND DP_FIELDID NOT IN('DP_YEAR', 'DP_PERIOD')

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 = 'IP'

# 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