SSR_CRSE_CLASIFEFFDTDefault Value: %date
A=Active
I=Inactive
Default Value: A
C=Course
P=Program
Default Value: SSR_CRSE_CLASIF.DESCR60
SSR_CRSE_CLASIF(SQL Table) |
Index Back |
|---|---|
Course ClassificationCourse classification based on the MOE standards. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SSR_CRSE_CLASIF |
Character(4) | VARCHAR2(4) NOT NULL | BBWW6YW - SDR ver 2.00 changes. It is course classification field. |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 3 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
| 4 | SSR_CRS_CLASIF_TYP | Character(1) | VARCHAR2(1) NOT NULL |
BBWW6YW - SDR ver 2.0. It is course classification type. This is either a course type 'C' or a program type 'P'.
C=Course P=Program |
| 5 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL |
Description of length 254
Default Value: SSR_CRSE_CLASIF.DESCR60 |
| 6 | DESCR60 | Character(60) | VARCHAR2(60) NOT NULL | Description |