AGC_CAT_IMG(SQL Table) |
Index Back |
---|---|
AGC Category Image TableActivity Guide Composer Category Image Table - This table stores the attributes of an Image for an activity guide category. An image can be defined to display in the sub banner of an activity guide. |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | AGC_CATEGORY_ID | Character(15) | VARCHAR2(15) NOT NULL |
Activity Guide Category
Prompt Table: AGC_CAT_TBL |
2 | EFFDT | Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
3 | AGC_IMAGE_ID | Character(15) | VARCHAR2(15) NOT NULL | Activity Guide Composer Image Id |
4 | DESCR100 | Character(100) | VARCHAR2(100) NOT NULL | Length 100 Description |
5 | DESCRLONG | Long Character | CLOB NOT NULL | Long Description |
6 | AGC_IMAGE_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Activity Guide Composer Image Type
A=Application Class M=Image Catalog S=Static URL |
7 | IMAGE_NAME | Character(30) | VARCHAR2(30) NOT NULL | The name of images used in Personalizations explanations. |
8 | URL_ID | Character(30) | VARCHAR2(30) NOT NULL |
URL Identifier (see PSURLDEFN).
Prompt Table: PSURLDEFN |
9 | PACKAGEROOT | Character(30) | VARCHAR2(30) NOT NULL |
Root Package ID
Prompt Table: PSPACKAGROOT_VW |
10 | QUALIFYPATH | Character(127) | VARCHAR2(127) NOT NULL |
Qualified Package/Class Path
Prompt Table: PSPACKAGPATH_VW |
11 | AGC_IMAGE_CLASS | Character(30) | VARCHAR2(30) NOT NULL |
Activity Guide Composer Image Class
Prompt Table: PSPACKAGCLAS_VW |
12 | METHODNAME | Character(32) | VARCHAR2(32) NOT NULL | Method Name |
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 |