PTLT_ASN_FT_VW

(SQL View)
Index Back

Product to Feature Mapping

Product to Feature Mapping

SELECT PTLT_PRODUCT_CODE , %Table(PTLT_FEATURE).PTLT_FEATURE_CODE , PTLT_FEATURE FROM %Table(PTLT_FEATURE) , %Table(PTLT_ASSGN_FEAT) WHERE %Table(PTLT_FEATURE).PTLT_FEATURE_CODE = %Table(PTLT_ASSGN_FEAT).PTLT_FEATURE_CODE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PTLT_PRODUCT_CODE Character(4) VARCHAR2(4) NOT NULL Unique code for a product.
2 PTLT_FEATURE_CODE Character(10) VARCHAR2(10) NOT NULL Unique code identifying a feature
3 PTLT_FEATURE Character(50) VARCHAR2(50) NOT NULL Defintion of a feature