SSR_TSRSLT_MLS

#	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	ACAD_PROG	Character(5)	VARCHAR2(5) NOT NULL	Academic Program
8	MILESTONE_NBR	Number(4,0)	SMALLINT NOT NULL	Milestone Nbr
9	MILESTONE	Character(10)	VARCHAR2(10) NOT NULL	Milestone
10	DESCRFORMAL	Character(50)	VARCHAR2(50) NOT NULL	Formal Description field
11	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
12	MILESTONE_LEVEL	Character(15)	VARCHAR2(15) NOT NULL	Milestone Level
13	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
14	MILESTONE_TITLE	Character(254)	VARCHAR2(254) NOT NULL	Milestone Title
15	MILESTONE_COMPLETE	Character(1)	VARCHAR2(1) NOT NULL	Milestone Complete I=In Progress N=Not Completed Y=Completed
16	HOW_COMPLETED	Character(2)	VARCHAR2(2) NOT NULL	How Completed A=Native Speaker B=Attended Seminar C=Submitted Work D=Filed Petition E=Exam Taken
17	DATE_COMPLETED	Date(10)	DATE	Date Completed
18	TRANSCRIPT_LEVEL	Character(2)	VARCHAR2(2) NOT NULL	Transcript level 00=Never Print 20=Print on Official 40=Print on Unofficial 60=Print on Student Life 80=Print on Degree Progress
19	PRNT_MLSTN_DETL	Character(1)	VARCHAR2(1) NOT NULL	Print Milestone Detail A=Always Print N=Never Print S=Print If Satisfied
20	ACAD_PROG_DESCR	Character(30)	VARCHAR2(30) NOT NULL	This field is a DESCR field that will contain the academic program description for views with multiple DESCR fields.
21	ACAD_PLAN	Character(10)	VARCHAR2(10) NOT NULL	Academic Plan
22	SSR_ACADPLAN_DESCR	Character(30)	VARCHAR2(30) NOT NULL	This field is a DESCR field that will contain the academic plan description
23	SSR_SORT_MLSTN	Character(1)	VARCHAR2(1) NOT NULL	Sort Milestones by Program on the Transcript