DP_KEYFLDS_VW

(SQL View)
 Index Back

View with Key fields

View use in the script that populates DP_VIEWFLD_SELS table SELECT DP_CONFIGVIEW ,DP_FIELDID ,'Y' FROM PS_DP_CONFIGFIELDS WHERE DP_KEYFIELD_LVL <> 0

SELECT DP_CONFIGVIEW ,DP_FIELDID ,'N' FROM PS_DP_CONFIGFIELDS

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 DP_CONFIGVIEW Character(20) VARCHAR2(20) NOT NULL DP_CONFIGVIEW

Prompt Table: DP_CONFIGVIEWS

2 DP_FIELDID Character(24) VARCHAR2(24) NOT NULL DP_FIELDID
3 DP_KEYFIELD Character(1) VARCHAR2(1) NOT NULL DP_KEYFIELD