EODP_CTGRY_CDLANGUAGE_CDEODP_CGFLVW_LNG(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.LANGUAGE_CD ,CT.EODP_CTGRY_DESC FROM ps_EODP_RECFIELD RF LEFT OUTER JOIN PS_EODP_CTR_CD_LNG CT ON 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 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 3 | EODP_CTGRY_DESC | Character(100) | VARCHAR2(100) NOT NULL | Category Name |