PERSDATA_ITA_CV

(SQL View)
 Index Back

PERSON for ITA Clairvia

Clone of PERS_DATA_ITA record for Clairvia Fullsync message

SELECT ITA.EMPLID , ITA.EFFDT , ITA.MILITARY_STAT_ITA , ITA.MILITARY_TYPE_ITA , ITA.MILITARY_RANK_ITA , ITA.MILITARY_END_ITA FROM PS_PERS_DATA_ITA ITA , PS_PER_ORG_ASG_INT ASG WHERE %EffdtCheck(PERS_DATA_ITA,ITA,%CurrentDateIn) AND ASG.EMPLID = ITA.EMPLID AND ASG.INT_APP_TYPE = 'SCH' AND ASG.INTEGR_PROD_CD = 'CV' AND ASG.ENROLLED_FLAG = 'Y'

  • Parent record: PERSON

    • # 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 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    3 MILITARY_STAT_ITA Character(1) VARCHAR2(1) NOT NULL Military Status Italy
    C=Completed
    E=Exempt
    M=Mandatory
    R=Revisited
    4 MILITARY_TYPE_ITA Character(2) VARCHAR2(2) NOT NULL Type of Service
    AE=Airforce
    CA=Carabinieri
    CI=Civil Service
    M=Military
    MA=Navy
    5 MILITARY_RANK_ITA Character(50) VARCHAR2(50) NOT NULL Function or Rank
    6 MILITARY_END_ITA Date(10) DATE Military End Date