HR_RATINGS_BOX_IDPrompt Table: HR_SP_RB_VW
HR_SP_RB_DFLT_V(SQL View) |
Index Back |
|---|---|
Succession Plan DefaultsSuccession Plan Defaults |
| SELECT A.hr_ratings_box_id FROM ps_hr_ratings_box A , PS_HR_SP_RB_DFLT B WHERE A.hr_ratings_box_id = B.hr_ratings_box_id AND %EffdtCheck(HR_RATINGS_BOX C, A, %CurrentDateIn) AND A.EFF_STATUS = 'A' AND A.HR_RB_TPOOL_IND = 'N' |
| # | 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_SP_RB_VW |