RF_SERVICE_P_VW

(SQL View)
 Index Back

Service Prompt View

Prompt View for searching services

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

  • 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.