SSR_HE_DL_SURVW

(SQL View)
 Index Back

DLHE SURVEY

DLHE SURVEY VIEW

SELECT INSTITUTION ,EMPLID ,SSR_HE_APRJAN ,SSR_HE_RET_NAME ,STDNT_CAR_NBR ,ACAD_CAREER ,SSR_HE_SOURCE ,SSR_HE_CAREER1 ,SSR_HE_CAREER10 ,SSR_HE_CAREER11 ,SSR_HE_CAREER12 ,SSR_HE_CAREER2 ,SSR_HE_CAREER3 ,SSR_HE_CAREER5 ,SSR_HE_CAREER9 ,SSR_HE_COURSEID ,SSR_HE_CRSENAME ,SSR_HE_CRSESBJ ,SSR_HE_DURATION ,SSR_HE_EMPCIR ,SSR_HE_EMPCRSE ,SSR_HE_EMPIMP ,SSR_HE_EMPNAME ,SSR_HE_EMPSIZE ,SSR_HE_EMSPNS1 ,SSR_HE_EMSPNS2 ,SSR_HE_EMSPNS3 ,SSR_HE_EMSPNS4 ,SSR_HE_EMSPNS5 ,SSR_HE_FOLLOWUP ,SSR_HE_FUNDSTDY ,SSR_HE_HUSID ,SSR_HE_INSTNAME ,SSR_HE_INSTPROV ,SSR_HE_INTENT ,SSR_HE_JOBDUTIES ,SSR_HE_JOBFND ,SSR_HE_JOBTITLE ,SSR_HE_NATSTUDY ,SSR_HE_NHSORG ,SSR_HE_NUMHUS ,SSR_HE_LOCEMP_AREA ,SSR_HE_LOCEMP_CTRY ,SSR_HE_LOCEMP_PCDE ,SSR_HE_MAKEDO ,SSR_HE_METHOD ,SSR_HE_PREVCAT1 ,SSR_HE_PREVCAT2 ,SSR_HE_PREVCAT3 ,SSR_HE_PREVCAT4 ,SSR_HE_PREVCAT5 ,SSR_HE_PREVCAT6 ,SSR_HE_PREVEMP ,SSR_HE_PROFSOCT ,SSR_HE_PT_FLAG ,SSR_HE_QTS_FLAG ,SSR_HE_QUALREQ ,SSR_HE_SALARY ,SSR_HE_SALARY_NO ,SSR_HE_SECINT1 ,SSR_HE_SECINT2 ,SSR_HE_MODSTUDY ,SSR_HE_MODE ,SSR_HE_SECINT3 ,SSR_HE_SECINT4 ,SSR_HE_SECINT5 ,SSR_HE_SIC2007 ,SSR_HE_SOCDLHE ,SSR_HE_SECINT6 ,SSR_HE_SECINT7 ,SSR_HE_SECINT9 ,SSR_HE_SURV_STATUS ,SSR_HE_TCHEMP ,SSR_HE_TCHSEEK ,SSR_HE_TEACHPHS ,SSR_HE_TEACHSCT ,SSR_HE_TTCID ,SSR_HE_TYPEQUAL FROM %Table(ssr_he_dlhe_sur) WHERE ssr_he_surv_status IN ('N', 'I') AND ssr_he_aprjan ='2'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

Default Value: OPR_DEF_TBL_CS.INSTITUTION

