NAME_TYPE_CV(SQL View) |
Index Back |
---|---|
Employee Name Types ClairviaClone 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' |
# | 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 |