REG_STNDRVW_LNG

(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.LANGUAGE_CD , R.DESCR50 FROM PS_REG_REGION_LANG R , PSCLASSDEFN S

  • Related Language Record for REG_STANDARD_VW
  • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50