INSTITUTIONSSR_HE_RET_NAMEEMPLIDSSR_HE_NUMHUS1=April Survey
1=April Survey
2=January Survey
2=January Survey
A=December Survey
B=March Survey
C=June Survey
D=September Survey
1=Home
2=EU
3=Overseas
4=Not known
SSR_HE_IMTP_STG(SQL Table) |
Index Back |
|---|---|
DLHE IMPORT STAGEDLHE IMPORT STAGE REC |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL | Academic Institution |
| 2 | SSR_HE_RET_NAME |
Character(30) | VARCHAR2(30) NOT NULL | Return Name |
| 3 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 4 | SSR_HE_NUMHUS |
Character(10) | VARCHAR2(10) NOT NULL | NUMHUS |
| 5 | SSR_HE_HUSID | Character(17) | VARCHAR2(17) NOT NULL | HUSID |
| 6 | SSR_HE_COURSEID | Character(10) | VARCHAR2(10) NOT NULL | Course ID |
| 7 | SSR_HE_MODE | Character(2) | VARCHAR2(2) NOT NULL | MODE |
| 8 | SSR_HE_TTCID | Character(2) | VARCHAR2(2) NOT NULL | Teacher Training Course |
| 9 | 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 |
| 10 | SSR_HE_FNAMES | Character(100) | VARCHAR2(100) NOT NULL | Forenames |
| 11 | SSR_HE_SURNAME | Character(100) | VARCHAR2(100) NOT NULL | Surname |
| 12 | SSR_HE_HOMEEUOS | Character(1) | VARCHAR2(1) NOT NULL |
HESA Home/EU/Overseas
1=Home 2=EU 3=Overseas 4=Not known |