GPES_NRP_SE1_VW(SQL View) |
Index Back |
---|---|
Sen. earnings by sen. measureSen. earnings by sen. measure, for non-rule packager export view |
SELECT GPES_SEN_MEASU ,PIN_NUM + 50000000 FROM PS_GPES_SEN_ERN |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | GPES_SEN_MEASU | Number(2,0) | SMALLINT NOT NULL | Seniority measurement, i.e. Trienniums |
2 | PIN_NUM | Number(8,0) | INTEGER NOT NULL |
PIN Number
Prompt Table: %GP_EDIT_FLD4 |