GP_PG_ERNDD_CDLANGUAGE_CDGP_AB_EDPN_LANG(SQL View) |
Index Back |
|---|---|
GP_AB_EDPN_LANGGP_AB_EDPN_LANG |
| SELECT DISTINCT c.pin_nm ,a.language_cd ,a.descr FROM ps_gp_pin_lang A , PS_GP_ABS_ANLY_GEN b , ps_gp_pin c WHERE a.pin_nm= b.pin_nm AND a.pin_num=b.pin_num AND b.pin_num=c.pin_num |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GP_PG_ERNDD_CD |
Character(6) | VARCHAR2(6) NOT NULL | GP_PG_ERNDD_CD |
| 2 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 3 | DESCR5 | Character(30) | VARCHAR2(30) NOT NULL | This field is used in a complex query that shows many descr fields. |