SETID_WRKLANGUAGE_CDPRODUCT_GROUPRF_CRITGRP_LVW(SQL View) |
Index Back |
|---|---|
Person criteria - ProdGroup RLRelated language - Used to display the product group name on the Worker and Provider Group criteria pages. |
| SELECT DISTINCT A.SETID , A.LANGUAGE_CD , A.PRODUCT_GROUP FROM PS_PROD_GROUP_LNG A , PS_PROD_GROUP_TBL B WHERE A.SETID = B.SETID AND A.PRODUCT_GROUP = B.PRODUCT_GROUP AND A.PROD_GRP_TYPE = B.PROD_GRP_TYPE AND A.EFFDT = B.EFFDT AND B.EFF_STATUS = 'A' AND B.EFFDT = ( SELECT MAX(C.EFFDT) FROM PS_PROD_GROUP_TBL C WHERE C.SETID = B.SETID AND C.PROD_GRP_TYPE = B.PROD_GRP_TYPE AND C.PRODUCT_GROUP = B.PRODUCT_GROUP AND C.EFFDT <= %CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID_WRK |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 3 | PRODUCT_GROUP |
Character(10) | VARCHAR2(10) NOT NULL | PRoduct Group |