REG_STANDARD_VW

(SQL View)
 Index Back

Standard Regulatory Regions

Standard regions used for regulatory edits. Used for prompt-edits for most reg_region fields throughout. Only displays the regions that the operator has access to.

SELECT S.CLASSID ,R.REG_REGION ,R.DESCR50 ,R.COUNTRY FROM PS_REG_REGION_TBL R ,PS_REG_TRX_REGION T ,PSCLASSDEFN S WHERE T.REG_TRX = 'STANDARD' AND T.REG_REGION = R.REG_REGION AND ( R.REG_AVAIL = 'ALL' OR ( R.REG_AVAIL = 'GBL' AND S.CLASSID = ( SELECT G.OPRCLASS FROM PS_SCRTY_TBL_GBL G WHERE G.OPRCLASS = S.CLASSID AND G.COUNTRY = R.COUNTRY ) ) )

  • Related Language Record: REG_STNDRVW_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRCLASS Character(30) VARCHAR2(30) NOT NULL Operator Class
    2 REG_REGION Character(5) VARCHAR2(5) NOT NULL Regulatory Region
    3 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50
    4 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country