EXT_TERM_TBLV2 (SQL View)	Index Back
External Term Table Use EXT_TERM_TBL to define external terms which includes defining them into external term types and relating these to month codes.

EXT_TERM_TBLV2

(SQL View)

External Term Table

Use EXT_TERM_TBL to define external terms which includes defining them into external term types and relating these to month codes.

SELECT DISTINCT a.EXT_TERM_TYPE , a.EXT_TERM , a.DESCRSHORT FROM PS_EXT_TERM_TBL a

Related Language Record: EXTTERMTBLV2LNG

# 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 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

#	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	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description