PTLT_PROJ_NAMEPTLT_PRODUCT_CODELANGUAGE_CDPTLT_PRODFL_LVW(SQL View) |
Index Back |
|---|---|
Project Product View |
| SELECT DISTINCT A.PTLT_PROJ_NAME , E.PTLT_PRODUCT_CODE , E.LANGUAGE_CD , E.PTLT_PRODUCT FROM %Table(PTLT_PROJ_DEFN) A , %Table(PTLT_PROJ_TASK) B , %Table(PTLT_ASSGN_TASK) C , %Table(PTLT_ASSGN_FEAT) D , %Table(PTLT_PROD_LANG) E WHERE A.PTLT_PROJ_NAME = B.PTLT_PROJ_NAME AND B.PTLT_TASK_CODE = C.PTLT_TASK_CODE AND C.PTLT_FEATURE_CODE = D.PTLT_FEATURE_CODE AND D.PTLT_PRODUCT_CODE = E.PTLT_PRODUCT_CODE |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PTLT_PROJ_NAME |
Character(15) | VARCHAR2(15) NOT NULL | Used in Setup Manager v2.0 for Implementation Project Name. |
| 2 | PTLT_PRODUCT_CODE |
Character(4) | VARCHAR2(4) NOT NULL | Unique code for a product. |
| 3 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 4 | PTLT_PRODUCT | Character(30) | VARCHAR2(30) NOT NULL | Name of a product |