GM_PRIORWORK_VW

(SQL View)
Index Back

EE Prior Work Experience

Use PRIORWORK_EXPER to record an employee's prior job experiences -- employers, locations, dates worked, type of position, and pay rate.

SELECT EMPLID , START_DT , SEQUENCE_NBR , EMPLOYER , CITY , STATE , COUNTRY , COUNTRY_CODE ,PHONE , END_DT , ENDING_TITLE , ENDING_RATE , PAY_FREQ_ABBRV , CURRENCY_CD , US_SOC_CD , CAN_NOC_CD , REL_WRK_EXPER FROM PS_PRIORWORK_EXPER

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: PERSONAL_DATA

2 START_DT Date(10) DATE NOT NULL Start Date
3 SEQUENCE_NBR Number(2,0) SMALLINT NOT NULL Sequence Number

Default Value: 1

4 EMPLOYER Character(30) VARCHAR2(30) NOT NULL Employer
5 CITY Character(30) VARCHAR2(30) NOT NULL City
6 STATE Character(6) VARCHAR2(6) NOT NULL State

Prompt Table: STATE_NAMES_TBL

7 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

Default Value: INSTALLATION.COUNTRY

Prompt Table: COUNTRY_TBL

8 COUNTRY_CODE Character(3) VARCHAR2(3) NOT NULL Int'l Prefix
9 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone
10 END_DT Date(10) DATE End Date
11 ENDING_TITLE Character(30) VARCHAR2(30) NOT NULL Ending Job Title
12 ENDING_RATE Number(19,3) DECIMAL(18,3) NOT NULL Ending Pay Rate
13 PAY_FREQ_ABBRV Character(1) VARCHAR2(1) NOT NULL Pay Frequency
B=Bi-weeky
H=Hour
M=Month
Y=Year

Default Value: M

14 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Default Value: INSTALLATION.EXCHNG_TO_CURRENCY

Prompt Table: CURRENCY_CD_TBL

15 US_SOC_CD Character(6) VARCHAR2(6) NOT NULL Standard Occupational Classif

Prompt Table: US_SOC_TBL

16 CAN_NOC_CD Character(10) VARCHAR2(10) NOT NULL National Occupational Classif
17 REL_WRK_EXPER Character(1) VARCHAR2(1) NOT NULL Relevant Work Experience