WCS_EE_DMG_VW

(SQL View)
Index Back

Main Employee Record View

Parent Employee Record

SELECT BUDGET_ID ,BUDGET_START_DT ,TREE_NODE_NUM ,EMPLID ,EMPL_RCD ,WCS_ECM_EXCLUDED ,JOB_EFFDT ,JOB_EFFSEQ ,COMP_RATECD ,ANNUAL_RT ,CURRENCY_CD ,REG_REGION ,COMPANY ,WCS_TOT_ANNUAL_RT ,WCS_ANNUAL_RT ,LAST_HIRE_DT ,BUSINESS_UNIT ,LOCATION ,DEPTID ,JOBCODE ,POSITION_NBR ,REPORTS_TO ,MANAGER_POSN ,SUPERVISOR_ID ,MANAGER_ID ,SAL_ADMIN_PLAN ,GRADE ,STEP ,FULL_PART_TIME ,FTE ,REVIEW_RATING ,EP_RATING ,REVIEW_POINTS ,MIN_RT_ANNUAL ,MID_RT_ANNUAL ,MAX_RT_ANNUAL FROM PS_WCS_ECM_EE_DMG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUDGET_ID Character(10) VARCHAR2(10) NOT NULL Budget ID
2 BUDGET_START_DT Date(10) DATE NOT NULL Budget Start Date
3 TREE_NODE_NUM Number(10,0) DECIMAL(10) NOT NULL Internal beginning node range number
4 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
5 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
6 WCS_ECM_EXCLUDED Character(1) VARCHAR2(1) NOT NULL Employee Exclusion Flag

Y/N Table Edit

7 JOB_EFFDT Date(10) DATE Job Effective Date
8 JOB_EFFSEQ Number(3,0) SMALLINT NOT NULL Job Effective Sequence
9 COMP_RATECD Character(6) VARCHAR2(6) NOT NULL Comp Rate Code
10 ANNUAL_RT Number(19,3) DECIMAL(18,3) NOT NULL Annual Rate
11 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
12 REG_REGION Character(5) VARCHAR2(5) NOT NULL Regulatory Region
13 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
14 WCS_TOT_ANNUAL_RT Number(22,6) DECIMAL(21,6) NOT NULL Employee Total Annual Rate
15 WCS_ANNUAL_RT Number(22,6) DECIMAL(21,6) NOT NULL Employee's Annual Rate
16 LAST_HIRE_DT Date(10) DATE Latest Start Date - The latest time that an Employee or a Contingent Worker has started - based on EMPLID/EMPL_RCD.
17 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
18 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
19 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
20 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code
21 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number
22 REPORTS_TO Character(8) VARCHAR2(8) NOT NULL Reports To Position Number
23 MANAGER_POSN Character(8) VARCHAR2(8) NOT NULL Manager Position
24 SUPERVISOR_ID Character(11) VARCHAR2(11) NOT NULL Supervisor ID
25 MANAGER_ID Character(11) VARCHAR2(11) NOT NULL Manager ID
26 SAL_ADMIN_PLAN Character(4) VARCHAR2(4) NOT NULL Salary Administration Plan
27 GRADE Character(3) VARCHAR2(3) NOT NULL Salary Grade
28 STEP Number(2,0) SMALLINT NOT NULL Step
29 FULL_PART_TIME Character(1) VARCHAR2(1) NOT NULL Full/Part Time
D=On Demand
F=Full-Time
P=Part-Time
30 FTE Number(8,6) DECIMAL(7,6) NOT NULL This field represent Full Time Equivalence
31 REVIEW_RATING Character(1) VARCHAR2(1) NOT NULL Review Rating
32 EP_RATING Number(6,2) DECIMAL(5,2) NOT NULL Rating
33 REVIEW_POINTS Number(3,0) SMALLINT NOT NULL Review Points
34 MIN_RT_ANNUAL Number(19,3) DECIMAL(18,3) NOT NULL Minimum Pay Rate-Annual
35 MID_RT_ANNUAL Number(19,3) DECIMAL(18,3) NOT NULL Midpoint Pay Rate-Annual
36 MAX_RT_ANNUAL Number(19,3) DECIMAL(18,3) NOT NULL Maximum Pay Rate-Annual