RQ_MAIN_VW (SQL View)	Index Back
Program Req View -for REF This view of the Requirement Line table is used to do an F4 on Line Sequence number where the main and child sequence numbers are prefixed with 'REF_'.

RQ_MAIN_VW

(SQL View)

Program Req View -for REF

This view of the Requirement Line table is used to do an F4 on Line Sequence number where the main and child sequence numbers are prefixed with 'REF_'.

Select Requirement, Rq_Connect_Type, Descr from PS_RQ_MAIN_TBL

Related Language Record: RQ_MAIN_VW_LANG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 REF_MAIN_RQ Character(9) VARCHAR2(9) NOT NULL Reference Main 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_MAIN_RQ	Character(9)	VARCHAR2(9) NOT NULL	Reference Main Requirement
2	REF_REQ_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Reference Requirement Type
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description