TERM_VAL_TBL_VW (SQL View)	Index Back
Term Value Table View This is a view of the Term Value Table.

TERM_VAL_TBL_VW

(SQL View)

Term Value Table View

This is a view of the Term Value Table.

SELECT strm , descr , descrshort , next_class_no , SSR_SSCLS_STD_BDT , SSR_SSCLS_STD_EDT , SSR_SSCLS_INSR_BDT , SSR_SSCLS_INSR_EDT FROM PS_TERM_VAL_TBL

Related Language Record: TERM_VAL_LANG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 STRM Character(4) VARCHAR2(4) NOT NULL Term

2 DESCR Character(30) VARCHAR2(30) NOT NULL Description

3 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
Default Value: TERM_VAL_TBL.DESCR

4 NEXT_CLASS_NO Number(5,0) INTEGER NOT NULL Next Class Nbr
Default Value: 1001

5 SSR_SSCLS_STD_BDT Date(10) DATE NOT NULL Show term in Self Service Planner begin date

6 SSR_SSCLS_STD_EDT Date(10) DATE NOT NULL Show term in Self Service Planner begin date

7 SSR_SSCLS_INSR_BDT Date(10) DATE NOT NULL Show term in Self Service Planner begin date

8 SSR_SSCLS_INSR_EDT Date(10) DATE NOT NULL Show term in Self Service Planner begin date

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	STRM	Character(4)	VARCHAR2(4) NOT NULL	Term
2	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
3	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description Default Value: TERM_VAL_TBL.DESCR
4	NEXT_CLASS_NO	Number(5,0)	INTEGER NOT NULL	Next Class Nbr Default Value: 1001
5	SSR_SSCLS_STD_BDT	Date(10)	DATE NOT NULL	Show term in Self Service Planner begin date
6	SSR_SSCLS_STD_EDT	Date(10)	DATE NOT NULL	Show term in Self Service Planner begin date
7	SSR_SSCLS_INSR_BDT	Date(10)	DATE NOT NULL	Show term in Self Service Planner begin date
8	SSR_SSCLS_INSR_EDT	Date(10)	DATE NOT NULL	Show term in Self Service Planner begin date