RS_SO_ACMP_LNG

(SQL Table)
Index Back

SO accomplishment - Language

Desired or required accomplishment requirements (languages) for a resource request.

  • Audit Record: RS_SO_AUDIT
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 SO_ID Character(15) VARCHAR2(15) NOT NULL Service Order ID
    3 SO_LINE Number(3,0) SMALLINT NOT NULL Line Number
    4 ACCOMPLISHMENT Character(8) VARCHAR2(8) NOT NULL Accomplishment

    Prompt Table: RS_ACMP_LNG_VW

    5 SPEAK_PROFICIENCY Character(1) VARCHAR2(1) NOT NULL Speaking Proficiency
    1=Low
    2=Moderate
    3=High
    6 READ_PROFICIENCY Character(1) VARCHAR2(1) NOT NULL Reading Proficiency
    1=Low
    2=Moderate
    3=High
    7 WRITE_PROFICIENCY Character(1) VARCHAR2(1) NOT NULL Writing Proficiency
    1=Low
    2=Moderate
    3=High
    8 WEIGHT_POINTS Number(7,2) DECIMAL(6,2) NOT NULL Factor Weight Points
    9 SPEAK_PROF_NUM Number(1,0) SMALLINT NOT NULL The numeric version of the SPEAK_PROFICIENCY field.
    10 READ_PROF_NUM Number(1,0) SMALLINT NOT NULL Numeric version of the READ_PROFICIENCY field.
    11 WRITE_PROF_NUM Number(1,0) SMALLINT NOT NULL Numeric version of the WRITE_PROFICIENCY field.
    12 SRCH_RESUME Character(1) VARCHAR2(1) NOT NULL Search in resume.
    N=Inactive
    Y=Active