INSTITUTIONSSR_ITEM_IDEFFDTDefault Value: %date
SSR_MP_CRSE_VW(SQL View) |
Index Back |
|---|---|
My Planner - CRSE View |
| SELECT H.INSTITUTION , H.SSR_ITEM_ID , H.EFFDT , H.CRSE_ID , H.CRSE_OFFER_NBR , C.UNITS_MINIMUM , C.UNITS_MAXIMUM FROM PS_SSR_AIR_H_CRSE H , PS_CRSE_CATALOG C WHERE H.CRSE_ID = C.CRSE_ID AND H.EFFDT = C.EFFDT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL | Academic Institution |
| 2 | SSR_ITEM_ID |
Character(11) | VARCHAR2(11) NOT NULL | Academic Item ID |
| 3 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 4 | CRSE_ID | Character(6) | VARCHAR2(6) NOT NULL | Course ID |
| 5 | CRSE_OFFER_NBR | Number(2,0) | SMALLINT NOT NULL | Course Offering Nbr |
| 6 | UNITS_MINIMUM | Number(6,2) | DECIMAL(5,2) NOT NULL | Minimum Units |
| 7 | UNITS_MAXIMUM | Number(6,2) | DECIMAL(5,2) NOT NULL | Maximum Units |