CTI_CMPNT_LNG(SQL View) |
Index Back |
---|---|
CTI Components Prompt viewDate Initials Issue Description 022301 dms SP2 (F-CJORGENS-9) CTI Integration |
SELECT m1.menuname , m1.barname , m1.pnlgrpname , m.language_cd , m.itemlabel FROM PSMENUITEMlang m , PSMENUITEM m1 WHERE m.menuname = m1.menuname AND m.barname = m1.barname AND m.itemname = m1.itemname AND m1.itemtype = 5 |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | MENUNAME | Character(30) | VARCHAR2(30) NOT NULL | Menu Name (see PSMENUDEFN). |
2 | BARNAME | Character(30) | VARCHAR2(30) NOT NULL | Menu Bar Name |
3 | COMPONENT_ID | Character(18) | VARCHAR2(18) NOT NULL | 04/10/00 (Internet Architecture) SCC: Uppercase label Id. |
4 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |