| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 2 |
HP_STATS_CAN_YR |
Number(4,0) |
SMALLINT NOT NULL |
Stats-Can Reporting Year
|
| 3 |
HP_STATS_INSTN_CD |
Number(8,0) |
INTEGER NOT NULL |
Stats Reporting Institution
|
| 4 |
HP_STATS_DEPT_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Stats-Can Dept Code
|
| 5 |
HP_STATS_SUBJ_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Principal Subject Taught
|
| 6 |
SEX |
Character(1) |
VARCHAR2(1) NOT NULL |
Gender
F=Female
M=Male
U=Unknown
X=Indeterminate/Intersex/Unspec
|
| 7 |
HP_YEAR_OF_BIRTH |
Number(4,0) |
SMALLINT NOT NULL |
Year of Birth
|
| 8 |
HP_YEAR_OF_APPTMNT |
Number(4,0) |
SMALLINT NOT NULL |
Year of Appointment
|
| 9 |
HP_PREV_EMPLYMNT |
Character(2) |
VARCHAR2(2) NOT NULL |
Previous Employment Code
01=Teaching
02=Non-Teaching
03=Teaching At Other Institution
04=Non-Teaching At Other Institn
05=Student
06=In Health Care Institution
07=Military
08=Government Dept or Agency
09=Industry or Commerce
10=Self-Employed
11=Other
99=Unknown
|
| 10 |
HP_PREV_EMPLT_LOC |
Character(5) |
VARCHAR2(5) NOT NULL |
Previous Employment Location
|
| 11 |
HP_FIRST_DEGREE_YR |
Number(4,0) |
SMALLINT NOT NULL |
Year of First Degree
|
| 12 |
HP_FIRST_DEG_PROV |
Character(5) |
VARCHAR2(5) NOT NULL |
Province of First Degree
|
| 13 |
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
|
| 14 |
HP_HIGHEST_DEG_YR |
Number(4,0) |
SMALLINT NOT NULL |
Year of Highest Degree
|
| 15 |
HP_HIGH_DEG_PROV |
Character(5) |
VARCHAR2(5) NOT NULL |
Province of Highest Degree
|
| 16 |
HP_STATS_LOC_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Stats-Can Location Code
|
| 17 |
HP_IMMIGRTN_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Stats Can Immigration Status
1=Permanent Resident
2=Resident At Time of Offer
3=Employement VISA
5=Not Applicable
9=Unknown
|
| 18 |
HP_STATS_RANK_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Stats-Can Rank Code
1=Full Professor
2=Associate Professor
3=Assistant Professor
4=Below Assistant Professor
5=Next Below Assistant Professor
6=Other
|
| 19 |
HP_STATS_RESP_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Stats-Can Responsibilty Code
0=Teaching - No other adm duties
1=Dean
2=Dean - Assit., Assoc. or Vice
3=Dir. w/ Resp./Salry = Dean
4=Director/Dept Head/Coordinator
5=Chairperson
6=Visitor - Teaching
7=Researcher - Non-Visitor
8=Researcher - Visitor
9=Asst/Assoc Dir,DptHd,Coord,Oth
|
| 20 |
HP_APPT_TO_RANK_YR |
Number(4,0) |
SMALLINT NOT NULL |
Year of Appointment to Rank
|
| 21 |
HP_MED_DENT_CAT |
Character(1) |
VARCHAR2(1) NOT NULL |
Stats-Can Med./Dental Category
0=Regular Full-Time
1=Geographic Full-Time
2=Full-Time Joint Apptmnt.
9=Not Applicable
|
| 22 |
HP_FT_APPTMNT_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Type of Appointment
1=Non-Vstng Tchg Mbr Tenured
2=Non-Vstng Tchg Mbr Non-Tenured
3=Non-Vstng Tchg Mbr Contract
4=Visiting Academic Teaching Mbr
5=Other
|
| 23 |
HP_SALARY_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Stats-Can Salary Status
1=Regular Salary Scales
2=Military/Religious Reduced
|
| 24 |
HP_ACTUAL_SALARY |
Number(9,0) |
DECIMAL(9) NOT NULL |
Actual Salary
|
| 25 |
HP_ANNUAL_SALARY |
Number(9,0) |
DECIMAL(9) NOT NULL |
Annual Salary
|
| 26 |
HP_ADMIN_STIPENDS |
Number(9,0) |
DECIMAL(9) NOT NULL |
Administrative Stipends
|
| 27 |
HP_MM_NOT_ON_LEAVE |
Number(2,0) |
SMALLINT NOT NULL |
Number of Months Not On Leave
|
| 28 |
HP_MM_ON_SABBATICL |
Number(2,0) |
SMALLINT NOT NULL |
Number of Months on Sabbatical
|
| 29 |
HP_MM_ON_OTHER_PD |
Number(2,0) |
SMALLINT NOT NULL |
Number of Months on Oth Pd Lve
|
| 30 |
HP_MM_ON_UNPAID_LV |
Number(2,0) |
SMALLINT NOT NULL |
Number of Months on Unpaid Lve
|
| 31 |
HP_REDUCED_LOAD |
Number(2,0) |
SMALLINT NOT NULL |
Percentage of Load Reduction
|
| 32 |
HP_ONT_SALARY_SRCE |
Character(2) |
VARCHAR2(2) NOT NULL |
Ontario Salary Source
|
| 33 |
HP_ONT_FINAL_SALRY |
Number(9,0) |
DECIMAL(9) NOT NULL |
Ontario Final Rate of Salary
|
| 34 |
HP_LAST_DT_CHNGD |
Date(10) |
DATE |
Last Date Changed
|
| 35 |
HP_LAST_DT_RPRTED |
Date(10) |
DATE |
Last Date Reported
|
| 36 |
HP_LAST_LOAD_DT |
Date(10) |
DATE |
Last Load Date
|