AWRDACTIONVW1LN

(SQL View)
 Index Back

Award Action Translate View

View of the table XLATTABLE used to aid in prompting for valid values for Award Action in the Award Entry panel.

SELECT X.FIELDVALUE , X.LANGUAGE_CD , X.XLATLONGNAME , X.XLATSHORTNAME FROM PSXLATITEMLANG X WHERE X.FIELDNAME = 'AWARD_ACTION' AND X.FIELDVALUE <> 'X' AND X.EFFDT = ( SELECT MAX(EFFDT) FROM PSXLATITEMLANG X1 WHERE X1.FIELDNAME = X.FIELDNAME AND X1.FIELDVALUE = X.FIELDVALUE )

  • Related Language Record for AWRD_ACTION_VW1

    • # 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