AGC_SRCHREC_TBL (SQL Table)	Index Back
AGC TMA Search Source Record Activity Guide Composer Template Assignment Search Source Record Table - This table will store the configuration for source records for search keys that can be used when defining a Template Assignment table.

AGC_SRCHREC_TBL

(SQL Table)

AGC TMA Search Source Record

Activity Guide Composer Template Assignment Search Source Record Table - This table will store the configuration for source records for search keys that can be used when defining a Template Assignment table.

Parent Record Of AGC_SRCHKEY_FLD

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 DATA_TYPE_CD Character(1) VARCHAR2(1) NOT NULL Data Type CD
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_SRC_TBL	Character(15)	VARCHAR2(15) NOT NULL	Activity Guide Composer Search Source Table Prompt Table: PSRECDEFNPVW
2	DATA_TYPE_CD	Character(1)	VARCHAR2(1) NOT NULL	Data Type CD N=Customer Data S=Sample Data Y=System Data Default Value: N