WCS_JOB_SCH_VW (SQL View)	Index Back
EE Job History JOB is one of the core records in the database. Use it to record an employee's job history data such as actions taken, department, job code, location, and salary history. You can create multiple JOB records for an employee.

WCS_JOB_SCH_VW

(SQL View)

EE Job History

JOB is one of the core records in the database. Use it to record an employee's job history data such as actions taken, department, job code, location, and salary history. You can create multiple JOB records for an employee.

SELECT C.OPRID ,C.ROWSECCLASS ,A.EMPLID ,A.EMPL_RCD ,A.EFFDT ,A.EFFSEQ ,A.PER_ORG ,A.DEPTID ,A.JOBCODE ,A.POSITION_NBR ,A.SUPERVISOR_ID ,B.NAME_DISPLAY FROM PS_JOB A , PS_NAMES B , PS_PERS_SRCH_GBL C WHERE A.EMPLID = B.EMPLID AND B.NAME_TYPE = 'PRI' AND %EffdtCheck(NAMES B1, B, %CurrentDateIn) AND A.EMPLID = C.EMPLID AND A.EMPL_RCD = C.EMPL_RCD

Parent record: PER_ORG_ASGN

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

2 ROWSECCLASS Character(30) VARCHAR2(30) NOT NULL The class used to determine row level security

3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Default Value: PER_ORG_ASGN.EMPLID
Prompt Table: PERS_SRCH_GBL

4 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record

5 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

6 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence

7 PER_ORG Character(3) VARCHAR2(3) NOT NULL Defines the Organizational Relationship(s) that a Person has to the Organization. These are Employee, Contingent Worker, and Persons of Interest.
CWR=Contingent Worker
EMP=Employee
POI=Person of Interest
Default Value: PER_ORG_ASGN.PER_ORG

8 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
Prompt Table: DEPT_TBL

9 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code
Prompt Table: JOBCODE_TBL

10 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number
Prompt Table: POSN_DATA_VW

11 SUPERVISOR_ID Character(11) VARCHAR2(11) NOT NULL Supervisor ID
Prompt Table: WORKER_PROMPT

12 NAME Character(50) VARCHAR2(50) NOT NULL Name
Prompt Table: WCS_NAME_SCH_VW

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	ROWSECCLASS	Character(30)	VARCHAR2(30) NOT NULL	The class used to determine row level security
3	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Default Value: PER_ORG_ASGN.EMPLID Prompt Table: PERS_SRCH_GBL
4	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
5	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
6	EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Effective Sequence
7	PER_ORG	Character(3)	VARCHAR2(3) NOT NULL	Defines the Organizational Relationship(s) that a Person has to the Organization. These are Employee, Contingent Worker, and Persons of Interest. CWR=Contingent Worker EMP=Employee POI=Person of Interest Default Value: PER_ORG_ASGN.PER_ORG
8	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department Prompt Table: DEPT_TBL
9	JOBCODE	Character(6)	VARCHAR2(6) NOT NULL	Job Code Prompt Table: JOBCODE_TBL
10	POSITION_NBR	Character(8)	VARCHAR2(8) NOT NULL	Position Number Prompt Table: POSN_DATA_VW
11	SUPERVISOR_ID	Character(11)	VARCHAR2(11) NOT NULL	Supervisor ID Prompt Table: WORKER_PROMPT
12	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name Prompt Table: WCS_NAME_SCH_VW