GPGB_SS_ACM_VW(SQL View) |
Index Back |
|---|---|
Shares - Get Accumulator PINShares - Gets the PIN Number of the auto-asigned accumulator that a Share Deduction contributes to. |
| SELECT A.PIN_PARENT_NUM , A.PIN_NUM , A.PIN_NM FROM PS_GP_PIN A , PS_GP_ACCUMULATOR B , PS_GP_PIN C WHERE A.PIN_NUM = B.PIN_NUM AND A.PIN_PARENT_NUM = C.PIN_NUM AND B.ACM_PRD_OPTN = '5' AND C.PIN_NM LIKE 'SS DD%' AND A.COUNTRY = 'GBR' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PIN_PARENT_NUM | Number(8,0) | INTEGER NOT NULL | Parent Element Number |
| 2 | PIN_NUM | Number(8,0) | INTEGER NOT NULL | PIN Number |
| 3 | PIN_NM | Character(18) | VARCHAR2(18) NOT NULL | Element Name field |