RS_SO_ACMP_DEG

(SQL Table)
Index Back

SO accomplishment - Degrees

Desired or required accomplishment requirements (degrees) 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_DEG_VW

    5 MAJOR_CODE Character(10) VARCHAR2(10) NOT NULL Major Code

    Prompt Table: MAJOR_TBL

    6 WEIGHT_POINTS Number(7,2) DECIMAL(6,2) NOT NULL Factor Weight Points
    7 SRCH_RESUME Character(1) VARCHAR2(1) NOT NULL Search in resume.
    N=Inactive
    Y=Active