EXT_TERM_CNVRSN (SQL Table)	Index Back
External Term Conversion Use EXT_TERM_CNVRSN is a child table of EXT_TERM_TBL. This table stores the conversion multipliers used to convert external term units to internal units for different term types.

EXT_TERM_CNVRSN

(SQL Table)

External Term Conversion

Use EXT_TERM_CNVRSN is a child table of EXT_TERM_TBL. This table stores the conversion multipliers used to convert external term units to internal units for different term types.

Parent record: EXT_TERM_TBL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EXT_TERM_TYPE Character(4) VARCHAR2(4) NOT NULL External Term Type
1YR=Full Year
MINI=Miniterm
OTHR=Other
QTR=Quarter
QUIN=Quinmester
SEM=Semester
TRIM=Trimester
UNKN=Unknown

2 EXT_TERM Character(4) VARCHAR2(4) NOT NULL External Term
FALL=Fall
SPR=Spring
SUMR=Summer
WINT=Winter

3 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

4 TERM_TYPE_MULT Number(6,2) DECIMAL(5,2) NOT NULL Term Type Multiple
Default Value: 1

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EXT_TERM_TYPE	Character(4)	VARCHAR2(4) NOT NULL	External Term Type 1YR=Full Year MINI=Miniterm OTHR=Other QTR=Quarter QUIN=Quinmester SEM=Semester TRIM=Trimester UNKN=Unknown
2	EXT_TERM	Character(4)	VARCHAR2(4) NOT NULL	External Term FALL=Fall SPR=Spring SUMR=Summer WINT=Winter
3	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
4	TERM_TYPE_MULT	Number(6,2)	DECIMAL(5,2) NOT NULL	Term Type Multiple Default Value: 1