RF_SERV_IPRD_VW

(SQL View)
 Index Back

Installed Product Service View

Retrieves active FieldService Service definitions

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

  • Related Language Record: RF_SERV_IPR_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.

    Default Value: OPR_DEF_TBL_RB.SETID

    Prompt Table: SP_SETID_NONVW

    2 SERVICE_ID Character(20) VARCHAR2(20) NOT NULL Service Number

    Default Value: NEXT

    3 DESCR80 Character(80) VARCHAR2(80) NOT NULL This generic field stores the description and used used on various tables.
    4 SHORT_DESCR Character(15) VARCHAR2(15) NOT NULL This field is used to represent the short description for various objects
    5 START_DATE Date(10) DATE NOT NULL Start Date for Gen Standing PO

    Default Value: %date

    6 END_DATE Date(10) DATE End date field to store an end date.