| # |
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
Prompt Table:
INSTITUTION_TBL
|
| 3 |
ACAD_STATS_PERIOD |
Character(10) |
VARCHAR2(10) NOT NULL |
Academic Statistics Period
Prompt Table:
STAT_PERIOD_TBL
|
| 4 |
CONS_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Consolidation Status
E=Error
P=Pending
S=Success
W=Warning
|
| 5 |
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
|
| 6 |
STRM |
Character(4) |
VARCHAR2(4) NOT NULL |
Term
Prompt Table:
TERM_TBL
|
| 7 |
WITHDRAW_CODE |
Character(3) |
VARCHAR2(3) NOT NULL |
Withdrawal \ Cancel
CAN=Cancelled
NWD=
WDR=Withdrew
|
| 8 |
WITHDRAW_REASON |
Character(4) |
VARCHAR2(4) NOT NULL |
Withdrawal \ Cancel Reason
MEDI=Medical
NPAY=Non-Payment of Fees
RETR=Retroactive
|
| 9 |
WITHDRAW_DATE |
Date(10) |
DATE |
Withdrawal \ Cancel Date
|
| 10 |
LAST_DATE_ATTENDED |
Date(10) |
DATE |
Last Date of Attendance
|
| 11 |
STDNT_CAR_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Student Career Nbr
Prompt Table:
%EDITTABLE
|
| 12 |
ACAD_PROG_PRIMARY |
Character(5) |
VARCHAR2(5) NOT NULL |
Primary Academic Program
|
| 13 |
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
|
| 14 |
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
|
| 15 |
OVRD_ACADEMIC_LOAD |
Character(1) |
VARCHAR2(1) NOT NULL |
Override Academic Load
Y/N Table Edit
Default Value: N
|
| 16 |
ACADEMIC_LOAD_CL |
Character(1) |
VARCHAR2(1) NOT NULL |
Academic Load Calculated
F=Full-Time
H=Half-Time
L=Less 1/2
N=No Units
P=Part-Time
T=3/4 Time
Prompt Table:
ACAD_LOAD_TBL
|
| 17 |
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
|
| 18 |
ACADEMIC_LOAD_NSLC |
Character(1) |
VARCHAR2(1) NOT NULL |
This field contains the academic load value to report to the NSC.
F=Full-Time
H=Half-Time
L=Less Than Half-Time
Q=Three Quarter Time
|
| 19 |
ACAD_LOAD_NSLC_CL |
Character(1) |
VARCHAR2(1) NOT NULL |
This field contains the academic load value to report to the NSC.
F=Full-Time
H=Half-Time
L=Less Than Half-Time
|
| 20 |
ACAD_LEVEL_PROJ |
Character(3) |
VARCHAR2(3) NOT NULL |
Academic Level - Projected
Prompt Table:
ACAD_LEVEL_TBL
|
| 21 |
ACAD_LEVEL_PROJ_CL |
Character(3) |
VARCHAR2(3) NOT NULL |
Acad Level Proj Calculated
5AR=Fifth year Architecture
DOC=Doctorate
FR=Freshman
GR=Graduate
HS=High School Concurrent
JR=Junior
MAS=Masters
NDG=Non-deg Graduate
NDU=Non-deg Undergraduate
NST=Not Set
P1=Professional Year 1
P2=Professional Year 2
P3=Professional Year 3
P4=Professional Year 4
PBC=Post-bacc Teach Certificate
PBU=Post-bacc Undergraduate
PMC=Post-mast Teach Cert
PPR=Post-Professional
PRE=Pre-Candidate
SO=Sophomore
SR=Senior
|
| 22 |
ACAD_LEVEL_BOT |
Character(3) |
VARCHAR2(3) NOT NULL |
Academic Level - Term Start
Prompt Table:
ACAD_LEVEL_TBL
|
| 23 |
ACAD_LEVEL_BOT_CL |
Character(3) |
VARCHAR2(3) NOT NULL |
Acad Level BOT Calculated
5AR=Fifth year Architecture
DOC=Doctorate
FR=Freshman
GR=Graduate
HS=High School Concurrent
JR=Junior
MAS=Masters
NDG=Non-deg Graduate
NDU=Non-deg Undergraduate
NST=Not Set
P1=Professional Year 1
P2=Professional Year 2
P3=Professional Year 3
P4=Professional Year 4
PBC=Post-bacc Teach Certificate
PBU=Post-bacc Undergraduate
PMC=Post-mast Teach Cert
PPR=Post-Professional
PRE=Pre-Candidate
SO=Sophomore
SR=Senior
|
| 24 |
ACAD_LEVEL_EOT |
Character(3) |
VARCHAR2(3) NOT NULL |
Academic Level - Term End
Prompt Table:
ACAD_LEVEL_TBL
|
| 25 |
ACAD_LEVEL_EOT_CL |
Character(3) |
VARCHAR2(3) NOT NULL |
Acad Level EOT Calculated
5AR=Fifth year Architecture
DOC=Doctorate
FR=Freshman
GR=Graduate
HS=High School Concurrent
JR=Junior
MAS=Masters
NDG=Non-deg Graduate
NDU=Non-deg Undergraduate
NST=Not Set
P1=Professional Year 1
P2=Professional Year 2
P3=Professional Year 3
P4=Professional Year 4
PBC=Post-bacc Teach Certificate
PBU=Post-bacc Undergraduate
PMC=Post-mast Teach Cert
PPR=Post-Professional
PRE=Pre-Candidate
SO=Sophomore
SR=Senior
|
| 26 |
ACAD_LEVEL_IPEDS |
Character(3) |
VARCHAR2(3) NOT NULL |
IPEDS Academic Level
00=Not Set
10=Freshman
1F=First Time Freshman
20=Sophomore
30=Junior
40=Senior
50=Post-Bacc Undergraduate
GF=First Time Graduate
GR=Graduate
P1=Professional Year 1
P2=Professional Year 2
P3=Professional Year 3
P4=Professional Year 4
PF=First Time Professional
|
| 27 |
ACAD_LEVEL_IPED_CL |
Character(3) |
VARCHAR2(3) NOT NULL |
IPEDS Academic Level
00=Not Set
10=Freshman
1F=First Time Freshman
20=Sophomore
30=Junior
40=Senior
50=Post-Bacc Undergraduate
GF=First Time Graduate
GR=Graduate
P1=Professional Year 1
P2=Professional Year 2
P3=Professional Year 3
P4=Professional Year 4
PF=First Time Professional
|
| 28 |
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
|
| 29 |
OVRD_ACAD_LVL_PROJ |
Character(1) |
VARCHAR2(1) NOT NULL |
Override Projected Level
Y/N Table Edit
Default Value: N
|
| 30 |
OVRD_ACAD_LVL_ALL |
Character(1) |
VARCHAR2(1) NOT NULL |
Override All Academic Levels
Y/N Table Edit
Default Value: N
|
| 31 |
ELIG_TO_ENROLL |
Character(1) |
VARCHAR2(1) NOT NULL |
Eligible to Enroll
Y/N Table Edit
Default Value: Y
|
| 32 |
UNT_TAKEN_PRGRSS |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Units Taken for Progress
|
| 33 |
UNT_TAKEN_PRGRS_CL |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Calculated Progress Units
|
| 34 |
OVRD_UNT_TAKEN_PRG |
Character(1) |
VARCHAR2(1) NOT NULL |
Override Units for Progress
Y/N Table Edit
Default Value: N
|
| 35 |
UNT_PASSD_PRGRSS |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Units Passed for Progress
|
| 36 |
UNT_TAKEN_GPA |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Units Taken Toward GPA
|
| 37 |
UNT_PASSD_GPA |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Units Passed Toward GPA
|
| 38 |
UNT_TAKEN_NOGPA |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Units Taken Not Toward GPA
|
| 39 |
UNT_PASSD_NOGPA |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Units Passed Not Toward GPA
|
| 40 |
UNT_INPROG_GPA |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Units In Progress - GPA
|
| 41 |
UNT_INPROG_NOGPA |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Unit In Progress - Not for GPA
|
| 42 |
GRADE_POINTS |
Number(10,3) |
DECIMAL(9,3) NOT NULL |
Grade Points
|
| 43 |
UNT_AUDIT |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Units Audited
|
| 44 |
UNT_TRNSFR |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Units Transferred
|
| 45 |
TRF_TAKEN_GPA |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Term Units for GPA of Transfer Credits
|
| 46 |
TRF_TAKEN_NOGPA |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Transfer Taken Not for GPA
|
| 47 |
TRF_PASSED_GPA |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Transfer Passed for GPA
|
| 48 |
TRF_PASSED_NOGPA |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Transfer Passed Not for GPA
|
| 49 |
TRF_GRADE_POINTS |
Number(10,3) |
DECIMAL(9,3) NOT NULL |
Term Grade Points of Transfer Credits.
|
| 50 |
UNT_TEST_CREDIT |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Units from Test Credit
|
| 51 |
UNT_OTHER |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Units from Other Credit
|
| 52 |
UNT_TAKEN_FA |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Fin Aid Progress Units Taken
|
| 53 |
UNT_PASSD_FA |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Fin Aid Progress Units Passed
|
| 54 |
UNT_TAKEN_FA_GPA |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
FA Units Taken Toward GPA
|
| 55 |
GRADE_POINTS_FA |
Number(10,3) |
DECIMAL(9,3) NOT NULL |
Financial Aid Grade Points
|
| 56 |
UNT_TERM_TOT |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Total Term Units
|
| 57 |
RESET_CUM_STATS |
Character(1) |
VARCHAR2(1) NOT NULL |
Reset Cum Stats at Term Start
Y/N Table Edit
Default Value: N
|
| 58 |
TOT_TAKEN_PRGRSS |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Total Taken for Progress
|
| 59 |
TOT_PASSD_PRGRSS |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Total Passed for Progress
|
| 60 |
TOT_TAKEN_GPA |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Cumulative Units for GPA of Enrollments and Transfer Credits
|
| 61 |
TOT_PASSD_GPA |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Total Passed Toward GPA
|
| 62 |
TOT_TAKEN_NOGPA |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Total Taken Not Toward GPA
|
| 63 |
TOT_PASSD_NOGPA |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Total Passed Not Toward GPA
|
| 64 |
TOT_INPROG_GPA |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Total In Progress - GPA
|
| 65 |
TOT_INPROG_NOGPA |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Total In Progress -Not for GPA
|
| 66 |
TOT_AUDIT |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Total Audited
|
| 67 |
TOT_TRNSFR |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Total Transferred
|
| 68 |
TOT_TEST_CREDIT |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Total From Test Credit
|
| 69 |
TOT_OTHER |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Total from Other Credit
|
| 70 |
TOT_CUMULATIVE |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Total Cumulative Units
|
| 71 |
TOT_CUMULATIVE_CL |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Total Cumulative Units
|
| 72 |
OVRD_TOT_CUM |
Character(1) |
VARCHAR2(1) NOT NULL |
Override Total Cumulative Unit
Y/N Table Edit
Default Value: N
|
| 73 |
TOT_GRADE_POINTS |
Number(10,3) |
DECIMAL(9,3) NOT NULL |
Cumulative Grade Points of Enrollment and Transfer Credits
|
| 74 |
TOT_TAKEN_FA |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Total Fin Aid Units Taken
|
| 75 |
TOT_PASSD_FA |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Total Fin Aid Units Passed
|
| 76 |
TOT_TAKEN_FA_GPA |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Total Fin Aid Taken Toward GPA
|
| 77 |
TOT_GRD_POINTS_FA |
Number(10,3) |
DECIMAL(9,3) NOT NULL |
Total Fin Aid Grade Points
|
| 78 |
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
|
| 79 |
FORM_OF_STUDY_PD |
Character(4) |
VARCHAR2(4) NOT NULL |
Form of Study for Period
ABRD=Study Abroad
CAND=Advanced to Candidacy
DTCH=Detached Study
ENRL=Class Enrollment
|
| 80 |
FORM_OF_STUDY_CL |
Character(4) |
VARCHAR2(4) NOT NULL |
Form of Study Calculated
ABRD=Study Abroad
CAND=Advanced to Candidacy
DTCH=Detached Study
ENRL=Class Enrollment
|
| 81 |
OVRD_FORM_OF_STUDY |
Character(1) |
VARCHAR2(1) NOT NULL |
Override Form of Study
Y/N Table Edit
Default Value: N
|
| 82 |
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
|
| 83 |
CLASS_RANK_NBR |
Number(5,0) |
INTEGER NOT NULL |
Class Rank Nbr
|
| 84 |
CLASS_RANK_TOT |
Number(5,0) |
INTEGER NOT NULL |
Class Rank Total
|
| 85 |
SEL_GROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Tuition Group
Prompt Table:
SEL_GROUP_VW
|
| 86 |
BILLING_CAREER |
Character(4) |
VARCHAR2(4) NOT NULL |
Billing Career
Prompt Table:
STDNT_CARBT_VW
|
| 87 |
UNIT_MULTIPLIER |
Number(9,4) |
DECIMAL(8,4) NOT NULL |
Unit Multiplier
|
| 88 |
ACAD_YEAR |
Character(4) |
VARCHAR2(4) NOT NULL |
Academic Year
|
| 89 |
CUR_RESIDENT_TERMS |
Number(7,3) |
DECIMAL(6,3) NOT NULL |
Current In Residence Terms
|
| 90 |
TRF_RESIDENT_TERMS |
Number(7,3) |
DECIMAL(6,3) NOT NULL |
Transfer In Residence Terms
|
| 91 |
CUM_RESIDENT_TERMS |
Number(7,3) |
DECIMAL(6,3) NOT NULL |
Cumulative In Residence Terms
|
| 92 |
REFUND_PCT |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Refund Percentage
|
| 93 |
REFUND_SCHEME |
Character(8) |
VARCHAR2(8) NOT NULL |
Refund Scheme
|
| 94 |
PRO_RATA_ELIGIBLE |
Character(1) |
VARCHAR2(1) NOT NULL |
Pro-Rata Eligible
Y/N Table Edit
Default Value: N
|
| 95 |
FULLY_ENRL_DT |
Date(10) |
DATE |
Fully Enrolled Date
|
| 96 |
FULLY_GRADED_DT |
Date(10) |
DATE |
Fully Graded Date
|
| 97 |
EXT_ORG_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
External Org ID
Prompt Table:
EXT_ORG_TBL
|
| 98 |
COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
Prompt Table:
COUNTRY_TBL
|
| 99 |
STUDY_AGREEMENT |
Character(10) |
VARCHAR2(10) NOT NULL |
Study Agreement
Prompt Table:
STUDY_AGRM_TBL
|
| 100 |
START_DATE |
Date(10) |
DATE |
Start Date for Gen Standing PO
|
| 101 |
END_DATE |
Date(10) |
DATE |
End Date
|
| 102 |
CUR_GPA |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Current GPA
|
| 103 |
GPA_CL |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
GPA Calculated
|
| 104 |
OVRD_GPA |
Character(1) |
VARCHAR2(1) NOT NULL |
Override GPA
Y/N Table Edit
Default Value: N
|
| 105 |
CUM_GPA |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Cumulative GPA
|
| 106 |
CUM_GPA_CL |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Cumulative GPA Calculated
|
| 107 |
OVRD_CUM_GPA |
Character(1) |
VARCHAR2(1) NOT NULL |
Override Cum GPA
Y/N Table Edit
Default Value: N
|
| 108 |
OVRD_TUIT_GROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Override Tuition Group
Prompt Table:
TUIT_CAL_GRP_VW
|
| 109 |
OVRD_WDRW_SCHED |
Character(8) |
VARCHAR2(8) NOT NULL |
Override Withdrawal Schedule
Prompt Table:
ADJ_CODE_TBL
|
| 110 |
TUITION_RES_TERMS |
Number(7,3) |
DECIMAL(6,3) NOT NULL |
Tuition Residency
|
| 111 |
TC_UNITS_ADJUST |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Transfer Credits Units Adjustment
|
| 112 |
STDNT_COHORT_PRIM |
Character(10) |
VARCHAR2(10) NOT NULL |
Primary Student Cohort
|
| 113 |
ETHNIC_GROUP_SR |
Character(1) |
VARCHAR2(1) NOT NULL |
This field is used for consolidated stats reporting (mostly IPEDS ethnicity reporting) and contains the translate values used in the ETHNIC_GROUP field as welll as two calculated values used for IPEDS reporting.
1=White
2=Black
3=Hispanic
4=Asian/Pacific Islander
5=American Indian/Alaskan Native
6=Not Applicable
7=Native Hawaiian/Oth Pac Island
8=Two or More Races
9=International
|
| 114 |
AGE_CATEGORY_SR |
Character(2) |
VARCHAR2(2) NOT NULL |
Age Category
01=Under 18
02=18-19
03=20-21
04=22-24
05=25-29
06=30-34
07=35-39
08=40-49
09=50-64
10=65 and over
11=Age Unknown
|
| 115 |
DEGREE |
Character(8) |
VARCHAR2(8) NOT NULL |
Degree
|
| 116 |
EXP_GRAD_TERM |
Character(4) |
VARCHAR2(4) NOT NULL |
Expected Graduation Term
Prompt Table:
TERM_TBL
|
| 117 |
COMPLETION_TERM |
Character(4) |
VARCHAR2(4) NOT NULL |
Completion Term
Prompt Table:
TERM_TBL
|
| 118 |
DEGR_CONFER_DT |
Date(10) |
DATE |
Confer Date
|
| 119 |
ENRL_STAT_CHG_DT |
Date(10) |
DATE |
Enrollment Status Change Date
|
| 120 |
ACAD_PROG_MAIN |
Character(5) |
VARCHAR2(5) NOT NULL |
Academic Program
|
| 121 |
STDNT_CAR_NBR_MAIN |
Number(3,0) |
SMALLINT NOT NULL |
Student Career Nbr
|
| 122 |
ACAD_PLAN |
Character(10) |
VARCHAR2(10) NOT NULL |
Academic Plan
|
| 123 |
ACAD_SUB_PLAN |
Character(10) |
VARCHAR2(10) NOT NULL |
Academic Sub-Plan
|
| 124 |
EXTRA_ACTIVITY |
Character(6) |
VARCHAR2(6) NOT NULL |
Extracurricular Activity
|
| 125 |
SF_1098_GRAD_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
1098 Grad Flag
Y/N Table Edit
Default Value: N
|
| 126 |
SF_1098_HLFTME_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
1098 Half Time Flag
Y/N Table Edit
Default Value: N
|
| 127 |
CORRECTION_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Correction Status
1=Correction(s) Pending
2=Send Correction(s)
3=Correction(s) Sent
4=Correction(s) Accepted
5=Corrections Rejected
6=Do Not Send Corrections
|
| 128 |
SF_CORRECTION_DTTM |
DateTime(26) |
TIMESTAMP |
Correction Date Time
|
| 129 |
SF_OVERRIDE_GRAD |
Character(1) |
VARCHAR2(1) NOT NULL |
Override Grad Flag
Y/N Table Edit
Default Value: N
|
| 130 |
SF_OVERRIDE_HALF |
Character(1) |
VARCHAR2(1) NOT NULL |
Override Half Flag
Y/N Table Edit
Default Value: N
|
| 131 |
SF_ORIGINAL_SENTDT |
Date(10) |
DATE |
Original Sent DAte
|
| 132 |
SF_ORIGINAL_PRT_DT |
Date(10) |
DATE |
Original Print Date
|
| 133 |
ATHLETIC_AID |
Character(1) |
VARCHAR2(1) NOT NULL |
Athletic Aid
Y/N Table Edit
|
| 134 |
PROG_STATUS |
Character(4) |
VARCHAR2(4) NOT NULL |
Academic Program Status
AC=Active in Program
AD=Admitted
AP=Applicant
CM=Completed Program
CN=Cancelled
DC=Discontinued
DE=Deceased
DM=Dismissed
LA=Leave of Absence
PM=Prematriculant
SP=Suspended
WT=Waitlisted
|
| 135 |
MULTI_ACAD_CAREER |
Character(1) |
VARCHAR2(1) NOT NULL |
Multiple Academic Career
Y/N Table Edit
|
| 136 |
FA_UNIT_WARNING |
Character(1) |
VARCHAR2(1) NOT NULL |
Excluded FA Eligible Term Warn
Y/N Table Edit
Default Value: N
|
| 137 |
CAMPUS |
Character(5) |
VARCHAR2(5) NOT NULL |
Campus
|
| 138 |
LEVEL_LOAD_RULE |
Character(5) |
VARCHAR2(5) NOT NULL |
Academic Level Rule
|
| 139 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Default Value: OPR_DEF_TBL_CS.OPRID
|
| 140 |
LASTNAME_RPTD_NSLC |
Character(20) |
VARCHAR2(20) NOT NULL |
This field contains the last name reported to the NSC on the previous NSC report.
|
| 141 |
SSN_RPTD_NSLC |
Character(9) |
VARCHAR2(9) NOT NULL |
This field is used to track the SSN reported to the NSC in the previous NSC run.
|
| 142 |
PREV_STATSPER_NSLC |
Character(10) |
VARCHAR2(10) NOT NULL |
This field is used to track the previous NSC reporting value when running the sqr to process the current NSC status.
|
| 143 |
SSR_NSC_CRD_LVL |
Character(1) |
VARCHAR2(1) NOT NULL |
This field is used to identify the NSC Class Credential Level for the NSC report.
A=Associate's Degree
B=Bachelor's Degree
C=Certificate - Undergraduate
D=Doctoral Degree
F=Freshman
G=Unspecified-Grad/Professional
J=Junior
L=Professional
M=Master's Degree
N=Unspecified-Undergraduate
P=Postdoctorate
R=Senior
S=Sophomore
T=Post baccalaureate certificate
|
| 144 |
SSR_NSC_CRD_LVL_CL |
Character(1) |
VARCHAR2(1) NOT NULL |
This field is used to identify the NSC Class Credential Level for the NSC report.
A=Associate's Degree
B=Bachelor's Degree
C=Certificate - Undergraduate
D=Doctoral Degree
F=Freshman
G=Unspecified-Grad/Professional
J=Junior
L=Professional
M=Master's Degree
N=Unspecified-Undergraduate
P=Postdoctorate
R=Senior
S=Sophomore
T=Post baccalaureate certificate
|
| 145 |
SSR_OVRD_NSC_CRLVL |
Character(1) |
VARCHAR2(1) NOT NULL |
Override NSC Classification
Y/N Table Edit
Default Value: N
|