HCSC_RTG_CDHCSC_RTG_RATINGLM_RTG_VALUESVW(SQL View) |
Index Back |
|---|---|
Ratings Values DescriptionThis view will select the description of the ratings values. |
| SELECT H.HCSC_RTG_CD , H.HCSC_RTG_RATING , H.HCSC_RTG_DESCR FROM PS_HCSC_RTG_VALUES H WHERE H.EFFDT = ( SELECT MAX(X.EFFDT) FROM PS_HCSC_RTG_VALUES X WHERE X.HCSC_RTG_CD = H.HCSC_RTG_CD AND X.HCSC_RTG_RATING = H.HCSC_RTG_RATING AND X.EFFDT <= %CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | HCSC_RTG_CD |
Character(30) | VARCHAR2(30) NOT NULL | Ratings Identification |
| 2 | HCSC_RTG_RATING |
Number(3,0) | SMALLINT NOT NULL | Ratings value |
| 3 | HCSC_RTG_DESCR | Character(254) | VARCHAR2(254) NOT NULL | Ratings Description |