JOB_GM_VW (SQL View)	Index Back
EE Job History View 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.

JOB_GM_VW

(SQL View)

EE Job History View

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 EMPLID, EFFDT, POSITION_NBR FROM PS_JOB

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Default Value: NEW
Prompt Table: PERSONAL_DATA

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

3 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number
Prompt Table: POSITION_DATA