SAD_BR_ITMTP_VW

(SQL View)
Index Back

SELECT DISTINCT AI.INSTITUTION , AI.SCC_BRINCD_NLD , AI.SAD_BR_EDU_SEC_NLD , AI.EFFDT , A.SSR_ITEM_TYPE , A.DESCR20 FROM PS_SSR_ITEM_TYPE A , PS_SAD_BR_BO_NLD AI WHERE AI.SAD_BR_EDU_SEC_NLD = 'BO' AND A.SSR_ITEM_TYPE NOT IN ( SELECT AI1.SSR_ITEM_TYPE FROM PS_SAD_BR_AIGT_NLD AI1 WHERE AI1.INSTITUTION = AI.INSTITUTION AND AI1.SCC_BRINCD_NLD = AI.SCC_BRINCD_NLD AND AI1.SAD_BR_EDU_SEC_NLD = AI.SAD_BR_EDU_SEC_NLD AND AI1.EFFDT = AI.EFFDT)

# 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 SCC_BRINCD_NLD Character(4) VARCHAR2(4) NOT NULL BRINcode

Prompt Table: SCC_BRINCD_NLD

3 SAD_BR_EDU_SEC_NLD Character(2) VARCHAR2(2) NOT NULL Educational Sector
BO=Professional Education
ED=Education
VA=VAVO
4 EFFDT Date(10) DATE NOT NULL Effective Date

Default Value: %date

5 SSR_ITEM_TYPE Character(20) VARCHAR2(20) NOT NULL Academic Item Type
6 DESCR20 Character(20) VARCHAR2(20) NOT NULL Description