GPES_PINS190L050=Exempt Tavelling Expenses
051=Exempt Dismissal Compensation
052=Other Exemptions
Prompt Table: GPES_PIN_ACY_VW
GPES_NRP_TX3_VW(SQL View) |
Index Back |
|---|---|
190 L-Key Accumulators Setup190 L-Key Accumulators Setup, for non-rule packager export view |
| SELECT GPES_PINS190L , PIN_NM , PIN_NUM + 50000000 FROM PS_GPES_TX190L_SET |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GPES_PINS190L |
Character(3) | VARCHAR2(3) NOT NULL |
Elements to be printed in report Model-190. Key L.
050=Exempt Tavelling Expenses 051=Exempt Dismissal Compensation 052=Other Exemptions |
| 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 |