NAME_TYPE_CV

(SQL View)
Index Back

Employee Name Types Clairvia

Clone of NAMES_TYPE_VW record for Clairvia sync message

SELECT DISTINCT NME.EMPLID ,TYP.ORDER_BY_SEQ ,NME.NAME_TYPE FROM PS_NAMES NME , PS_NAME_TYPE_TBL TYP , PS_PER_ORG_ASG_INT ASG WHERE NME.NAME_TYPE = TYP.NAME_TYPE AND ASG.EMPLID = NME.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

    Prompt Table: PERSON

    2 ORDER_BY_SEQ Number(2,0) SMALLINT NOT NULL Added in Mouse Over Label
    3 NAME_TYPE Character(3) VARCHAR2(3) NOT NULL Type of Name

    Prompt Table: NAME_TYPE_TBL