EODP_CTGRY_CDEODP_CTGR_FL_VW(SQL View) |
Index Back |
|---|---|
Category Code description vwCategory Code from Rec Field tablae and description form Category table, to be used in pages |
| SELECT DISTINCT RF.EODP_CTGRY_CD ,CT.EODP_CTGRY_DESC FROM ps_EODP_RECFIELD RF , PS_EODP_CTGRY_CODE CT WHERE CT.EODP_CTGRY_CD = RF.EODP_CTGRY_CD |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EODP_CTGRY_CD |
Character(6) | VARCHAR2(6) NOT NULL | Category Code |
| 2 | EODP_CTGRY_DESC | Character(100) | VARCHAR2(100) NOT NULL | Category Name |