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