CRSE_IDEFFDTDefault Value: %date
CRSE_OFFER_NBRCRSE_OFF_DYNVW(SQL View) |
Index Back |
|---|
| SELECT CRSE_ID , EFFDT , CRSE_OFFER_NBR , DYN_CLASS_DATA , OEE_DYN_DATE_RULE FROM PS_CRSE_OFFER |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CRSE_ID |
Character(6) | VARCHAR2(6) NOT NULL | Course ID |
| 2 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 3 | CRSE_OFFER_NBR |
Number(2,0) | SMALLINT NOT NULL | Course Offering Nbr |
| 4 | DYN_CLASS_DATA | Character(10) | VARCHAR2(10) NOT NULL | Dynamic Class Data Rule |
| 5 | OEE_DYN_DATE_RULE | Character(10) | VARCHAR2(10) NOT NULL | OEE Dynamic Date Rule |