| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 AGC_TEMPLATE_ID |
Character(7) |
VARCHAR2(7) NOT NULL |
Activity Guide Composer Template Id
|
| 2 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: %date
|
| 3 |
DESCR100 |
Character(100) |
VARCHAR2(100) NOT NULL |
Length 100 Description
|
| 4 |
DESCRLONG |
Long Character |
CLOB |
Long Description
|
| 5 |
AGC_CATEGORY_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Activity Guide Category
|
| 6 |
AGC_ACTIVE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Activity Guide Composer Active Flag
N=No
Y=Yes
Default Value: N
|
| 7 |
AGC_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Activity Guide Composer Type
HOGP=Horizontal Sequential
VNSP=Vertical Non Sequential
VSGP=Vertical Sequential
|
| 8 |
AGC_FIXED_SIDE |
Character(1) |
VARCHAR2(1) NOT NULL |
Activity Guide Composer Fixed Side Panel (i.e. Display Side Panel)
Y/N Table Edit
Default Value: Y
|
| 9 |
AGC_AUTO_SAVE |
Character(1) |
VARCHAR2(1) NOT NULL |
Activity Guide Composer Auto Save Indicator
N=No
Y=Yes
Default Value: N
|
| 10 |
AGC_VERSION_ID |
Character(3) |
VARCHAR2(3) NOT NULL |
Activity Guide Composer Template Version Id
|
| 11 |
AGC_LIST_ID |
Character(31) |
VARCHAR2(31) NOT NULL |
Activity Guide Composer List Id
|
| 12 |
AGC_SUB_BNR_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Activity Guide Sub Banner Type
0000=No Sub Banner
0001=Image with 1 Primary Field
0002=Image, No Primary Field
0003=No Image with 1 Primary Field
0004=No Image, No Primary Field
0005=Display Page
Default Value: 0000
|
| 13 |
AGC_CTX_DISP_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Activity Guide Composer Sub Banner Display Option
F=Fixed
M=Modal
P=Pop Up
Default Value: F
|
| 14 |
AGC_CTX_DISPLAY_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Activity Guide Composer Context Display
|
| 15 |
AGC_MYAG_DISPLAY |
Character(1) |
VARCHAR2(1) NOT NULL |
Activity Guide Composer Display in My Activity Guide indicator
N=No
Y=Yes
Default Value: N
|
| 16 |
AGC_MYAG_DESCR |
Long Character |
CLOB |
Activity Guide Composer My Activity Guide Description
|
| 17 |
AGC_MYAG_START |
Character(1) |
VARCHAR2(1) NOT NULL |
Activity Guide Composer Start in My Activity Guide indicator
N=No
Y=Yes
Default Value: N
|
| 18 |
AGC_MYAG_DELETE |
Character(1) |
VARCHAR2(1) NOT NULL |
Activity Guide Composer Delete in My Activity Guides indicator
N=No
Y=Yes
Default Value: N
|
| 19 |
AGC_MYAG_MAX |
Number(3,0) |
SMALLINT NOT NULL |
Activity Guide Composer Maximum Instances for My Activity Guides
Default Value: 0
|
| 20 |
AGC_MYAG_ICON |
Character(30) |
VARCHAR2(30) NOT NULL |
Activity Guide Composer Template Icon for My Activity Guides
|
| 21 |
OBJECTOWNERID |
Character(4) |
VARCHAR2(4) NOT NULL |
Object owner identifier
|
| 22 |
AGC_FULL_TRANSLATE |
Character(1) |
VARCHAR2(1) NOT NULL |
Activity Guide Composer Full Translation Indicator
N=Partial Translation
Y=Full Translation
Default Value: N
|
| 23 |
AGC_NOTIF_ENABLED |
Character(1) |
VARCHAR2(1) NOT NULL |
Enable Notifications for Activity Guide Category
Y/N Table Edit
Default Value: N
|
| 24 |
AGC_HIDE_STEPS |
Character(1) |
VARCHAR2(1) NOT NULL |
Activity Guide Composer - Hide Steps Indicator
Y/N Table Edit
Default Value: N
|
| 25 |
DATA_TYPE_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Data Type Code
N=Customer Data
S=Sample Data
Y=System Data
Default Value: N
|