SCC_PERITA_VW (SQL View)	Index Back
Person Italy View Person Italy View used by personal data view SCC_PERDATA_VW.

SCC_PERITA_VW

(SQL View)

Person Italy View

Person Italy View used by personal data view SCC_PERDATA_VW.

SELECT P.EMPLID , IT.MILITARY_STAT_ITA , IT.MILITARY_TYPE_ITA , IT.MILITARY_RANK_ITA , IT.MILITARY_END_ITA FROM PS_PERSON P , PS_PERS_DATA_ITA IT , PS_PERSON_DT_SETUP S , PS_INSTALLATION I WHERE IT.EMPLID = P.EMPLID AND %EffdtCheck(PERS_DATA_ITA IT2, IT, %CURRENTDATEIN) AND S.COUNTRY_FLG = 'Y' AND I.ITA = 'Y' UNION SELECT PX.EMPLID , ' ' , ' ' , ' ' , %DateNull FROM PS_PERSON PX WHERE NOT EXISTS ( SELECT 'X' FROM PS_PERS_DATA_ITA ITX , PS_PERSON_DT_SETUP SX , PS_INSTALLATION IX WHERE ITX.EMPLID = PX.EMPLID AND %EffdtCheck(PERS_DATA_ITA ITX2, ITX, %CURRENTDATEIN) AND SX.COUNTRY_FLG = 'Y' AND IX.ITA = 'Y' )

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 MILITARY_STAT_ITA Character(1) VARCHAR2(1) NOT NULL Military Status Italy
C=Completed
E=Exempt
M=Mandatory
R=Revisited

3 MILITARY_TYPE_ITA Character(2) VARCHAR2(2) NOT NULL Type of Service
AE=Airforce
CA=Carabinieri
CI=Civil Service
M=Military
MA=Navy

4 MILITARY_RANK_ITA Character(50) VARCHAR2(50) NOT NULL Function or Rank

5 MILITARY_END_ITA Date(10) DATE Military End Date

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Default Value: PERSON.EMPLID Prompt Table: PERSON
2	MILITARY_STAT_ITA	Character(1)	VARCHAR2(1) NOT NULL	Military Status Italy C=Completed E=Exempt M=Mandatory R=Revisited
3	MILITARY_TYPE_ITA	Character(2)	VARCHAR2(2) NOT NULL	Type of Service AE=Airforce CA=Carabinieri CI=Civil Service M=Military MA=Navy
4	MILITARY_RANK_ITA	Character(50)	VARCHAR2(50) NOT NULL	Function or Rank
5	MILITARY_END_ITA	Date(10)	DATE	Military End Date