RA_EXTACDLV_LVW

(SQL View)
 Index Back

Academic Level View

Academic Level View - search prompt related language record

SELECT A.FIELDVALUE , A.LANGUAGE_CD , A.XLATLONGNAME FROM PSXLATITEMLANG A WHERE A.FIELDNAME='EXT_ACAD_LEVEL' AND A.EFFDT = ( SELECT MAX(AA.EFFDT) FROM PSXLATITEMLANG AA WHERE A.FIELDNAME = AA.FIELDNAME AND A.FIELDVALUE=AA.FIELDVALUE AND AA.EFFDT <= %CurrentDateIn)

  • Related Language Record for RA_EXTACDLVL_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EXT_ACAD_LEVEL Character(4) VARCHAR2(4) NOT NULL Academic level
    0=Unknown
    01=Pre-Eighth Grade
    1=Eighth Grade
    2=Ninth Grade
    3=Tenth Grade
    4=Eleventh Grade
    5=Twelfth Grade
    6=Postsecondary First Year
    7=Postsecondary Sophomore
    8=Postsecondary Junior
    9=Postsecondary Senior
    90=Post-Secondary
    91=Postsecondary Professional
    92=Postsecondary Master
    93=Postsecondary Doctoral
    94=Postdoctoral
    A1=Basic User/Breakthrough (NLD)
    A2=Basic User/Waystage (NLD)
    B1=Independ. User/Threshold (NLD)
    B2=Independ. User/Vantage (NLD)
    C1=Prof. User/Effective (NLD)
    C2=Proficient User/Master (NLD)
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name