COMPETENCYEP_SUB_IDREVIEW_RATINGPrompt Table: REVW_RATING_TBL
EP_SEQ_NUMLANGUAGE_CDEP_SUBWRT_LANG(SQL Table) |
Index Back |
|---|---|
Sub-Competency Results WriterRelated language record for Sub-Competency Results Writer (EP_SUB_WRT_TBL) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | COMPETENCY |
Character(8) | VARCHAR2(8) NOT NULL | Competency |
| 2 | EP_SUB_ID |
Character(12) | VARCHAR2(12) NOT NULL | Sub-Item unique identifier |
| 3 | REVIEW_RATING |
Character(1) | VARCHAR2(1) NOT NULL |
Review Rating
Prompt Table: REVW_RATING_TBL |
| 4 | EP_SEQ_NUM |
Number(3,0) | SMALLINT NOT NULL | Sequence number |
| 5 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 6 | EP_RESULTS_WRITER | Long Character | CLOB | Results writer statement, contains character identifers used to pass in gender specific pronouns |