RA_EXTACDLVL_VW

(SQL View)
 Index Back

Academic Level View

View is used as search prompt for profile field definition.

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

  • Related Language Record: RA_EXTACDLV_LVW

    • # 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 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name