| # |
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
Prompt Table:
INSTITUTION_TBL
|
| 2 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table:
SSR_HE_PPL_SRCH
|
| 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
Prompt Table:
SSR_HE_RNM1_VW
|
| 5 |
STDNT_CAR_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Student Career Nbr
Prompt Table:
SSR_HE_CNBR_VW
|
| 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
Prompt Table:
SSR_HE_ACAR_VW
|
| 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
1/0 Table Edit (1=True, 0=False)
|
| 9 |
SSR_HE_CAREER10 |
Number(1,0) |
SMALLINT NOT NULL |
Career10
1/0 Table Edit (1=True, 0=False)
|
| 10 |
SSR_HE_CAREER11 |
Number(1,0) |
SMALLINT NOT NULL |
CAREER11
1/0 Table Edit (1=True, 0=False)
|
| 11 |
SSR_HE_CAREER12 |
Number(1,0) |
SMALLINT NOT NULL |
CAREER12
1/0 Table Edit (1=True, 0=False)
|
| 12 |
SSR_HE_CAREER2 |
Number(1,0) |
SMALLINT NOT NULL |
CAREER2
1/0 Table Edit (1=True, 0=False)
|
| 13 |
SSR_HE_CAREER3 |
Number(1,0) |
SMALLINT NOT NULL |
CAREER3
1/0 Table Edit (1=True, 0=False)
|
| 14 |
SSR_HE_CAREER5 |
Number(1,0) |
SMALLINT NOT NULL |
CAREER5
1/0 Table Edit (1=True, 0=False)
|
| 15 |
SSR_HE_CAREER9 |
Number(1,0) |
SMALLINT NOT NULL |
CAREER9
1/0 Table Edit (1=True, 0=False)
|
| 16 |
SSR_HE_COURSEID |
Character(10) |
VARCHAR2(10) NOT NULL |
Course ID
Prompt Table:
SSR_HE_ACPLN_VW
|
| 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
1/0 Table Edit (1=True, 0=False)
|
| 26 |
SSR_HE_EMSPNS2 |
Number(1,0) |
SMALLINT NOT NULL |
EMSPNS2
1/0 Table Edit (1=True, 0=False)
|
| 27 |
SSR_HE_EMSPNS3 |
Number(1,0) |
SMALLINT NOT NULL |
EMSPNS3
1/0 Table Edit (1=True, 0=False)
|
| 28 |
SSR_HE_EMSPNS4 |
Number(1,0) |
SMALLINT NOT NULL |
EMSPNS4
1/0 Table Edit (1=True, 0=False)
|
| 29 |
SSR_HE_EMSPNS5 |
Number(1,0) |
SMALLINT NOT NULL |
EMSPNS5
1/0 Table Edit (1=True, 0=False)
|
| 30 |
SSR_HE_FOLLOWUP |
Character(1) |
VARCHAR2(1) NOT NULL |
FOLLOWUP
Y/N Table Edit
Default Value: N
|
| 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
Prompt Table:
SSR_HE_CODES_VW
|
| 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
Prompt Table:
SSR_HE_CODES_VW
|
| 47 |
SSR_HE_PREVWORK_1 |
Number(1,0) |
SMALLINT NOT NULL |
PREVWORK_1
1/0 Table Edit (1=True, 0=False)
|
| 48 |
SSR_HE_PREVWORK_2 |
Number(1,0) |
SMALLINT NOT NULL |
Previous Work 2
1/0 Table Edit (1=True, 0=False)
|
| 49 |
SSR_HE_PREVWORK_3 |
Number(1,0) |
SMALLINT NOT NULL |
Previous Work 3
1/0 Table Edit (1=True, 0=False)
|
| 50 |
SSR_HE_PREVWORK_4 |
Number(1,0) |
SMALLINT NOT NULL |
Previous Work 4
1/0 Table Edit (1=True, 0=False)
|
| 51 |
SSR_HE_PREVWORK_5 |
Number(1,0) |
SMALLINT NOT NULL |
Previous Work 5
1/0 Table Edit (1=True, 0=False)
|
| 52 |
SSR_HE_PREVWORK_6 |
Number(1,0) |
SMALLINT NOT NULL |
Previous Work 6
1/0 Table Edit (1=True, 0=False)
|
| 53 |
SSR_HE_PREVWORK_7 |
Number(1,0) |
SMALLINT NOT NULL |
Previous Work 7
1/0 Table Edit (1=True, 0=False)
|
| 54 |
SSR_HE_ALLACT_1 |
Number(1,0) |
SMALLINT NOT NULL |
All activities 1
1/0 Table Edit (1=True, 0=False)
|
| 55 |
SSR_HE_ALLACT_2 |
Number(1,0) |
SMALLINT NOT NULL |
All activities 2
1/0 Table Edit (1=True, 0=False)
|
| 56 |
SSR_HE_ALLACT_3 |
Number(1,0) |
SMALLINT NOT NULL |
All activities 3
1/0 Table Edit (1=True, 0=False)
|
| 57 |
SSR_HE_ALLACT_4 |
Number(1,0) |
SMALLINT NOT NULL |
All activities 4
1/0 Table Edit (1=True, 0=False)
|
| 58 |
SSR_HE_ALLACT_5 |
Number(1,0) |
SMALLINT NOT NULL |
All activities 5
1/0 Table Edit (1=True, 0=False)
|
| 59 |
SSR_HE_ALLACT_6 |
Number(1,0) |
SMALLINT NOT NULL |
All activities 6
1/0 Table Edit (1=True, 0=False)
|
| 60 |
SSR_HE_ALLACT_7 |
Number(1,0) |
SMALLINT NOT NULL |
All activities 7
1/0 Table Edit (1=True, 0=False)
|
| 61 |
SSR_HE_ALLACT_8 |
Number(1,0) |
SMALLINT NOT NULL |
All activities 8
1/0 Table Edit (1=True, 0=False)
|
| 62 |
SSR_HE_PREVCAT1 |
Number(1,0) |
SMALLINT NOT NULL |
PREVCAT1
1/0 Table Edit (1=True, 0=False)
|
| 63 |
SSR_HE_PREVCAT2 |
Number(1,0) |
SMALLINT NOT NULL |
PREVCAT2
1/0 Table Edit (1=True, 0=False)
|
| 64 |
SSR_HE_PREVCAT3 |
Number(1,0) |
SMALLINT NOT NULL |
PREVCAT3
1/0 Table Edit (1=True, 0=False)
|
| 65 |
SSR_HE_PREVCAT4 |
Number(1,0) |
SMALLINT NOT NULL |
PREVCAT4
1/0 Table Edit (1=True, 0=False)
|
| 66 |
SSR_HE_PREVCAT5 |
Number(1,0) |
SMALLINT NOT NULL |
PREVCAT5
1/0 Table Edit (1=True, 0=False)
|
| 67 |
SSR_HE_PREVCAT6 |
Number(1,0) |
SMALLINT NOT NULL |
PREVCAT6
1/0 Table Edit (1=True, 0=False)
|
| 68 |
SSR_HE_PREVEMP |
Character(1) |
VARCHAR2(1) NOT NULL |
PREVEMP
1=1
2=2
3=3
4=4
|
| 69 |
SSR_HE_PROFSOCT |
Character(5) |
VARCHAR2(5) NOT NULL |
PROFSOCT
Prompt Table:
SSR_HE_CODES_VW
|
| 70 |
SSR_HE_PT_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
PT FLAG
Y/N Table Edit
|
| 71 |
SSR_HE_QTS_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
QTS FLAG
Y/N Table Edit
|
| 72 |
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
|
| 73 |
SSR_HE_SALARY |
Number(20,2) |
DECIMAL(19,2) NOT NULL |
SALARY
|
| 74 |
SSR_HE_SALARY_NO |
Character(1) |
VARCHAR2(1) NOT NULL |
SALARY NO
1=Do not wish
Default Value: 0
|
| 75 |
SSR_HE_SECINT1 |
Number(1,0) |
SMALLINT NOT NULL |
SSR_HE_SECINT1
1/0 Table Edit (1=True, 0=False)
|
| 76 |
SSR_HE_SECINT2 |
Number(1,0) |
SMALLINT NOT NULL |
SSR_HE_SECINT2
1/0 Table Edit (1=True, 0=False)
|
| 77 |
SSR_HE_MODSTUDY |
Character(1) |
VARCHAR2(1) NOT NULL |
MODSTUDY
1=Yes - full-time
2=Yes - part-time
3=No
|
| 78 |
SSR_HE_MODE |
Character(2) |
VARCHAR2(2) NOT NULL |
MODE
Prompt Table:
SSR_HE_CODES_VW
|
| 79 |
SSR_HE_SECINT3 |
Number(1,0) |
SMALLINT NOT NULL |
SSR_HE_SECINT3
1/0 Table Edit (1=True, 0=False)
|
| 80 |
SSR_HE_SECINT4 |
Number(1,0) |
SMALLINT NOT NULL |
SSR_HE_SECINT4
1/0 Table Edit (1=True, 0=False)
|
| 81 |
SSR_HE_SECINT5 |
Number(1,0) |
SMALLINT NOT NULL |
SSR_HE_SECINT5
1/0 Table Edit (1=True, 0=False)
|
| 82 |
SSR_HE_SIC2007 |
Character(4) |
VARCHAR2(4) NOT NULL |
Industrial Classification Code
Prompt Table:
SSR_HE_CODES_VW
|
| 83 |
SSR_HE_SOCDLHE |
Character(5) |
VARCHAR2(5) NOT NULL |
Select an Occupation Code
Prompt Table:
SSR_HE_CODES_VW
|
| 84 |
SSR_HE_SECINT6 |
Number(1,0) |
SMALLINT NOT NULL |
SSR_HE_SECINT6
1/0 Table Edit (1=True, 0=False)
|
| 85 |
SSR_HE_SECINT7 |
Number(1,0) |
SMALLINT NOT NULL |
SSR_HE_SECINT7
1/0 Table Edit (1=True, 0=False)
|
| 86 |
SSR_HE_SECINT9 |
Number(1,0) |
SMALLINT NOT NULL |
SSR_HE_SECINT9
1/0 Table Edit (1=True, 0=False)
|
| 87 |
SSR_HE_SURV_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Survey Status
C=Coded
D=Duplicate
E=Excluded
L=Saved
N=New
S=Submitted
|
| 88 |
SSR_HE_TCHEMP |
Character(1) |
VARCHAR2(1) NOT NULL |
Employed as teacher
1=Yes
2=No
3=Yes
4=No
|
| 89 |
SSR_HE_TEACHFUND |
Character(1) |
VARCHAR2(1) NOT NULL |
Teaching funded
1=State
2=Both
3=Non-state
4=Not known
|
| 90 |
SSR_HE_TCHSEEK |
Character(1) |
VARCHAR2(1) NOT NULL |
Seeking a teaching post
1=Yes
2=No
|
| 91 |
SSR_HE_TEACHPHS |
Character(1) |
VARCHAR2(1) NOT NULL |
Teaching phase
1=1
2=2
3=3
4=4
|
| 92 |
SSR_HE_TEACHSCT |
Character(1) |
VARCHAR2(1) NOT NULL |
SSR_HE_TEACHSCT
1=1
2=2
3=3
4=4
|
| 93 |
SSR_HE_TTCID |
Character(2) |
VARCHAR2(2) NOT NULL |
Teacher Training Course
Prompt Table:
SSR_HE_CODES_VW
|
| 94 |
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
|
| 95 |
SSR_HE_MIMPACT |
Character(1) |
VARCHAR2(1) NOT NULL |
Most important activity
1=1
2=2
3=3
4=4
5=5
6=6
7=7
8=8
|
| 96 |
SSR_HE_JOBSNO |
Number(2,0) |
SMALLINT NOT NULL |
Number of jobs
|
| 97 |
SSR_HE_POSTDOC |
Character(1) |
VARCHAR2(1) NOT NULL |
Postdoctoral Research Contract
Prompt Table:
SSR_HE_CODES_VW
|
| 98 |
SSR_HE_EMPBASIS |
Character(2) |
VARCHAR2(2) NOT NULL |
Employment basis
01=01
02=02
03=03
04=04
05=05
06=06
07=07
08=08
09=09
10=10
11=11
|
| 99 |
SSR_HE_EMPUNPAID |
Number(1,0) |
SMALLINT NOT NULL |
Unpaid Work
1/0 Table Edit (1=True, 0=False)
|
| 100 |
SSR_HE_PTHOURS |
Number(5,2) |
DECIMAL(4,2) NOT NULL |
Part-time hours
|
| 101 |
SSR_HE_ESTEARN |
Number(7,0) |
INTEGER NOT NULL |
Estimated earnings
|
| 102 |
SSR_HE_EMPCOUNTRY |
Character(2) |
VARCHAR2(2) NOT NULL |
Employment Country
Prompt Table:
SSR_HE_CODES_VW
|
| 103 |
SSR_HE_JOBRSNALL_1 |
Number(1,0) |
SMALLINT NOT NULL |
Job reason 1
1/0 Table Edit (1=True, 0=False)
|
| 104 |
SSR_HE_JOBRSNALL_2 |
Number(1,0) |
SMALLINT NOT NULL |
Job reason 2
1/0 Table Edit (1=True, 0=False)
|
| 105 |
SSR_HE_JOBRSNALL_3 |
Number(1,0) |
SMALLINT NOT NULL |
Job reason 3
1/0 Table Edit (1=True, 0=False)
|
| 106 |
SSR_HE_JOBRSNALL_4 |
Number(1,0) |
SMALLINT NOT NULL |
Job reason 4
1/0 Table Edit (1=True, 0=False)
|
| 107 |
SSR_HE_JOBRSNALL_5 |
Number(1,0) |
SMALLINT NOT NULL |
Job reason 5
1/0 Table Edit (1=True, 0=False)
|
| 108 |
SSR_HE_JOBRSNALL_6 |
Number(1,0) |
SMALLINT NOT NULL |
Job reason 6
1/0 Table Edit (1=True, 0=False)
|
| 109 |
SSR_HE_JOBRSNALL_7 |
Number(1,0) |
SMALLINT NOT NULL |
Job reason 7
1/0 Table Edit (1=True, 0=False)
|
| 110 |
SSR_HE_JOBRSNALL_8 |
Number(1,0) |
SMALLINT NOT NULL |
Job reason 8
1/0 Table Edit (1=True, 0=False)
|
| 111 |
SSR_HE_JOBRSNALL_9 |
Number(1,0) |
SMALLINT NOT NULL |
Job reason 9
1/0 Table Edit (1=True, 0=False)
|
| 112 |
SSR_HE_JOBRSNMAIN |
Character(2) |
VARCHAR2(2) NOT NULL |
Main reason
01=01
02=02
03=03
04=04
05=05
06=06
07=07
08=08
09=09
|
| 113 |
SSR_HE_GTCSTIS |
Character(1) |
VARCHAR2(1) NOT NULL |
GTC Scotland Teach Indc Scheme
1=Yes
2=No
|
| 114 |
SSR_HE_JACS |
Character(4) |
VARCHAR2(4) NOT NULL |
JACS Subject
Prompt Table:
SSR_HE_CODES_VW
|
| 115 |
SSR_HE_UCNAME |
Character(50) |
VARCHAR2(50) NOT NULL |
Institution Name
|
| 116 |
SSR_HE_UCPROV |
Character(1) |
VARCHAR2(1) NOT NULL |
Institution Providing Study
Prompt Table:
SSR_HE_CODES_VW
|
| 117 |
SSR_HE_HEBUSNEXP |
Character(1) |
VARCHAR2(1) NOT NULL |
HE experience for business
1=Very well
2=Well
3=Not very well
4=Not at all
5=Can't tell
6=Unable to code
|
| 118 |
SSR_HE_HESTUDYEXP |
Character(1) |
VARCHAR2(1) NOT NULL |
HE experience for study
1=Very well
2=Well
3=Not very well
4=Not at all
5=Can't tell
6=Unable to code
|
| 119 |
SSR_HE_HEWORKEXP |
Character(1) |
VARCHAR2(1) NOT NULL |
HE experience for work
1=Very well
2=Well
3=Not very well
4=Not at all
5=Can't tell
6=Unable to code
|
| 120 |
SSR_HE_COURSENO |
Number(2,0) |
SMALLINT NOT NULL |
Number of courses
|
| 121 |
SSR_HE_JACS_S2 |
Character(4) |
VARCHAR2(4) NOT NULL |
JACS Subject 2
Prompt Table:
SSR_HE_CODES_VW
|
| 122 |
SSR_HE_JACS_S3 |
Character(4) |
VARCHAR2(4) NOT NULL |
JACS Subject 3
Prompt Table:
SSR_HE_CODES_VW
|
| 123 |
SSR_HE_CURRENCY |
Character(1) |
VARCHAR2(1) NOT NULL |
Currency
1=Pounds sterling
2=Other
|
| 124 |
SSR_HE_PERIOD |
Character(1) |
VARCHAR2(1) NOT NULL |
Currency
1=Annually
2=Monthly
3=Weekly
4=Hourly
5=Other
|
| 125 |
SSR_HE_FNAMES |
Character(100) |
VARCHAR2(100) NOT NULL |
Forenames
|
| 126 |
SSR_HE_SURNAME |
Character(100) |
VARCHAR2(100) NOT NULL |
Surname
|
| 127 |
SSR_HE_GRADSTATUS |
Character(2) |
VARCHAR2(2) NOT NULL |
Graduate Status
Prompt Table:
SSR_HE_CODES_VW
|
| 128 |
SSR_HE_HOMEEUOS |
Character(1) |
VARCHAR2(1) NOT NULL |
HESA Home/EU/Overseas
1=Home
2=EU
3=Overseas
4=Not known
|