OPRIDPIN_NUMDefault Value: 999999
LANGUAGE_CDGPSC_EB_PN_LANG(SQL View) |
Index Back |
|---|---|
Element Browser Cmp LanguageElement Browser Cmp Language |
| SELECT B.OPRID , B.PIN_NUM_TGT , C.LANGUAGE_CD , C.PIN_CODE , C.PIN_NM , C.DESCR , C.COMMENTS FROM PS_GP_PKG_ELEMENTS A , PS_GPSC_ELM_CMPLST B , PS_GP_PIN_LANG C WHERE A.GP_PKG_ID =B.GP_PKG_ID AND A.PIN_NUM=B.PIN_NUM AND A.PIN_NUM+50000000=C.PIN_NUM AND (A.GP_PKG_NEW_PIN_FLG='Y' OR (GP_PKG_UPG_ACTION='U' AND A.GP_PKG_NEW_PIN_FLG='N')) |
| # | 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_NUM |
Number(8,0) | INTEGER NOT NULL |
PIN Number
Default Value: 999999 |
| 3 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 4 | 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) |
| 5 | PIN_NM | Character(18) | VARCHAR2(18) NOT NULL | Element Name field |
| 6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 7 | COMMENTS | Long Character | CLOB | Comment |