PIN_NUMGPES_SEN_ERN_VW(SQL View) |
Index Back |
|---|---|
Sen. earnings by sen. measureRetrieves the value of each seniority earning rate component. This is intended to avoid absences and to get the earning amount for the month in process |
| SELECT A.PIN_NUM , X.PIN_NUM FROM PS_GPES_SEN_ERN A , PS_GP_PIN X WHERE X.PIN_PARENT_NUM = A.PIN_NUM AND X.AUTO_ASSIGNED_TYPE = 'RT' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PIN_NUM |
Number(8,0) | INTEGER NOT NULL | PIN Number |
| 2 | PIN_RATE_NUM | Number(8,0) | INTEGER NOT NULL | PinNumber Rate |