HR_TP_IDDefault Value: NEW
EFFDTDefault Value: %date
HR_RATINGS_BOX_IDPrompt Table: HR_TP_RB_VW
HR_TP_RB_SEL_VW(SQL View) |
Index Back |
|---|---|
Talent Pool Ratings BoxesTalent Pool Ratings Boxes |
| SELECT A.HR_TP_ID , A.EFFDT , A.HR_RATINGS_BOX_ID , B.HR_RB_MAINTITLE FROM PS_HR_TP_RB_SELECT A , PS_HR_TP_RB_VW B WHERE A.HR_RATINGS_BOX_ID = B.HR_RATINGS_BOX_ID |
| # | 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 |