| # |
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 |
CUR_GPA |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Current GPA
|
| 9 |
CUM_GPA |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Cumulative GPA
|
| 10 |
UNT_TAKEN_GPA |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Units Taken Toward GPA
|
| 11 |
UNT_TAKEN_NOGPA |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Units Taken Not Toward GPA
|
| 12 |
UNT_TAKEN_PRGRSS |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Units Taken for Progress
|
| 13 |
UNT_TEST_CREDIT |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Units from Test Credit
|
| 14 |
UNT_TRNSFR |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Units Transferred
|
| 15 |
UNT_OTHER |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Units from Other Credit
|
| 16 |
UNT_PASSD_GPA |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Units Passed Toward GPA
|
| 17 |
UNT_PASSD_NOGPA |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Units Passed Not Toward GPA
|
| 18 |
UNT_PASSD_PRGRSS |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Units Passed for Progress
|
| 19 |
UNT_INPROG_GPA |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Units In Progress - GPA
|
| 20 |
UNT_INPROG_NOGPA |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Unit In Progress - Not for GPA
|
| 21 |
GRADE_POINTS |
Number(10,3) |
DECIMAL(9,3) NOT NULL |
Grade Points
|
| 22 |
TRF_PASSED_GPA |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Transfer Passed for GPA
|
| 23 |
TRF_PASSED_NOGPA |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Transfer Passed Not for GPA
|
| 24 |
TRF_TAKEN_GPA |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Term Units for GPA of Transfer Credits
|
| 25 |
TRF_TAKEN_NOGPA |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Transfer Taken Not for GPA
|
| 26 |
TRF_GRADE_POINTS |
Number(10,3) |
DECIMAL(9,3) NOT NULL |
Term Grade Points of Transfer Credits.
|
| 27 |
TC_UNITS_ADJUST |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Transfer Credits Units Adjustment
|
| 28 |
TOT_TC_UNIT_ADJUST |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Total TC Units Adjustment
|
| 29 |
TOT_TAKEN_GPA |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Cumulative Units for GPA of Enrollments and Transfer Credits
|
| 30 |
TOT_TAKEN_NOGPA |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Total Taken Not Toward GPA
|
| 31 |
TOT_TAKEN_PRGRSS |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Total Taken for Progress
|
| 32 |
TOT_PASSD_GPA |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Total Passed Toward GPA
|
| 33 |
TOT_PASSD_NOGPA |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Total Passed Not Toward GPA
|
| 34 |
TOT_PASSD_PRGRSS |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Total Passed for Progress
|
| 35 |
TOT_INPROG_GPA |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Total In Progress - GPA
|
| 36 |
TOT_INPROG_NOGPA |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Total In Progress -Not for GPA
|
| 37 |
TOT_GRADE_POINTS |
Number(10,3) |
DECIMAL(9,3) NOT NULL |
Cumulative Grade Points of Enrollment and Transfer Credits
|
| 38 |
TOT_TRNSFR |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Total Transferred
|
| 39 |
TOT_TEST_CREDIT |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Total From Test Credit
|
| 40 |
TOT_OTHER |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Total from Other Credit
|
| 41 |
TOT_CUMULATIVE |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Total Cumulative Units
|
| 42 |
SSR_TRF_CUR_GPA |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Term GPA of Transfer Credits
|
| 43 |
SSR_COMB_CUR_GPA |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Term GPA of Enrollments and Transfer Credits
|
| 44 |
SSR_CUM_EN_GPA |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Cumulative Enrollment GPA
|
| 45 |
SSR_TOT_EN_GRDPTS |
Number(10,3) |
DECIMAL(9,3) NOT NULL |
Cumulative Enrollment Grade Points
|
| 46 |
SSR_TOT_EN_PRGRSS |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Cumulative Enrollment Attempted Units
|
| 47 |
SSR_TOT_ENPASPRGRS |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Cumulative Enrollment Earned Units
|
| 48 |
SSR_TOT_EN_TKNGPA |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Cumulative Enrollment Units for GPA
|
| 49 |
SSR_CUM_TR_GPA |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Cumulative GPA of Transfer Credits
|
| 50 |
SSR_TOT_TR_GRDPTS |
Number(10,3) |
DECIMAL(9,3) NOT NULL |
Cumulative Transfer Credits Grade Points
|
| 51 |
SSR_TOT_TR_TKNGPA |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Cumulative Transfer Credits Units for GPA
|
| 52 |
SSR_SUMTRF_TKNNGPA |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Sum of Transfer Taken No GPA used on transcript report statistics
|
| 53 |
SSR_SUMTRF_PASGPA |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Sum of Transfer Passed GPA used on transcript report statistics
|
| 54 |
SSR_SUMTRF_PASNGPA |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Sum of Transfer Passed No GPA used on transcript report statistics
|
| 55 |
SSR_SUMUNT_PASGPA |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Sum of Unit Passed for GPA used on transcript report statistics
|
| 56 |
SSR_SUMUNT_PASNGPA |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Sum of Unit Passed Not for GPA used on transcript report statistics
|
| 57 |
SSR_SUMUNT_TKNNGPA |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Sum of Unit Taken No GPA used on transcript report statistics
|
| 58 |
SSR_SUMUNT_INPRGPA |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Sum of Unit In Progress for GPA used on transcript report statistics
|
| 59 |
SSR_SUMUNT_INPRNGP |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Sum of Unit In Progress for Not for GPA used on transcript report statistics
|
| 60 |
RESET_CUM_STATS |
Character(1) |
VARCHAR2(1) NOT NULL |
Reset Cum Stats at Term Start
|
| 61 |
SSR_TERMSTAT_TRFCR |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Transfer Credit Stats
|
| 62 |
CUM_STAT_COP |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Cums at Change of Pgm
|
| 63 |
CUM_STAT_EOT |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Cums at End of Term
|
| 64 |
CUM_STAT_EOX |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Cums at End of Tscript
|