SSR_TSRSLT_TCDH

(SQL Table)
Index Back

Transcript Record

Transcript results term record

# 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_CR_DETAIL Character(1) VARCHAR2(1) NOT NULL Details to Print
B=External and Internal
E=External Courses
I=Internal Equivalent Course
10 TRNSFR_SRC_TYPE Character(1) VARCHAR2(1) NOT NULL Credit Source Type
E=External
I=Internal
M=Manual Input
11 DESCR Character(30) VARCHAR2(30) NOT NULL Description
12 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50
13 MODEL_STATUS Character(1) VARCHAR2(1) NOT NULL Model Status
C=Evaluation Complete
M=Submitted
P=Posted
U=Unposted
14 UNT_TAKEN Number(6,2) DECIMAL(5,2) NOT NULL Units Taken
15 UNT_TRNSFR Number(9,3) DECIMAL(8,3) NOT NULL Units Transferred
16 TRF_TAKEN_GPA Number(9,3) DECIMAL(8,3) NOT NULL Term Units for GPA of Transfer Credits
17 TRF_TAKEN_NOGPA Number(9,3) DECIMAL(8,3) NOT NULL Transfer Taken Not for GPA
18 TRF_PASSED_GPA Number(9,3) DECIMAL(8,3) NOT NULL Transfer Passed for GPA
19 TRF_PASSED_NOGPA Number(9,3) DECIMAL(8,3) NOT NULL Transfer Passed Not for GPA
20 TRF_GRADE_POINTS Number(10,3) DECIMAL(9,3) NOT NULL Term Grade Points of Transfer Credits.
21 TRF_GPA Number(9,3) DECIMAL(8,3) NOT NULL Transfer GPA