AGC_TEMPLATE_IDEFFDTDefault Value: %date
RECNAMEFIELDNAMEN=No
Y=Yes
N=No
Y=Yes
N=Customer Data
S=Sample Data
Y=System Data
AGC_TMPL_SBNR(SQL Table) |
Index Back |
|---|---|
AGC Template Sub Banner TableActivity Guide Composer Template Sub Banner Table |
| # | 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 |
Effective Date
Default Value: %date |
| 3 | RECNAME |
Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). |
| 4 | FIELDNAME |
Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
| 5 | AGC_PRIMARY | Character(1) | VARCHAR2(1) NOT NULL |
Activity Guide Composer Primary Indicator
N=No Y=Yes |
| 6 | AGC_DISPLAY_LABEL | Character(1) | VARCHAR2(1) NOT NULL |
Activity Guide Composer Display Label Indicator
N=No Y=Yes |
| 7 | AGC_IMAGE_ID | Character(15) | VARCHAR2(15) NOT NULL | Activity Guide Composer Image Id |
| 8 | DATA_TYPE_CD | Character(1) | VARCHAR2(1) NOT NULL |
Data Type Code
N=Customer Data S=Sample Data Y=System Data |