| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 INSTITUTION |
Character(5) |
VARCHAR2(5) NOT NULL |
Academic Institution
Default Value: OPR_DEF_TBL_CS.INSTITUTION
Prompt Table:
INSTITUTION_TBL
|
| 2 |
AID_YEAR |
Character(4) |
VARCHAR2(4) NOT NULL |
Aid Year
Default Value: OPR_DEF_TBL_CS.AID_YEAR
Prompt Table:
AID_YEAR_TBL
|
| 3 |
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
Default Value: OPR_DEF_TBL_CS.ACAD_CAREER
Prompt Table:
ACAD_CAR_TBL
|
| 4 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: %Date
|
| 5 |
EFF_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Effective Status
A=Active
I=Inactive
Default Value: A
|
| 6 |
RATING_CMP1 |
Character(5) |
VARCHAR2(5) NOT NULL |
Rating Component #1
Prompt Table:
%EDITTABLE
|
| 7 |
SR_FLAG1 |
Character(1) |
VARCHAR2(1) NOT NULL |
Records Rating Component
Y/N Table Edit
Default Value: N
|
| 8 |
RATING_CMP2 |
Character(5) |
VARCHAR2(5) NOT NULL |
Rating Component #2
Prompt Table:
%EDITTABLE2
|
| 9 |
SR_FLAG2 |
Character(1) |
VARCHAR2(1) NOT NULL |
Records Rating Component
Y/N Table Edit
Default Value: N
|
| 10 |
RATING_CMP3 |
Character(5) |
VARCHAR2(5) NOT NULL |
Rating Component #3
Prompt Table:
%EDITTABLE3
|
| 11 |
SR_FLAG3 |
Character(1) |
VARCHAR2(1) NOT NULL |
Records Rating Component
Y/N Table Edit
Default Value: N
|
| 12 |
RATING_CMP4 |
Character(5) |
VARCHAR2(5) NOT NULL |
Rating Component #4
Prompt Table:
%EDITTABLE4
|
| 13 |
SR_FLAG4 |
Character(1) |
VARCHAR2(1) NOT NULL |
Records Rating Component
Y/N Table Edit
Default Value: N
|
| 14 |
RATING_CMP5 |
Character(5) |
VARCHAR2(5) NOT NULL |
Rating Component #5
Prompt Table:
%EDITTABLE5
|
| 15 |
SR_FLAG5 |
Character(1) |
VARCHAR2(1) NOT NULL |
Records Rating Component
Y/N Table Edit
Default Value: N
|
| 16 |
RATING_CMP6 |
Character(5) |
VARCHAR2(5) NOT NULL |
Rating Component #6
Prompt Table:
%EDITTABLE6
|
| 17 |
SR_FLAG6 |
Character(1) |
VARCHAR2(1) NOT NULL |
Records Rating Component
Y/N Table Edit
Default Value: N
|
| 18 |
RATING_CMP7 |
Character(5) |
VARCHAR2(5) NOT NULL |
Rating Component #7
Prompt Table:
%EDITTABLE7
|
| 19 |
SR_FLAG7 |
Character(1) |
VARCHAR2(1) NOT NULL |
Records Rating Component
Y/N Table Edit
Default Value: N
|
| 20 |
RATING_CMP8 |
Character(5) |
VARCHAR2(5) NOT NULL |
Rating Component #8
Prompt Table:
%EDITTABLE8
|
| 21 |
SR_FLAG8 |
Character(1) |
VARCHAR2(1) NOT NULL |
Records Rating Component
Y/N Table Edit
Default Value: N
|
| 22 |
RATING_CMP9 |
Character(5) |
VARCHAR2(5) NOT NULL |
Rating Component #9
Prompt Table:
%EDITTABLE9
|
| 23 |
SR_FLAG9 |
Character(1) |
VARCHAR2(1) NOT NULL |
Records Rating Component
Y/N Table Edit
Default Value: N
|
| 24 |
RATING_CMP10 |
Character(5) |
VARCHAR2(5) NOT NULL |
Rating Component #10
Prompt Table:
%EDITTABLE10
|
| 25 |
SR_FLAG10 |
Character(1) |
VARCHAR2(1) NOT NULL |
Records Rating Component
Y/N Table Edit
Default Value: N
|
| 26 |
RATING_CMP11 |
Character(5) |
VARCHAR2(5) NOT NULL |
Rating Component #11
Prompt Table:
%EDITTABLE11
|
| 27 |
SR_FLAG11 |
Character(1) |
VARCHAR2(1) NOT NULL |
Records Rating Component
Y/N Table Edit
Default Value: N
|
| 28 |
RATING_CMP12 |
Character(5) |
VARCHAR2(5) NOT NULL |
Rating Component #12
Prompt Table:
%EDITTABLE12
|
| 29 |
SR_FLAG12 |
Character(1) |
VARCHAR2(1) NOT NULL |
Records Rating Component
Y/N Table Edit
Default Value: N
|
| 30 |
RATING_CMP13 |
Character(5) |
VARCHAR2(5) NOT NULL |
Rating Component #13
Prompt Table:
%EDITTABLE13
|
| 31 |
SR_FLAG13 |
Character(1) |
VARCHAR2(1) NOT NULL |
Records Rating Component
Y/N Table Edit
Default Value: N
|
| 32 |
RATING_CMP14 |
Character(5) |
VARCHAR2(5) NOT NULL |
Rating Component #14
Prompt Table:
%EDITTABLE14
|
| 33 |
SR_FLAG14 |
Character(1) |
VARCHAR2(1) NOT NULL |
Records Rating Component
Y/N Table Edit
Default Value: N
|
| 34 |
RATING_CMP15 |
Character(5) |
VARCHAR2(5) NOT NULL |
Rating Component #15
Prompt Table:
%EDITTABLE15
|
| 35 |
SR_FLAG15 |
Character(1) |
VARCHAR2(1) NOT NULL |
Records Rating Component
Y/N Table Edit
Default Value: N
|
| 36 |
RATING_CMP16 |
Character(5) |
VARCHAR2(5) NOT NULL |
Rating Component #16
Prompt Table:
%EDITTABLE16
|
| 37 |
SR_FLAG16 |
Character(1) |
VARCHAR2(1) NOT NULL |
Records Rating Component
Y/N Table Edit
Default Value: N
|
| 38 |
RATING_CMP17 |
Character(5) |
VARCHAR2(5) NOT NULL |
Rating Component #17
Prompt Table:
%EDITTABLE17
|
| 39 |
SR_FLAG17 |
Character(1) |
VARCHAR2(1) NOT NULL |
Records Rating Component
Y/N Table Edit
Default Value: N
|
| 40 |
RATING_CMP18 |
Character(5) |
VARCHAR2(5) NOT NULL |
Rating Component #18
Prompt Table:
%EDITTABLE18
|
| 41 |
SR_FLAG18 |
Character(1) |
VARCHAR2(1) NOT NULL |
Records Rating Component
Y/N Table Edit
Default Value: N
|
| 42 |
RATING_CMP19 |
Character(5) |
VARCHAR2(5) NOT NULL |
Rating Component #19
Prompt Table:
%EDITTABLE19
|
| 43 |
SR_FLAG19 |
Character(1) |
VARCHAR2(1) NOT NULL |
Records Rating Component
Y/N Table Edit
Default Value: N
|
| 44 |
RATING_CMP20 |
Character(5) |
VARCHAR2(5) NOT NULL |
Rating Component #20
Prompt Table:
%EDITTABLE20
|
| 45 |
SR_FLAG20 |
Character(1) |
VARCHAR2(1) NOT NULL |
Records Rating Component
Y/N Table Edit
Default Value: N
|