TRN_INSTR_SRCH (SQL View)	Index Back
Instructor Search PERSONAL_DATA is one of the core records in the database. Use it to record personal and demographic data about an employee or applicant including name, address, birthdate, and ethnic group. You can create only one PERSONAL_DATA record per person.

TRN_INSTR_SRCH

(SQL View)

Instructor Search

PERSONAL_DATA is one of the core records in the database. Use it to record personal and demographic data about an employee or applicant including name, address, birthdate, and ethnic group. You can create only one PERSONAL_DATA record per person.

SELECT DISTINCT SEC.OPRID ,SEC.EMPLID , SEC.NAME , SEC.NAME_DISPLAY_SRCH , SEC.NAME_AC , SEC.LAST_NAME_SRCH FROM PS_PERALL_SEC_SRCH SEC , PS_TRN_INSTRCT_TBL TRN WHERE TRN.INSTRUCTOR_ID = SEC.EMPLID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

2 INSTRUCTOR_ID Character(11) VARCHAR2(11) NOT NULL Instructor ID
Prompt Table: PERSON

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

4 NAME_DISPLAY_SRCH Character(50) VARCHAR2(50) NOT NULL Uppercase version of Name to improve performance on searches.

5 NAME_AC Character(50) VARCHAR2(50) NOT NULL Alternate Character Name

6 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	INSTRUCTOR_ID	Character(11)	VARCHAR2(11) NOT NULL	Instructor ID Prompt Table: PERSON
3	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
4	NAME_DISPLAY_SRCH	Character(50)	VARCHAR2(50) NOT NULL	Uppercase version of Name to improve performance on searches.
5	NAME_AC	Character(50)	VARCHAR2(50) NOT NULL	Alternate Character Name
6	LAST_NAME_SRCH	Character(30)	VARCHAR2(30) NOT NULL	Last Name