RBC_TERM_VW(SQL View) |
Index Back |
---|---|
Template term viewUsed 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 |