AGC_CATEGORY_IDEFFDTDefault Value: %date
AGC_STEP_IDHR_OBD_CAT_STEP(SQL View) |
Index Back |
|---|---|
Steps that do not allow Prebrd |
| SELECT A.AGC_CATEGORY_ID , A.EFFDT , B.AGC_STEP_ID , C.AGC_PARAM_NAME , C.AGC_PARAM_VALUE FROM PS_AGC_CAT_TBL A , (PS_AGC_CAT_STEP B LEFT OUTER JOIN PS_AGC_CAT_STEPCTX C ON C.AGC_CATEGORY_ID = B.AGC_CATEGORY_ID AND C.EFFDT = B.EFFDT AND C.AGC_STEP_ID = B.AGC_STEP_ID AND C.AGC_PARAM_NAME='PROCESS_TYPE') WHERE B.AGC_CATEGORY_ID = A.AGC_CATEGORY_ID AND B.EFFDT = A.EFFDT |
| # | 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 |
Effective Date
Default Value: %date |
| 3 | AGC_STEP_ID |
Character(15) | VARCHAR2(15) NOT NULL | Activity Guide Composer Step Id |
| 4 | AGC_RC_PARAM_NAME | Character(128) | VARCHAR2(128) NOT NULL | Activity Guide Composer Related Content Service Parameter Name |
| 5 | AGC_PARAM_VALUE | Character(254) | VARCHAR2(254) NOT NULL | Activity Guide Composer Parameter Value |