EODP_CLFN_FL_VW(SQL View) |
Index Back |
---|---|
Classification filter View |
SELECT DISTINCT RF.EODP_CLFNCD ,CF.EODP_CFCN_NAME FROM PS_EODP_RECFIELD RF , ps_EODP_CLSFCN CF WHERE CF.EODP_CLFNCD = RF.EODP_CLFNCD |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | EODP_CLFNCD | Number(3,0) | SMALLINT NOT NULL | Classification Code |
2 | EODP_CFCN_NAME | Character(100) | VARCHAR2(100) NOT NULL | Classification Name |