TRN_INS_TLNG_VW (SQL View)	Index Back
Instrctrs Teaching Lang View Administer Training/Budget Training modules. View to retrieve the Language/s in which the instructor can teach. Either because there are native speakers or because there are able to teach in that particular language.

TRN_INS_TLNG_VW

(SQL View)

Instrctrs Teaching Lang View

Administer Training/Budget Training modules. View to retrieve the Language/s in which the instructor can teach. Either because there are native speakers or because there are able to teach in that particular language.

SELECT A.INSTRUCTOR_ID , B.ACCOMPLISHMENT FROM PS_TRN_INSTRCT_TBL A , PS_ACCOMPLISHMENTS B , PS_ACCOMP_TBL C WHERE A.INSTRUCTOR_ID = B.EMPLID AND B.ACCOMPLISHMENT = C.ACCOMPLISHMENT AND C.ACCOMP_CATEGORY = 'LNG' AND (B.TEACHER ='Y' OR B.NATIVE_LANGUAGE ='Y') AND %EffdtCheck(TRN_INSTRCT_TBL, A, %currentdatein) AND A.EFF_STATUS = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 INSTRUCTOR_ID Character(11) VARCHAR2(11) NOT NULL Instructor ID

2 ACCOMPLISHMENT Character(8) VARCHAR2(8) NOT NULL Language
Prompt Table: LANGUAGE_VW

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	INSTRUCTOR_ID	Character(11)	VARCHAR2(11) NOT NULL	Instructor ID
2	ACCOMPLISHMENT	Character(8)	VARCHAR2(8) NOT NULL	Language Prompt Table: LANGUAGE_VW