DP_CFGVWSPEC_VW

(SQL View)
 Index Back

Holds configviews within spec

SELECT SETID , DP_IMPORTSPEC , DP_CONFIGVIEW FROM PS_DP_EISPECD_VWS

SELECT A.DP_IMPORTSPEC , A.DP_CONFIGVIEW , C.OPRID FROM PS_DP_EISPECD_VWS A , PS_DP_VIEW1USER_VW B , PSOPRDEFN C WHERE A.DP_CONFIGVIEW = B.DP_CONFIGVIEW AND B.DP_USERID = C.OPRID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 DP_IMPORTSPEC Character(20) VARCHAR2(20) NOT NULL Specification used for running imports
2 DP_CONFIGVIEW Character(20) VARCHAR2(20) NOT NULL DP_CONFIGVIEW
3 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).