HPEMPLTTEACH_CV(SQL View) |
Index Back |
|---|---|
HP_EMPLT_TEACH MSG ClairviaClone of HP_EMPLT_TEACH record for Clairvia Fullsync message |
| SELECT HP.EMPLID , HP.EMPL_RCD , HP.DATA_KEY1_DT , HP.HP_STATS_RPT_FLAG , HP.HP_STATS_DUTIES , HP.HP_STATS_SUBJ_CD , HP.HP_TEACHING_LOAD , HP.HP_FTTE , HP.HP_COLLAPSE_INDC FROM PS_HP_EMPLT_TEACH HP , PS_PER_ORG_ASG_INT ASG WHERE ASG.EMPLID = HP.EMPLID AND ASG.EMPL_RCD = HP.EMPL_RCD AND ASG.INT_APP_TYPE = 'SCH' AND ASG.INTEGR_PROD_CD = 'CV' AND ASG.ENROLLED_FLAG = 'Y' |
| # | 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 Record |
| 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 |