R_RQDPLN_DETAIL

#	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	RQRMNT_GROUP	Character(6)	VARCHAR2(6) NOT NULL	Requirement Group Prompt Table: RQ_GRP_TBL
7	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
8	ACAD_PROG	Character(5)	VARCHAR2(5) NOT NULL	Academic Program Prompt Table: ACAD_PROG
9	ACAD_PLAN	Character(10)	VARCHAR2(10) NOT NULL	Academic Plan Prompt Table: ACAD_PLAN_TBL
10	ACAD_SUB_PLAN	Character(10)	VARCHAR2(10) NOT NULL	Academic Sub-Plan Prompt Table: ACAD_SUBPLAN