REG_HANDS_VW (SQL View)	Index Back
Health and Safety Reg Regions Health and Safety regulatory Regions. Used for prompt-edits for the reg_region fields in Health and Safety type transactions. Only displays the regions that the operator has access to.

REG_HANDS_VW

(SQL View)

Health and Safety Reg Regions

Health and Safety regulatory Regions. Used for prompt-edits for the reg_region fields in Health and Safety type transactions. 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 = 'HANDS' 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_HANDSVW_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

#	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