TRAINING_SRCH (SQL View)	Index Back
Student Training Search View TRAINING_SRCH is a search record that selects students whose training status for a course is 'currently attending', 'completed', or 'enrolled'. This functionality is part of the Training Administration application.

TRAINING_SRCH

(SQL View)

Student Training Search View

TRAINING_SRCH is a search record that selects students whose training status for a course is 'currently attending', 'completed', or 'enrolled'. This functionality is part of the Training Administration application.

SELECT %Sql(SCRTY_SEL_PKEY,SEC,SEC) FROM PS_TRAINING D , PS_PERS_SRCH_GBL SEC WHERE SEC.EMPLID = D.EMPLID AND D.ATTENDANCE IN ('A' ,'C' ,'E')

# 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 ROWSECCLASS Character(30) VARCHAR2(30) NOT NULL The class used to determine row level security

3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

4 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr

#	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	ROWSECCLASS	Character(30)	VARCHAR2(30) NOT NULL	The class used to determine row level security
3	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
4	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr