RS_XS_ACCOMPDEG(SQL View) |
Index Back |
|---|---|
Worker Degree DetailView to get the Degree detail Resources |
| SELECT B.EMPLID , %TrimSubstr(B.ACCOMPLISHMENT,1,8) %Concat 'x' %Concat %TrimSubstr(B.MAJOR_CODE,1,10) AS DEG FROM PS_RS_WRKR_ELGBL_V A , PS_ACCOMPLISHMENTS B , PS_ACCOMP_TBL C WHERE A.EMPLID = B.EMPLID AND B.ACCOMPLISHMENT = C.ACCOMPLISHMENT AND C.ACCOMP_CATEGORY = 'DEG' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | DEG | Character(32) | VARCHAR2(32) NOT NULL | Accomplishment |