EMPL_AUT_VW_ESP (SQL View)	Index Back
Employee by SS Authorizatn ESP This view shows all employees under one or some companies with the same social security authorization number for Spain.

EMPL_AUT_VW_ESP

(SQL View)

Employee by SS Authorizatn ESP

This view shows all employees under one or some companies with the same social security authorization number for Spain.

SELECT DISTINCT C.SOCS_AUTH_KEY_ESP , A.EMPLID , C.EFFDT , B.NAME , C.COMPANY FROM PS_JOB A , PS_NAMES B , PS_SOCS_SETHD_ESP C WHERE A.EMPLID = B.EMPLID AND A.COMPANY = C.COMPANY AND C.EFFDT = ( SELECT MAX(ED.EFFDT) FROM PS_SOCS_SETHD_ESP ED WHERE ED.COMPANY = C.COMPANY AND ED.EFFDT <= %CurrentDateIn)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SOCS_AUTH_KEY_ESP Character(8) VARCHAR2(8) NOT NULL Authorization Key

2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Default Value: PERSON.EMPLID
Prompt Table: PERSON

3 EFFDT Date(10) DATE Effective Date
Default Value: %date

4 NAME Character(50) VARCHAR2(50) NOT NULL Name

5 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SOCS_AUTH_KEY_ESP	Character(8)	VARCHAR2(8) NOT NULL	Authorization Key
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Default Value: PERSON.EMPLID Prompt Table: PERSON
3	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
4	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
5	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company