RBC_GRP_TERM_V(SQL View) |
Index Back |
|---|---|
Group termCRm common object view used for group term |
| SELECT A.RB_TKNGRP_NAME ,A.RB_TOKEN_ID ,B.EOCF_LIB_TERM_NAME FROM PS_RBC_TKNGRP_DTL A ,PS_EOCF_TERM_DEFN B WHERE A.RB_TOKEN_ID = B.EOCF_LIB_TERM_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Character(30) | VARCHAR2(30) NOT NULL | Token Group Name | |
| 2 | Number(31,0) | DECIMAL(31) NOT NULL | Unique Token Identifier | |
| 3 | EOCF_LIB_TERM_NAME | Character(80) | VARCHAR2(80) NOT NULL | the name of the Term in the library |