RBN_LANGCODELNG(SQL View) |
Index Back |
---|---|
NLP language code related viewlanguage code related view for Natural Language Process |
SELECT %Substring(A.FIELDVALUE, 1, 3) , B.LANGUAGE_CD , B.XLATLONGNAME FROM PSXLATITEM A ,PSXLATITEMLANG B WHERE A.FIELDNAME = 'LANGUAGE_CD' AND A.EFF_STATUS = 'A' AND A.FIELDNAME = B.FIELDNAME AND A.FIELDVALUE = B.FIELDVALUE AND A.EFFDT = B.EFFDT |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | NLP_LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Used as language code |
2 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
3 | XLATLONGNAME | Character(30) | VARCHAR2(30) NOT NULL | Translate Long Name |