OPRIDPIN_CODEEFFDTDefault Value: %date
A=Active
I=Inactive
A=All Countries
C=Specific Country
GP_ERN_DED_SRCH(SQL View) |
Index Back |
|---|---|
Earning & Deduction SearchEarning & Deduction Search |
| SELECT B.OPRID , A.PIN_CODE , C.EFFDT , C.EFF_STATUS , A.PIN_NM , A.DESCR , A.USED_BY , A.COUNTRY , A.PIN_TYPE FROM PS_GP_PIN A , PS_GP_OPR_RULE_PRF B , PS_GP_ERN_DED C WHERE A.PIN_NUM = C.PIN_NUM AND (A.USED_BY = 'A' OR (A.USED_BY = 'C' AND A.COUNTRY = B.COUNTRY) OR (A.USED_BY = 'C' AND B.USED_BY = 'A')) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | PIN_CODE |
Character(22) | VARCHAR2(22) NOT NULL | Unique identifier of a PIN (alternate to PIN number). critical for use in merging packages of elements from one database onto another when PINs may or may not be renumbered as they are moved across. Constructed from PIN_NM + COUNTRY of the element definition (GP_PIN) |
| 3 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 4 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |
| 5 | PIN_NM | Character(18) | VARCHAR2(18) NOT NULL | Element Name field |
| 6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 7 | USED_BY | Character(1) | VARCHAR2(1) NOT NULL |
USED_BY
A=All Countries C=Specific Country |
| 8 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL | Country |
| 9 | PIN_TYPE | Character(2) | VARCHAR2(2) NOT NULL | Element Type |