PTLT_PROD_SUITE_CDPTLT_PRODUCT_CODEPTLT_FEATURE_CODEPrompt Table: PTLT_FEATURE
PTLT_S_P_F_VW(SQL View) |
Index Back |
|---|---|
Product Features in SolutionsUsed in Setup Manager |
| SELECT A.PTLT_PROD_SUITE_CD , A.PTLT_PRODUCT_CODE , B.PTLT_FEATURE_CODE , B.PTLT_REQUIRED FROM %Table(PTLT_ASSGN_PROD) A , %Table(PTLT_ASSGN_FEAT) B WHERE A.PTLT_PRODUCT_CODE = B.PTLT_PRODUCT_CODE |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PTLT_PROD_SUITE_CD |
Character(10) | VARCHAR2(10) NOT NULL | Unique code for solutions |
| 2 | PTLT_PRODUCT_CODE |
Character(4) | VARCHAR2(4) NOT NULL | Unique code for a product. |
| 3 | PTLT_FEATURE_CODE |
Character(10) | VARCHAR2(10) NOT NULL |
Unique code identifying a feature
Prompt Table: PTLT_FEATURE |
| 4 | PTLT_REQUIRED | Character(1) | VARCHAR2(1) NOT NULL | Is this required for implementation? |