EMPLIDHP_STATS_CAN_YREG_EMPL_RCDSTART_DT1=FT Appointment < 12 Months
2=Part Time Appointment
3=Overload Apptmnt < 12 Months
1=Tenured
2=Non-Tenure on Track
3=Duties Code = 10
4=Duties Code <> 10
HP_PT_APPNTMNT(SQL Table) |
Index Back |
|---|
| # | 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 | EG_EMPL_RCD |
Character(3) | VARCHAR2(3) NOT NULL | Employment Record |
| 4 | START_DT |
Date(10) | DATE | Start Date |
| 5 | END_DT | Date(10) | DATE | end date |
| 6 | HP_PT_SALARY_PAID | Number(9,0) | DECIMAL(9) NOT NULL | Salary Paid |
| 7 | HP_APPTMNT_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Appointment Status
1=FT Appointment < 12 Months 2=Part Time Appointment 3=Overload Apptmnt < 12 Months |
| 8 | HP_PT_APPTMNT_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Type of Appointment
1=Tenured 2=Non-Tenure on Track 3=Duties Code = 10 4=Duties Code <> 10 |
| 9 | HP_STATS_SUBJ_CD | Character(5) | VARCHAR2(5) NOT NULL | Principal Subject Taught |
| 10 | HP_TEACHING_LOAD | Number(4,2) | DECIMAL(3,2) NOT NULL | Stats-Can Teaching Load |
| 11 | HP_FTTE | Number(4,2) | DECIMAL(3,2) NOT NULL | Full-Time Teaching Equivalent |