GM_ADVISEE_DATA(SQL Table) |
Index Back |
|---|---|
Instructor/Advisor tableThis table contains the instructors and advisors and the type of instructors they are. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERSONAL_DATA |
| 2 | EFFDT |
Date(10) | DATE | Effective Date |
| 3 | SEQ_NUM |
Number(3,0) | SMALLINT NOT NULL |
Sequence
Default Value: 10 |
| 4 | ADV_REC_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Advisor/Advisee Record Type
A=Advisor E=Advisee Default Value: A |
| 5 | ADVISOR_ROLE | Character(4) | VARCHAR2(4) NOT NULL |
Advisor Role
ACAD=Academic DOCT=Doctoral / Postdoc GRAD=Graduate Student OTHR=Other RSCH=Research Default Value: OTHR |
| 6 | ORG | Character(30) | VARCHAR2(30) NOT NULL |
Organization
Prompt Table: GM_INST_VW |
| 7 | EMPLID_RELATED | Character(11) | VARCHAR2(11) NOT NULL |
Related People ID
Prompt Table: GM_PERSONAL1_VW |
| 8 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
| 9 | START_DATE | Date(10) | DATE | Start Date for Gen Standing PO |
| 10 | END_DATE | Date(10) | DATE | End Date |