HR_RATINGS_BOX_IDDefault Value: HR_RATINGS_BOX.HR_RATINGS_BOX_ID
EFFDTDefault Value: %date
RANKDefault Value: 1
HR_RB_X_RAT_VW(SQL View) |
Index Back |
|---|---|
Ratings Box RatingsRatings Box Ratings |
| SELECT HR_RATINGS_BOX_ID ,EFFDT ,RANK ,HRXAXISRATINGS FROM PS_HR_RB_X_RATINGS A WHERE A.EFFDT = ( SELECT MAX(EFFDT) FROM PS_HR_RB_X_RATINGS A1 WHERE A1.HR_RATINGS_BOX_ID = A.HR_RATINGS_BOX_ID AND A1.EFFDT <= %CurrentDateIn AND A1.RANK = A.RANK) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | HR_RATINGS_BOX_ID |
Character(11) | VARCHAR2(11) NOT NULL |
Ratings Box ID
Default Value: HR_RATINGS_BOX.HR_RATINGS_BOX_ID |
| 2 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 3 | RANK |
Number(3,0) | SMALLINT NOT NULL |
Rank
Default Value: 1 |
| 4 | HRXAXISRATINGS | Character(20) | VARCHAR2(20) NOT NULL | X-Axis Rating - Rating Boxes |