AGC_CAT_ASGNEE(SQL Table) |
Index Back |
|---|---|
AGC Category Assignee TableActivity Guide Composer Category Assignee Table - This table stores the technical attributes of assignees for an activity guide category. Assignees are selected and configured when definining an activity guide template step. |
| # | 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_ASSIGNEE_ID |
Character(15) | VARCHAR2(15) NOT NULL | Activity Guide Composer - Assignee ID |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | DESCRLONG | Long Character | CLOB NOT NULL | Long Description |
| 6 | AGC_ASSIGNEE_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Activity Guide Composer - Assignee Type
1=Application Package 2=Role Default Value: 1 |
| 7 | AGC_ASGNEE_PACKAGE | Character(30) | VARCHAR2(30) NOT NULL |
Activity Guide Composer - Assignee Application Package
Prompt Table: PSPACKAGROOT_VW |
| 8 | AGC_ASGNEE_PATH | Character(127) | VARCHAR2(127) NOT NULL |
Activity Guide Composer - Assignee Application Path
Prompt Table: AGC_ASGNPATH_VW |
| 9 | AGC_ASGNEE_CLASS | Character(30) | VARCHAR2(30) NOT NULL |
Activity Guide Composer - Assignee Class
Prompt Table: AGC_ASGNCLS_VW |
| 10 | AGC_ASGNEE_METHOD | Character(30) | VARCHAR2(30) NOT NULL | Activity Guide Composer - Assignee Method |
| 11 | AGC_ASGNEE_ROLE | Character(30) | VARCHAR2(30) NOT NULL |
Activity Guide Composer - Assignee Role Name
Prompt Table: PSROLEDEFN_SRCH |
| 12 | DATA_TYPE_CD | Character(1) | VARCHAR2(1) NOT NULL |
Data Type Code
N=Customer Data S=Sample Data Y=System Data Default Value: N |