PTLT_ASN_FT_VW(SQL View) |
Index Back |
---|---|
Product to Feature MappingProduct 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 |