EG_RANK_TBL(SQL Table) |
Index Back |
|---|---|
Academic Rank TableAcademic Rank Table |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EG_ACADEMIC_RANK |
Character(3) | VARCHAR2(3) NOT NULL | Academic Rank |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 3 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
| 4 | EG_GROUP | Character(6) | VARCHAR2(6) NOT NULL |
Service Calculation Group
Prompt Table: EG_CALC_TEN_VW |
| 5 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 7 | DESCRLONG | Long Character | CLOB | Long Description |
| 8 | EG_RANK_IPEDS | Character(2) | VARCHAR2(2) NOT NULL |
Rank - IPEDS
1=Professor 2=Associate Professor 3=Assistant Professor 4=Instructor 5=Lecturer 6=No Academic Rank |
| 9 | EG_TRACK_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Eligible for Tenure Tracking |
| 10 | EG_REQ_PROB_PRD | Number(5,1) | DECIMAL(4,1) NOT NULL | Required Probationary Period |
| 11 | EG_AUTO_TNR_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Carry Automatic Tenure
Y/N Table Edit |
| 12 | EG_PARTIAL_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Partial Credit Allowed
Y/N Table Edit |
| 13 | 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 |