DFW_OPRDEFN_LNG(SQL View) |
Index Back |
|---|---|
View Record For Base Language |
| SELECT O.LANGUAGE_CD , COUNT(*) FROM PSOPRDEFN O , PSLANGUAGES L WHERE O.LANGUAGE_CD = L.LANGUAGE_CD AND L.INSTALLED=1 GROUP BY O.LANGUAGE_CD ORDER BY COUNT(*) DESC, LANGUAGE_CD |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 2 | DFW_LANG_COUNT | Number(9,0) | DECIMAL(9) NOT NULL |