AGC_SRCH_SRC_TBLPrompt Table: PSRECDEFNPVW
AGC_SRCH_CRT_FLDD=Derived
R=Required
N=Customer Data
S=Sample Data
Y=System Data
Default Value: N
AGC_SRCHKEY_FLD(SQL Table) |
Index Back |
|---|---|
AGC TMA Search Record KeysActivity Guide Composer Template Assignment Search Record Keys Table - This table will store the keys for source records for search keys that can be used when defining a Template Assignment table. |
| # | 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 | AGC_SRCH_CRT_FLD |
Character(18) | VARCHAR2(18) NOT NULL | Activity Guide Composer Criteria Field |
| 3 | AGC_SRCH_CRT_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Activity Guide Composer Criteria Type
D=Derived R=Required |
| 4 | AGC_KEY_ORDER | Number(3,0) | SMALLINT NOT NULL | Activity Guide Composer Key Order |
| 5 | DATA_TYPE_CD | Character(1) | VARCHAR2(1) NOT NULL |
Data Type Code
N=Customer Data S=Sample Data Y=System Data Default Value: N |