RA_YES_NO_VW

(SQL View)
 Index Back

Yes/No Prompt View


SELECT %Substring(A.FIELDVALUE,1,1) , A.XLATSHORTNAME FROM PSXLATITEM A WHERE A.FIELDNAME = 'RA_YESNO' AND A.EFFDT = ( SELECT MAX(A_ED.EFFDT) FROM PSXLATITEM A_ED WHERE A.FIELDNAME = A_ED.FIELDNAME AND A.FIELDVALUE = A_ED.FIELDVALUE AND A_ED.EFFDT <= %CurrentDateIn AND A_ED.EFF_STATUS = 'A')

  • Related Language Record: RA_YES_NO_LANG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 RA_YESNO Character(1) VARCHAR2(1) NOT NULL This field denotes if Profile can be updated or not.
    N=No
    Y=Yes
    2 XLATSHORTNAME Character(10) VARCHAR2(10) NOT NULL Translate Value Short Name