PTLT_BP_NAMEPTLT_BP_DTL_NAMEPTLT_PRODUCT_CODEPTLT_FEATURE_CODEPrompt Table: PTLT_FEATURE
PTLT_B_P_F_VW |
index back |
|---|---|
Product Features-Bus Processes |
| SELECT A.PTLT_BP_NAME , A.PTLT_BP_DTL_NAME , B.PTLT_PRODUCT_CODE , B.PTLT_FEATURE_CODE , C.PTLT_REQUIRED FROM %Table(PTLT_BP_DTL_VW) A , %Table(PTLT_ASSGN_PRFT) B , %Table(PTLT_ASSGN_FEAT) C WHERE A.PTLT_BP_NAME = B.PTLT_BP_NAME AND A.PTLT_BP_DTL_NAME = B.PTLT_BP_DTL_NAME AND B.PTLT_PRODUCT_CODE = C.PTLT_PRODUCT_CODE AND B.PTLT_FEATURE_CODE = C.PTLT_FEATURE_CODE |
| PeopleSoft Field Name | Field Type | Column Type | Description |
|---|---|---|---|
| PTLT_BP_NAME |
Character(50) | VARCHAR2(50) NOT NULL | Business Process Name |
| PTLT_BP_DTL_NAME |
Character(50) | VARCHAR2(50) NOT NULL | Detailed Business Process Name |
| PTLT_PRODUCT_CODE |
Character(4) | VARCHAR2(4) NOT NULL | Unique code for a product. |
| PTLT_FEATURE_CODE |
Character(10) | VARCHAR2(10) NOT NULL |
Unique code identifying a feature
Prompt Table: PTLT_FEATURE |
| PTLT_REQUIRED | Character(1) | VARCHAR2(1) NOT NULL | Is this required for implementation? |
| index back | (c)David Kurtz 2020, www.go-faster.co.uk | PeopleTools 8.58 PTRef generated on 21-DEC-20 |