AGC_CAT_TBL(SQL Table) |
Index Back |
|---|---|
AGC Category TableActivity Guide Composer Category Table - This table stores attributes for the activity guide composer category. The activity guide category is associated to buttons, images, and step definitions that are used to define an activity guiude composer template. |
| # | 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 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |
| 4 | DESCRLONG | Long Character | CLOB NOT NULL | Long Description |
| 5 | AGC_STEP_DEFN_RULE | Character(2) | VARCHAR2(2) NOT NULL |
Activity Guide Composer Step Definition Rule
NA=Not Applicable SC=Single Component Default Value: NA |
| 6 | PACKAGEROOT | Character(30) | VARCHAR2(30) NOT NULL |
Root Package ID
Prompt Table: PSPACKAGROOT_VW |
| 7 | QUALIFYPATH | Character(127) | VARCHAR2(127) NOT NULL |
Qualified Package/Class Path
Prompt Table: PSPACKAGPATH_VW |
| 8 | AGC_CREATE_CLASS | Character(30) | VARCHAR2(30) NOT NULL |
Instance Creation Class
Prompt Table: PSPACKAGCLAS_VW |
| 9 | AGC_CREATE_METHOD | Character(32) | VARCHAR2(32) NOT NULL | Instance Create Method |
| 10 | AGC_BUTTONS_CLASS | Character(30) | VARCHAR2(30) NOT NULL |
Button Class
Prompt Table: PSPACKAGCLAS_VW |
| 11 | AGC_ROLE_ADMIN | Character(30) | VARCHAR2(30) NOT NULL | Activity Guide Composer Administrator Role |
| 12 | OBJECTOWNERID | Character(4) | VARCHAR2(4) NOT NULL | Object owner identifier |
| 13 | AGC_NOTIF_ENABLED | Character(1) | VARCHAR2(1) NOT NULL |
Enable Notifications for Activity Guide Category
Y/N Table Edit Default Value: N |
| 14 | AGC_NOTIF_EMAIL | Character(1) | VARCHAR2(1) NOT NULL |
Activity Guide Composer - Email Notification
Y/N Table Edit Default Value: N |
| 15 | AGC_NOTIF_PUSH | Character(1) | VARCHAR2(1) NOT NULL |
Activity Guide Composer - Push Notification
Y/N Table Edit Default Value: N |
| 16 | AGC_NOTIF_PRIORITY | Character(1) | VARCHAR2(1) NOT NULL |
Notification Priority for Activity Guide Category
1=Initial 2=Overdue Default Value: 2 |
| 17 | DATA_TYPE_CD | Character(1) | VARCHAR2(1) NOT NULL |
Data Type Code
N=Customer Data S=Sample Data Y=System Data Default Value: N |