PSOPTNLVLANG_VW(SQL View) | 
Index Back | 
|---|
| SELECT FIELDVALUE , LANGUAGE_CD , XLATLONGNAME FROM PSXLATITEMLANG WHERE FIELDNAME = 'OPTN_CATEGORY_LVL' | 
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description | 
|---|---|---|---|---|
| 1 | Character(4) | VARCHAR2(4) NOT NULL | 
Option Category  Level
 CRM=Customer Relationship Mgmt CSTM=Custom EPM=Enterprise Performance Mgmt FIN=Financials HRMS=Human Resources Management LS=Learning Solutions PPTL=PeopleTools SCM=Supply Chain Management  | 
|
| 2 | Character(3) | VARCHAR2(3) NOT NULL | Language Code | |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |