SSR_CRSE_CLASIFEFFDTDefault Value: %date
A=Active
I=Inactive
LANGUAGE_CDDefault Value: SSR_CRSE_CLASIF.DESCR60
SSR_CRSCLASF_LN(SQL Table) |
Index Back |
|---|---|
Course Classification Rel LangRelated Language Record for Course classification Table. |
| # | 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 |
| 4 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 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 |