NVQ_EMPLEL_LNG

(SQL Table)
Index Back

Employee Elements

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_EMPLELEMENT
  • 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 Review Date
    4 COMPETENCY Character(8) VARCHAR2(8) NOT NULL Competency
    5 ELEMENT_NBR Number(2,0) SMALLINT NOT NULL Number

    Prompt Table: NVQ_ELEMENT_TBL

    6 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    7 DESCRLONG Long Character CLOB Long Description