2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
3 SSR_HE_APRJAN Character(3) VARCHAR2(3) NOT NULL Survey
1=April Survey
1=April Survey
2=January Survey
2=January Survey
A=December Survey
B=March Survey
C=June Survey
D=September Survey
4 SSR_HE_RET_NAME Character(30) VARCHAR2(30) NOT NULL Return Name
5 STDNT_CAR_NBR Number(3,0) SMALLINT NOT NULL Student Career Nbr
6 ACAD_CAREER Character(4) VARCHAR2(4) NOT NULL Academic Career
BAC=Bachelor (NLD)
BBL=Vocational Coaching (NLD)
BOL=Vocational Training (NLD)
BUSN=Graduate Business
CNED=Continuing Education
CRED=Semester Credit
EDU=Education (NLD)
EXED=Extended Education
GRAD=Graduate
LAW=Law
MEDS=Medical School
NONA=Non Award
PGRD=Postgraduate
RSCH=Research
TECH=Technical
UENG=Undergraduate Engineering
UGRD=Undergraduate
VAVO=Advanced General Educ. (NLD)
VETM=Veterinary Medicine
7 SSR_HE_SOURCE Character(1) VARCHAR2(1) NOT NULL Source
H=HESA Survey
I=Identify Target Population
M=Manually added
P=Import Population File
S=Seeded
U=User Entered
8 SSR_HE_CAREER1 Number(1,0) SMALLINT NOT NULL Career related code 1
9 SSR_HE_CAREER10 Number(1,0) SMALLINT NOT NULL Career10
10 SSR_HE_CAREER11 Number(1,0) SMALLINT NOT NULL CAREER11
11 SSR_HE_CAREER12 Number(1,0) SMALLINT NOT NULL CAREER12
12 SSR_HE_CAREER2 Number(1,0) SMALLINT NOT NULL CAREER2
13 SSR_HE_CAREER3 Number(1,0) SMALLINT NOT NULL CAREER3
14 SSR_HE_CAREER5 Number(1,0) SMALLINT NOT NULL CAREER5
15 SSR_HE_CAREER9 Number(1,0) SMALLINT NOT NULL CAREER9
16 SSR_HE_COURSEID Character(10) VARCHAR2(10) NOT NULL Course ID
17 SSR_HE_CRSENAME Character(200) VARCHAR2(200) NOT NULL Course Name
18 SSR_HE_CRSESBJ Character(200) VARCHAR2(200) NOT NULL Course Subject
19 SSR_HE_DURATION Character(1) VARCHAR2(1) NOT NULL Duration
1=1
2=2
3=3
4=4
5=5
6=6
8=8
20 SSR_HE_EMPCIR Character(2) VARCHAR2(2) NOT NULL Employment Circumstances
01=01
02=02
03=03
10=10
11=11
12=12
13=13
14=14
15=15
16=16
17=17
21 SSR_HE_EMPCRSE Character(1) VARCHAR2(1) NOT NULL EmpCrse
0=No
1=Yes
22 SSR_HE_EMPIMP Character(1) VARCHAR2(1) NOT NULL EMPIMP
1=The subject(s) studied
2=The level of study
3=Both were equally important
4=Sandwich/work experience
5=No one thing was most importan
8=Don't know
23 SSR_HE_EMPNAME Character(60) VARCHAR2(60) NOT NULL EMPNAME
24 SSR_HE_EMPSIZE Character(1) VARCHAR2(1) NOT NULL EMPSIZE
1=1 to 49
2=50 to 249
3=250 or more
8=Don't know
25 SSR_HE_EMSPNS1 Number(1,0) SMALLINT NOT NULL EMSPNS1
26 SSR_HE_EMSPNS2 Number(1,0) SMALLINT NOT NULL EMSPNS2
27 SSR_HE_EMSPNS3 Number(1,0) SMALLINT NOT NULL EMSPNS3
28 SSR_HE_EMSPNS4 Number(1,0) SMALLINT NOT NULL EMSPNS4
29 SSR_HE_EMSPNS5 Number(1,0) SMALLINT NOT NULL EMSPNS5
30 SSR_HE_FOLLOWUP Character(1) VARCHAR2(1) NOT NULL FOLLOWUP
31 SSR_HE_FUNDSTDY Character(2) VARCHAR2(2) NOT NULL FUNDSTDY
01=01
02=02
03=03
04=04
05=05
1=1
2=2
4=4
5=5
8=8
32 SSR_HE_HUSID Character(17) VARCHAR2(17) NOT NULL HUSID
33 SSR_HE_INSTNAME Character(60) VARCHAR2(60) NOT NULL INSTNAME
34 SSR_HE_INSTPROV Character(4) VARCHAR2(4) NOT NULL INSTPROV
35 SSR_HE_INTENT Character(1) VARCHAR2(1) NOT NULL INTENT
1=1
2=2
3=3
9=9
36 SSR_HE_JOBDUTIES Character(200) VARCHAR2(200) NOT NULL JOBDUTIES
37 SSR_HE_JOBFND Character(2) VARCHAR2(2) NOT NULL JOBFIND
01=01
02=02
03=03
04=04
05=05
06=06
07=07
08=08
09=09
1=1
11=11
2=2
3=3
4=4
5=5
6=6
7=7
8=8
9=9
38 SSR_HE_JOBTITLE Character(60) VARCHAR2(60) NOT NULL JOBTITLE
39 SSR_HE_NATSTUDY Character(1) VARCHAR2(1) NOT NULL NATSTUDY
1=1
2=2
3=3
4=4
40 SSR_HE_NHSORG Character(1) VARCHAR2(1) NOT NULL NHSORG
1=Yes
2=No
8=Don't know
41 SSR_HE_NUMHUS Character(10) VARCHAR2(10) NOT NULL NUMHUS
42 SSR_HE_LOCEMP_AREA Character(200) VARCHAR2(200) NOT NULL LOCEMP
43 SSR_HE_LOCEMP_CTRY Character(60) VARCHAR2(60) NOT NULL LOCEMP CTRY
44 SSR_HE_LOCEMP_PCDE Character(8) VARCHAR2(8) NOT NULL PCDE
45 SSR_HE_MAKEDO Character(60) VARCHAR2(60) NOT NULL MAKEDO
46 SSR_HE_METHOD Character(2) VARCHAR2(2) NOT NULL METHOD
47 SSR_HE_PREVCAT1 Number(1,0) SMALLINT NOT NULL PREVCAT1
48 SSR_HE_PREVCAT2 Number(1,0) SMALLINT NOT NULL PREVCAT2
49 SSR_HE_PREVCAT3 Number(1,0) SMALLINT NOT NULL PREVCAT3
50 SSR_HE_PREVCAT4 Number(1,0) SMALLINT NOT NULL PREVCAT4
51 SSR_HE_PREVCAT5 Number(1,0) SMALLINT NOT NULL PREVCAT5
52 SSR_HE_PREVCAT6 Number(1,0) SMALLINT NOT NULL PREVCAT6
53 SSR_HE_PREVEMP Character(1) VARCHAR2(1) NOT NULL PREVEMP
1=1
2=2
3=3
4=4
54 SSR_HE_PROFSOCT Character(5) VARCHAR2(5) NOT NULL PROFSOCT
55 SSR_HE_PT_FLAG Character(1) VARCHAR2(1) NOT NULL PT FLAG
56 SSR_HE_QTS_FLAG Character(1) VARCHAR2(1) NOT NULL QTS FLAG
57 SSR_HE_QUALREQ Character(2) VARCHAR2(2) NOT NULL QUALREG
11=11
12=12
13=13
14=14
3=3
4=4
5=5
8=8
58 SSR_HE_SALARY Number(20,2) DECIMAL(19,2) NOT NULL SALARY
59 SSR_HE_SALARY_NO Character(1) VARCHAR2(1) NOT NULL SALARY NO
1=Do not wish
60 SSR_HE_SECINT1 Number(1,0) SMALLINT NOT NULL SSR_HE_SECINT1
61 SSR_HE_SECINT2 Number(1,0) SMALLINT NOT NULL SSR_HE_SECINT2
62 SSR_HE_MODSTUDY Character(1) VARCHAR2(1) NOT NULL MODSTUDY
1=Yes - full-time
2=Yes - part-time
3=No
63 SSR_HE_MODE Character(2) VARCHAR2(2) NOT NULL MODE
64 SSR_HE_SECINT3 Number(1,0) SMALLINT NOT NULL SSR_HE_SECINT3
65 SSR_HE_SECINT4 Number(1,0) SMALLINT NOT NULL SSR_HE_SECINT4
66 SSR_HE_SECINT5 Number(1,0) SMALLINT NOT NULL SSR_HE_SECINT5
67 SSR_HE_SIC2007 Character(4) VARCHAR2(4) NOT NULL Industrial Classification Code
68 SSR_HE_SOCDLHE Character(5) VARCHAR2(5) NOT NULL Select an Occupation Code
69 SSR_HE_SECINT6 Number(1,0) SMALLINT NOT NULL SSR_HE_SECINT6
70 SSR_HE_SECINT7 Number(1,0) SMALLINT NOT NULL SSR_HE_SECINT7
71 SSR_HE_SECINT9 Number(1,0) SMALLINT NOT NULL SSR_HE_SECINT9
72 SSR_HE_SURV_STATUS Character(1) VARCHAR2(1) NOT NULL Survey Status
C=Coded
D=Duplicate
E=Excluded
L=Saved
N=New
S=Submitted
73 SSR_HE_TCHEMP Character(1) VARCHAR2(1) NOT NULL Employed as teacher
1=Yes
2=No
3=Yes
4=No
74 SSR_HE_TCHSEEK Character(1) VARCHAR2(1) NOT NULL Seeking a teaching post
1=Yes
2=No
75 SSR_HE_TEACHPHS Character(1) VARCHAR2(1) NOT NULL Teaching phase
1=1
2=2
3=3
4=4
76 SSR_HE_TEACHSCT Character(1) VARCHAR2(1) NOT NULL SSR_HE_TEACHSCT
1=1
2=2
3=3
4=4
77 SSR_HE_TTCID Character(2) VARCHAR2(2) NOT NULL Teacher Training Course
78 SSR_HE_TYPEQUAL Character(2) VARCHAR2(2) NOT NULL Type of qualification
01=01
02=02
03=03
04=04
05=05
06=06
07=07
98=98