HR_RB_X_RANK_VW(SQL View) |
Index Back |
---|---|
Ratings Box RatingsRatings Box Ratings Rank Values |
SELECT HR_RATINGS_BOX_ID , EFFDT , RANK , HRXAXISRATINGS FROM PS_HR_RB_X_RATINGS |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | HR_RATINGS_BOX_ID | Character(11) | VARCHAR2(11) NOT NULL |
Ratings Box ID
Prompt Table: HR_RATINGS_BOX |
2 | EFFDT | Date(10) | DATE |
Effective Date
Default Value: %date |
3 | HR_RB_XAXISRANK | Number(3,0) | SMALLINT NOT NULL | X-Axis Rank |
4 | HRXAXISRATINGS | Character(20) | VARCHAR2(20) NOT NULL | X-Axis Rating - Rating Boxes |