CC_EMPL_ID_VW

(SQL View)
Index Back

ProCard Employee ID Prompt


SELECT DISTINCT A.EMPLID , B.NAME FROM PS_CC_CARD_DATA_EX A , PS_PERSONAL_DATA B WHERE %Join(COMMON_KEYS, CC_CARD_DATA_EX A, PERSONAL_DATA B)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: PERSONAL_DATA

2 NAME Character(50) VARCHAR2(50) NOT NULL Name