EMPLIDHP_FAC_ACTV_TYPEORG=Original Research
SCH=Scholarly Research
ACTIVITY_DESCRN=Not Compensated
Y=Compensated
Default Value: N
E=External
I=Internal
Default Value: I
EG_ACTIVITIES(SQL Table) |
Index Back |
|---|---|
Administrative PostsAdministrative Posts |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | HP_FAC_ACTV_TYPE |
Character(3) | VARCHAR2(3) NOT NULL |
Faculty Activity Type
ORG=Original Research SCH=Scholarly Research |
| 3 | ACTIVITY_DESCR |
Character(50) | VARCHAR2(50) NOT NULL | Activity Description |
| 4 | FROM_DATE | Date(10) | DATE | From Date |
| 5 | THRU_DATE | Date(10) | DATE | Thru Date |
| 6 | SPONSOR | Character(50) | VARCHAR2(50) NOT NULL | Sponsor |
| 7 | COMPENSATED | Character(1) | VARCHAR2(1) NOT NULL |
Compensated
N=Not Compensated Y=Compensated Default Value: N |
| 8 | INTERNAL_EXTERNAL | Character(1) | VARCHAR2(1) NOT NULL |
Internal/External
E=External I=Internal Default Value: I |
| 9 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |
| 10 | DESCRLONG | Long Character | CLOB | Long Description |