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