SSR_RES_MAP_V1L

(SQL View)
 Index Back

Activity Management Results

This record contains result mapping information for Activity Management (Activity Setup).

SELECT a.SETID , a.SSR_RES_MAP_ID , a.EFFDT , aRL.LANGUAGE_CD , aRL.DESCR50 FROM PS_SSR_RES_MAP_TBL a , PS_SSR_RES_MAP_LNG aRL WHERE a.SETID = aRL.SETID AND a.SSR_RES_MAP_ID = aRL.SSR_RES_MAP_ID AND a.EFFDT = aRL.EFFDT AND (a.SSR_RES_MARK_OPT = 'Y' OR a.SSR_RES_SCORE_OPT = 'Y')

  • Related Language Record for SSR_RES_MAP_VW1

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_CS.SETID_CAREER

    Prompt Table: SETID_TBL

    2 SSR_RES_MAP_ID Character(12) VARCHAR2(12) NOT NULL Result Scale
    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50