AV_LEG_DEG_LANG(SQL View) |
Index Back |
---|---|
Legacy Degrees Language ViewRelated Language View of AV_LEG_DEG_VW |
SELECT A.EMPLID , E.LANGUAGE_CD , D.DESCR , C.DESCR , E.DESCR , F.DESCR , G.DESCR , H.DESCR FROM PS_AV_LEGACY_DEG A LEFT OUTER JOIN PS_MAJOR_TBL_LANG E ON A.AV_MAJOR1_CD = E.MAJOR_CODE LEFT OUTER JOIN PS_MAJOR_TBL_LANG F ON A.AV_MAJOR2_CD = F.MAJOR_CODE LEFT OUTER JOIN PS_MAJOR_TBL_LANG G ON A.AV_MINOR1_CD = G.MAJOR_CODE LEFT OUTER JOIN PS_MAJOR_TBL_LANG H ON A.AV_MINOR2_CD = H.MAJOR_CODE , PS_INSTITUTION_TBL B , PS_ACCOMP_TBL_LANG C , PS_INSTITUTION_LNG D WHERE B.INSTITUTION = A.INSTITUTION AND B.EFFDT = ( SELECT MAX(B1.EFFDT) FROM PS_INSTITUTION_LNG B1 WHERE B.INSTITUTION = B1.INSTITUTION AND B1.EFFDT <= %CurrentDateIn) AND B.EFF_STATUS = 'A' AND A.ACCOMPLISHMENT = C.ACCOMPLISHMENT AND B.INSTITUTION = D.INSTITUTION AND B.EFFDT = D.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 |