HR_VT_SETUP_IDDefault Value: NEW
EFFDTDefault Value: %date
HR_SP_READINESS0=Ready Now
1=1 - 2 Years
2=3 - 5 Years
E=Emergency
Prompt Table: HR_VT_CONT_VW
Prompt Table: HR_VT_CONT_VW
HR_VT_DISP_OPTN(SQL Table) |
Index Back |
|---|---|
SP360 Readiness Icons Mapping |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | HR_VT_SETUP_ID |
Character(4) | VARCHAR2(4) NOT NULL |
seed row of HR_VT_SRCHSETUP
Default Value: NEW |
| 2 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 3 | HR_SP_READINESS |
Character(1) | VARCHAR2(1) NOT NULL |
Displays Readiness of a Succession Plan Candidate.
0=Ready Now 1=1 - 2 Years 2=3 - 5 Years E=Emergency |
| 4 | CONTNAME | Character(30) | VARCHAR2(30) NOT NULL |
Icon Name
Prompt Table: HR_VT_CONT_VW |
| 5 | HR_CONTNAME | Character(30) | VARCHAR2(30) NOT NULL |
Ratings Box Icon Name
Prompt Table: HR_VT_CONT_VW |