RBC_TERM_VW

(SQL View)
Index Back

Template term view

Used to retrieve template terms

SELECT A.RB_TEMPLATE_ID ,A.RB_TEMPLATE_NAME ,B.EOCF_LIB_TERM_ID ,B.EOCF_LIB_TERM_NAME FROM PS_RBC_TEMPLAT_TKN A ,PS_EOCF_TERM_DEFN B WHERE A.RB_USE_TKNGRP = '0' AND A.RB_TOKEN_ID = B.EOCF_LIB_TERM_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 RB_TEMPLATE_ID Number(10,0) DECIMAL(10) NOT NULL Template ID
2 RB_TEMPLATE_NAME Character(30) VARCHAR2(30) NOT NULL Template Name
3 EOCF_LIB_TERM_ID Number(31,0) DECIMAL(31) NOT NULL a library element that can be evaluated. NOTE: this primary key value is actually a foreign key to the library element portion of a term. Terms are sub-types of elements.
4 EOCF_LIB_TERM_NAME Character(80) VARCHAR2(80) NOT NULL the name of the Term in the library