HR_TP_IDDefault Value: NEW
EFFDTDefault Value: %date
HR_RATINGS_BOX_IDPrompt Table: HR_TP_RB_VW
HR_VT_RBOX_VW(SQL View) |
Index Back |
|---|---|
SP360 TPool Ratings Boxes ViewTalent Pool Ratings Boxes View |
| SELECT a.HR_TP_ID , a.EFFDT , a.HR_RATINGS_BOX_ID , c.HR_RB_MAINTITLE , c.DESCR FROM PS_HR_TP_RB_SELECT a , PS_HR_RATINGS_BOX c WHERE c.HR_RATINGS_BOX_ID = a.HR_RATINGS_BOX_ID AND c.EFF_STATUS = 'A' AND c.HR_RB_TPOOL_IND = 'Y' AND %EffdtCheck(HR_RATINGS_BOX c1, c, a.EFFDT) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | HR_TP_ID |
Character(30) | VARCHAR2(30) NOT NULL |
Talent Pool ID
Default Value: NEW |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 3 | HR_RATINGS_BOX_ID |
Character(11) | VARCHAR2(11) NOT NULL |
Ratings Box ID
Prompt Table: HR_TP_RB_VW |
| 4 | HR_RB_MAINTITLE | Character(35) | VARCHAR2(35) NOT NULL | Ratings Box Main Title |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |