AV_ACAD_SUMM_VW(SQL View) |
Index Back |
---|---|
Academic Degree SummaryThis view summarizes the academic degrees that a person has earned. It contains one row for any 'type' (Internal, Internal Legacy and External) of degree earned. |
SELECT A.EMPLID , A.AV_DEGREE_TYPE , A.AV_INST_ORG_ID , A.AV_YEAR , A.ACCOMPLISHMENT , A.AV_MAJOR1_CD , A.AV_MAJOR2_CD , A.AV_MINOR1_CD , A.AV_MINOR2_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_VW A UNION SELECT B.EMPLID , B.AV_DEGREE_TYPE , B.AV_INST_ORG_ID , B.AV_YEAR , B.ACCOMPLISHMENT , B.AV_MAJOR1_CD , B.AV_MAJOR2_CD , B.AV_MINOR1_CD , B.AV_MINOR2_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_VW B UNION SELECT C.EMPLID , C.AV_DEGREE_TYPE , C.AV_INST_ORG_ID , C.AV_YEAR , C.ACCOMPLISHMENT , C.AV_MAJOR1_CD , C.AV_MAJOR2_CD , C.AV_MINOR1_CD , C.AV_MINOR2_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_VW C |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
2 | AV_DEGREE_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
The degree type. Internal, External or legacy.
E=External Degree I=Internal Degree L=Legacy Degree |
3 | AV_INST_ORG_ID | Character(11) | VARCHAR2(11) NOT NULL | Institution or EXT_ORG_ID container |
4 | AV_YEAR | Character(6) | VARCHAR2(6) NOT NULL | Year |
5 | ACCOMPLISHMENT | Character(8) | VARCHAR2(8) NOT NULL | Accomplishment |
6 | AV_MAJOR1_CD | Character(10) | VARCHAR2(10) NOT NULL | Major |
7 | AV_MAJOR2_CD | Character(10) | VARCHAR2(10) NOT NULL | Major 2 |
8 | AV_MINOR1_CD | Character(10) | VARCHAR2(10) NOT NULL | Minor |
9 | AV_MINOR2_CD | Character(10) | VARCHAR2(10) NOT NULL | Minor 2 |
10 | INSTITUTION_NAME | Character(40) | VARCHAR2(40) NOT NULL | Institution Name |
11 | AV_DEGREE_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description of a degree that was conferred to a person. |
12 | AV_MAJOR1_NAME | Character(50) | VARCHAR2(50) NOT NULL | Major1 description of a person |
13 | AV_MAJOR2_NAME | Character(50) | VARCHAR2(50) NOT NULL | Major2 description |
14 | AV_MINOR1_NAME | Character(50) | VARCHAR2(50) NOT NULL | Minor1 description |
15 | AV_MINOR2_NAME | Character(50) | VARCHAR2(50) NOT NULL | Minor2 description |