RS_XS_ACCOMPLIC(SQL View) |
Index Back |
|---|---|
Worker Licence DetailView to get the Resource License detail. |
| SELECT B.EMPLID , %TrimSubstr(B.ACCOMPLISHMENT,1,8) %Concat 'x' %Concat %TrimSubstr(B.COUNTRY,1,3) %Concat 'x' %Concat %TrimSubstr(B.STATE,1,6) AS LIC 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 = 'LIC' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | LIC | Character(32) | VARCHAR2(32) NOT NULL | License |