AGC_TMA_IDAGC_SRCH_CRT_FLDAGC_TMA_RKEY_VW(SQL View) |
Index Back |
|---|---|
AGC TMA Required Key ViewActivity Guide Composer Required Key View |
| SELECT DISTINCT TS.AGC_TMA_ID , SF.AGC_SRCH_CRT_FLD , SF.AGC_SRCH_SRC_TBL FROM PS_AGC_TMA_SKEY TS , PS_AGC_SRCHKEY_TBL ST , PS_AGC_SRCHKEY_FLD SF WHERE TS.AGC_SRCH_KEY = ST.AGC_SRCH_KEY AND ST.AGC_SRCH_SRC_TBL = SF.AGC_SRCH_SRC_TBL AND SF.AGC_SRCH_CRT_TYPE = 'R' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | AGC_TMA_ID |
Character(20) | VARCHAR2(20) NOT NULL | Activity Guide Composer Template Assignement Id |
| 2 | AGC_SRCH_CRT_FLD |
Character(18) | VARCHAR2(18) NOT NULL | Activity Guide Composer Criteria Field |
| 3 | AGC_SRCH_SRC_TBL | Character(15) | VARCHAR2(15) NOT NULL | Activity Guide Composer Search Source Table |