EP_SECTION_TYPEEP_SEQ_NUMEP_SECTION_ITEM_SWEP_ITEM_IDEP_CHK_WRD_IDEP_LC_MTCHS_CNT(SQL Table) |
Index Back |
|---|---|
Lang Checker - Matches CountUsed in fluid performance documents. This table contains the matches in an Employee Review found by the Language Checker. This table is only used as temporary local rowset in the Employee Review. The table never stores any rows in the database. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EP_SECTION_TYPE |
Character(8) | VARCHAR2(8) NOT NULL | Section type |
| 2 | EP_SEQ_NUM |
Number(3,0) | SMALLINT NOT NULL | Sequence number |
| 3 | EP_SECTION_ITEM_SW |
Character(1) | VARCHAR2(1) NOT NULL | Yes/No switch used to determine if the section contains items |
| 4 | EP_ITEM_ID |
Character(12) | VARCHAR2(12) NOT NULL | Item unique identifier |
| 5 | EP_CHK_WRD_ID |
Character(8) | VARCHAR2(8) NOT NULL | Field used to uniquely identify a word/phrase to check for language sensitivity. |
| 6 | EP_POS_NBR | Number(15,0) | DECIMAL(15) NOT NULL | Text Position Number |
| 7 | EP_ITEM_SEQ | Number(2,0) | SMALLINT NOT NULL | Item sequence number |
| 8 | EP_TITLE | Character(60) | VARCHAR2(60) NOT NULL | Title of an item |
| 9 | EP_WORDS_PHRASES | Character(30) | VARCHAR2(30) NOT NULL | Word/Phrase used to search for language suggestions |
| 10 | EP_LC_WORD_CNT1 | Number(3,0) | SMALLINT NOT NULL | Language checker word/phrase count. |
| 11 | EP_RESULTS | Long Character | CLOB | Results statement |
| 12 | EP_RESULTS_HTML | Long Character | CLOB | Generic HTML Area |