GPES_NRP_TX4_VW(SQL View) |
Index Back |
|---|---|
190 Prev Year Accum Setup190 Prev Year Accum Setup, for non-rule packager export view |
| SELECT GPES_PINS190AR ,PIN_NM , PIN_NUM + 50000000 FROM PS_GPES_TX190R_SET |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  GPES_PINS190AR |
Character(3) | VARCHAR2(3) NOT NULL |
Elements to be printed in report Model-190. Arrears.
001=Salary Income Last Year 002=Salary Withholding Last Year 003=In kind Income Last Year 004=In kind Withholding Last Year 005=In Kind Withholding Last Year 006=Exempt Traveling Last Year 007=Other Exemptions Last Year 008=Social Security Last Year 009=Non-Regular Income Rd. Last Yr |
| 2 | PIN_NM | Character(18) | VARCHAR2(18) NOT NULL |
Element Name field
Prompt Table: GPES_PIN_ACY_VW |
| 3 | PIN_NUM | Number(8,0) | INTEGER NOT NULL | PIN Number |