UNIT_CONV_TRVW(SQL View) |
Index Back |
|---|---|
Unit Conv Transfer Credit ViewThis view is used in the Transfer Credit process to convert units. |
| SELECT a.SETID , a.TERM_TYPE , a.EFFDT , a.TERM_TYPE_CONVR_TO , a.UNIT_MULTIPLIER FROM PS_UNIT_CONVR_TBL a |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SRC_SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | SRC_TERM_TYPE |
Character(1) | VARCHAR2(1) NOT NULL |
Term Unit Type
C=Clock Hours E=Continuing Education Units Q=Quarter Hours S=Semester Hours T=Trimester Hours U=Units |
| 3 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 4 | TERM_TYPE |
Character(1) | VARCHAR2(1) NOT NULL |
Term Unit Type
C=Clock Hours E=Continuing Education Units Q=Quarter Hours S=Semester Hours T=Trimester Hours U=Units Prompt Table: TERM_TYPE_TBL |
| 5 | UNIT_MULTIPLIER | Number(9,4) | DECIMAL(8,4) NOT NULL | Unit Multiplier |