SSR_TSRSLT_ENRL

(SQL Table)
Index Back

Transcript Enrollment Record

Transcript Results student enrollment coursework

# 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 STRM Character(4) VARCHAR2(4) NOT NULL Term
5 SEQNO Number(5,0) INTEGER NOT NULL Sequence Number
6 PRINT_AREA_CODE Character(2) VARCHAR2(2) NOT NULL Print Area Code
7 SSR_ROWTYPE Character(4) VARCHAR2(4) NOT NULL Transcript Result Row Type
8 CLASS_NBR Number(5,0) INTEGER NOT NULL Class Nbr
9 CRSE_ID Character(6) VARCHAR2(6) NOT NULL Course ID
10 CRSE_OFFER_NBR Number(2,0) SMALLINT NOT NULL Course Offering Nbr
11 CLASS_SECTION Character(4) VARCHAR2(4) NOT NULL Class Section
12 SESSION_CODE Character(3) VARCHAR2(3) NOT NULL Session
1=Regular Academic Session
10W=10 Week
12W=Twelve Week
4W1=Four Week - First
4W2=Four Week - Second
4W3=Four Week - Third
4W4=Four Week - Fourth
6W1=Six Week - First
6W2=Six Week - Second
8W1=Eight Week - First
8W2=Eight Week - Second
A11=Medical Period 1, 4 Weeks
A12=Medical Period 1, 8 Weeks
A13=Medical Pd 1, 12 Weeks
A21=Medical Period 2, 4 Weeks
A22=Medical Period 2, 8 Weeks
A23=Medical Period 2, 12 Week
FYR=Full Year
MIN=Mini Session
OEE=Open Entry/Open Exit
SM1=Semester 1
SM2=Semester 2
13 DESCR30 Character(30) VARCHAR2(30) NOT NULL Description
14 SUBJECT Character(8) VARCHAR2(8) NOT NULL Subject Area
15 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
16 CATALOG_NBR Character(10) VARCHAR2(10) NOT NULL Catalog Nbr
17 DESCR Character(30) VARCHAR2(30) NOT NULL Description
18 COURSE_TITLE_LONG Character(100) VARCHAR2(100) NOT NULL Long Course Title
19 ASSOCIATED_CLASS Number(4,0) SMALLINT NOT NULL Associated Class
20 GRADING_BASIS_ENRL Character(3) VARCHAR2(3) NOT NULL Grading Basis
21 SSR_GRDBASIS_DESCR Character(50) VARCHAR2(50) NOT NULL Transcript Grade Basis Formal Description field
22 UNT_TAKEN Number(6,2) DECIMAL(5,2) NOT NULL Units Taken
23 UNT_EARNED Number(6,2) DECIMAL(5,2) NOT NULL Units Earned
24 GRADE_POINTS Number(10,3) DECIMAL(9,3) NOT NULL Grade Points
25 CRSE_GRADE_OFF Character(3) VARCHAR2(3) NOT NULL Official Grade
26 SSR_TRAN_UNT_ATMPT Number(6,2) DECIMAL(5,2) NOT NULL Transcript Units Attempted field
27 SSR_TRAN_UNT_EARN Number(6,2) DECIMAL(5,2) NOT NULL Transcript Units Earned field
28 SSR_TRAN_GPA_UNITS Number(6,2) DECIMAL(5,2) NOT NULL Transcript GPA Units field
29 EARN_CREDIT Character(1) VARCHAR2(1) NOT NULL Earn Credit
30 INCLUDE_IN_GPA Character(1) VARCHAR2(1) NOT NULL Include in GPA
31 UNITS_ATTEMPTED Character(1) VARCHAR2(1) NOT NULL Units Attempted
I=In Progress
N=No
Y=Yes
32 RQMNT_DESIGNTN Character(4) VARCHAR2(4) NOT NULL This field is used to track the Requirement Designation attached to a course in Student Records. This field is also used for tracking information through Academic Advisement.
33 RQMNT_DESIGNTN_OPT Character(1) VARCHAR2(1) NOT NULL Requirement Designation Option
N=No
Y=Yes
34 RQMNT_DESIGNTN_GRD Character(1) VARCHAR2(1) NOT NULL Requirement Designation Grade
N=Not Satisfied
S=Satisfied
35 DESCRFORMAL Character(50) VARCHAR2(50) NOT NULL Formal Description field
36 REPEAT_CODE Character(4) VARCHAR2(4) NOT NULL Repeat Code
NTEA=No Taking Exam/Assessment
37 REPEAT_DT Date(10) DATE Repeat Date
38 SSR_RPTCODE_DESCR Character(50) VARCHAR2(50) NOT NULL Transcript Repeat Code Formal Description field
39 PRINT_REPEAT_DATE Character(1) VARCHAR2(1) NOT NULL Print Repeat Date
40 CRS_TOPIC_ID Number(3,0) SMALLINT NOT NULL Course Topic ID
41 SSR_TOPIC_DESCR Character(30) VARCHAR2(30) NOT NULL Course Topic
42 TSCRPT_NOTE_ID Character(4) VARCHAR2(4) NOT NULL Transcript Note ID
43 TSCRPT_NOTE_EXISTS Character(1) VARCHAR2(1) NOT NULL Transcript Note Exists Flag
44 INSTRUCTOR_ID Character(11) VARCHAR2(11) NOT NULL Instructor ID
45 SESS_BEGIN_DT Date(10) DATE Session Beginning Date
46 SESS_END_DT Date(10) DATE Session End Date
47 START_DT Date(10) DATE Start Date
48 END_DT Date(10) DATE end date
49 OEE_START_DT Date(10) DATE This is a date used for picking a start date for OEE rosters.
50 OEE_END_DT Date(10) DATE End Date
51 CRSE_CONTACT_HRS Number(6,2) DECIMAL(5,2) NOT NULL Course Contact Hours
52 ENRL_CLASS_END_DT Character(1) VARCHAR2(1) NOT NULL Print Class Dates
53 ENRL_OEE_CLASS_DT Character(1) VARCHAR2(1) NOT NULL Print OEE Class Dates
54 SSR_TS_SHOWGRADE Character(1) VARCHAR2(1) NOT NULL Show Grade
55 SSR_TSATTR_EXISTS Character(1) VARCHAR2(1) NOT NULL Flag used during transcript generation to show if course attribute data exists.

Y/N Table Edit

Default Value: N

56 SSR_TSINSR_EXISTS Character(1) VARCHAR2(1) NOT NULL Flag used during transcript generation to show if course instructor data exists.

Y/N Table Edit

Default Value: N

57 SSR_TSNOTE_EXISTS Character(1) VARCHAR2(1) NOT NULL Flag used during transcript generation to show if course note data exists.

Y/N Table Edit

Default Value: N

58 SSR_TSNOTS_EXISTS Character(1) VARCHAR2(1) NOT NULL Flag used during transcript generation to show if course note data exists.

Y/N Table Edit

Default Value: N

59 SSR_TSTPIC_EXISTS Character(1) VARCHAR2(1) NOT NULL Flag used during transcript generation to show if course topic data exists.

Y/N Table Edit

Default Value: N

60 FULLY_GRADED_DT Date(10) DATE Fully Graded Date
61 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