DP_IPITMCODE_VW

(SQL View)
Index Back

IP Master Item Code Values

IP Master Item Code Values by View

SELECT DISTINCT( DP_POLICYSET) , DP_ITEMCODE FROM PS_DP_IPMASTER WHERE DP_ITEMCODE <> ' '

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 DP_POLICYSET Character(10) VARCHAR2(10) NOT NULL DP_POLICYSET

Prompt Table: DP_POLICYSETS

2 DP_ITEMCODE Character(18) VARCHAR2(18) NOT NULL DP_ITEMCODE