AGC_CAT_CTX(SQL Table) |
Index Back |
|---|---|
AGC Category Context TableActivity Guide Composer Category Context Table - This table stores the context definition for the activity guide composer category. The context definition consists of a set of fields that provide context to the activity guide composer template. The context key fields defined in this definition are assigned values when an activity guide instance is created and are used to uniquely identify activity guide instances. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  AGC_CATEGORY_ID |
Character(15) | VARCHAR2(15) NOT NULL | Activity Guide Category |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 3 | RECNAME |
Character(15) | VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
Prompt Table: AGC_CTXREC_VW |
| 4 | FIELDNAME |
Character(18) | VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
Prompt Table: AGC_CTXFLD_VW |
| 5 | DESCR100 | Character(100) | VARCHAR2(100) NOT NULL | Length 100 Description |
| 6 | AGC_CTX_DSPL_ORDER | Number(3,0) | SMALLINT NOT NULL | AGC Context Display Order |
| 7 | AGC_CTX_KEY | Character(1) | VARCHAR2(1) NOT NULL |
AGC Context Key
Y/N Table Edit |
| 8 | AGC_CTX_VALUE | Character(254) | VARCHAR2(254) NOT NULL | AGC Context Value |
| 9 | AGC_CTX_EDIT_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
AGC Prompt Edit Type
1=No Table Edit 2=Prompt Table 3=Translate Table 4=Yes/No Default Value: 1 |
| 10 | AGC_CTX_PROMPT | Character(15) | VARCHAR2(15) NOT NULL |
AGC Context Prompt Table
Prompt Table: AGC_CTXREC_VW |
| 11 | AGC_CTX_PROMPTDESC | Character(18) | VARCHAR2(18) NOT NULL |
Activity Guide Composer Context Prompt Description Field
Prompt Table: AGC_CTXREL_VW |
| 12 | AGC_CTXDTA_ID | Character(15) | VARCHAR2(15) NOT NULL |
AGC Contextual Data Id
Prompt Table: AGC_CTXDTA_TBL |
| 13 | AGC_CTXDTA_FLD_ID | Character(3) | VARCHAR2(3) NOT NULL |
AGC Contextual Data Field Id
Prompt Table: AGC_CTXDTA_FLDS |
| 14 | DATA_TYPE_CD | Character(1) | VARCHAR2(1) NOT NULL |
Data Type Code
N=Customer Data S=Sample Data Y=System Data Default Value: N |