HRS_ACCOMP_TBL

(SQL View)
 Index Back

Accomplishment Table

The HRS_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 %Substring(A.JPM_CAT_ITEM_ID,1,8) ,%Substring(A.JPM_DESCR90,1,30) ,A.DESCRSHORT ,%Substring(A.JPM_CAT_TYPE,1,3) ,A.JPM_YN_1 ,A.JPM_DURATION_TYPE1 ,A.JPM_DURATION_1 ,A.JPM_DURATION_1 ,A.EDUCATION_LVL ,A.COUNTRY ,A.FIELD_OF_STUDY_GER ,A.TYPE_OF_STUDY_GER ,A.JPM_DURATION_2 ,A.JPM_DESCR90 ,A.NVQ_LEVEL ,A.JPM_DATE_1 ,A.HP_STATS_DEG_LVL ,A.FP_DEGREE_LVL FROM PS_JPM_CAT_ITEMS A WHERE A.JPM_CAT_TYPE IN('DEG', 'HON', 'LIC', 'LNG', 'MEM', 'NVQ', 'TST') AND A.EFFDT = ( SELECT MAX(X.EFFDT) FROM PS_JPM_CAT_ITEMS X WHERE A.JPM_CAT_TYPE = X.JPM_CAT_TYPE AND A.JPM_CAT_ITEM_ID = X.JPM_CAT_ITEM_ID AND X.EFFDT <= %CurrentDateIn) AND A.EFF_STATUS = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 ACCOMPLISHMENT Character(8) VARCHAR2(8) NOT NULL Accomplishment
2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
3 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

Default Value: ACCOMP_TBL.DESCR

4 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
5 RENEWAL_REQUIRED Character(1) VARCHAR2(1) NOT NULL Renewal Required
N=No
Y=Yes

Default Value: N

6 RENEWAL_PERIOD Character(1) VARCHAR2(1) NOT NULL Renewal Period
D=Days
M=Months
W=Weeks
Y=Years
7 RENEWAL_LENGTH Number(3,0) SMALLINT NOT NULL Renewal Length
8 YEARS_OF_EDUCATN Number(2,0) SMALLINT NOT NULL Years Of Education
9 EDUCATION_LVL Character(2) VARCHAR2(2) NOT NULL Education Level
01=No Formal Education
02=Elementary School Completed
03=Some High School
04=High School Graduate
05=Terminal Occupation Prog DNC
06=Terminal Occupation Program
07=Some College - Less than 1 Yr
08=One Year College
09=Two Years College
10=Associate Degree
11=Three Years College
12=Four Years College
13=Bachelor Degree
14=Post Bachelors
15=First Professional
16=Post-first Professional
17=Master's Degree
18=Post Master's
19=Sixth-year Degree
20=Post-sixth Year
21=Doctorate Degree
22=Post-Doctorate
A=University - Advanced
T=Trade School
U=University
10 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

Prompt Table: COUNTRY_TBL

11 FIELD_OF_STUDY_GER Character(3) VARCHAR2(3) NOT NULL Field Of Study
COM=Commercial
IDN=Industrial
TEC=Technical
12 TYPE_OF_STUDY_GER Character(3) VARCHAR2(3) NOT NULL Type Of Study
CHE=Chemistry/Physics/Mat. Appl.
COM=Commerce/Banks
ELE=Electronics/Data Processing
FOD=Food/Kindered Products
FOR=Forestry/Timber/Agriculture
GLA=Glass/Ceramics
HOT=Hotels/Restaurants
MET=Metalworker/Mechanic/Engineer.
MIN=Construction/Mining
OTH=Other
PRI=Printing/Paper
PUB=Public Sector
TEX=Textiles/Clothing
13 DURATION_MONTH Number(3,0) SMALLINT NOT NULL Duration (Months)
14 NVQ_TITLE Character(90) VARCHAR2(90) NOT NULL Title
15 NVQ_LEVEL Character(1) VARCHAR2(1) NOT NULL Level
1=1
2=2
3=3
4=4
5=5
16 NVQ_EXPDATE Date(10) DATE Expiry Date
17 HP_STATS_DEG_LVL Character(2) VARCHAR2(2) NOT NULL Stats-Can Degree Level
01=Doctoral
02=Professional Para-Medical
03=Masters & Equivalent License
04=Graduate Program
05=Bachelor
06=Professional Designation
07=Undergraduate Diploma
08=No Degree/Diploma/Prof.Desgnt
09=Unknown
18 FP_DEGREE_LVL Character(1) VARCHAR2(1) NOT NULL Level
1=Primary Leaving Certificate
2=VcalTrainCertifandAlternatives
3=TechSchool CertifandAlternativ
4=High School Diploma
5=2 Years' Higher Education
6=3 Years' Higher Education
7=4 Years' Higher Education
8=5 + > Years' Higher Education