SSR_CRSE_CLASIFSSR_CRSCLASF_VW(SQL View) |
Index Back |
|---|---|
course classification Promptcourse classification Prompt view |
| SELECT SSR_CRSE_CLASIF ,DESCR60 FROM %Table(SSR_CRSE_CLASIF) C WHERE %EffdtCheck(SSR_CRSE_CLASIF C1,C,%CURRENTDATEIN) AND C.eff_status='A' |
| # | 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 | DESCR60 | Character(60) | VARCHAR2(60) NOT NULL | Description |