| # |
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 |
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_CAREER
|
| 3 |
INSTITUTION |
Character(5) |
VARCHAR2(5) NOT NULL |
Academic Institution
Default Value: OPR_DEF_TBL_CS.INSTITUTION
Prompt Table:
INSTITUTION_TBL
|
| 4 |
STRM |
Character(4) |
VARCHAR2(4) NOT NULL |
Term
Prompt Table:
TERM_TBL
|
| 5 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 6 |
EFFDT |
Date(10) |
DATE |
Effective Date
Default Value: %date
|
| 7 |
REG_CARD_DATE |
Date(10) |
DATE |
Registration Card Date
|
| 8 |
WITHDRAW_CODE |
Character(3) |
VARCHAR2(3) NOT NULL |
Withdrawal \ Cancel
CAN=Cancelled
NWD=
WDR=Withdrew
Default Value: NWD
|
| 9 |
WITHDRAW_REASON |
Character(4) |
VARCHAR2(4) NOT NULL |
Withdrawal \ Cancel Reason
MEDI=Medical
NPAY=Non-Payment of Fees
RETR=Retroactive
|
| 10 |
WITHDRAW_DATE |
Date(10) |
DATE |
Withdrawal \ Cancel Date
|
| 11 |
LAST_DATE_ATTENDED |
Date(10) |
DATE |
Last Date of Attendance
|
| 12 |
STDNT_CAR_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Student Career Nbr
Prompt Table:
%EDITTABLE
|
| 13 |
ACAD_PROG_PRIMARY |
Character(5) |
VARCHAR2(5) NOT NULL |
Primary Academic Program
|
| 14 |
ACAD_LOAD_APPR |
Character(1) |
VARCHAR2(1) NOT NULL |
Approved Academic Load
B=Vocational Coaching (NLD)
D=Dual (NLD)
E=Part-time Vocational Tr (NLD)
F=Full-Time
O=Vocational Training (NLD)
P=Part-Time
Default Value: F
|
| 15 |
ACADEMIC_LOAD |
Character(1) |
VARCHAR2(1) NOT NULL |
Academic Load
F=Enrolled Full-Time
H=Enrolled Half-Time
L=Less than Half-Time
N=No Unit Load
P=Enrolled Part-Time
T=Three Quarter Time
Default Value: N
|
| 16 |
FA_LOAD |
Character(1) |
VARCHAR2(1) NOT NULL |
Financial Aid Load
F=Enrolled Full-Time
H=Enrolled Half-Time
L=Less than Half-Time
N=No Unit Load
T=Three Quarter Time
|
| 17 |
ACAD_LEVEL_PROJ |
Character(3) |
VARCHAR2(3) NOT NULL |
Academic Level - Projected
Prompt Table:
ACAD_LEVEL_TBL
|
| 18 |
ACAD_LEVEL_BOT |
Character(3) |
VARCHAR2(3) NOT NULL |
Academic Level - Term Start
Prompt Table:
ACAD_LEVEL_TBL
|
| 19 |
ACAD_LEVEL_EOT |
Character(3) |
VARCHAR2(3) NOT NULL |
Academic Level - Term End
Prompt Table:
ACAD_LEVEL_TBL
|
| 20 |
NSLDS_LOAN_YEAR |
Character(1) |
VARCHAR2(1) NOT NULL |
NSLDS Loan Year
0=1st Year - Never Attended
1=1st Year - Previously Attended
2=2nd Year
3=3rd Year
4=4th Year
5=5th Year+
A=1st Year Graduate
B=2nd Year Graduate
C=3rd Year Graduate
D=4th or more Graduate
G=Graduate/Professional
|
| 21 |
OVRD_ACAD_LVL_PROJ |
Character(1) |
VARCHAR2(1) NOT NULL |
Override Projected Level
Y/N Table Edit
Default Value: N
|
| 22 |
OVRD_ACAD_LVL_ALL |
Character(1) |
VARCHAR2(1) NOT NULL |
Override All Academic Levels
Y/N Table Edit
Default Value: N
|
| 23 |
ELIG_TO_ENROLL |
Character(1) |
VARCHAR2(1) NOT NULL |
Eligible to Enroll
Y/N Table Edit
Default Value: Y
|
| 24 |
OVRD_MAX_UNITS |
Character(1) |
VARCHAR2(1) NOT NULL |
Override Maximum Units
Y/N Table Edit
Default Value: N
|
| 25 |
MAX_TOTAL_UNIT |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Max Total Units
|
| 26 |
MAX_NOGPA_UNIT |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Max No GPA Units
|
| 27 |
MAX_AUDIT_UNIT |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Max Audit Units
|
| 28 |
MAX_WAIT_UNIT |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Max Wait List Units
|
| 29 |
MIN_TOTAL_UNIT |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Min Total Units
|
| 30 |
OVRD_BILL_UNITS |
Character(1) |
VARCHAR2(1) NOT NULL |
Override Billing Units
Y/N Table Edit
Default Value: N
|
| 31 |
PROJ_BILL_UNT |
Number(3,0) |
SMALLINT NOT NULL |
Projected Bill Units
|
| 32 |
UNT_TAKEN_PRGRSS |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Units Taken for Progress
|
| 33 |
UNT_PASSD_PRGRSS |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Units Passed for Progress
|
| 34 |
UNT_TAKEN_GPA |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Units Taken Toward GPA
|
| 35 |
UNT_PASSD_GPA |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Units Passed Toward GPA
|
| 36 |
UNT_TAKEN_NOGPA |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Units Taken Not Toward GPA
|
| 37 |
UNT_PASSD_NOGPA |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Units Passed Not Toward GPA
|
| 38 |
UNT_INPROG_GPA |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Units In Progress - GPA
|
| 39 |
UNT_INPROG_NOGPA |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Unit In Progress - Not for GPA
|
| 40 |
GRADE_POINTS |
Number(10,3) |
DECIMAL(9,3) NOT NULL |
Grade Points
|
| 41 |
UNT_AUDIT |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Units Audited
|
| 42 |
UNT_TRNSFR |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Units Transferred
|
| 43 |
TRF_TAKEN_GPA |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Term Units for GPA of Transfer Credits
|
| 44 |
TRF_TAKEN_NOGPA |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Transfer Taken Not for GPA
|
| 45 |
TRF_PASSED_GPA |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Transfer Passed for GPA
|
| 46 |
TRF_PASSED_NOGPA |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Transfer Passed Not for GPA
|
| 47 |
TRF_GRADE_POINTS |
Number(10,3) |
DECIMAL(9,3) NOT NULL |
Term Grade Points of Transfer Credits.
|
| 48 |
UNT_TEST_CREDIT |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Units from Test Credit
|
| 49 |
UNT_OTHER |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Units from Other Credit
|
| 50 |
UNT_TAKEN_FA |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Fin Aid Progress Units Taken
|
| 51 |
UNT_PASSD_FA |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Fin Aid Progress Units Passed
|
| 52 |
UNT_TAKEN_FA_GPA |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
FA Units Taken Toward GPA
|
| 53 |
GRADE_POINTS_FA |
Number(10,3) |
DECIMAL(9,3) NOT NULL |
Financial Aid Grade Points
|
| 54 |
UNT_TERM_TOT |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Total Term Units
|
| 55 |
RESET_CUM_STATS |
Character(1) |
VARCHAR2(1) NOT NULL |
Reset Cum Stats at Term Start
Y/N Table Edit
Default Value: N
|
| 56 |
TOT_TAKEN_PRGRSS |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Total Taken for Progress
|
| 57 |
TOT_PASSD_PRGRSS |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Total Passed for Progress
|
| 58 |
TOT_TAKEN_GPA |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Cumulative Units for GPA of Enrollments and Transfer Credits
|
| 59 |
TOT_PASSD_GPA |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Total Passed Toward GPA
|
| 60 |
TOT_TAKEN_NOGPA |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Total Taken Not Toward GPA
|
| 61 |
TOT_PASSD_NOGPA |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Total Passed Not Toward GPA
|
| 62 |
TOT_INPROG_GPA |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Total In Progress - GPA
|
| 63 |
TOT_INPROG_NOGPA |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Total In Progress -Not for GPA
|
| 64 |
TOT_AUDIT |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Total Audited
|
| 65 |
TOT_TRNSFR |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Total Transferred
|
| 66 |
TOT_TEST_CREDIT |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Total From Test Credit
|
| 67 |
TOT_OTHER |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Total from Other Credit
|
| 68 |
TOT_CUMULATIVE |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Total Cumulative Units
|
| 69 |
TOT_GRADE_POINTS |
Number(10,3) |
DECIMAL(9,3) NOT NULL |
Cumulative Grade Points of Enrollment and Transfer Credits
|
| 70 |
TOT_TAKEN_FA |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Total Fin Aid Units Taken
|
| 71 |
TOT_PASSD_FA |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Total Fin Aid Units Passed
|
| 72 |
TOT_TAKEN_FA_GPA |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Total Fin Aid Taken Toward GPA
|
| 73 |
TOT_GRD_POINTS_FA |
Number(10,3) |
DECIMAL(9,3) NOT NULL |
Total Fin Aid Grade Points
|
| 74 |
FORM_OF_STUDY |
Character(4) |
VARCHAR2(4) NOT NULL |
Form of Study
ABRD=Study Abroad
CAND=Advanced to Candidacy
DTCH=Detached Study
ENRL=Class Enrollment
Default Value: ENRL
|
| 75 |
TERM_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Term Unit Type
C=Clock Hours
E=Continuing Education Units
Q=Quarter Hours
S=Semester Hours
T=Trimester Hours
U=Units
Default Value: ACAD_CAR_TBL.TERM_TYPE
Prompt Table:
TERM_TYPE_TBL
|
| 76 |
CLASS_RANK_NBR |
Number(5,0) |
INTEGER NOT NULL |
Class Rank Nbr
|
| 77 |
CLASS_RANK_TOT |
Number(5,0) |
INTEGER NOT NULL |
Class Rank Total
|
| 78 |
SEL_GROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Tuition Group
Prompt Table:
SEL_GROUP_VW
|
| 79 |
TUIT_CALC_REQ |
Character(1) |
VARCHAR2(1) NOT NULL |
Tuition Calc Required
Y/N Table Edit
Default Value: BUS_UNIT_TBL_SF.TERM_ACT_INIT_SET
|
| 80 |
TUIT_CALC_DTTM |
DateTime(26) |
TIMESTAMP |
Tuit Calc Date Time
|
| 81 |
FA_STATS_CALC_REQ |
Character(1) |
VARCHAR2(1) NOT NULL |
FA Stats Calculation Required
Default Value: N
|
| 82 |
FA_STATS_CALC_DTTM |
DateTime(26) |
TIMESTAMP |
FA Stats Calc Date Time
|
| 83 |
FA_ELIGIBILITY |
Character(1) |
VARCHAR2(1) NOT NULL |
Program Eligibility Flag
Default Value: ACAD_PROG_TBL.FA_ELIGIBILITY
|
| 84 |
BILLING_CAREER |
Character(4) |
VARCHAR2(4) NOT NULL |
Billing Career
Default Value: STDNT_CAR_TERM.ACAD_CAREER
Prompt Table:
STDNT_CARBT_VW
|
| 85 |
UNIT_MULTIPLIER |
Number(9,4) |
DECIMAL(8,4) NOT NULL |
Unit Multiplier
|
| 86 |
ACAD_YEAR |
Character(4) |
VARCHAR2(4) NOT NULL |
Academic Year
Default Value: TERM_TBL.ACAD_YEAR
|
| 87 |
ACAD_GROUP_ADVIS |
Character(5) |
VARCHAR2(5) NOT NULL |
Academic Group of Advisor
Prompt Table:
ACAD_GROUP_TBL
|
| 88 |
CUR_RESIDENT_TERMS |
Number(7,3) |
DECIMAL(6,3) NOT NULL |
Current In Residence Terms
|
| 89 |
TRF_RESIDENT_TERMS |
Number(7,3) |
DECIMAL(6,3) NOT NULL |
Transfer In Residence Terms
|
| 90 |
CUM_RESIDENT_TERMS |
Number(7,3) |
DECIMAL(6,3) NOT NULL |
Cumulative In Residence Terms
|
| 91 |
REFUND_PCT |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Refund Percentage
|
| 92 |
REFUND_SCHEME |
Character(8) |
VARCHAR2(8) NOT NULL |
Refund Scheme
|
| 93 |
PRO_RATA_ELIGIBLE |
Character(1) |
VARCHAR2(1) NOT NULL |
Pro-Rata Eligible
Y/N Table Edit
Default Value: N
|
| 94 |
FULLY_ENRL_DT |
Date(10) |
DATE NOT NULL |
Fully Enrolled Date
|
| 95 |
ENRL_ON_TRANS_DT |
Date(10) |
DATE NOT NULL |
Show Enrollment on Transcript
|
| 96 |
STATS_ON_TRANS_DT |
Date(10) |
DATE NOT NULL |
Show Statistics on Transcript
|
| 97 |
FULLY_GRADED_DT |
Date(10) |
DATE NOT NULL |
Fully Graded Date
|
| 98 |
EXT_ORG_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
External Org ID
Prompt Table:
EXT_ORG_TBL
|
| 99 |
COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
Prompt Table:
COUNTRY_TBL
|
| 100 |
STUDY_AGREEMENT |
Character(10) |
VARCHAR2(10) NOT NULL |
Study Agreement
Prompt Table:
STUDY_AGRM_TBL
|
| 101 |
START_DATE |
Date(10) |
DATE |
Start Date for Gen Standing PO
|
| 102 |
END_DATE |
Date(10) |
DATE |
End Date
|
| 103 |
MAX_CRSE_COUNT |
Number(3,0) |
SMALLINT NOT NULL |
Max Total Courses
|
| 104 |
CUR_GPA |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Current GPA
|
| 105 |
CUM_GPA |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Cumulative GPA
|
| 106 |
REGISTERED |
Character(1) |
VARCHAR2(1) NOT NULL |
Registered
R=Registered
|
| 107 |
OVRD_TUIT_GROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Override Tuition Group
Prompt Table:
TUIT_CAL_GRP_VW
|
| 108 |
OVRD_WDRW_SCHED |
Character(8) |
VARCHAR2(8) NOT NULL |
Override Withdrawal Schedule
Prompt Table:
ADJ_CODE_TRM_VW
|
| 109 |
TUITION_RES_TERMS |
Number(7,3) |
DECIMAL(6,3) NOT NULL |
Tuition Residency
|
| 110 |
OVRD_INIT_ADD_FEE |
Character(1) |
VARCHAR2(1) NOT NULL |
Override Initial Add Fees
Y/N Table Edit
Default Value: N
|
| 111 |
OVRD_INIT_ENR_FEE |
Character(1) |
VARCHAR2(1) NOT NULL |
Override Initial Enroll Fee
Y/N Table Edit
Default Value: N
|
| 112 |
TC_UNITS_ADJUST |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Transfer Credits Units Adjustment
|
| 113 |
LOCK_IN_AMT |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Lock In Amount
|
| 114 |
LOCK_IN_DT |
Date(10) |
DATE |
Lock In Date
|
| 115 |
ACAD_CAREER_FIRST |
Character(1) |
VARCHAR2(1) NOT NULL |
First Time in Career
Y/N Table Edit
Default Value: Y
|
| 116 |
ACADEMIC_LOAD_DT |
Date(10) |
DATE |
Academic Load Change Date
|
| 117 |
UNTPRG_CHG_NSLC_DT |
Date(10) |
DATE |
Unit Progrss Changed Date NSC
|
| 118 |
SSR_ACTIVATION_DT |
Date(10) |
DATE |
Date when the student was term activated.
|
| 119 |
SSR_TRF_CUR_GPA |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Term GPA of Transfer Credits
|
| 120 |
SSR_COMB_CUR_GPA |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Term GPA of Enrollments and Transfer Credits
|
| 121 |
SSR_CUM_EN_GPA |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Cumulative Enrollment GPA
|
| 122 |
SSR_TOT_EN_GRDPTS |
Number(10,3) |
DECIMAL(9,3) NOT NULL |
Cumulative Enrollment Grade Points
|
| 123 |
SSR_TOT_EN_TKNGPA |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Cumulative Enrollment Units for GPA
|
| 124 |
SSR_CUM_TR_GPA |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Cumulative GPA of Transfer Credits
|
| 125 |
SSR_TOT_TR_GRDPTS |
Number(10,3) |
DECIMAL(9,3) NOT NULL |
Cumulative Transfer Credits Grade Points
|
| 126 |
SSR_TOT_TR_TKNGPA |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Cumulative Transfer Credits Units for GPA
|