AGC_TEMPLATE_IDEFFDTDefault Value: %date
RECNAMEPrompt Table: AGC_CTXREC_VW
FIELDNAMEPrompt Table: AGC_CTXFLD_VW
AGC_CAT_CTX_VW(SQL View) |
Index Back |
|---|---|
AGC Category Context ViewActivity Guide Composer Category Context View |
| SELECT TMPL1.AGC_TEMPLATE_ID , TMPL1.EFFDT , CTX.RECNAME , CTX.FIELDNAME , CTX.DESCR100 FROM PS_AGC_TMPL_TBL TMPL1 , PS_AGC_CAT_CTX CTX WHERE TMPL1.AGC_CATEGORY_ID = CTX.AGC_CATEGORY_ID AND CTX.EFFDT = ( SELECT MAX(CTX_ED.EFFDT) FROM PS_AGC_CAT_CTX CTX_ED WHERE CTX_ED.AGC_CATEGORY_ID = CTX.AGC_CATEGORY_ID AND CTX_ED.EFFDT <= TMPL1.EFFDT) UNION SELECT TMPL2.AGC_TEMPLATE_ID , TMPL2.EFFDT , CTXD.RECNAME , CTXD.FIELDNAME , CTXF.DESCR100 FROM PS_AGC_TMPL_TBL TMPL2 , PS_AGC_CAT_CTXDTA CTXD , PS_AGC_CTXDTA_FLDS CTXF WHERE TMPL2.AGC_CATEGORY_ID = CTXD.AGC_CATEGORY_ID AND CTXD.AGC_ENABLE_SBNR = 'Y' AND CTXD.AGC_CTXDTA_ID = CTXF.AGC_CTXDTA_ID AND CTXD.AGC_CTXDTA_FLD_ID = CTXF.AGC_CTXDTA_FLD_ID AND CTXD.EFFDT = ( SELECT MAX(CTXD_ED.EFFDT) FROM PS_AGC_CAT_CTXDTA CTXD_ED WHERE CTXD_ED.AGC_CATEGORY_ID = CTXD.AGC_CATEGORY_ID AND CTXD_ED.EFFDT <= TMPL2.EFFDT) |
| # | 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).
Prompt Table: AGC_CTXREC_VW |
| 4 | FIELDNAME |
Character(18) | VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
Prompt Table: AGC_CTXFLD_VW |
| 5 | DESCR100 | Character(100) | VARCHAR2(100) NOT NULL | Length 100 Description |