HR_SUCC_PLAN_IDHR_SUCC_PLAN_TYPE1=Job Code
2=Person
3=Position
HR_SUCC_PLAN_CTLEFFDTDefault Value: %date
HR_RATINGS_BOX_IDPrompt Table: HR_SP_RB_VW
HR_SP_RB_SELECT(SQL Table) |
Index Back |
|---|---|
Succession Plan Ratings BoxesSuccession Plan Ratings Boxes |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | HR_SUCC_PLAN_ID |
Character(11) | VARCHAR2(11) NOT NULL | Succession Plan ID |
| 2 | HR_SUCC_PLAN_TYPE |
Character(1) | VARCHAR2(1) NOT NULL |
Succession Plan Type
1=Job Code 2=Person 3=Position |
| 3 | HR_SUCC_PLAN_CTL |
Character(11) | VARCHAR2(11) NOT NULL | Succession Plan Control Value |
| 4 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 5 | HR_RATINGS_BOX_ID |
Character(11) | VARCHAR2(11) NOT NULL |
Ratings Box ID
Prompt Table: HR_SP_RB_VW |