SSR_TSRSLT_DSPL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	REPORT_REQUEST_NBR	Character(9)	VARCHAR2(9) NOT NULL	Report Request Nbr
2	REQUEST_SEQ_NBR	Number(5,0)	INTEGER NOT NULL	Request Seq Nbr
3	REPORT_NUMBER	Number(2,0)	SMALLINT NOT NULL	Report Number
4	SEQNO	Number(5,0)	INTEGER NOT NULL	Sequence Number
5	PRINT_AREA_CODE	Character(2)	VARCHAR2(2) NOT NULL	Print Area Code
6	SSR_ROWTYPE	Character(4)	VARCHAR2(4) NOT NULL	Transcript Result Row Type
7	STDNT_DEGR	Character(2)	VARCHAR2(2) NOT NULL	Student Degree Nbr
8	ACAD_PLAN	Character(10)	VARCHAR2(10) NOT NULL	Academic Plan
9	ACAD_SUB_PLAN	Character(10)	VARCHAR2(10) NOT NULL	Academic Sub-Plan
10	SUB_PLAN_SEQUENCE	Number(2,0)	SMALLINT NOT NULL	Sub-Plan Seq
11	OVERRIDE_FL	Character(1)	VARCHAR2(1) NOT NULL	Override Flag
12	TRNSCR_DESCR	Character(100)	VARCHAR2(100) NOT NULL	Transcript Description
13	DESCR100	Character(100)	VARCHAR2(100) NOT NULL	Length 100 Description
14	HONORS_PREFIX	Character(3)	VARCHAR2(3) NOT NULL	Honors Prefix
15	DESCR50	Character(50)	VARCHAR2(50) NOT NULL	Description of length 50
16	HONORS_SUFFIX	Character(3)	VARCHAR2(3) NOT NULL	Honors Suffix
17	DESCR50_1	Character(50)	VARCHAR2(50) NOT NULL	Description of length 50
18	ACAD_SUBPLAN_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Academic Sub-Plan Type CON=Concentration EMP=Emphasis MIN=Minor OPT=Option SPC=Specialization TRK=Track
19	SSR_SPLNTYPE_DESCR	Character(30)	VARCHAR2(30) NOT NULL	This field is a DESCR field that will contain the academic subplan type description