| # |
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 |
SSR_HE_RET_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Return Name
Prompt Table:
SSR_HE_DLHERTVW
|
| 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 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table:
SSR_HE_PPL_SRCH
|
| 5 |
SSR_HE_SURNAME |
Character(100) |
VARCHAR2(100) NOT NULL |
Surname
|
| 6 |
SSR_HE_FNAMES |
Character(100) |
VARCHAR2(100) NOT NULL |
Forenames
|
| 7 |
SSR_HE_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Staging Status
E=Error
I=Imported
N=New
O=Obsolete
P=Pending
|
| 8 |
SSR_HE_EMPCOUNTRY |
Character(2) |
VARCHAR2(2) NOT NULL |
Employment Country
|
| 9 |
SSR_HE_HUSID |
Character(17) |
VARCHAR2(17) NOT NULL |
HUSID
|
| 10 |
SSR_HE_NUMHUS |
Character(10) |
VARCHAR2(10) NOT NULL |
NUMHUS
|
| 11 |
SSR_HE_MODE |
Character(2) |
VARCHAR2(2) NOT NULL |
MODE
Prompt Table:
SSR_HE_CODES_VW
|
| 12 |
SSR_HE_COURSEID |
Character(10) |
VARCHAR2(10) NOT NULL |
Course ID
Prompt Table:
SSR_HE_ACPLN_VW
|
| 13 |
SSR_HE_TTCID |
Character(2) |
VARCHAR2(2) NOT NULL |
Teacher Training Course
Prompt Table:
SSR_HE_CODES_VW
|
| 14 |
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
|
| 15 |
STDNT_CAR_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Student Career Nbr
Prompt Table:
SSR_HE_CNBR_VW
|
| 16 |
SSR_HE_METHOD |
Character(2) |
VARCHAR2(2) NOT NULL |
METHOD
Prompt Table:
SSR_HE_CODES_VW
|
| 17 |
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
|
| 18 |
SSR_HE_EMAILID |
Character(80) |
VARCHAR2(80) NOT NULL |
Email Address
|
| 19 |
SSR_HE_ADDRESS1 |
Character(50) |
VARCHAR2(50) NOT NULL |
Address 1
|
| 20 |
SSR_HE_ADDRESS2 |
Character(50) |
VARCHAR2(50) NOT NULL |
Address 2
|
| 21 |
SSR_HE_ADDRESS3 |
Character(50) |
VARCHAR2(50) NOT NULL |
Address 3
|
| 22 |
SSR_HE_COMP_STATUS |
Character(2) |
VARCHAR2(2) NOT NULL |
Completion Status
|
| 23 |
SSR_HE_COUNTRY |
Character(50) |
VARCHAR2(50) NOT NULL |
Country
|
| 24 |
SSR_HE_COUNTY |
Character(50) |
VARCHAR2(50) NOT NULL |
County/Region/State
|
| 25 |
SSR_HE_CRSE_STD |
Character(254) |
VARCHAR2(254) NOT NULL |
Course Studied
|
| 26 |
SSR_HE_INCOMP_SECT |
Character(1) |
VARCHAR2(1) NOT NULL |
Incomplete Section
|
| 27 |
SSR_HE_PIN |
Character(10) |
VARCHAR2(10) NOT NULL |
PIN Number
|
| 28 |
SSR_HE_POSTCODE |
Character(8) |
VARCHAR2(8) NOT NULL |
Postcode
|
| 29 |
SSR_HE_TELEPHONE |
Character(30) |
VARCHAR2(30) NOT NULL |
Telephone
|
| 30 |
SSR_HE_TIMESTAMP |
Character(23) |
VARCHAR2(23) NOT NULL |
Timestamp
|
| 31 |
SSR_HE_TOWNCITY |
Character(50) |
VARCHAR2(50) NOT NULL |
Town/City
|
| 32 |
SSR_HE_ALLACT_1 |
Number(1,0) |
SMALLINT NOT NULL |
All activities 1
|
| 33 |
SSR_HE_ALLACT_2 |
Number(1,0) |
SMALLINT NOT NULL |
All activities 2
|
| 34 |
SSR_HE_ALLACT_3 |
Number(1,0) |
SMALLINT NOT NULL |
All activities 3
|
| 35 |
SSR_HE_ALLACT_4 |
Number(1,0) |
SMALLINT NOT NULL |
All activities 4
|
| 36 |
SSR_HE_ALLACT_5 |
Number(1,0) |
SMALLINT NOT NULL |
All activities 5
|
| 37 |
SSR_HE_ALLACT_6 |
Number(1,0) |
SMALLINT NOT NULL |
All activities 6
|
| 38 |
SSR_HE_ALLACT_7 |
Number(1,0) |
SMALLINT NOT NULL |
All activities 7
|
| 39 |
SSR_HE_ALLACT_8 |
Number(1,0) |
SMALLINT NOT NULL |
All activities 8
|
| 40 |
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
|
| 41 |
SSR_HE_JOBDUTIES |
Character(200) |
VARCHAR2(200) NOT NULL |
JOBDUTIES
|
| 42 |
SSR_HE_JOBSNO |
Number(2,0) |
SMALLINT NOT NULL |
Number of jobs
|
| 43 |
SSR_HE_JOBTITLE |
Character(60) |
VARCHAR2(60) NOT NULL |
JOBTITLE
|
| 44 |
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
|
| 45 |
SSR_HE_EMPUNPAID |
Number(1,0) |
SMALLINT NOT NULL |
Unpaid Work
|
| 46 |
SSR_HE_EMPNAME |
Character(60) |
VARCHAR2(60) NOT NULL |
EMPNAME
|
| 47 |
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
|
| 48 |
SSR_HE_SALARY |
Number(20,2) |
DECIMAL(19,2) NOT NULL |
SALARY
|
| 49 |
SSR_HE_PTHOURS |
Number(5,2) |
DECIMAL(4,2) NOT NULL |
Part-time hours
|
| 50 |
SSR_HE_ESTEARN |
Number(7,0) |
INTEGER NOT NULL |
Estimated earnings
|
| 51 |
SSR_HE_MAKEDO |
Character(60) |
VARCHAR2(60) NOT NULL |
MAKEDO
|
| 52 |
SSR_HE_LOCEMP_AREA |
Character(200) |
VARCHAR2(200) NOT NULL |
LOCEMP
|
| 53 |
SSR_HE_LOCEMP_PCDE |
Character(8) |
VARCHAR2(8) NOT NULL |
PCDE
|
| 54 |
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
|
| 55 |
SSR_HE_JOBRSNALL_1 |
Number(1,0) |
SMALLINT NOT NULL |
Job reason 1
|
| 56 |
SSR_HE_JOBRSNALL_2 |
Number(1,0) |
SMALLINT NOT NULL |
Job reason 2
|
| 57 |
SSR_HE_JOBRSNALL_3 |
Number(1,0) |
SMALLINT NOT NULL |
Job reason 3
|
| 58 |
SSR_HE_JOBRSNALL_4 |
Number(1,0) |
SMALLINT NOT NULL |
Job reason 4
|
| 59 |
SSR_HE_JOBRSNALL_5 |
Number(1,0) |
SMALLINT NOT NULL |
Job reason 5
|
| 60 |
SSR_HE_JOBRSNALL_6 |
Number(1,0) |
SMALLINT NOT NULL |
Job reason 6
|
| 61 |
SSR_HE_JOBRSNALL_7 |
Number(1,0) |
SMALLINT NOT NULL |
Job reason 7
|
| 62 |
SSR_HE_JOBRSNALL_8 |
Number(1,0) |
SMALLINT NOT NULL |
Job reason 8
|
| 63 |
SSR_HE_JOBRSNALL_9 |
Number(1,0) |
SMALLINT NOT NULL |
Job reason 9
|
| 64 |
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
|
| 65 |
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
|
| 66 |
SSR_HE_PREVEMP |
Character(1) |
VARCHAR2(1) NOT NULL |
PREVEMP
1=1
2=2
3=3
4=4
|
| 67 |
SSR_HE_PREVWORK_1 |
Number(1,0) |
SMALLINT NOT NULL |
PREVWORK_1
|
| 68 |
SSR_HE_PREVWORK_2 |
Number(1,0) |
SMALLINT NOT NULL |
Previous Work 2
|
| 69 |
SSR_HE_PREVWORK_3 |
Number(1,0) |
SMALLINT NOT NULL |
Previous Work 3
|
| 70 |
SSR_HE_PREVWORK_4 |
Number(1,0) |
SMALLINT NOT NULL |
Previous Work 4
|
| 71 |
SSR_HE_PREVWORK_5 |
Number(1,0) |
SMALLINT NOT NULL |
Previous Work 5
|
| 72 |
SSR_HE_PREVWORK_6 |
Number(1,0) |
SMALLINT NOT NULL |
Previous Work 6
|
| 73 |
SSR_HE_PREVWORK_7 |
Number(1,0) |
SMALLINT NOT NULL |
Previous Work 7
|
| 74 |
SSR_HE_TCHEMP |
Character(1) |
VARCHAR2(1) NOT NULL |
Employed as teacher
1=Yes
2=No
3=Yes
4=No
|
| 75 |
SSR_HE_TCHSEEK |
Character(1) |
VARCHAR2(1) NOT NULL |
Seeking a teaching post
1=Yes
2=No
|
| 76 |
SSR_HE_GTCSTIS |
Character(1) |
VARCHAR2(1) NOT NULL |
GTC Scotland Teach Indc Scheme
1=Yes
2=No
|
| 77 |
SSR_HE_TEACHFUND |
Character(1) |
VARCHAR2(1) NOT NULL |
Teaching funded
1=State
2=Both
3=Non-state
4=Not known
|
| 78 |
SSR_HE_TEACHPHS |
Character(1) |
VARCHAR2(1) NOT NULL |
Teaching phase
1=1
2=2
3=3
4=4
|
| 79 |
SSR_HE_COURSENO |
Number(2,0) |
SMALLINT NOT NULL |
Number of courses
|
| 80 |
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
|
| 81 |
SSR_HE_CRSENAME |
Character(200) |
VARCHAR2(200) NOT NULL |
Course Name
|
| 82 |
SSR_HE_CRSESBJ |
Character(200) |
VARCHAR2(200) NOT NULL |
Course Subject
|
| 83 |
SSR_HE_UCNAME |
Character(50) |
VARCHAR2(50) NOT NULL |
Institution Name
|
| 84 |
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
|
| 85 |
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
|
| 86 |
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
|
| 87 |
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
|
| 88 |
SSR_HE_FOLLOWUP |
Character(1) |
VARCHAR2(1) NOT NULL |
FOLLOWUP
|
| 89 |
SSR_HE_CURRENCY |
Character(1) |
VARCHAR2(1) NOT NULL |
Currency
1=Pounds sterling
2=Other
|
| 90 |
SSR_HE_PERIOD |
Character(1) |
VARCHAR2(1) NOT NULL |
Currency
1=Annually
2=Monthly
3=Weekly
4=Hourly
5=Other
|
| 91 |
SSR_HE_NONQTS |
Character(1) |
VARCHAR2(1) NOT NULL |
Non Qualified Teacher Status
|
| 92 |
SSR_HE_OPTOUT |
Character(1) |
VARCHAR2(1) NOT NULL |
Opt Out
|
| 93 |
SSR_HE_NHSORG |
Character(1) |
VARCHAR2(1) NOT NULL |
NHSORG
1=Yes
2=No
8=Don't know
|