SSR_TSRSLT_ENRL(SQL Table) |
Index Back |
---|---|
Transcript Enrollment RecordTranscript 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 |