HR_CP_LANG_VW (SQL View)	Index Back
Employee Resume Languages This view is created from the HR_CP_ACCOMP_VW and ACCOMP_TBL tables and is used for the Languages grid on the Employee Self-Service Internal Resume.

HR_CP_LANG_VW

(SQL View)

Employee Resume Languages

This view is created from the HR_CP_ACCOMP_VW and ACCOMP_TBL tables and is used for the Languages grid on the Employee Self-Service Internal Resume.

SELECT DISTINCT A.EMPLID ,%Substring(B.JPM_CAT_ITEM_ID,1,8) , B.EFFDT ,B.MAJOR_CODE , %Substring(C.JPM_DESCR90,1,30) , ' ' , ' ' , ' ' , ' ' ,B.JPM_YN_1 ,B.JPM_YN_2 ,B.JPM_YN_3 ,B.JPM_RATING2 ,B.JPM_RATING1 ,B.JPM_RATING3 ,B.JPM_DATE_3 FROM PS_HR_CP_CAT_VW A , PS_JPM_JP_ITEMS B , PS_JPM_CAT_ITEMS C WHERE A.JPM_PROFILE_ID = B.JPM_PROFILE_ID AND A.JPM_CAT_TYPE = B.JPM_CAT_TYPE AND A.JPM_CAT_TYPE = C.JPM_CAT_TYPE AND B.JPM_CAT_ITEM_ID = C.JPM_CAT_ITEM_ID AND A.JPM_CAT_TYPE = 'LNG'

Parent record: PERSON

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Prompt Table: PERSON

2 JPM_CAT_ITEM_ID Character(12) VARCHAR2(12) NOT NULL Catalog Item Id. Identifies a unique catalog item defintion within a catalog type.

3 DT_ISSUED Date(10) DATE Issue Date

4 MAJOR_CODE Character(10) VARCHAR2(10) NOT NULL Major Code

5 DESCR Character(30) VARCHAR2(30) NOT NULL Description

6 TEXT1 Character(15) VARCHAR2(15) NOT NULL To hold a text string

7 TEXT15 Character(15) VARCHAR2(15) NOT NULL Text (15 Characters)

8 TEXT2 Character(15) VARCHAR2(15) NOT NULL To hold a text string

9 YESNO_LBL Character(25) VARCHAR2(25) NOT NULL Used on work records to be the label for page fields.

10 NATIVE_LANGUAGE Character(1) VARCHAR2(1) NOT NULL Native Language
Y/N Table Edit
Default Value: N

11 TRANSLATOR Character(1) VARCHAR2(1) NOT NULL Able to Translate
Y/N Table Edit
Default Value: N

12 TEACHER Character(1) VARCHAR2(1) NOT NULL Able to Teach
Y/N Table Edit
Default Value: N

13 SPEAK_PROFICIENCY Character(1) VARCHAR2(1) NOT NULL Speaking Proficiency
1=Low
2=Moderate
3=High

14 READ_PROFICIENCY Character(1) VARCHAR2(1) NOT NULL Reading Proficiency
1=Low
2=Moderate
3=High

15 WRITE_PROFICIENCY Character(1) VARCHAR2(1) NOT NULL Writing Proficiency
1=Low
2=Moderate
3=High

16 EVALUATION_DT Date(10) DATE Evaluation Date

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERSON
2	JPM_CAT_ITEM_ID	Character(12)	VARCHAR2(12) NOT NULL	Catalog Item Id. Identifies a unique catalog item defintion within a catalog type.
3	DT_ISSUED	Date(10)	DATE	Issue Date
4	MAJOR_CODE	Character(10)	VARCHAR2(10) NOT NULL	Major Code
5	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
6	TEXT1	Character(15)	VARCHAR2(15) NOT NULL	To hold a text string
7	TEXT15	Character(15)	VARCHAR2(15) NOT NULL	Text (15 Characters)
8	TEXT2	Character(15)	VARCHAR2(15) NOT NULL	To hold a text string
9	YESNO_LBL	Character(25)	VARCHAR2(25) NOT NULL	Used on work records to be the label for page fields.
10	NATIVE_LANGUAGE	Character(1)	VARCHAR2(1) NOT NULL	Native Language Y/N Table Edit Default Value: N
11	TRANSLATOR	Character(1)	VARCHAR2(1) NOT NULL	Able to Translate Y/N Table Edit Default Value: N
12	TEACHER	Character(1)	VARCHAR2(1) NOT NULL	Able to Teach Y/N Table Edit Default Value: N
13	SPEAK_PROFICIENCY	Character(1)	VARCHAR2(1) NOT NULL	Speaking Proficiency 1=Low 2=Moderate 3=High
14	READ_PROFICIENCY	Character(1)	VARCHAR2(1) NOT NULL	Reading Proficiency 1=Low 2=Moderate 3=High
15	WRITE_PROFICIENCY	Character(1)	VARCHAR2(1) NOT NULL	Writing Proficiency 1=Low 2=Moderate 3=High
16	EVALUATION_DT	Date(10)	DATE	Evaluation Date