REG_GENDID_LVW (SQL View)	Index Back
Gender Identity 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_GENDID_LVW

(SQL View)

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

Related Language Record for REG_GENDERID_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

#	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