NVQ_ACCOMP_SRCH (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_SRCH

(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 accomplishment ,accomp_category ,descr ,nvq_title FROM PS_ACCOMP_TBL WHERE accomp_category='NVQ'

Related Language Record: NVQ_ACCOMP_LNG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 ACCOMP_CATEGORY Character(3) VARCHAR2(3) NOT NULL Accomplishment Category
DEG=Degree
HON=Honor or Award
LIC=License or Certification
LNG=Language
MEM=Membership
NVQ=NVQ
TST=Test

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	ACCOMP_CATEGORY	Character(3)	VARCHAR2(3) NOT NULL	Accomplishment Category DEG=Degree HON=Honor or Award LIC=License or Certification LNG=Language MEM=Membership NVQ=NVQ TST=Test
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
4	NVQ_TITLE	Character(90)	VARCHAR2(90) NOT NULL	Title