NVQ_UNITSPR_LNG (SQL Table)	Index Back
NVQ Units in progress ACCOMPLISHMENTS contains the degrees, tests, languages, honors/awards, licenses/certifications, and professional memberships of your employees, applicants and contractors. The key structure allows for a blank ACCOMPLISHMENT field in the cases of professional memberships (the ORG field will contain the name of the organization) and honors/awards (the DESCR field will contain the name of the honor/award).

NVQ_UNITSPR_LNG

(SQL Table)

NVQ Units in progress

ACCOMPLISHMENTS contains the degrees, tests, languages, honors/awards, licenses/certifications, and professional memberships of your employees, applicants and contractors. The key structure allows for a blank ACCOMPLISHMENT field in the cases of professional memberships (the ORG field will contain the name of the organization) and honors/awards (the DESCR field will contain the name of the honor/award).

Related Language Record for NVQ_UNITS_PROG

Parent record: PERSON

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

3 REVIEW_DT Date(10) DATE NOT NULL Review Date

4 COMPETENCY Character(8) VARCHAR2(8) NOT NULL Competency
Prompt Table: NVQ_UNIT_REQ_VW

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

6 DESCRLONG Long Character CLOB Long Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	ACCOMPLISHMENT	Character(8)	VARCHAR2(8) NOT NULL	Accomplishment
3	REVIEW_DT	Date(10)	DATE NOT NULL	Review Date
4	COMPETENCY	Character(8)	VARCHAR2(8) NOT NULL	Competency Prompt Table: NVQ_UNIT_REQ_VW
5	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
6	DESCRLONG	Long Character	CLOB	Long Description