SSR_AIR_SRCH_LN

(SQL View)

SELECT a1.INSTITUTION , a1.SSR_ITEM_TYPE , a1.SSR_ITEM_ID , a1RL.LANGUAGE_CD , a1.EFFDT , a1RL.DESCR50 , b1RL.DESCR FROM PS_SSR_AIR_HDR a1 , PS_SSR_AIR_HDR_LN a1RL , PS_SSR_ITEM_TYPE b1 , PS_SSR_ITEMTYPE_LN b1RL WHERE a1.INSTITUTION = a1RL.INSTITUTION AND a1.SSR_ITEM_ID = a1RL.SSR_ITEM_ID AND a1.EFFDT = a1RL.EFFDT AND a1.SSR_ITEM_TYPE = b1.SSR_ITEM_TYPE AND b1.SSR_ITEM_TYPE = b1RL.SSR_ITEM_TYPE AND a1RL.LANGUAGE_CD = b1RL.LANGUAGE_CD UNION SELECT a2.INSTITUTION , a2.SSR_ITEM_TYPE , a2.SSR_ITEM_ID , a2RL.LANGUAGE_CD , a2.EFFDT , a2RL.DESCR50 , b2.DESCR FROM PS_SSR_AIR_HDR a2 , PS_SSR_AIR_HDR_LN a2RL , PS_SSR_ITEM_TYPE b2 WHERE a2.INSTITUTION = a2RL.INSTITUTION AND a2.SSR_ITEM_ID = a2RL.SSR_ITEM_ID AND a2.EFFDT = a2RL.EFFDT AND a2.SSR_ITEM_TYPE = b2.SSR_ITEM_TYPE AND NOT EXISTS ( SELECT 'X' FROM PS_SSR_ITEMTYPE_LN b2RL WHERE b2RL.SSR_ITEM_TYPE = b2.SSR_ITEM_TYPE AND b2RL.LANGUAGE_CD = a2RL.LANGUAGE_CD) UNION SELECT a3.INSTITUTION , a3.SSR_ITEM_TYPE , a3.SSR_ITEM_ID , b3RL.LANGUAGE_CD , a3.EFFDT , a3.DESCR50 , b3RL.DESCR FROM PS_SSR_AIR_HDR a3 , PS_SSR_ITEM_TYPE b3 , PS_SSR_ITEMTYPE_LN b3RL WHERE a3.SSR_ITEM_TYPE = b3.SSR_ITEM_TYPE AND b3.SSR_ITEM_TYPE = b3RL.SSR_ITEM_TYPE AND NOT EXISTS ( SELECT 'X' FROM PS_SSR_AIR_HDR_LN a3RL WHERE a3RL.INSTITUTION = a3.INSTITUTION AND a3RL.SSR_ITEM_ID = a3.SSR_ITEM_ID AND a3RL.EFFDT = a3.EFFDT )

Related Language Record for SSR_AIR_SRCH

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
Prompt Table: INSTITUTION_TBL

2 SSR_ITEM_TYPE Character(20) VARCHAR2(20) NOT NULL Academic Item Type
Prompt Table: SSR_ITEM_TYPE

3 SSR_ITEM_ID Character(11) VARCHAR2(11) NOT NULL Academic Item ID
Prompt Table: SSR_AIR_HDR

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

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

6 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50

7 SSR_DESCR Character(30) VARCHAR2(30) NOT NULL This field is used to hold a description in student records. This field is mixed case.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	INSTITUTION	Character(5)	VARCHAR2(5) NOT NULL	Academic Institution Prompt Table: INSTITUTION_TBL
2	SSR_ITEM_TYPE	Character(20)	VARCHAR2(20) NOT NULL	Academic Item Type Prompt Table: SSR_ITEM_TYPE
3	SSR_ITEM_ID	Character(11)	VARCHAR2(11) NOT NULL	Academic Item ID Prompt Table: SSR_AIR_HDR
4	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
5	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
6	DESCR50	Character(50)	VARCHAR2(50) NOT NULL	Description of length 50
7	SSR_DESCR	Character(30)	VARCHAR2(30) NOT NULL	This field is used to hold a description in student records. This field is mixed case.