SSR_TSRSLT_TCSH(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 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
9 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |
10 | MODEL_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Model Status
C=Evaluation Complete M=Submitted P=Posted U=Unposted |
11 | TRF_GPA | Number(9,3) | DECIMAL(8,3) NOT NULL | Transfer GPA |
12 | TRF_TAKEN_GPA | Number(9,3) | DECIMAL(8,3) NOT NULL | Term Units for GPA of Transfer Credits |
13 | TRF_TAKEN_NOGPA | Number(9,3) | DECIMAL(8,3) NOT NULL | Transfer Taken Not for GPA |
14 | TRF_PASSED_GPA | Number(9,3) | DECIMAL(8,3) NOT NULL | Transfer Passed for GPA |
15 | TRF_PASSED_NOGPA | Number(9,3) | DECIMAL(8,3) NOT NULL | Transfer Passed Not for GPA |
16 | SSR_TRCR_PASSED | Number(9,3) | DECIMAL(8,3) NOT NULL | Tranfer Credit Passed |
17 | TRF_GRADE_POINTS | Number(10,3) | DECIMAL(9,3) NOT NULL | Term Grade Points of Transfer Credits. |
18 | UNT_TAKEN | Number(6,2) | DECIMAL(5,2) NOT NULL | Units Taken |
19 | UNT_TRNSFR | Number(9,3) | DECIMAL(8,3) NOT NULL | Units Transferred |