AGC_SRCHKEY_TBL (SQL Table)	Index Back
AGC TMA Search Key Table Activity Guide Composer Template Assignment Search Key Table - This table will store the configuration for seach keys that can be used when defining a Template Assignement table.

AGC_SRCHKEY_TBL

(SQL Table)

AGC TMA Search Key Table

Activity Guide Composer Template Assignment Search Key Table - This table will store the configuration for seach keys that can be used when defining a Template Assignement table.

Related Language Record: AGC_SRCHKEY_LNG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 AGC_SRCH_KEY Character(30) VARCHAR2(30) NOT NULL Activity Guide Composer Search Key

2 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50

3 AGC_SRCH_SRC_TBL Character(15) VARCHAR2(15) NOT NULL Activity Guide Composer Search Source Table
Prompt Table: AGC_SRCHREC_TBL

4 AGC_SRCH_SRC_FLD Character(18) VARCHAR2(18) NOT NULL Activity Guide Composer Search Key Source Field
Prompt Table: AGC_SRCH_SF_VW

5 AGC_SRCH_S_FKEY1 Character(18) VARCHAR2(18) NOT NULL Activity Guide Composer Search Source Foreign Key 1
Prompt Table: AGC_SRCH_SFK_VW

6 AGC_SRCH_S_FKEY2 Character(18) VARCHAR2(18) NOT NULL Activity Guide Composer Search Source Foreign Key 2
Prompt Table: AGC_SRCH_SFK_VW

7 AGC_SRCH_S_FKEY3 Character(18) VARCHAR2(18) NOT NULL Activity Guide Composer Search Source Foreign Key 3
Prompt Table: AGC_SRCH_SFK_VW

8 AGC_TMA_EDITTYPE Character(1) VARCHAR2(1) NOT NULL Activity Guide Composer Edit Type
1=No Table Edit
2=Prompt Table
3=Translate Table Edit
4=Yes/No

9 AGC_SRCH_P_TBL Character(15) VARCHAR2(15) NOT NULL Activity Guide Composer Search Prompt Table
Prompt Table: PSRECDEFNPVW

10 AGC_SRCH_P_KEY1 Character(18) VARCHAR2(18) NOT NULL Activity Guide Composer Prompt Key 1
Prompt Table: AGC_SRCH_PK_VW

11 AGC_SRCH_P_KEY2 Character(18) VARCHAR2(18) NOT NULL Activity Guide Composer Prompt Key 2
Prompt Table: AGC_SRCH_PK_VW

12 AGC_SRCH_P_KEY3 Character(18) VARCHAR2(18) NOT NULL Activity Guide Composer Prompt Key 3
Prompt Table: AGC_SRCH_PK_VW

13 DATA_TYPE_CD Character(1) VARCHAR2(1) NOT NULL Data Type Code
N=Customer Data
S=Sample Data
Y=System Data
Default Value: N

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	AGC_SRCH_KEY	Character(30)	VARCHAR2(30) NOT NULL	Activity Guide Composer Search Key
2	DESCR50	Character(50)	VARCHAR2(50) NOT NULL	Description of length 50
3	AGC_SRCH_SRC_TBL	Character(15)	VARCHAR2(15) NOT NULL	Activity Guide Composer Search Source Table Prompt Table: AGC_SRCHREC_TBL
4	AGC_SRCH_SRC_FLD	Character(18)	VARCHAR2(18) NOT NULL	Activity Guide Composer Search Key Source Field Prompt Table: AGC_SRCH_SF_VW
5	AGC_SRCH_S_FKEY1	Character(18)	VARCHAR2(18) NOT NULL	Activity Guide Composer Search Source Foreign Key 1 Prompt Table: AGC_SRCH_SFK_VW
6	AGC_SRCH_S_FKEY2	Character(18)	VARCHAR2(18) NOT NULL	Activity Guide Composer Search Source Foreign Key 2 Prompt Table: AGC_SRCH_SFK_VW
7	AGC_SRCH_S_FKEY3	Character(18)	VARCHAR2(18) NOT NULL	Activity Guide Composer Search Source Foreign Key 3 Prompt Table: AGC_SRCH_SFK_VW
8	AGC_TMA_EDITTYPE	Character(1)	VARCHAR2(1) NOT NULL	Activity Guide Composer Edit Type 1=No Table Edit 2=Prompt Table 3=Translate Table Edit 4=Yes/No
9	AGC_SRCH_P_TBL	Character(15)	VARCHAR2(15) NOT NULL	Activity Guide Composer Search Prompt Table Prompt Table: PSRECDEFNPVW
10	AGC_SRCH_P_KEY1	Character(18)	VARCHAR2(18) NOT NULL	Activity Guide Composer Prompt Key 1 Prompt Table: AGC_SRCH_PK_VW
11	AGC_SRCH_P_KEY2	Character(18)	VARCHAR2(18) NOT NULL	Activity Guide Composer Prompt Key 2 Prompt Table: AGC_SRCH_PK_VW
12	AGC_SRCH_P_KEY3	Character(18)	VARCHAR2(18) NOT NULL	Activity Guide Composer Prompt Key 3 Prompt Table: AGC_SRCH_PK_VW
13	DATA_TYPE_CD	Character(1)	VARCHAR2(1) NOT NULL	Data Type Code N=Customer Data S=Sample Data Y=System Data Default Value: N