SAA_RQLNDTL_VW (SQL View)	Index Back
Requirement Line Detail Table Use this table to record pointers to Course Lists, or specifications of Dynamic Course Lists or Conditions belonging to a Requirement Line in the Requirement Datastore.

SAA_RQLNDTL_VW

(SQL View)

Requirement Line Detail Table

Use this table to record pointers to Course Lists, or specifications of Dynamic Course Lists or Conditions belonging to a Requirement Line in the Requirement Datastore.

SELECT a.REQUIREMENT , a.EFFDT , b.RQ_LINE_KEY_NBR , a.EFF_STATUS , b.RQ_LINE_NBR FROM PS_RQ_MAIN_TBL a , PS_RQ_LINE_TBL b WHERE a.REQUIREMENT = b.REQUIREMENT AND a.EFFDT = b.EFFDT

Parent record: RQ_LINE_TBL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

3 RQ_LINE_KEY_NBR Character(4) VARCHAR2(4) NOT NULL Background Key

4 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive

5 RQ_LINE_NBR Character(4) VARCHAR2(4) NOT NULL Line Nbr

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	REQUIREMENT	Character(9)	VARCHAR2(9) NOT NULL	Academic Requirement
2	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
3	RQ_LINE_KEY_NBR	Character(4)	VARCHAR2(4) NOT NULL	Background Key
4	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive
5	RQ_LINE_NBR	Character(4)	VARCHAR2(4) NOT NULL	Line Nbr