AVMTVTNCMPVWLNG

(SQL View)
Index Back

Motivation Campaing View

Contains all valid campaign motivations for the GP module

SELECT A.SETID , A.MOTIVATION_CD , A.EFFDT , A.LANGUAGE_CD , A.DESCR FROM PS_AV_MTVTN_LNG A ,PS_AV_MTVTN_TBL B WHERE B.APPEAL_CMPGN = 'Y' AND A.SETID=B.SETID AND A.MOTIVATION_CD=B.MOTIVATION_CD AND A.EFFDT=B.EFFDT

  • Related Language Record for AV_MTVTN_CMP_VW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    2 MOTIVATION_CD Character(9) VARCHAR2(9) NOT NULL Appeal Code
    3 EFFDT Date(10) DATE Effective Date
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description