RS_WRK_LANG_VW

(SQL View)
 Index Back

Language View


SELECT A.EMPLID , A.ACCOMPLISHMENT , A.DT_ISSUED , A.MAJOR_CODE ,B.DESCR ,A.NATIVE_LANGUAGE ,A.TRANSLATOR ,A.TEACHER ,A.SPEAK_PROFICIENCY ,A.READ_PROFICIENCY ,A.WRITE_PROFICIENCY ,A.EVALUATION_DT ,A.SELECT_CMP FROM PS_ACCOMPLISHMENTS A , PS_ACCOMP_TBL B WHERE A.ACCOMPLISHMENT = B.ACCOMPLISHMENT AND B.ACCOMP_CATEGORY = 'LNG'

  • Related Language Record: RS_WRK_LANG_VWL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PERSONAL_DATA

    2 ACCOMPLISHMENT Character(8) VARCHAR2(8) NOT NULL Accomplishment

    Prompt Table: %RECNAME_EDIT

    3 DT_ISSUED Date(10) DATE Issue Date
    4 MAJOR_CODE Character(10) VARCHAR2(10) NOT NULL Major Code

    Prompt Table: MAJOR_TBL

    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 NATIVE_LANGUAGE Character(1) VARCHAR2(1) NOT NULL Native Language

    Y/N Table Edit

    Default Value: N

    7 TRANSLATOR Character(1) VARCHAR2(1) NOT NULL Able to Translate

    Y/N Table Edit

    Default Value: N

    8 TEACHER Character(1) VARCHAR2(1) NOT NULL Able to Teach

    Y/N Table Edit

    Default Value: N

    9 SPEAK_PROFICIENCY Character(1) VARCHAR2(1) NOT NULL Speaking Proficiency
    1=Low
    2=Moderate
    3=High
    10 READ_PROFICIENCY Character(1) VARCHAR2(1) NOT NULL Reading Proficiency
    1=Low
    2=Moderate
    3=High
    11 WRITE_PROFICIENCY Character(1) VARCHAR2(1) NOT NULL Writing Proficiency
    1=Low
    2=Moderate
    3=High
    12 EVALUATION_DT Date(10) DATE Evaluation Date
    13 SELECT_CMP Character(1) VARCHAR2(1) NOT NULL Include Competency for Search

    Y/N Table Edit

    Default Value: N