SCC_PERITA_VW(SQL View) |
Index Back |
---|---|
Person Italy ViewPerson 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 |