STYLESHEETNAMESTYLECLASSNAMEFE_FONT_VW(SQL View) |
Index Back |
|---|---|
Forms Engine Font View |
| SELECT A.STYLESHEETNAME ,A.STYLECLASSNAME ,A.FONTSIZE ,A.FONTSIZELEN ,A.FONTSIZEUNITS ,A.FONTSIZEABS ,A.FONTWGHT ,A.FONTSTYLE ,A.FONTVARIANT ,B.FONTNAME ,D.POSTSCRIPTFONTNAME FROM PSSTYLECLASS A , PSSTYLECLASSFNT B , PS_POSTSCRIPT_FONT D WHERE B.STYLESHEETNAME = A.STYLESHEETNAME AND B.STYLECLASSNAME = A.STYLECLASSNAME AND B.SEQNUM = ( SELECT MIN(C.SEQNUM) FROM PSSTYLECLASSFNT C WHERE C.STYLESHEETNAME = B.STYLESHEETNAME AND C.STYLECLASSNAME = B.STYLECLASSNAME ) AND B.FONTNAME = D.PPLFONTNAME |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | STYLESHEETNAME |
Character(30) | VARCHAR2(30) NOT NULL | Style Sheet Name (see PSSTYLSHEETDEFN). |
| 2 | STYLECLASSNAME |
Character(30) | VARCHAR2(30) NOT NULL | Style Class Name |
| 3 | FONTSIZE | Number(2,0) | SMALLINT NOT NULL | Font Size |
| 4 | FONTSIZELEN | Number(10,0) | DECIMAL(10) NOT NULL | Font Size Len |
| 5 | FONTSIZEUNITS | Number(2,0) | SMALLINT NOT NULL | Font Size Units |
| 6 | FONTSIZEABS | Number(2,0) | SMALLINT NOT NULL | Font Size Abs |
| 7 | FONTWGHT | Number(2,0) | SMALLINT NOT NULL | Font Weight |
| 8 | FONTSTYLE | Number(2,0) | SMALLINT NOT NULL | Font Style |
| 9 | FONTVARIANT | Number(2,0) | SMALLINT NOT NULL | Font Variant |
| 10 | FONTNAME | Character(30) | VARCHAR2(30) NOT NULL | Font Name |
| 11 | POSTSCRIPTFONTNAME | Character(40) | VARCHAR2(40) NOT NULL | PostScript FontName |