Transfer (TRNS) Course Report
Data Source | Snowflake |
|---|---|
Job/Process Source (Refresh Interval) | Nightly refreshed data
|
Report Domain | Transfer credit course information for students |
Functional User(s) | Justine Kincade |
Constituent(s) | |
Report Owner | Justine Kincade |
Data Domain(s) | Academic |
Contains PII | No |
What It’s Used For
To identify students that are enrolled in a term who have transfer credit or students that have bulk transfer credit regardless of term. Bulk credit is an outdated evaluation method and if the student is currently taking courses that needs to be re-evaluated. This report is a way to identify the students for re-evaluation so that their record and DegreeWorks audit is accurate.
Options
Options | Description |
|---|---|
Enrolled Term (TRNS Course Enrolled By Term Tab) | |
Effective Term (TRNS Course By Transfer Effective Term) | |
Student ID | Banner ID of the Student. Default value is @, which will show all student ID’s. Specify in @XXXXXXXX |
Subject Code | Subject Code of the equivalent transfer course. |
Course Number | Course Number of the equivalent transfer course. |
Institution | The school's name. |
Results
Field Name | Data Source/Logic |
|---|---|
TERM_CODE | |
STUDENT_ID |
|
TRANSFER_EFF_TERM_CODE |
|
SUBJ_CODE |
|
CRSE_NUMB |
|
CRSE_TITLE |
|
CRSE_SEQ_NO |
|
CREDIT_HOURS |
|
GRADING_MODE |
|
GRADING_MODE_DESC |
|
GRADE |
|
COUNT_GPA |
|
REPEAT_COURSE |
|
REPEAT_SYSTEM |
|
INSTITUTION_CODE |
|
INSTITUTION_DESC |
|
TRANSCRIPTION_RECEIPT_DATE |
|
ATTENDANCE_PERIOD |
|
ACCEPTANCE_DATE |
|
EFFECTIVE_TERM_OF_TRANSFER_ACCEPTANCE |
|
| Version | Date | Comment |
|---|---|---|
| Current Version (v. 3) | May 12, 2025 15:25 | Jordan Lamb |
| v. 2 | May 09, 2025 23:15 | Farzan Yazdani |
| v. 1 | May 09, 2025 22:44 | Farzan Yazdani |