AGC_TEMPLATE_IDEFFDTDefault Value: %date
AGC_STEP_IDNA=Not Applicable
SC=Single Component
N=No
Y=Yes
AGC_STEP_VW(SQL View) |
Index Back |
|---|---|
AGC Step ViewActivity Guide Step View |
| SELECT TMPL.AGC_TEMPLATE_ID , TMPL.EFFDT , STP.AGC_STEP_ID , STP.DESCR100 , STP.DESCRLONG , CAT.AGC_STEP_DEFN_RULE , STP.AGC_REQUIRED FROM PS_AGC_TMPL_TBL TMPL , PS_AGC_CAT_TBL CAT , PS_AGC_CAT_STEP STP WHERE TMPL.AGC_CATEGORY_ID = CAT.AGC_CATEGORY_ID AND CAT.EFFDT = ( SELECT MAX(CAT_ED.EFFDT) FROM PS_AGC_CAT_TBL CAT_ED WHERE CAT_ED.AGC_CATEGORY_ID = CAT.AGC_CATEGORY_ID AND CAT_ED.EFFDT <= TMPL.EFFDT) AND STP.AGC_CATEGORY_ID = CAT.AGC_CATEGORY_ID AND STP.EFFDT = CAT.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 | AGC_STEP_ID |
Character(15) | VARCHAR2(15) NOT NULL | Activity Guide Composer Step Id |
| 4 | DESCR100 | Character(100) | VARCHAR2(100) NOT NULL | Length 100 Description |
| 5 | DESCRLONG | Long Character | CLOB NOT NULL | Long Description |
| 6 | AGC_STEP_DEFN_RULE | Character(2) | VARCHAR2(2) NOT NULL |
Activity Guide Composer Step Definition Rule
NA=Not Applicable SC=Single Component |
| 7 | AGC_REQUIRED | Character(1) | VARCHAR2(1) NOT NULL |
Activity Guide Composer Required Indicator
N=No Y=Yes |