SSR_TSRSLT_TCDT

#	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	MODEL_NBR	Number(3,0)	SMALLINT NOT NULL	Transfer Model Nbr
8	ARTICULATION_TERM	Character(4)	VARCHAR2(4) NOT NULL	Articulation Term
9	TRNSFR_EQVLNCY_GRP	Number(3,0)	SMALLINT NOT NULL	Transfer Equivalency Group
10	TRNSFR_EQVLNCY_SEQ	Number(3,0)	SMALLINT NOT NULL	Transfer Equivalency Seq
11	TRNSFR_SRC_ID	Character(11)	VARCHAR2(11) NOT NULL	Source ID
12	TERM_YEAR	Number(4,0)	SMALLINT NOT NULL	Term Year
13	EXT_COURSE_NBR	Number(3,0)	SMALLINT NOT NULL	External Course Number
14	EXT_TERM_TYPE	Character(4)	VARCHAR2(4) NOT NULL	External Term Type 1YR=Full Year MINI=Miniterm OTHR=Other QTR=Quarter QUIN=Quinmester SEM=Semester TRIM=Trimester UNKN=Unknown
15	EXT_TERM	Character(4)	VARCHAR2(4) NOT NULL	External Term FALL=Fall SPR=Spring SUMR=Summer WINT=Winter
16	SRC_TERM	Character(4)	VARCHAR2(4) NOT NULL	Source Term
17	SRC_CLASS_NBR	Number(5,0)	INTEGER NOT NULL	Source Class
18	SCHOOL_SUBJECT	Character(8)	VARCHAR2(8) NOT NULL	School Subject
19	SCHOOL_CRSE_NBR	Character(10)	VARCHAR2(10) NOT NULL	School Course Nbr
20	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
21	UNT_TAKEN	Number(6,2)	DECIMAL(5,2) NOT NULL	Units Taken
22	CRSE_GRADE_INPUT	Character(3)	VARCHAR2(3) NOT NULL	Grade Input A=A
23	TRNSFR_STAT	Character(1)	VARCHAR2(1) NOT NULL	Transfer Status C=Contingent Credit N=Rejected P=Posted R=No Rule Y=Accepted
24	MODEL_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Model Status C=Evaluation Complete M=Submitted P=Posted U=Unposted
25	REPEAT_CODE	Character(4)	VARCHAR2(4) NOT NULL	Repeat Code NTEA=No Taking Exam/Assessment
26	SSR_RPTCODE_DESCR	Character(50)	VARCHAR2(50) NOT NULL	Transcript Repeat Code Formal Description field
27	POST_DT	Date(10)	DATE	The Date a transaction was Posted.
28	DESCR1	Character(30)	VARCHAR2(30) NOT NULL	Descr
29	DESCRSHORT1	Character(10)	VARCHAR2(10) NOT NULL	Descr Short One
30	INSTITUTION	Character(5)	VARCHAR2(5) NOT NULL	Academic Institution
31	CRSE_ID	Character(6)	VARCHAR2(6) NOT NULL	Course ID
32	CRSE_OFFER_NBR	Number(2,0)	SMALLINT NOT NULL	Course Offering Nbr
33	SUBJECT	Character(8)	VARCHAR2(8) NOT NULL	Subject Area
34	CATALOG_NBR	Character(10)	VARCHAR2(10) NOT NULL	Catalog Nbr
35	DESCR2	Character(30)	VARCHAR2(30) NOT NULL	Descr2
36	UNT_TRNSFR	Number(9,3)	DECIMAL(8,3) NOT NULL	Units Transferred
37	CRSE_GRADE_OFF	Character(3)	VARCHAR2(3) NOT NULL	Official Grade
38	GRD_PTS_PER_UNIT	Number(10,3)	DECIMAL(9,3) NOT NULL	Grade Points Per Unit
39	GRADING_SCHEME	Character(3)	VARCHAR2(3) NOT NULL	Grading Scheme
40	GRADING_BASIS	Character(3)	VARCHAR2(3) NOT NULL	Grading Basis ANC=ABC/NC Grading AUD=Audit BMT=Multi-Term Course: Not Graded CNC=Credit / No Credit EQV=Equivalent GRD=Graded HSC=Hundred Point Scale (NLD) LAW=Law MED=Medical School Grades NOG=No Grade Associated NON=Non-Graded Component NQF=NQF Scale OPT=Student Option PNP=Pass/Not Pass SUS=Satisfactory/Unsatisfactory TRN=Transfer Grading Basis TSC=Ten Point Scale (NLD)
41	SSR_GRDBASIS_DESCR	Character(50)	VARCHAR2(50) NOT NULL	Transcript Grade Basis Formal Description field
42	EARN_CREDIT	Character(1)	VARCHAR2(1) NOT NULL	Earn Credit
43	INCLUDE_IN_GPA	Character(1)	VARCHAR2(1) NOT NULL	Include in GPA
44	UNITS_ATTEMPTED	Character(1)	VARCHAR2(1) NOT NULL	Units Attempted I=In Progress N=No Y=Yes