POSITION_NBRDefault Value: OPR_DEF_TBL_HR.BUSINESS_UNIT
Prompt Table: MIL_RANK_TBL
HR_CP_POS_VW(SQL View) |
Index Back |
|---|---|
Position View for Career PlanHR_CP_POS_VW is Position View for Career Planning Self Service product. |
| SELECT A.POSITION_NBR ,A.DESCR ,A.BUSINESS_UNIT ,A.DEPTID , A.JOBCODE ,A.SAL_ADMIN_PLAN , A.GRADE , A.STEP , A.MIL_RANK FROM PS_POSITION_DATA A WHERE A.EFF_STATUS = 'A' AND A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_POSITION_DATA B WHERE B.POSITION_NBR = A.POSITION_NBR AND EFFDT <= %CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | POSITION_NBR |
Character(8) | VARCHAR2(8) NOT NULL | Position Number |
| 2 | POS_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Position Description |
| 3 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_HR.BUSINESS_UNIT |
| 4 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL | Department |
| 5 | JOBCODE | Character(6) | VARCHAR2(6) NOT NULL | Job Code |
| 6 | SAL_ADMIN_PLAN | Character(4) | VARCHAR2(4) NOT NULL | Salary Administration Plan |
| 7 | GRADE | Character(3) | VARCHAR2(3) NOT NULL | Salary Grade |
| 8 | STEP | Number(2,0) | SMALLINT NOT NULL | Step |
| 9 | MIL_RANK | Character(5) | VARCHAR2(5) NOT NULL |
Military Rank
Prompt Table: MIL_RANK_TBL |