RQGRPENRSRCHLNG (SQL View)	Index Back
Req Group Enrl Srch Rel Lng Vw Use this view to search Requirement Groups for Enrollment.

RQGRPENRSRCHLNG

(SQL View)

Req Group Enrl Srch Rel Lng Vw

Use this view to search Requirement Groups for Enrollment.

SELECT B.RQRMNT_GROUP ,B.LANGUAGE_CD ,B.EFFDT ,B.DESCR FROM PS_RQ_GRP_TBL A , PS_RQ_GRP_LANG B WHERE A.RQRMNT_USEAGE = 'ENR' AND A.RQRMNT_GROUP = B.RQRMNT_GROUP AND A.EFFDT = B.EFFDT

Related Language Record for RQ_GRP_ENR_SRCH

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 RQRMNT_GROUP Character(6) VARCHAR2(6) NOT NULL Requirement Group

2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

3 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

4 DESCR Character(30) VARCHAR2(30) NOT NULL Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	RQRMNT_GROUP	Character(6)	VARCHAR2(6) NOT NULL	Requirement Group
2	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
3	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
4	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description