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 | RB_TKNGRP_NAME | Character(30) | VARCHAR2(30) NOT NULL | Token Group Name |
2 | RB_TOKEN_ID | 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 |