RS_SO_EXPLNG_VW

(SQL View)
 Index Back

Express Search Language View

Shadow view for RS_SO_ACMP_LNG. Used by Express Search Component Interface for Service Order Creation and Update.

SELECT BUSINESS_UNIT , SO_ID , SO_LINE , ACCOMPLISHMENT , SPEAK_PROFICIENCY , READ_PROFICIENCY , WRITE_PROFICIENCY , WEIGHT_POINTS , SPEAK_PROF_NUM , READ_PROF_NUM , WRITE_PROF_NUM FROM %Table(RS_SO_ACMP_LNG)

  • 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.