EMPLIDEFFDTSEQ_NUMA=Advisor
E=Advisee
ACAD=Academic
DOCT=Doctoral / Postdoc
GRAD=Graduate Student
OTHR=Other
RSCH=Research
GM_ADVISEE_VW(SQL View) |
Index Back |
|---|---|
Instructor/Advisor tableThis table contains the instructors, type of instructors and advisors. |
| select A.EMPLID ,A.EFFDT ,A.SEQ_NUM ,A.ADV_REC_TYPE ,A.ADVISOR_ROLE ,A.ORG ,A.EMPLID_RELATED ,A.NAME ,A.START_DATE ,A.END_DATE from PS_GM_ADVISEE_DATA A |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | EFFDT |
Date(10) | DATE | Effective Date |
| 3 | SEQ_NUM |
Number(3,0) | SMALLINT NOT NULL | Sequence |
| 4 | ADV_REC_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Advisor/Advisee Record Type
A=Advisor E=Advisee |
| 5 | ADVISOR_ROLE | Character(4) | VARCHAR2(4) NOT NULL |
Advisor Role
ACAD=Academic DOCT=Doctoral / Postdoc GRAD=Graduate Student OTHR=Other RSCH=Research |
| 6 | ORG | Character(30) | VARCHAR2(30) NOT NULL | Organization |
| 7 | EMPLID_RELATED | Character(11) | VARCHAR2(11) NOT NULL | Related People ID |
| 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 |