PIN_NUMGPBR_PIN_NU3_VW(SQL View) |
Index Back |
|---|---|
Prompt - Earn+Ded PINsView is used as PROMPT view for both Earning and Deduction PINs |
| SELECT B.PIN_NUM ,B.PIN_CODE ,B.PIN_NM ,B.DESCR ,B.COMMENTS ,B.COUNTRY FROM PS_GP_PIN B WHERE B.PIN_NUM < 50000000 AND (B.USED_BY = 'A' OR B.USED_BY = 'C' ) AND B.PIN_TYPE IN ('ER', 'DD', 'VR') AND B.COUNTRY = 'BRA' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PIN_NUM |
Number(8,0) | INTEGER NOT NULL | PIN Number |
| 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 | PIN_NM | Character(18) | VARCHAR2(18) NOT NULL | Element Name field |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | COMMENTS | Long Character | CLOB | Comment |
| 6 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL | Country |