RA_YES_NO_LANG

(SQL View)
 Index Back

Yes/No Prompt View Related

Yes/No Prompt View Related Language

SELECT %Substring(A.FIELDVALUE,1,1) , A.LANGUAGE_CD , A.XLATSHORTNAME FROM PSXLATITEMLANG 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 for RA_YES_NO_VW

    • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 XLATSHORTNAME Character(10) VARCHAR2(10) NOT NULL Translate Value Short Name