MRQ_TYPE_VW (SQL View)	Index Back
Program Req View -for REF This view of the Requirement table is used to prompt on Requirement and relate-display Requirement Type where Requirement is renamed.

MRQ_TYPE_VW

(SQL View)

Program Req View -for REF

This view of the Requirement table is used to prompt on Requirement and relate-display Requirement Type where Requirement is renamed.

SELECT Requirement , RQ_Connect_Type , Descr FROM PS_RQ_MAIN_TBL

Related Language Record: MRQTYPE_VW_LANG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 REF_REQUIREMENT Character(9) VARCHAR2(9) NOT NULL Academic Requirement

2 REF_REQ_TYPE Character(3) VARCHAR2(3) NOT NULL Reference Requirement Type

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	REF_REQUIREMENT	Character(9)	VARCHAR2(9) NOT NULL	Academic Requirement
2	REF_REQ_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Reference Requirement Type
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description