USED_BYA=All Countries
C=Specific Country
COUNTRYPrompt Table: COUNTRY_TBL
PIN_CATEGORYPrompt Table: GP_PIN_CATEGORY
LANGUAGE_CDGPFR_CAT_SRCLNG(SQL View) |
Index Back |
|---|---|
Variable by Cat search rel/lanSearch record used to provide access to the variable by category panel - related language view A related language record enables text fields on a table to be translated into various languages for use in other countries. |
| SELECT A.USED_BY , A.COUNTRY , A.PIN_CATEGORY , B.LANGUAGE_CD , B.DESCR FROM PS_GP_PIN A , PS_GP_PIN_CAT_LANG B WHERE A.USED_BY = B.USED_BY AND A.COUNTRY = B.COUNTRY AND A.PIN_CATEGORY = B.PIN_CATEGORY AND A.PIN_TYPE = 'VR' AND A.PIN_CATEGORY <> ' ' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | USED_BY |
Character(1) | VARCHAR2(1) NOT NULL |
USED_BY
A=All Countries C=Specific Country |
| 2 | COUNTRY |
Character(3) | VARCHAR2(3) NOT NULL |
Country
Prompt Table: COUNTRY_TBL |
| 3 | PIN_CATEGORY |
Character(4) | VARCHAR2(4) NOT NULL |
Element Category
Prompt Table: GP_PIN_CATEGORY |
| 4 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |