ACCOMPLISHMENTLANGUAGE_CDDefault Value: ACCOMP_TBL.DESCR
DEG=Degree
HON=Honor or Award
LIC=License or Certification
LNG=Language
MEM=Membership
NVQ=NVQ
TST=Test
DEGREE_LVW(SQL View) |
Index Back |
|---|---|
Accomplishment TableThe 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 7)NVQs (UK only) 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 ,B.LANGUAGE_CD ,B.DESCR ,B.DESCRSHORT ,A.ACCOMP_CATEGORY FROM PS_ACCOMP_TBL A , PS_ACCOMP_TBL_LANG B WHERE A.ACCOMPLISHMENT = B.ACCOMPLISHMENT AND ACCOMP_CATEGORY = 'DEG' |
| # | 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 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL |
Short Description
Default Value: ACCOMP_TBL.DESCR |
| 5 | 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 |