VID_DATA_SRCH

(SQL View)
 Index Back

VID Data Search Record


SELECT VISITOR_ID , FIRST_NAME , LAST_NAME , LAST_NAME_SRCH , FIRST_NAME_SRCH , VID_EFFDT FROM PS_VID_DATA

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 VISITOR_ID Character(15) VARCHAR2(15) NOT NULL Reference Number
2 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
3 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
4 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name
5 FIRST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL First Name
6 VID_EFFDT Date(10) DATE NOT NULL Date Entered

Default Value: %date