AGC_TMA_DATA

(SQL Table)
Index Back

AGC TMA Data Table

Activity 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