EMPLIDLANGUAGE_CDAV_EXT_DEG_LANG(SQL View) |
Index Back |
|---|---|
External Degrees Language ViewRelated language view of AV_EXT_DEG_VW. |
| SELECT A.EMPLID , D.LANGUAGE_CD , E.DESCR , F.DESCR , D.FIELD_OF_STUDY_1 , D.FIELD_OF_STUDY_2 , ' ' , ' ' FROM PS_EXT_DEGREE A , PS_EXT_ORG_TBL B , PS_DEGREE_TBL C , PS_EXT_DEGREE_LANG D , PS_EXT_ORG_LANG E , PS_DEGREE_TBL_LANG F WHERE B.EXT_ORG_ID = A.EXT_ORG_ID AND B.EFFDT = ( SELECT MAX(B1.EFFDT) FROM PS_EXT_ORG_TBL B1 WHERE B.EXT_ORG_ID = B1.EXT_ORG_ID AND B1.EFFDT <= %CurrentDateIn) AND B.EFF_STATUS = 'A' AND A.DEGREE = C.DEGREE AND C.EFFDT = ( SELECT MAX(C1.EFFDT) FROM PS_DEGREE_TBL C1 WHERE C.DEGREE = C1.DEGREE AND C1.EFFDT <= %CurrentDateIn) AND C.EFF_STATUS = 'A' AND D.EMPLID = A.EMPLID AND D.EXT_ORG_ID = A.EXT_ORG_ID AND D.EXT_DEGREE_NBR = A.EXT_DEGREE_NBR AND E.EXT_ORG_ID = B.EXT_ORG_ID AND E.EFFDT = B.EFFDT AND F.DEGREE = C.DEGREE AND F.EFFDT= C.EFFDT |
| # | 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 |