HR_TP_IDEFFDTDefault Value: %date
A=Active
I=Inactive
HR_TPOOL_RB_VW(SQL View) |
Index Back |
|---|---|
Talent Pool RB Metric Srch RecSearch Record for Talent Pool Ratings Box metric page. This view selects active Talent Pools (as of the system date) that have at least one associated Ratings Box. |
| SELECT A.HR_TP_ID , A.EFFDT , A.STATUS , A.DESCR20 , A.DESCR50 , A.HR_TP_CAT_ID , A.BUSINESS_UNIT , A.POSITION_NBR , A.JOBCODE , A.JOB_FAMILY , A.DEPTID , A.COMPANY FROM PS_HR_TPOOL A WHERE A.STATUS = 'A' AND %EffdtCheck(HR_TPOOL B, A, %CurrentDateIn) AND EXISTS ( SELECT 'X' FROM PS_HR_TP_RB_SELECT RB WHERE A.HR_TP_ID = RB.HR_TP_ID AND A.EFFDT = RB.EFFDT) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | HR_TP_ID |
Character(30) | VARCHAR2(30) NOT NULL | Talent Pool ID |
| 2 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 3 | STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Status Indicator
A=Active I=Inactive |
| 4 | DESCR20 | Character(20) | VARCHAR2(20) NOT NULL | Description |
| 5 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |
| 6 | HR_TP_CAT_ID | Character(30) | VARCHAR2(30) NOT NULL | Talent Pool Category |
| 7 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 8 | POSITION_NBR | Character(8) | VARCHAR2(8) NOT NULL | Position Number |
| 9 | JOBCODE | Character(6) | VARCHAR2(6) NOT NULL | Job Code |
| 10 | JOB_FAMILY | Character(6) | VARCHAR2(6) NOT NULL | Job Family |
| 11 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL | Department |
| 12 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL | Company |