EODP_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 |