SAA_RQD_CLST_VW

(SQL View)
 Index Back

Requirement Line Detail View

This view is used to select the correct detail information to be used to create a where clause to be used by complex requirement lines.

SELECT A.REQUIREMENT , A.EFFDT , B.RQ_LINE_NBR , C.RQ_LINE_DET_SEQ , C.RQ_LINE_DET_TYPE , C.LIST_INCLUDE_MODE , COURSE_LIST FROM PS_RQ_MAIN_TBL A , PS_RQ_LINE_TBL B , PS_RQ_LN_DETL_TBL C WHERE A.EFF_STATUS = 'A' AND A.REQUIREMENT = B.REQUIREMENT AND A.EFFDT = B.EFFDT AND C.REQUIREMENT = B.REQUIREMENT AND C.EFFDT = B.EFFDT AND C.RQ_LINE_KEY_NBR = B.RQ_LINE_KEY_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 Effective Date

Default Value: %date

3 RQ_LINE_NBR Character(4) VARCHAR2(4) NOT NULL Line Nbr
4 RQ_LINE_DET_SEQ Number(3,0) SMALLINT NOT NULL Line Detail Sequence
5 RQ_LINE_DET_TYPE Character(4) VARCHAR2(4) NOT NULL Line Detail Type
CLST=Course List
COND=Condition
DLST=Derived Course List
6 LIST_INCLUDE_MODE Character(1) VARCHAR2(1) NOT NULL List Include Mode
C=Complement of
I=Intersection with
N=Subtract from
Y=Union with
7 COURSE_LIST Character(9) VARCHAR2(9) NOT NULL Course List