R_CAREER (SQL Table)	Index Back
Stdnt career for analysis Analysis table for academic advisement containing Student career information.

R_CAREER

(SQL Table)

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

#	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