SSR_XLAT_VW

(SQL View)
 Index Back

Student Records Current XLAT

This view is used to get the xlatlongname and xlatshortname values for the current effective date for a specific field and value.

SELECT X.FIELDNAME , X.FIELDVALUE , X.XLATLONGNAME , X.XLATSHORTNAME FROM PSXLATITEM X WHERE X.EFFDT = ( SELECT MAX (X1.EFFDT) FROM PSXLATITEM X1 WHERE X1.FIELDNAME = X.FIELDNAME AND X1.FIELDVALUE = X.FIELDVALUE AND X1.EFFDT <= %CurrentDateIn ) AND X.EFF_STATUS = 'A'

  • Related Language Record: SSR_XLAT_VW_LN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
    2 FIELDVALUE Character(4) VARCHAR2(4) NOT NULL Field Value
    3 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name
    4 XLATSHORTNAME Character(10) VARCHAR2(10) NOT NULL Translate Value Short Name