SCC_PERITA_VW

(SQL View)
Index Back

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