HR_VT_POS_VW(SQL View) |
Index Back |
|---|---|
SP360 Position Search Viewused on succession dashboard search page |
| SELECT pos.POSITION_NBR ,pos.EFFDT ,pos.DESCR ,pos.BUSINESS_UNIT ,pos.KEY_POSITION ,pos.JOBCODE ,pos.COMPANY ,pos.DEPTID ,pos.LOCATION ,pos.STD_HOURS ,pos.STD_HRS_FREQUENCY ,pos.REG_TEMP ,pos.SAL_ADMIN_PLAN ,pos.GRADE ,pos.STEP ,pos.REPORTS_TO ,pos.REPORT_DOTTED_LINE ,pos.DESCRSHORT FROM PS_POSITION_DATA pos WHERE pos.EFF_STATUS = 'A' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  POSITION_NBR |
Character(8) | VARCHAR2(8) NOT NULL |
Position Number
Default Value: 00000000 |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 5 | KEY_POSITION | Character(1) | VARCHAR2(1) NOT NULL |
Key Position
N=No Y=Yes Y/N Table Edit Default Value: N |
| 6 | JOBCODE | Character(6) | VARCHAR2(6) NOT NULL | Job Code |
| 7 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL | Company |
| 8 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL |
Department
Prompt Table: DEPT_TBL |
| 9 | LOCATION | Character(10) | VARCHAR2(10) NOT NULL |
Location Code
Prompt Table: LOCATION_TBL |
| 10 | STD_HOURS | Number(7,2) | DECIMAL(6,2) NOT NULL | Standard Hours |
| 11 | STD_HRS_FREQUENCY | Character(5) | VARCHAR2(5) NOT NULL |
Standard Work Period
Prompt Table: STDHRS_FREQ_VW |
| 12 | REG_TEMP | Character(1) | VARCHAR2(1) NOT NULL |
Regular/Temporary
R=Regular T=Temporary Default Value: JOBCODE_TBL.REG_TEMP |
| 13 | SAL_ADMIN_PLAN | Character(4) | VARCHAR2(4) NOT NULL |
Salary Administration Plan
Prompt Table: %EDITTABLE |
| 14 | GRADE | Character(3) | VARCHAR2(3) NOT NULL |
Salary Grade
Prompt Table: %EDITTABLE2 |
| 15 | STEP | Number(2,0) | SMALLINT NOT NULL |
Step
Prompt Table: %EDITTABLE3 |
| 16 | REPORTS_TO | Character(8) | VARCHAR2(8) NOT NULL |
Reports To Position Number
Prompt Table: POSITION_DATA |
| 17 | REPORT_DOTTED_LINE | Character(8) | VARCHAR2(8) NOT NULL |
Dotted-Line Report
Prompt Table: POSITION_DATA |
| 18 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |