RF_SVC_SRCH_VW

(SQL View)
 Index Back

Service Search View

Search View Used for the Service Component

SELECT SETID ,SERVICE_ID ,DESCR80 ,SHORT_DESCR ,SERVICE_TYPE_CD ,ACTIVE_STATUS ,PRVNT_MNTC_FLAG ,WARRANTY_FLAG ,AGREEMENT_FLAG ,BILLABLE_FLAG , OFF_HOURS_FLAG ,ALL_PRODUCT_FLAG ,ALL_REGION_FLAG ,START_DATE ,END_DATE FROM PS_RF_SERVICE WHERE 1 = 1

  • Related Language Record: RF_SERVICE_LANG

    • # 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 SERVICE_TYPE_CD Character(8) VARCHAR2(8) NOT NULL User-definable code to classify the type of service.

    Prompt Table: RF_SERVICE_TYPE

    6 ACTIVE_STATUS Character(1) VARCHAR2(1) NOT NULL Allows for Active and Inactive status.
    A=Active
    I=Inactive

    Default Value: A

    7 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

    Default Value: N

    8 WARRANTY_FLAG Character(1) VARCHAR2(1) NOT NULL Indicates that the agreement is classified as a warranty.
    N=No
    Y=Yes

    Default Value: N

    9 AGREEMENT_FLAG Character(1) VARCHAR2(1) NOT NULL Indicates whether or not the service can be used on an agreement.
    N=No
    Y=Yes

    Default Value: Y

    10 BILLABLE_FLAG Character(1) VARCHAR2(1) NOT NULL This is used to determine of the item under consideration is billable or not.
    N=No
    Y=Yes

    Default Value: N

    11 OFF_HOURS_FLAG Character(1) VARCHAR2(1) NOT NULL Off Hours
    N=No
    Y=Yes

    Default Value: N

    12 ALL_PRODUCT_FLAG Character(1) VARCHAR2(1) NOT NULL Flag to determine if a service is applicable to all products in the Service component.
    N=Applicable Products
    Y=Applicable to All Products

    Default Value: N

    13 ALL_REGION_FLAG Character(1) VARCHAR2(1) NOT NULL Flag to determine if a service is applicable to all regions in the Service component.
    N=Applicable Regions
    Y=Applicable to All Regions

    Default Value: N

    14 START_DATE Date(10) DATE NOT NULL Start Date for Gen Standing PO

    Default Value: %date

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