DEGR_HONORS_LN3(SQL View) |
Index Back |
---|---|
Degree Honors View 3 Rel LangThis is a related language view used in the Degree panels to prompt for honors. It is basically used to get the codes valid for Prefix-type honors. |
SELECT A.INSTITUTION , A.HONORS_TYPE , A.HONORS_CODE , A.LANGUAGE_CD , A.EFFDT , A.DESCRSHORT FROM PS_DEGR_HONORS_LNG A |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Prompt Table: INSTITUTION_TBL |
|
2 | Character(2) | VARCHAR2(2) NOT NULL | Honors Type 1 | |
3 | Character(3) | VARCHAR2(3) NOT NULL | Honors Code | |
4 | Character(3) | VARCHAR2(3) NOT NULL | Language Code | |
5 | Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
|
6 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |