HR_VT_SRCH_RSLT(SQL View) |
Index Back |
|---|---|
SP360 Search Result ViewSuccession Planning Dashboard Search Results |
| SELECT %CurrentDateIn ,' ' ,0 ,' ' ,' ' ,' ' ,' ' ,' ' ,' ' ,' ' ,' ' ,' ' ,' ' ,' ' ,%CurrentDateIn FROM PS_INSTALLATION |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EFFDT | Date(10) | DATE |
Effective Date
Default Value: %date |
| 2 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 3 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 4 | JOBCODE | Character(6) | VARCHAR2(6) NOT NULL | Job Code |
| 5 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 6 | POSITION_NBR | Character(8) | VARCHAR2(8) NOT NULL | Position Number |
| 7 | HR_SUCC_PLAN_ID | Character(11) | VARCHAR2(11) NOT NULL | Succession Plan ID |
| 8 | HR_SUCC_PLAN_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Succession Plan Type
1=Job Code 2=Person 3=Position |
| 9 | HR_SUCC_PLAN_CTL | Character(11) | VARCHAR2(11) NOT NULL | Succession Plan Control Value |
| 10 | KEY_PERSON | Character(1) | VARCHAR2(1) NOT NULL |
Key Person
N=No Y=Yes |
| 11 | KEY_JOBCODE | Character(1) | VARCHAR2(1) NOT NULL |
Key Job Code
N=No Y=Yes |
| 12 | KEY_POSITION | Character(1) | VARCHAR2(1) NOT NULL |
Key Position
N=No Y=Yes |
| 13 | HR_VT_DEFAULT_SRCH | Character(1) | VARCHAR2(1) NOT NULL |
used on Setup Pages for Configurable Dashboard and Progression Chart
1=Persons 2=Positions 3=Job Codes 4=Succession Plans |
| 14 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 15 | ASOF_DATE | Date(10) | DATE | As of Date |