RF_AG_SVC_LVW

(SQL View)
 Index Back

Agreement Service Rel Lang Vw

Agreement Services Related Language View

SELECT DISTINCT A.SETID , A.SERVICE_ID , B.LANGUAGE_CD , B.DESCR80 FROM PS_RF_SERVICE A , PS_RF_SERVICE_LANG B WHERE (A.AGREEMENT_FLAG = 'Y' AND A.ACTIVE_STATUS = 'A' AND END_DATE >= %CurrentDateIn AND B.SETID = A.SETID AND B.SERVICE_ID = A.SERVICE_ID) OR (A.AGREEMENT_FLAG = 'Y' AND END_DATE IS NULL AND ACTIVE_STATUS = 'A' AND B.SETID = A.SETID AND B.SERVICE_ID = A.SERVICE_ID)

  • Related Language Record for RF_AG_SVC_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.
    2 SERVICE_ID Character(20) VARCHAR2(20) NOT NULL Service ID
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR80 Character(80) VARCHAR2(80) NOT NULL This generic field stores the description and used used on various tables.