RF_AG_SVC_VW

(SQL View)
 Index Back

Agreement Service Vw

Lists all available active services for an agreement

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

  • Related Language Record: RF_AG_SVC_LVW

    • # 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 DESCR80 Character(80) VARCHAR2(80) NOT NULL This generic field stores the description and used used on various tables.
    4 PRVNT_MNTC_FLAG Character(1) VARCHAR2(1) NOT NULL This field is used to show whether Preventive Maintenance is required or not.
    N=No
    Y=Yes