ERE_RESP_ESP_VW

(SQL View)
 Index Back

Responsible Data ESP

Responsible Data ESP

SELECT DISTINCT C.ERE_ID_ESP , C.COMPANY , A.EMPLID , A.NAME , A.FIRST_NAME , A.LAST_NAME , A.SECOND_LAST_NAME , B.NATIONAL_ID_TYPE , B.NATIONAL_ID , A.SEX , A.BIRTHDATE , A.BIRTHPLACE , A.BIRTHCOUNTRY , A.ADDRESS1 , A.PHONE , A.STATE , A.CITY , A.POSTAL , A.COUNTRY , %Substring (B.NATIONAL_ID_TYPE, 1, 1) %Concat %Substring(B.NATIONAL_ID, 1, 19) FROM PS_PERSONAL_DATA A , PS_PERS_NID B , PS_ERE_CMP_DTA_ESP C WHERE A.EMPLID = B.EMPLID AND A.EMPLID = C.RESPONSIBLE_ID AND B.PRIMARY_NID = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 ERE_ID_ESP Character(10) VARCHAR2(10) NOT NULL ERE ID
2 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

Prompt Table: COMPANY_TBL

3 RESPONSIBLE_ID Character(11) VARCHAR2(11) NOT NULL Responsible ID
4 NAME Character(50) VARCHAR2(50) NOT NULL Name
5 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
6 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
7 SECOND_LAST_NAME Character(30) VARCHAR2(30) NOT NULL Second Last Name
8 NATIONAL_ID_TYPE Character(6) VARCHAR2(6) NOT NULL National ID Type
9 NATIONAL_ID Character(20) VARCHAR2(20) NOT NULL National ID
10 SEX Character(1) VARCHAR2(1) NOT NULL Gender
F=Female
M=Male
U=Unknown
11 BIRTHDATE Date(10) DATE Date of Birth
12 BIRTHPLACE Character(30) VARCHAR2(30) NOT NULL Birth Location
13 BIRTHCOUNTRY Character(3) VARCHAR2(3) NOT NULL Birth Country
14 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
15 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone
16 STATE Character(6) VARCHAR2(6) NOT NULL State
17 CITY Character(30) VARCHAR2(30) NOT NULL City
18 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
19 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
20 PERSON_NID_ESP Character(20) VARCHAR2(20) NOT NULL Occupational Code