PTPN_CATEGORY_NAMELANGUAGE_CDPrompt Table: PTPN_FUNCAT_DVW
EONC_CAT_REG_LW(SQL View) |
Index Back |
|---|---|
Rel Lang for EONC_CAT_REG_VWRelated language record for EOPN_CAT_REG_VW. |
| SELECT A.PTPN_CATEGORY_NAME , L.LANGUAGE_CD , COALESCE(( SELECT AL.DESCR100 FROM PS_PTPN_CAT_REGLNG AL WHERE AL.PTPN_CATEGORY_NAME = A.PTPN_CATEGORY_NAME AND AL.LANGUAGE_CD = L.LANGUAGE_CD) , (A.DESCR100), ' ') , COALESCE(( SELECT BL.XLATLONGNAME FROM PSXLATITEMLANG BL WHERE BL.FIELDNAME = 'OBJECTOWNERID' AND BL.FIELDVALUE = A.OBJECTOWNERID AND BL.LANGUAGE_CD = L.LANGUAGE_CD AND %EffdtCheck(PSXLATITEMLANG BL1, BL, %CurrentDateIn)), ( SELECT B.XLATLONGNAME FROM PSXLATITEM B WHERE B.FIELDNAME = 'OBJECTOWNERID' AND B.FIELDVALUE = A.OBJECTOWNERID AND %EffdtCheck(PSXLATITEM B1, B, %CurrentDateIn)), ' ') , COALESCE(( SELECT AL.PTPN_FUNC_CATEGORY FROM PS_PTPN_CAT_REGLNG AL WHERE AL.PTPN_CATEGORY_NAME = A.PTPN_CATEGORY_NAME AND AL.LANGUAGE_CD = L.LANGUAGE_CD) , (A.PTPN_FUNC_CATEGORY), ' ') FROM PS_PTPN_CAT_REG A, PSLANGUAGES L WHERE L.INSTALLED = 1 AND L.LANGUAGE_CD <> ( SELECT O.LANGUAGE_CD FROM PSOPTIONS O) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PTPN_CATEGORY_NAME |
Character(50) | VARCHAR2(50) NOT NULL | Notification Name |
| 2 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 3 | EONC_PTNOTIF_DESCR | Character(100) | VARCHAR2(100) NOT NULL | PTPN Notification description |
| 4 | EONC_OBJOWNR_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Object Owner description |
| 5 | PTPN_FUNC_CATEGORY | Character(30) | VARCHAR2(30) NOT NULL |
Functional Category
Prompt Table: PTPN_FUNCAT_DVW |