AGC_CAT_CTXDTA

(SQL Table)
 Index Back

AGC Category Contextual Data

Activity Guide Componser Category Context Data table - This table will store the contextual data fields for the category and indicate where and how the contextual data is being used. (Sub Banner, Page Text, or Start/Due Date Options)

# 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 AGC_CTXDTA_ID Character(15) VARCHAR2(15) NOT NULL AGC Contextual Data Id

Prompt Table: AGC_CTXDTA_TBL

4 AGC_CTXDTA_FLD_ID Character(3) VARCHAR2(3) NOT NULL AGC Contextual Data Field Id

Prompt Table: AGC_CTXDTA_FLDS

5 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
6 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
7 AGC_ENABLE_SBNR Character(1) VARCHAR2(1) NOT NULL Activity Guide Composer Use in Sub Bannner indicator
N=No
Y=Yes

Default Value: N

8 AGC_ENABLE_PGTEXT Character(1) VARCHAR2(1) NOT NULL Activity Guide Composer Use in Page Text indicator
N=No
Y=Yes

Default Value: N

9 AGC_ENABLE_SDDATE Character(1) VARCHAR2(1) NOT NULL Activity Guide Composer Use in Start/Due Date Option indicator
N=No
Y=Yes

Default Value: N

10 DATA_TYPE_CD Character(1) VARCHAR2(1) NOT NULL Data Type Code
N=Customer Data
S=Sample Data
Y=System Data

Default Value: N