LNDEPTYPEVW1LNG(SQL View) |
Index Back |
---|---|
Direct Loan dep stat viewLNDEPTYPEVW1LNG is the language record view related to LN_DEP_TYPE_VW1. A related language record enables text fields on a table to be translated into various languages for use in other countries. |
SELECT X.FIELDVALUE ,X.LANGUAGE_CD , X.XLATLONGNAME , X.XLATSHORTNAME FROM PSXLATITEMLANG X ,PSXLATITEM Y WHERE X.FIELDNAME =Y.FIELDNAME AND X.FIELDVALUE=Y.FIELDVALUE AND X. EFFDT = Y.EFFDT AND X.FIELDNAME = 'FED_DEPEND_STAT' AND (X.FIELDVALUE = 'D' OR X.FIELDVALUE = 'I') AND X.EFFDT = ( SELECT MAX(EFFDT) FROM PSXLATITEMLANG X1 WHERE X1.FIELDNAME = X.FIELDNAME AND X1.FIELDVALUE = X.FIELDVALUE AND Y.EFF_STATUS <> 'I') |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | FIELDVALUE | Character(4) | VARCHAR2(4) NOT NULL | Field Value |
2 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
4 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |