RS_FACTOR_VW

(SQL View)
Index Back

SELECT A.FACTOR_ID , A.DESCR , A.FACTOR_FAMILY_ID , A.WEIGHT_POINTS , A.FACTOR_DESCR_MGR , A.FACTOR_DESCR_WO , A.RECALC_ON_RR_MOD FROM %Table(RS_FACTOR) A WHERE NOT EXISTS ( SELECT 'X' FROM %Table(RS_ATTRIBUTES) AA WHERE (AA.FACTOR_ID_FWA = A.FACTOR_ID AND AA.FACTOR_FWA_FLG = 'N') OR (AA.FACTOR_ID_FWP = A.FACTOR_ID AND AA.FACTOR_FWP_FLG = 'N'))

  • Related Language Record: RS_FACTOR_VWL
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 FACTOR_ID Character(3) VARCHAR2(3) NOT NULL Factor ID
    ACC=Accomplishments
    AVA=Availability
    PRO=Competency Proficiency
    YRS=Competency Years Of Experience
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    3 FACTOR_FAMILY_ID Character(3) VARCHAR2(3) NOT NULL Factor Family ID
    4 WEIGHT_POINTS Number(7,2) DECIMAL(6,2) NOT NULL Factor Weight Points
    5 FACTOR_DESCR_MGR Character(254) VARCHAR2(254) NOT NULL Manager factor description
    6 FACTOR_DESCR_WO Character(254) VARCHAR2(254) NOT NULL Resource factor description
    7 RECALC_ON_RR_MOD Character(1) VARCHAR2(1) NOT NULL Recalculated on RR Mod