AV_R_CAT_IND_VW

(SQL View)
Index Back

Indicators for a category


SELECT DISTINCT A.AV_RATING_ORIGIN , A.EFFDT , B.IND_CD , B.DESCR FROM PS_AV_R_CAT_TBL A , PS_AV_R_IND_TBL B WHERE B.EFFDT <= A.EFFDT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 AV_RATING_ORIGIN Character(6) VARCHAR2(6) NOT NULL Rating Origin Code
2 EFFDT Date(10) DATE Effective Date

Default Value: %date

3 IND_CD Character(6) VARCHAR2(6) NOT NULL Indicator Code

Prompt Table: AV_R_IND_TBL

4 DESCR Character(30) VARCHAR2(30) NOT NULL Description