SCC_LANGUAGES_H

(SQL View)
 Index Back

Person Accomplishments

ACCOMPLISHMENTS contains the degrees, tests, languages, honors/awards, licenses/certifications, and professional memberships of your employees, applicants and contractors.

SELECT ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , %DateNull FROM %Table(INSTALLATION_SA)

  • Parent record: PERSON

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

    Prompt Table: PERSON

    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

    Prompt Table: SCC_LANG_VW

    3 NATIVE_LANGUAGE Character(1) VARCHAR2(1) NOT NULL Native Language

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

    6 SPEAK_PROFICIENCY Character(1) VARCHAR2(1) NOT NULL Speaking Proficiency
    1=Low
    2=Moderate
    3=High
    7 READ_PROFICIENCY Character(1) VARCHAR2(1) NOT NULL Reading Proficiency
    1=Low
    2=Moderate
    3=High
    8 WRITE_PROFICIENCY Character(1) VARCHAR2(1) NOT NULL Writing Proficiency
    1=Low
    2=Moderate
    3=High
    9 EVALUATION_DT Date(10) DATE Evaluation Date