HR_SUCC_PLAN_IDDefault Value: NEW
HR_SUCC_PLAN_TYPE1=Job Code
2=Person
3=Position
HR_SUCC_PLAN_CTLPrompt Table: %EDITTABLE
EFFDTDefault Value: %date
D=Draft
I=Inactive
O=Official
Default Value: D
HR_SPHDR_NPC_VW(SQL View) |
Index Back |
|---|---|
SP Header, No Pcode ViewThis view is based on HR_SUCC_PLN_HDR. It selects directly from the table with no joins and no PeopleCode. HR_SUCC_PLN_HDR is the header record which contains the effective date of the Succession Plan for this position. There would be one record for each effective-dated plan. |
| SELECT HR_SUCC_PLAN_ID , HR_SUCC_PLAN_TYPE , HR_SUCC_PLAN_CTL , EFFDT , HR_SUCC_PLAN_STS , DESCR , NEXT_SUCCESSPLN_DT , AVAILABILITY_DT , SETID_JOBCODE FROM PS_HR_SUCC_PLN_HDR |
| # | 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: NEW |
| 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
Prompt Table: %EDITTABLE |
| 4 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 5 | HR_SUCC_PLAN_STS | Character(1) | VARCHAR2(1) NOT NULL |
Succession Plan Status
D=Draft I=Inactive O=Official Default Value: D |
| 6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 7 | NEXT_SUCCESSPLN_DT | Date(10) | DATE | Next Succession Plan Date |
| 8 | AVAILABILITY_DT | Date(10) | DATE | Availability Date |
| 9 | SETID_JOBCODE | Character(5) | VARCHAR2(5) NOT NULL | Job Code Set ID |