HRS_POSN_DTA_I3

(SQL View)
 Index Back

Position Data

HRS_POSN_DTA_I3 is an interface view for the POSITION_DATA HR table. Thie view is created for use only by Create Job Opening from Position AE.

SELECT A.POSITION_NBR , A.EFFDT , A.EFF_STATUS , A.DESCR , A.DESCRSHORT , A.BUSINESS_UNIT , A.DEPTID , A.JOBCODE , A.POSN_STATUS , A.STATUS_DT , A.BUDGETED_POSN , A.CONFIDENTIAL_POSN , A.MAX_HEAD_COUNT , A.REPORTS_TO , A.LOCATION , A.COMPANY , A.STD_HOURS , A.STD_HRS_FREQUENCY , A.SHIFT , A.REG_TEMP , A.REG_REGION , A.GVT_ORG_TTL_DESCR , A.FULL_PART_TIME , A.SAL_ADMIN_PLAN , A.GRADE , A.GRADE_FROM , A.GRADE_TO , A.STEP_FROM , A.STEP_TO , A.STEP , A.MANAGER_LEVEL , A.FLSA_STATUS , A.GVT_LEO_POSITION , A.GVT_POSN_SENS_CD , A.COUNTRY_CODE , A.UPDATE_INCUMBENTS FROM PS_POSITION_DATA 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 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive

Default Value: A

4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
5 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
6 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: OPR_DEF_TBL_HR.BUSINESS_UNIT

Prompt Table: BUSUNIT_HR_VW

7 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

Prompt Table: DEPT_TBL

8 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code

Prompt Table: %RECNAME_EDIT

9 POSN_STATUS Character(1) VARCHAR2(1) NOT NULL Position Status
A=Approved
P=Proposed
R=Frozen

Default Value: A

10 STATUS_DT Date(10) DATE Status Date

Default Value: %date

11 BUDGETED_POSN Character(1) VARCHAR2(1) NOT NULL Budgeted Position

Y/N Table Edit

Default Value: Y

12 CONFIDENTIAL_POSN Character(1) VARCHAR2(1) NOT NULL Confidential Position

Y/N Table Edit

Default Value: N

13 MAX_HEAD_COUNT Number(4,0) SMALLINT NOT NULL Max Head Count

Default Value: 1

14 REPORTS_TO Character(8) VARCHAR2(8) NOT NULL Reports To Position Number

Prompt Table: POSITION_DATA

15 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
16 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
17 STD_HOURS Number(7,2) DECIMAL(6,2) NOT NULL Standard Hours
18 STD_HRS_FREQUENCY Character(5) VARCHAR2(5) NOT NULL Standard Work Period

Prompt Table: STDHRS_FREQ_VW

19 SHIFT Character(1) VARCHAR2(1) NOT NULL Regular Shift
1=Day
2=Evening
3=Night
A=Any
C=Compressed
N=Not Applicable
R=Rotating
20 REG_TEMP Character(1) VARCHAR2(1) NOT NULL Regular/Temporary
R=Regular
T=Temporary
21 REG_REGION Character(5) VARCHAR2(5) NOT NULL Regulatory Region
22 GVT_ORG_TTL_DESCR Character(70) VARCHAR2(70) NOT NULL Organization Position Title
23 FULL_PART_TIME Character(1) VARCHAR2(1) NOT NULL Full/Part Time
D=On Demand
F=Full-Time
P=Part-Time

Default Value: F

24 SAL_ADMIN_PLAN Character(4) VARCHAR2(4) NOT NULL Salary Administration Plan

Prompt Table: %EDITTABLE

25 GRADE Character(3) VARCHAR2(3) NOT NULL Salary Grade

Prompt Table: %EDITTABLE2

26 GRADE_FROM Character(3) VARCHAR2(3) NOT NULL From Grade
27 GRADE_TO Character(3) VARCHAR2(3) NOT NULL To Grade
28 STEP_FROM Number(2,0) SMALLINT NOT NULL Step
29 STEP_TO Number(2,0) SMALLINT NOT NULL Step
30 STEP Number(2,0) SMALLINT NOT NULL Step

Prompt Table: %EDITTABLE3

31 MANAGER_LEVEL Character(2) VARCHAR2(2) NOT NULL Manager Level
0=Chief Operating Officer
1=Director
2=Senior Officer
3=Vice President
4=Senior Manager
5=Mid-Level Manager
6=First-Line Manager
7=Supervisor
8=All Other Positions
9=Non-Manager
32 FLSA_STATUS Character(1) VARCHAR2(1) NOT NULL FLSA Status
A=Administrative
C=Computer Employee
E=Executive
H=Highly Compensated Employees
M=Management
N=Nonexempt
O=Outside Salesperson
P=Professional
V=Nonexempt Alt Overtime
X=No FLSA Required
33 GVT_LEO_POSITION Character(1) VARCHAR2(1) NOT NULL LEO/Fire Position
5=5USC 5305 LEO
C=D.C. Police Forces
F=Fire Fighter
N=Not Applicable
P=Primary FEPCA
S=Secondary FEPCA
34 GVT_POSN_SENS_CD Character(1) VARCHAR2(1) NOT NULL Sensitivity Code
1=Non Sensitive
2=Non-Critical, Sensitive
3=Critical Sensitive
4=Special Sensitive
35 COUNTRY_CODE Character(3) VARCHAR2(3) NOT NULL Country Code
36 UPDATE_INCUMBENTS Character(1) VARCHAR2(1) NOT NULL Update Incumbents