| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table:
PEOPLE_SRCH
|
| 2 |
INSTITUTION |
Character(5) |
VARCHAR2(5) NOT NULL |
Academic Institution
Default Value: OPR_DEF_TBL_CS.INSTITUTION
Prompt Table:
INSTITUTION_TBL
|
| 3 |
AID_YEAR |
Character(4) |
VARCHAR2(4) NOT NULL |
Aid Year
Default Value: OPR_DEF_TBL_CS.AID_YEAR
Prompt Table:
STUDENT_AID
|
| 4 |
ACAD_CAREER |
Character(4) |
VARCHAR2(4) NOT NULL |
Academic Career
BAC=Bachelor (NLD)
BBL=Vocational Coaching (NLD)
BOL=Vocational Training (NLD)
BUSN=Graduate Business
CNED=Continuing Education
CRED=Semester Credit
EDU=Education (NLD)
EXED=Extended Education
GRAD=Graduate
LAW=Law
MEDS=Medical School
NONA=Non Award
PGRD=Postgraduate
RSCH=Research
TECH=Technical
UENG=Undergraduate Engineering
UGRD=Undergraduate
VAVO=Advanced General Educ. (NLD)
VETM=Veterinary Medicine
Prompt Table:
STDNT_CR_TRM_VW
|
| 5 |
VARIABLE_CHAR1 |
Character(20) |
VARCHAR2(20) NOT NULL |
User Variable Character #1
|
| 6 |
VARIABLE_CHAR10 |
Character(20) |
VARCHAR2(20) NOT NULL |
User Variable Character #10
|
| 7 |
VARIABLE_CHAR2 |
Character(20) |
VARCHAR2(20) NOT NULL |
User Variable Character #2
|
| 8 |
VARIABLE_CHAR3 |
Character(20) |
VARCHAR2(20) NOT NULL |
User Variable Character #3
|
| 9 |
VARIABLE_CHAR4 |
Character(20) |
VARCHAR2(20) NOT NULL |
User Variable Character #4
|
| 10 |
VARIABLE_CHAR5 |
Character(20) |
VARCHAR2(20) NOT NULL |
User Variable Character #5
|
| 11 |
VARIABLE_CHAR6 |
Character(20) |
VARCHAR2(20) NOT NULL |
User Variable Character #6
|
| 12 |
VARIABLE_CHAR7 |
Character(20) |
VARCHAR2(20) NOT NULL |
User Variable Character #7
|
| 13 |
VARIABLE_CHAR8 |
Character(20) |
VARCHAR2(20) NOT NULL |
User Variable Character #8
|
| 14 |
VARIABLE_CHAR9 |
Character(20) |
VARCHAR2(20) NOT NULL |
User Variable Character #9
|
| 15 |
VARIABLE_FLAG1 |
Character(1) |
VARCHAR2(1) NOT NULL |
User Variable Y/N Flag #1
Y/N Table Edit
Default Value: N
|
| 16 |
VARIABLE_FLAG10 |
Character(1) |
VARCHAR2(1) NOT NULL |
User Variable Y/N Flag #10
Y/N Table Edit
Default Value: N
|
| 17 |
VARIABLE_FLAG2 |
Character(1) |
VARCHAR2(1) NOT NULL |
User Variable Y/N Flag #2
Y/N Table Edit
Default Value: N
|
| 18 |
VARIABLE_FLAG3 |
Character(1) |
VARCHAR2(1) NOT NULL |
User Variable Y/N Flag #3
Y/N Table Edit
Default Value: N
|
| 19 |
VARIABLE_FLAG4 |
Character(1) |
VARCHAR2(1) NOT NULL |
User Variable Y/N Flag #4
Y/N Table Edit
Default Value: N
|
| 20 |
VARIABLE_FLAG5 |
Character(1) |
VARCHAR2(1) NOT NULL |
User Variable Y/N Flag #5
Y/N Table Edit
Default Value: N
|
| 21 |
VARIABLE_FLAG6 |
Character(1) |
VARCHAR2(1) NOT NULL |
User Variable Y/N Flag #6
Y/N Table Edit
Default Value: N
|
| 22 |
VARIABLE_FLAG7 |
Character(1) |
VARCHAR2(1) NOT NULL |
User Variable Y/N Flag #7
Y/N Table Edit
Default Value: N
|
| 23 |
VARIABLE_FLAG8 |
Character(1) |
VARCHAR2(1) NOT NULL |
User Variable Y/N Flag #8
Y/N Table Edit
Default Value: N
|
| 24 |
VARIABLE_FLAG9 |
Character(1) |
VARCHAR2(1) NOT NULL |
User Variable Y/N Flag #9
Y/N Table Edit
Default Value: N
|
| 25 |
VARIABLE_NUM1 |
Number(16,3) |
DECIMAL(15,3) NOT NULL |
User Variable Numeric #1
|
| 26 |
VARIABLE_NUM10 |
Number(16,3) |
DECIMAL(15,3) NOT NULL |
User Variable Numeric #10
|
| 27 |
VARIABLE_NUM2 |
Number(16,3) |
DECIMAL(15,3) NOT NULL |
User Variable Numerice #2
|
| 28 |
VARIABLE_NUM3 |
Number(16,3) |
DECIMAL(15,3) NOT NULL |
User Variable Numeric #3
|
| 29 |
VARIABLE_NUM4 |
Number(16,3) |
DECIMAL(15,3) NOT NULL |
User Variable Numeric #4
|
| 30 |
VARIABLE_NUM5 |
Number(16,3) |
DECIMAL(15,3) NOT NULL |
User Variable Numeric #5
|
| 31 |
VARIABLE_NUM6 |
Number(16,3) |
DECIMAL(15,3) NOT NULL |
User Variable Numeric #6
|
| 32 |
VARIABLE_NUM7 |
Number(16,3) |
DECIMAL(15,3) NOT NULL |
User Variable Numeric #7
|
| 33 |
VARIABLE_NUM8 |
Number(16,3) |
DECIMAL(15,3) NOT NULL |
User Variable Numeric #8
|
| 34 |
VARIABLE_NUM9 |
Number(16,3) |
DECIMAL(15,3) NOT NULL |
User Variable Numeric #9
|
| 35 |
RATING_CMP1 |
Character(5) |
VARCHAR2(5) NOT NULL |
Rating Component #1
Prompt Table:
RTNG_CMPDEF_TBL
|
| 36 |
RATING_CMP2 |
Character(5) |
VARCHAR2(5) NOT NULL |
Rating Component #2
Prompt Table:
RTNG_CMPDEF_TBL
|
| 37 |
RATING_CMP3 |
Character(5) |
VARCHAR2(5) NOT NULL |
Rating Component #3
Prompt Table:
RTNG_CMPDEF_TBL
|
| 38 |
RATING_CMP4 |
Character(5) |
VARCHAR2(5) NOT NULL |
Rating Component #4
Prompt Table:
RTNG_CMPDEF_TBL
|
| 39 |
RATING_CMP5 |
Character(5) |
VARCHAR2(5) NOT NULL |
Rating Component #5
Prompt Table:
RTNG_CMPDEF_TBL
|
| 40 |
RATING_CMP6 |
Character(5) |
VARCHAR2(5) NOT NULL |
Rating Component #6
Prompt Table:
RTNG_CMPDEF_TBL
|
| 41 |
RATING_CMP7 |
Character(5) |
VARCHAR2(5) NOT NULL |
Rating Component #7
Prompt Table:
RTNG_CMPDEF_TBL
|
| 42 |
RATING_CMP8 |
Character(5) |
VARCHAR2(5) NOT NULL |
Rating Component #8
Prompt Table:
RTNG_CMPDEF_TBL
|
| 43 |
RATING_CMP9 |
Character(5) |
VARCHAR2(5) NOT NULL |
Rating Component #9
Prompt Table:
RTNG_CMPDEF_TBL
|
| 44 |
RATING_CMP10 |
Character(5) |
VARCHAR2(5) NOT NULL |
Rating Component #10
Prompt Table:
RTNG_CMPDEF_TBL
|
| 45 |
RATING_CMP11 |
Character(5) |
VARCHAR2(5) NOT NULL |
Rating Component #11
Prompt Table:
RTNG_CMPDEF_TBL
|
| 46 |
RATING_CMP12 |
Character(5) |
VARCHAR2(5) NOT NULL |
Rating Component #12
Prompt Table:
RTNG_CMPDEF_TBL
|
| 47 |
RATING_CMP13 |
Character(5) |
VARCHAR2(5) NOT NULL |
Rating Component #13
Prompt Table:
RTNG_CMPDEF_TBL
|
| 48 |
RATING_CMP14 |
Character(5) |
VARCHAR2(5) NOT NULL |
Rating Component #14
Prompt Table:
RTNG_CMPDEF_TBL
|
| 49 |
RATING_CMP15 |
Character(5) |
VARCHAR2(5) NOT NULL |
Rating Component #15
Prompt Table:
RTNG_CMPDEF_TBL
|
| 50 |
RATING_CMP16 |
Character(5) |
VARCHAR2(5) NOT NULL |
Rating Component #16
Prompt Table:
RTNG_CMPDEF_TBL
|
| 51 |
RATING_CMP17 |
Character(5) |
VARCHAR2(5) NOT NULL |
Rating Component #17
Prompt Table:
RTNG_CMPDEF_TBL
|
| 52 |
RATING_CMP18 |
Character(5) |
VARCHAR2(5) NOT NULL |
Rating Component #18
Prompt Table:
RTNG_CMPDEF_TBL
|
| 53 |
RATING_CMP19 |
Character(5) |
VARCHAR2(5) NOT NULL |
Rating Component #19
Prompt Table:
RTNG_CMPDEF_TBL
|
| 54 |
RATING_CMP20 |
Character(5) |
VARCHAR2(5) NOT NULL |
Rating Component #20
Prompt Table:
RTNG_CMPDEF_TBL
|
| 55 |
RATING_CMP_VALUE1 |
Number(10,4) |
DECIMAL(9,4) NOT NULL |
Rating Value #1
|
| 56 |
RATING_CMP_VALUE2 |
Number(10,4) |
DECIMAL(9,4) NOT NULL |
Rating Value #2
|
| 57 |
RATING_CMP_VALUE3 |
Number(10,4) |
DECIMAL(9,4) NOT NULL |
Rating Value #3
|
| 58 |
RATING_CMP_VALUE4 |
Number(10,4) |
DECIMAL(9,4) NOT NULL |
Rating Value #4
|
| 59 |
RATING_CMP_VALUE5 |
Number(10,4) |
DECIMAL(9,4) NOT NULL |
Rating Value #5
|
| 60 |
RATING_CMP_VALUE6 |
Number(10,4) |
DECIMAL(9,4) NOT NULL |
Rating Value #6
|
| 61 |
RATING_CMP_VALUE7 |
Number(10,4) |
DECIMAL(9,4) NOT NULL |
Rating Value #7
|
| 62 |
RATING_CMP_VALUE8 |
Number(10,4) |
DECIMAL(9,4) NOT NULL |
Rating Value #8
|
| 63 |
RATING_CMP_VALUE9 |
Number(10,4) |
DECIMAL(9,4) NOT NULL |
Rating Value #9
|
| 64 |
RATING_CMP_VALUE10 |
Number(10,4) |
DECIMAL(9,4) NOT NULL |
Rating Value #10
|
| 65 |
RATING_CMP_VALUE11 |
Number(10,4) |
DECIMAL(9,4) NOT NULL |
Rating Value #11
|
| 66 |
RATING_CMP_VALUE12 |
Number(10,4) |
DECIMAL(9,4) NOT NULL |
Rating Value #12
|
| 67 |
RATING_CMP_VALUE13 |
Number(10,4) |
DECIMAL(9,4) NOT NULL |
Rating Value #13
|
| 68 |
RATING_CMP_VALUE14 |
Number(10,4) |
DECIMAL(9,4) NOT NULL |
Rating Value #14
|
| 69 |
RATING_CMP_VALUE15 |
Number(10,4) |
DECIMAL(9,4) NOT NULL |
Rating Value #15
|
| 70 |
RATING_CMP_VALUE16 |
Number(10,4) |
DECIMAL(9,4) NOT NULL |
Rating Value #16
|
| 71 |
RATING_CMP_VALUE17 |
Number(10,4) |
DECIMAL(9,4) NOT NULL |
Rating Value #17
|
| 72 |
RATING_CMP_VALUE18 |
Number(10,4) |
DECIMAL(9,4) NOT NULL |
Rating Value #18
|
| 73 |
RATING_CMP_VALUE19 |
Number(10,4) |
DECIMAL(9,4) NOT NULL |
Rating Value #19
|
| 74 |
RATING_CMP_VALUE20 |
Number(10,4) |
DECIMAL(9,4) NOT NULL |
Rating Value #20
|