BENEFIT_PLANSP_ARSP_NONVW(SQL View) |
Index Back |
|---|---|
Pension SP Header view |
| SELECT DISTINCT M.BENEFIT_PLAN FROM %Table(AR_SP_MSG) M , %Table(CUSTOMER) C WHERE M.EMPLID = C.EMPLID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BENEFIT_PLAN |
Character(6) | VARCHAR2(6) NOT NULL | Service Purchase Benefit Plan |