PTLT_PRODUCT_CODEPTLT_ASN_PRD_VW(SQL View) |
Index Back |
|---|---|
Product to Feature MappingProduct to Feature Mapping |
| SELECT PTLT_PRODUCT_CODE , PTLT_PRODUCT FROM %Table(PTLT_PRODUCT) WHERE EXISTS ( SELECT 'X' FROM %Table(PTLT_ASSGN_FEAT) WHERE %Table(PTLT_PRODUCT).PTLT_PRODUCT_CODE = %Table(PTLT_ASSGN_FEAT).PTLT_PRODUCT_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_PRODUCT | Character(30) | VARCHAR2(30) NOT NULL | Name of a product |