HP_EMPLT_TEACH(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 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr |
| 3 | DATA_KEY1_DT |
Date(10) | DATE |
Data Key Date
Default Value: %date |
| 4 | HP_STATS_RPT_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Stats-Can Report Flag
B=Both Surveys F=Full-Time Survey N=Not Applicable P=Part-Time Survey |
| 5 | HP_STATS_DUTIES | Character(2) | VARCHAR2(2) NOT NULL |
Stats-Can Duties
10=Teaching Only 20=Teaching & Othr Responsibility 30=Research |
| 6 | HP_STATS_SUBJ_CD | Character(5) | VARCHAR2(5) NOT NULL |
Principal Subject Taught
Default Value: 99999 Prompt Table: %EDITTABLE17 |
| 7 | HP_TEACHING_LOAD | Number(4,2) | DECIMAL(3,2) NOT NULL | Stats-Can Teaching Load |
| 8 | HP_FTTE | Number(4,2) | DECIMAL(3,2) NOT NULL | Full-Time Teaching Equivalent |
| 9 | HP_COLLAPSE_INDC | Character(1) | VARCHAR2(1) NOT NULL |
Collapse Into FT Job Indicator
Y/N Table Edit Default Value: N |