OM_KEYFLD_LB_VW

(SQL View)
Index Back

Price-by Key Fieldnames

Price-by Key Fieldnames

SELECT A.EOEP_KEY_FLD_CD , L.LONGNAME FROM PS_EOEP_KEY_FIELD A , PSDBFLDLABL L , PSDBFIELD F WHERE A.FIELDNAME = L.FIELDNAME AND L.FIELDNAME = F.FIELDNAME AND A.FIELDNAME = F.FIELDNAME AND L.DEFAULT_LABEL = 1

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EOEP_KEY_FLD_CD Character(3) VARCHAR2(3) NOT NULL Key field code
2 LONGNAME Character(30) VARCHAR2(30) NOT NULL Long Name