SSR_BC_INDX_BND

(SQL View)
 Index Back

Browse Catalo Index Bind Table

Browse Catalog Index Bind Table

SELECT A.CRSE_ID , A.CRSE_OFFER_NBR , A.EFFDT , A.INSTITUTION , A.SUBJECT , A.CATALOG_NBR , A.ACAD_CAREER , 'X' FROM PS_CRSE_OFFER A UNION SELECT B.CRSE_ID , B.CRSE_OFFER_NBR , B.EFFDT , J.INSTITUTION , J.SUBJECT , J.CATALOG_NBR , J.ACAD_CAREER , 'X' FROM PS_SSR_CRS_OFFR_ES B LEFT OUTER JOIN PS_CRSE_OFFER J ON J.CRSE_ID = B.CRSE_ID AND J.CRSE_OFFER_NBR = B.CRSE_OFFER_NBR AND J.EFFDT = B.EFFDT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 CRSE_ID Character(6) VARCHAR2(6) NOT NULL Course ID
2 CRSE_OFFER_NBR Number(2,0) SMALLINT NOT NULL Course Offering Nbr
3 EFFDT Date(10) DATE Effective Date

Default Value: %date

4 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
5 SUBJECT Character(8) VARCHAR2(8) NOT NULL Subject Area

Prompt Table: SUBJECT_TBL

6 CATALOG_NBR Character(10) VARCHAR2(10) NOT NULL Catalog Nbr
7 CRSE_CAREER Character(4) VARCHAR2(4) NOT NULL Course Career
8 SSR_ROW_ACTION Character(1) VARCHAR2(1) NOT NULL Row Action