AWRD_ACTION_VW1

(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.XLATLONGNAME , X.XLATSHORTNAME FROM PSXLATITEM X WHERE X.FIELDNAME = 'AWARD_ACTION' AND X.FIELDVALUE <> 'X' AND X.EFFDT = ( SELECT MAX(EFFDT) FROM PSXLATITEM X1 WHERE X1.FIELDNAME = X.FIELDNAME AND X1.FIELDVALUE = X.FIELDVALUE AND X1.EFF_STATUS <> 'I')

  • Related Language Record: AWRDACTIONVW1LN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 FIELDVALUE Character(4) VARCHAR2(4) NOT NULL Field Value
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    3 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description