DP_IMPPOL_VW

(SQL View)
 Index Back

View of DP_SI_PS1USR_VW

SELECT A.DP_POLICYSET ,A.DP_CAPTION FROM PS_DP_SI_PS1USR_VW A , PS_DP_POLICYSETS B WHERE A.DP_POLICYSET = B.DP_POLICYSET AND B.DP_USESINVENTORY = 'N'

SELECT A.OPRID ,A.DP_POLICYSET ,A.DP_CAPTION FROM PS_DP_SI_PS1USR_VW A , PS_DP_POLICYSETS B WHERE A.DP_POLICYSET = B.DP_POLICYSET AND B.DP_USESINVENTORY = 'N'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 DP_POLICYSET Character(10) VARCHAR2(10) NOT NULL DP_POLICYSET
3 DP_CAPTION Character(30) VARCHAR2(30) NOT NULL DP_CAPTION