HR_RATINGS_BOX_IDPrompt Table: HR_SP_RB_VW
HR_TP_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_TP_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' |
| # | 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 |