AGC_TMA_DATA(SQL Table) |
Index Back |
---|---|
AGC TMA Data TableActivity Guide Composer Template Assignment Table - This table is the template assignment data table. It contains the values of the search keys that map to a specific activity guide template. |
# | 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 CD
N=Customer Data S=Sample Data Y=System Data Default Value: N |