RA_LSDATASRC_VW

(SQL View)
Index Back

Data Source View

View is used as search prompt for profile field definition.

SELECT %Substring(A.FIELDVALUE, 1,3) , A.XLATLONGNAME FROM PSXLATITEM A WHERE A.FIELDNAME='LS_DATA_SOURCE' 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_LSDATASR_LVW
  • # 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 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name