| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 2 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 3 |
ACAD_PROG |
Character(5) |
VARCHAR2(5) NOT NULL |
Academic Program
|
| 4 |
ACAD_PLAN |
Character(10) |
VARCHAR2(10) NOT NULL |
Academic Plan
|
| 5 |
ACAD_SUB_PLAN |
Character(10) |
VARCHAR2(10) NOT NULL |
Academic Sub-Plan
|
| 6 |
SSR_STAD_LTRGRPT |
Character(2) |
VARCHAR2(2) NOT NULL |
Student Assignment letter group to
|
| 7 |
SSR_STAD_LTRGRPF |
Character(2) |
VARCHAR2(2) NOT NULL |
Student advisor Assignment letter group from
|
| 8 |
COUNT1 |
Number(12,0) |
DECIMAL(12) NOT NULL |
AUS WGEA counts
|
| 9 |
ADVISOR |
Character(1) |
VARCHAR2(1) NOT NULL |
Advisor
|