AV_REL_ACAD_VW(SQL View) |
Index Back |
|---|---|
Relationship Academic InfoRelationship Academic Information |
| SELECT REL.EMPLID , REL.EMPLID_RELATED , REL.PEOPLE_RELATION , ACAD.AV_DEGREE_TYPE , ACAD.AV_INST_ORG_ID , ACAD.INSTITUTION_NAME , ACAD.DEGREE_DT , ACAD.AV_YEAR , ACAD.DEGREE , ACAD.AV_DEGREE_DESCR , ACAD.ACAD_CAREER , ACAD.ACAD_CAREER_DESCR , ACAD.AV_MAJOR1_CD , ACAD.AV_MAJOR1_NAME , ACAD.AV_MAJOR2_CD , ACAD.AV_MAJOR2_NAME , ACAD.AV_MINOR1_CD , ACAD.AV_MINOR1_NAME , ACAD.AV_MINOR2_CD , ACAD.AV_MINOR2_NAME FROM PS_RELATIONSHIPS REL , PS_AV_ACAD_PROF_VW ACAD WHERE ACAD.EMPLID = REL.EMPLID_RELATED AND REL.EFFDT= ( SELECT MAX (REL1.EFFDT) FROM PS_RELATIONSHIPS REL1 WHERE REL1.EMPLID = REL.EMPLID AND REL1.RELATIONSHIP_NBR = REL.RELATIONSHIP_NBR) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | EMPLID_RELATED | Character(11) | VARCHAR2(11) NOT NULL | Related People ID |
| 3 | PEOPLE_RELATION | Character(2) | VARCHAR2(2) NOT NULL | Relationship |
| 4 | 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 |
| 5 | AV_INST_ORG_ID | Character(11) | VARCHAR2(11) NOT NULL | Institution or EXT_ORG_ID container |
| 6 | INSTITUTION_NAME | Character(40) | VARCHAR2(40) NOT NULL | Institution Name |
| 7 | DEGREE_DT | Date(10) | DATE | Admissions degree date. |
| 8 | AV_YEAR | Character(6) | VARCHAR2(6) NOT NULL | Year |
| 9 | DEGREE | Character(8) | VARCHAR2(8) NOT NULL | Degree |
| 10 | AV_DEGREE_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description of a degree that was conferred to a person. |
| 11 | ACAD_CAREER | Character(4) | VARCHAR2(4) NOT NULL |
Academic Career
BAC=Bachelor (NLD) BBL=Vocational Coaching (NLD) BOL=Vocational Training (NLD) BUSN=Graduate Business CNED=Continuing Education CRED=Semester Credit EDU=Education (NLD) EXED=Extended Education GRAD=Graduate LAW=Law MEDS=Medical School NONA=Non Award PGRD=Postgraduate RSCH=Research TECH=Technical UENG=Undergraduate Engineering UGRD=Undergraduate VAVO=Advanced General Educ. (NLD) VETM=Veterinary Medicine |
| 12 | ACAD_CAREER_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Academic Career |
| 13 | AV_MAJOR1_CD | Character(10) | VARCHAR2(10) NOT NULL | Major |
| 14 | AV_MAJOR1_NAME | Character(50) | VARCHAR2(50) NOT NULL | Major1 description of a person |
| 15 | AV_MAJOR2_CD | Character(10) | VARCHAR2(10) NOT NULL | Major 2 |
| 16 | AV_MAJOR2_NAME | Character(50) | VARCHAR2(50) NOT NULL | Major2 description |
| 17 | AV_MINOR1_CD | Character(10) | VARCHAR2(10) NOT NULL | Minor |
| 18 | AV_MINOR1_NAME | Character(50) | VARCHAR2(50) NOT NULL | Minor1 description |
| 19 | AV_MINOR2_CD | Character(10) | VARCHAR2(10) NOT NULL | Minor 2 |
| 20 | AV_MINOR2_NAME | Character(50) | VARCHAR2(50) NOT NULL | Minor2 description |