RS_WRKR_INFO_VW

(SQL View)
 Index Back

View on Basic Worker info

This view combines the fields viewed in the basic worker information section of the worker profile. The fields in this view are sourced from the worker table and the HR tables replicated into the Financials database.

SELECT A.EMPLID , B.NAME , B.LAST_NAME_SRCH , B.FIRST_NAME_SRCH , B.COUNTRY , B.ADDRESS1 , B.ADDRESS2 , B.ADDRESS3 , B.ADDRESS4 , B.CITY , B.NUM1 , B.NUM2 , B.HOUSE_TYPE , B.COUNTY , B.STATE , B.POSTAL , B.GEO_CODE , B.IN_CITY_LIMIT , B.PHONE , B.SEX , A.AIRPORT , A.DESCR254 , A.WORKER_SUMMARY FROM PS_RS_WORKER_TBL A , PS_PERSONAL_DATA B WHERE A.EMPLID = B.EMPLID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 NAME Character(50) VARCHAR2(50) NOT NULL Name
3 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name
4 FIRST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL First Name
5 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
6 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
7 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
8 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
9 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
10 CITY Character(30) VARCHAR2(30) NOT NULL City
11 NUM1 Character(6) VARCHAR2(6) NOT NULL Number 1
12 NUM2 Character(6) VARCHAR2(6) NOT NULL Number 2
13 HOUSE_TYPE Character(2) VARCHAR2(2) NOT NULL House Type
AB=House Boat
WW=Trailer
14 COUNTY Character(30) VARCHAR2(30) NOT NULL County
15 STATE Character(6) VARCHAR2(6) NOT NULL State
16 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
17 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code
18 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit
19 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone
20 SEX Character(1) VARCHAR2(1) NOT NULL Gender
F=Female
M=Male
U=Unknown
21 AIRPORT Character(30) VARCHAR2(30) NOT NULL This field will represent the home airport for the employee.
22 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
23 WORKER_SUMMARY Long Character CLOB Worker summary/objective