| # |
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_KEY_SEQ |
Number(2,0) |
SMALLINT NOT NULL |
Activity Guide Composer Key Sequence/Priority
|
| 3 |
AGC_TEMPLATE_ID |
Character(7) |
VARCHAR2(7) NOT NULL |
Activity Guide Composer Template Id
Prompt Table:
AGC_TMPL_CAT_VW
|
| 4 |
AGC_SRCH_KEY_1_1 |
Character(20) |
VARCHAR2(20) NOT NULL |
Activity Guide Composer Search Key Value 1
Prompt Table:
AGC_PROMPT_DVW
|
| 5 |
AGC_SRCH_KEY_1_2 |
Character(20) |
VARCHAR2(20) NOT NULL |
Activity Guide Composer Search Key Value 1
Prompt Table:
AGC_PROMPT_DVW
|
| 6 |
AGC_SRCH_KEY_1_3 |
Character(20) |
VARCHAR2(20) NOT NULL |
Activity Guide Composer Search Key Value 1
Prompt Table:
AGC_PROMPT_DVW
|
| 7 |
AGC_SRCH_KEY_2_1 |
Character(20) |
VARCHAR2(20) NOT NULL |
Activity Guide Composer Search Key Value 1
Prompt Table:
AGC_PROMPT_DVW
|
| 8 |
AGC_SRCH_KEY_2_2 |
Character(20) |
VARCHAR2(20) NOT NULL |
Activity Guide Composer Search Key Value 1
Prompt Table:
AGC_PROMPT_DVW
|
| 9 |
AGC_SRCH_KEY_2_3 |
Character(20) |
VARCHAR2(20) NOT NULL |
Activity Guide Composer Search Key Value 1
Prompt Table:
AGC_PROMPT_DVW
|
| 10 |
AGC_SRCH_KEY_3_1 |
Character(20) |
VARCHAR2(20) NOT NULL |
Activity Guide Composer Search Key Value 1
Prompt Table:
AGC_PROMPT_DVW
|
| 11 |
AGC_SRCH_KEY_3_2 |
Character(20) |
VARCHAR2(20) NOT NULL |
Activity Guide Composer Search Key Value 1
Prompt Table:
AGC_PROMPT_DVW
|
| 12 |
AGC_SRCH_KEY_3_3 |
Character(20) |
VARCHAR2(20) NOT NULL |
Activity Guide Composer Search Key Value 1
Prompt Table:
AGC_PROMPT_DVW
|
| 13 |
AGC_SRCH_KEY_4_1 |
Character(20) |
VARCHAR2(20) NOT NULL |
Activity Guide Composer Search Key Value 1
Prompt Table:
AGC_PROMPT_DVW
|
| 14 |
AGC_SRCH_KEY_4_2 |
Character(20) |
VARCHAR2(20) NOT NULL |
Activity Guide Composer Search Key Value 1
Prompt Table:
AGC_PROMPT_DVW
|
| 15 |
AGC_SRCH_KEY_4_3 |
Character(20) |
VARCHAR2(20) NOT NULL |
Activity Guide Composer Search Key Value 1
Prompt Table:
AGC_PROMPT_DVW
|
| 16 |
AGC_SRCH_KEY_5_1 |
Character(20) |
VARCHAR2(20) NOT NULL |
Activity Guide Composer Search Key Value 1
Prompt Table:
AGC_PROMPT_DVW
|
| 17 |
AGC_SRCH_KEY_5_2 |
Character(20) |
VARCHAR2(20) NOT NULL |
Activity Guide Composer Search Key Value 1
Prompt Table:
AGC_PROMPT_DVW
|
| 18 |
AGC_SRCH_KEY_5_3 |
Character(20) |
VARCHAR2(20) NOT NULL |
Activity Guide Composer Search Key Value 1
Prompt Table:
AGC_PROMPT_DVW
|
| 19 |
AGC_SRCH_KEY_6_1 |
Character(20) |
VARCHAR2(20) NOT NULL |
Activity Guide Composer Search Key Value 1
Prompt Table:
AGC_PROMPT_DVW
|
| 20 |
AGC_SRCH_KEY_6_2 |
Character(20) |
VARCHAR2(20) NOT NULL |
Activity Guide Composer Search Key Value 1
Prompt Table:
AGC_PROMPT_DVW
|
| 21 |
AGC_SRCH_KEY_6_3 |
Character(20) |
VARCHAR2(20) NOT NULL |
Activity Guide Composer Search Key Value 1
Prompt Table:
AGC_PROMPT_DVW
|
| 22 |
AGC_SRCH_KEY_7_1 |
Character(20) |
VARCHAR2(20) NOT NULL |
Activity Guide Composer Search Key Value 1
Prompt Table:
AGC_PROMPT_DVW
|
| 23 |
AGC_SRCH_KEY_7_2 |
Character(20) |
VARCHAR2(20) NOT NULL |
Activity Guide Composer Search Key Value 1
Prompt Table:
AGC_PROMPT_DVW
|
| 24 |
AGC_SRCH_KEY_7_3 |
Character(20) |
VARCHAR2(20) NOT NULL |
Activity Guide Composer Search Key Value 1
Prompt Table:
AGC_PROMPT_DVW
|
| 25 |
AGC_SRCH_KEY_8_1 |
Character(20) |
VARCHAR2(20) NOT NULL |
Activity Guide Composer Search Key Value 1
Prompt Table:
AGC_PROMPT_DVW
|
| 26 |
AGC_SRCH_KEY_8_2 |
Character(20) |
VARCHAR2(20) NOT NULL |
Activity Guide Composer Search Key Value 1
Prompt Table:
AGC_PROMPT_DVW
|
| 27 |
AGC_SRCH_KEY_8_3 |
Character(20) |
VARCHAR2(20) NOT NULL |
Activity Guide Composer Search Key Value 1
Prompt Table:
AGC_PROMPT_DVW
|
| 28 |
AGC_SRCH_KEY_9_1 |
Character(20) |
VARCHAR2(20) NOT NULL |
Activity Guide Composer Search Key Value 1
Prompt Table:
AGC_PROMPT_DVW
|
| 29 |
AGC_SRCH_KEY_9_2 |
Character(20) |
VARCHAR2(20) NOT NULL |
Activity Guide Composer Search Key Value 1
Prompt Table:
AGC_PROMPT_DVW
|
| 30 |
AGC_SRCH_KEY_9_3 |
Character(20) |
VARCHAR2(20) NOT NULL |
Activity Guide Composer Search Key Value 1
Prompt Table:
AGC_PROMPT_DVW
|
| 31 |
AGC_SRCH_KEY_10_1 |
Character(20) |
VARCHAR2(20) NOT NULL |
Activity Guide Composer Search Key Value 1
Prompt Table:
AGC_PROMPT_DVW
|
| 32 |
AGC_SRCH_KEY_10_2 |
Character(20) |
VARCHAR2(20) NOT NULL |
Activity Guide Composer Search Key Value 1
Prompt Table:
AGC_PROMPT_DVW
|
| 33 |
AGC_SRCH_KEY_10_3 |
Character(20) |
VARCHAR2(20) NOT NULL |
Activity Guide Composer Search Key Value 1
Prompt Table:
AGC_PROMPT_DVW
|
| 34 |
AGC_SRCH_KEY_11_1 |
Character(20) |
VARCHAR2(20) NOT NULL |
Activity Guide Composer Search Key Value 1
Prompt Table:
AGC_PROMPT_DVW
|
| 35 |
AGC_SRCH_KEY_11_2 |
Character(20) |
VARCHAR2(20) NOT NULL |
Activity Guide Composer Search Key Value 1
Prompt Table:
AGC_PROMPT_DVW
|
| 36 |
AGC_SRCH_KEY_11_3 |
Character(20) |
VARCHAR2(20) NOT NULL |
Activity Guide Composer Search Key Value 1
Prompt Table:
AGC_PROMPT_DVW
|
| 37 |
AGC_SRCH_KEY_12_1 |
Character(20) |
VARCHAR2(20) NOT NULL |
Activity Guide Composer Search Key Value 1
Prompt Table:
AGC_PROMPT_DVW
|
| 38 |
AGC_SRCH_KEY_12_2 |
Character(20) |
VARCHAR2(20) NOT NULL |
Activity Guide Composer Search Key Value 1
Prompt Table:
AGC_PROMPT_DVW
|
| 39 |
AGC_SRCH_KEY_12_3 |
Character(20) |
VARCHAR2(20) NOT NULL |
Activity Guide Composer Search Key Value 1
Prompt Table:
AGC_PROMPT_DVW
|
| 40 |
AGC_SRCH_KEY_13_1 |
Character(20) |
VARCHAR2(20) NOT NULL |
Activity Guide Composer Search Key Value 1
Prompt Table:
AGC_PROMPT_DVW
|
| 41 |
AGC_SRCH_KEY_13_2 |
Character(20) |
VARCHAR2(20) NOT NULL |
Activity Guide Composer Search Key Value 1
Prompt Table:
AGC_PROMPT_DVW
|
| 42 |
AGC_SRCH_KEY_13_3 |
Character(20) |
VARCHAR2(20) NOT NULL |
Activity Guide Composer Search Key Value 1
Prompt Table:
AGC_PROMPT_DVW
|
| 43 |
AGC_SRCH_KEY_14_1 |
Character(20) |
VARCHAR2(20) NOT NULL |
Activity Guide Composer Search Key Value 1
Prompt Table:
AGC_PROMPT_DVW
|
| 44 |
AGC_SRCH_KEY_14_2 |
Character(20) |
VARCHAR2(20) NOT NULL |
Activity Guide Composer Search Key Value 1
Prompt Table:
AGC_PROMPT_DVW
|
| 45 |
AGC_SRCH_KEY_14_3 |
Character(20) |
VARCHAR2(20) NOT NULL |
Activity Guide Composer Search Key Value 1
Prompt Table:
AGC_PROMPT_DVW
|
| 46 |
AGC_SRCH_KEY_15_1 |
Character(20) |
VARCHAR2(20) NOT NULL |
Activity Guide Composer Search Key Value 1
Prompt Table:
AGC_PROMPT_DVW
|
| 47 |
AGC_SRCH_KEY_15_2 |
Character(20) |
VARCHAR2(20) NOT NULL |
Activity Guide Composer Search Key Value 1
Prompt Table:
AGC_PROMPT_DVW
|
| 48 |
AGC_SRCH_KEY_15_3 |
Character(20) |
VARCHAR2(20) NOT NULL |
Activity Guide Composer Search Key Value 1
Prompt Table:
AGC_PROMPT_DVW
|
| 49 |
DATA_TYPE_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Data Type Code
N=Customer Data
S=Sample Data
Y=System Data
Default Value: N
|