PROBINSTSCORE_RG_DESCRRY_EE_SCR_RG_VW(SQL View) |
Index Back |
|---|---|
Score Bracket Ordered ViewInput view to ACE report so score bracket is ordered correctly. |
| SELECT K.PROBINST , A.SCORE_RG_DESCR , A.SCORE_RG_ID FROM PS_RY_SVY_SCORES A , PS_RY_EE_PARM_RJC K WHERE A.DIALOG_ID = K.DIALOG_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROBINST |
Character(20) | VARCHAR2(20) NOT NULL | Optimization Problem Instance |
| 2 | SCORE_RG_DESCR |
Character(10) | VARCHAR2(10) NOT NULL | Workforce Connec - Years of service description. |
| 3 | SCORE_RG_ID | Number(3,0) | SMALLINT NOT NULL | Workforce Connect - Score Range |