RS_XS_ACCOMPMEM(SQL View) |
Index Back |
|---|---|
Worker Membership DetailView to get Resource Memebership detail. |
| SELECT B.EMPLID , %TrimSubstr(B.ACCOMPLISHMENT,1,8) AS MEM 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 = 'MEM' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | MEM | Character(32) | VARCHAR2(32) NOT NULL | Membership |