DEGR_HONORS_LN1(SQL View) |
Index Back |
---|---|
Degree Honors View 1 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.DESCRFORMAL FROM PS_DEGR_HONORS_LNG A |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | INSTITUTION | Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Prompt Table: INSTITUTION_TBL |
2 | HONORS_TYPE_1 | Character(2) | VARCHAR2(2) NOT NULL | Honors Type 1 |
3 | HONORS_CODE | Character(3) | VARCHAR2(3) NOT NULL | Honors Code |
4 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
5 | EFFDT | Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
6 | DESCRFORMAL | Character(50) | VARCHAR2(50) NOT NULL | Formal Description field |