EP_SECTION_TYPEEP_SEQ_NUMEP_SECTION_ITEM_SWEP_ITEM_IDEP_CHK_WRD_IDEP_POS_NBREP_LC_MATCHES(SQL Table) |
Index Back |
|---|---|
Lang Checker - Matches TableThis 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_RESULTS | Long Character | CLOB | Results statement |