GP_PG_ERNDD_CDGP_AB_PNA_VW(SQL View) |
Index Back |
|---|---|
GP_AB_PNA_VWGP_AB_PNA_VW |
| SELECT DISTINCT a.erncd ,a.descr FROM ps_gp_abs_naern_vw a , PS_GP_ABS_ANLY_GEN b WHERE a.erncd=b.erncd |
| # | 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 | DESCR5 | Character(30) | VARCHAR2(30) NOT NULL | This field is used in a complex query that shows many descr fields. |