NVQ_ACCOMP_LNG (SQL View)	Index Back
NVQ Search for ACCOMP_TBL The ACCOMP_TBL contains all your organizations accomplishments. Accomplishments are: 1) languages 2) degrees 3) licenses or certificates 4) honors or awards 5) professional memberships or 6) tests that your employees, applicants or contractors may achieve. The ACCOMPLISHMENT field must be unique across all these accomplishment types. The field ACCOMP_CATEGORY identifies the accomplishment as one of the above listed cateories.

NVQ_ACCOMP_LNG

(SQL View)

NVQ Search for ACCOMP_TBL

The ACCOMP_TBL contains all your organizations accomplishments. Accomplishments are: 1) languages 2) degrees 3) licenses or certificates 4) honors or awards 5) professional memberships or 6) tests that your employees, applicants or contractors may achieve. The ACCOMPLISHMENT field must be unique across all these accomplishment types. The field ACCOMP_CATEGORY identifies the accomplishment as one of the above listed cateories.

SELECT A.ACCOMPLISHMENT ,A.LANGUAGE_CD ,A.DESCR ,A.NVQ_TITLE FROM PS_ACCOMP_TBL_LANG A , PS_NVQ_ACCOMP_SRCH B WHERE A.ACCOMPLISHMENT = B.ACCOMPLISHMENT AND B.accomp_category ='NVQ'

Related Language Record for NVQ_ACCOMP_SRCH

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 ACCOMPLISHMENT Character(8) VARCHAR2(8) NOT NULL Accomplishment

2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

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

4 NVQ_TITLE Character(90) VARCHAR2(90) NOT NULL Title

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	ACCOMPLISHMENT	Character(8)	VARCHAR2(8) NOT NULL	Accomplishment
2	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
4	NVQ_TITLE	Character(90)	VARCHAR2(90) NOT NULL	Title