EMPLIDLANGUAGE_CDAV_ACAD_SUMM_LN(SQL View) |
Index Back |
|---|---|
Academic Degree Summary LangRelated language view for A_ACAD_SUMM_VW |
| SELECT A.EMPLID , A.LANGUAGE_CD , A.INSTITUTION_NAME , A.AV_DEGREE_DESCR , A.AV_MAJOR1_NAME , A.AV_MAJOR2_NAME , A.AV_MINOR1_NAME , A.AV_MINOR2_NAME FROM PS_AV_INT_DEG_LANG A UNION SELECT B.EMPLID , B.LANGUAGE_CD , B.INSTITUTION_NAME , B.AV_DEGREE_DESCR , B.AV_MAJOR1_NAME , B.AV_MAJOR2_NAME , B.AV_MINOR1_NAME , B.AV_MINOR2_NAME FROM PS_AV_LEG_DEG_LANG B UNION SELECT C.EMPLID , C.LANGUAGE_CD , C.INSTITUTION_NAME , C.AV_DEGREE_DESCR , C.AV_MAJOR1_NAME , C.AV_MAJOR2_NAME , C.AV_MINOR1_NAME , C.AV_MINOR2_NAME FROM PS_AV_EXT_DEG_LANG C |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 3 | INSTITUTION_NAME | Character(40) | VARCHAR2(40) NOT NULL | Institution Name |
| 4 | AV_DEGREE_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description of a degree that was conferred to a person. |
| 5 | AV_MAJOR1_NAME | Character(50) | VARCHAR2(50) NOT NULL | Major1 description of a person |
| 6 | AV_MAJOR2_NAME | Character(50) | VARCHAR2(50) NOT NULL | Major2 description |
| 7 | AV_MINOR1_NAME | Character(50) | VARCHAR2(50) NOT NULL | Minor1 description |
| 8 | AV_MINOR2_NAME | Character(50) | VARCHAR2(50) NOT NULL | Minor2 description |