RA_LSDATASR_LVW

(SQL View)
Index Back

Data Source View

Data Source View - search prompt related language record

SELECT %Substring(A.FIELDVALUE, 1,3) , A.LANGUAGE_CD , A.XLATLONGNAME FROM PSXLATITEMLANG A WHERE A.FIELDNAME='LS_DATA_SOURCE' 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_LSDATASRC_VW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 LS_DATA_SOURCE Character(3) VARCHAR2(3) NOT NULL The data source for the application data.
    A8=TEAS Degree Information
    AAD=AADSAS
    ACT=American College Testing
    AE=Ad-Hoc Employee
    AMC=AMCAS
    AO=Ad-Hoc Organizational
    E=Extract
    ETS=Educational Testing Service
    GH=OLSAS Last Secondary-G2
    LSD=LSDAS
    PI=Prev/Post Secondary Info
    RS=OLSAS Postsecondary Info
    SCH=School
    SLF=Self-Reported Information
    WWW=World Wide Web
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name