HR_SUCC_PLAN_IDDefault Value: HR_SUCC_PLN_HDR.HR_SUCC_PLAN_ID
EFFDTDefault Value: HR_SUCC_PLN_HDR.EFFDT
HR_RATINGS_BOX_IDPrompt Table: HR_SP_RB_VW
EMPLIDEMPL_RCDPrompt Table: HR_RB_X_RANK_VW
Prompt Table: HR_RB_Y_RANK_VW
HR_SP_RB_DATA(SQL Table) |
Index Back |
|---|---|
Succession Plan RatingsSuccession Plan Ratings |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | HR_SUCC_PLAN_ID |
Character(11) | VARCHAR2(11) NOT NULL |
Succession Plan ID
Default Value: HR_SUCC_PLN_HDR.HR_SUCC_PLAN_ID |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: HR_SUCC_PLN_HDR.EFFDT |
| 3 | HR_RATINGS_BOX_ID |
Character(11) | VARCHAR2(11) NOT NULL |
Ratings Box ID
Prompt Table: HR_SP_RB_VW |
| 4 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 5 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 6 | HR_RB_XAXISRANK | Number(3,0) | SMALLINT NOT NULL |
X-Axis Rank
Prompt Table: HR_RB_X_RANK_VW |
| 7 | HR_RB_YAXISRANK | Number(3,0) | SMALLINT NOT NULL |
Y-Axis Rank
Prompt Table: HR_RB_Y_RANK_VW |