R_CAREER

(SQL Table)
Index Back

Stdnt career for analysis

Analysis table for academic advisement containing Student career information.

# 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 RPT_DATE Date(10) DATE NOT NULL Report Date
3 RPT_TYPE Character(4) VARCHAR2(4) NOT NULL This field is the type of Academic Advisement report and is used by the tables in the Analysis Database. This field is reserved for use by SA.
SPC=Special Report
STD=Standard Report
4 ANALYSIS_DB_SEQ Number(4,0) SMALLINT NOT NULL Analysis DB Sequence

Default Value: 1

5 ENTRY_SEQ Number(3,0) SMALLINT NOT NULL Entry Sequence
6 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: ACAD_CAR_TBL

7 CAR_DATE Date(10) DATE Career Date
8 ITEM_R_STATUS Character(4) VARCHAR2(4) NOT NULL Item Status
COMP=Complete
EXMP=Exempted
FAIL=Fail