COMPETENCYFT_EP_SUB_IDREVIEW_RATINGPrompt Table: REVW_RATING_TBL
FT_SUBPROF_TBL(SQL Table) |
Index Back |
|---|---|
Sub-Competency ProficiencySub-Competency Proficiency - Describes a level of proficiency for a sub-competency. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | COMPETENCY |
Character(8) | VARCHAR2(8) NOT NULL | Competency |
| 2 | FT_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_PROF_STATEMENT | Character(254) | VARCHAR2(254) NOT NULL | Proficiency statement |
| 5 | JPM_DISTINCT_IND | Character(1) | VARCHAR2(1) NOT NULL | Discinct Indicator |