AGC_CAT_VW (SQL View)	Index Back
AGC Category View Activity Guide Composer Category View

AGC_CAT_VW

(SQL View)

AGC Category View

Activity Guide Composer Category View

SELECT DISTINCT PKG.AGC_CATEGORY_ID ,PKG.EFFDT ,PKG.DESCR50 FROM PS_AGC_CAT_TBL PKG , PS_AGC_CAT_CTX CTX , PS_AGC_CAT_STEP STEP WHERE PKG.AGC_CATEGORY_ID=CTX.AGC_CATEGORY_ID AND PKG.EFFDT=CTX.EFFDT AND PKG.AGC_CATEGORY_ID=STEP.AGC_CATEGORY_ID AND PKG.EFFDT=STEP.EFFDT AND PKG.PACKAGEROOT<>' ' AND PKG.AGC_CREATE_CLASS<>' '

Related Language Record: AGC_CAT_LVW

# 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 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50

#	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	DESCR50	Character(50)	VARCHAR2(50) NOT NULL	Description of length 50