HR_SP_RB_SEL_VW(SQL View) |
Index Back |
---|---|
Succ Plan Ratings Boxes ViewSuccession Plan Ratings Boxes joined to the Ratings Box definition table, HR_RATINGS_BOX. Only returns rows where the ratings box is assigned to a succession plan and active on HR_RATINGS_BOX as of the succession plans EFFDT. |
SELECT A.HR_SUCC_PLAN_ID , A.HR_SUCC_PLAN_TYPE , A.HR_SUCC_PLAN_CTL , A.EFFDT , A.HR_RATINGS_BOX_ID FROM PS_HR_SP_RB_SELECT A , PS_HR_RATINGS_BOX B WHERE A.HR_RATINGS_BOX_ID = B.HR_RATINGS_BOX_ID AND B.EFF_STATUS = 'A' AND %EffdtCheck(HR_RATINGS_BOX sub,B,A.EFFDT) |
# | 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 |