RSF_REGION_VW

(SQL View)
 Index Back

Sales Region


SELECT REGION_ID , STATUS , DESCR , PARENT_REGION_ID FROM PS_RB_REGION WHERE REGION_CATEGORY = 'TERR' AND STATUS = 'A'

  • Related Language Record: RSF_REGION_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 REGION_ID Character(15) VARCHAR2(15) NOT NULL This field stores the region id value.
    2 STATUS Character(1) VARCHAR2(1) NOT NULL Status Indicator
    A=Active
    I=Inactive
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 PARENT_REGION_ID Character(15) VARCHAR2(15) NOT NULL Unique identifier for Parent Region.

    Prompt Table: RSF_REGION_VW