CAT_SUBJ_VW

(SQL View)
 Index Back

Catalog Org Subject Prompt Tbl


SELECT A.EXT_ORG_ID ,A.SCHOOL_SUBJECT ,A.EFFDT ,A.EFF_STATUS ,A.DESCR ,A.DESCRSHORT ,A.EXT_SUBJECT_AREA FROM PS_SCHOOL_SUBJ_TBL A WHERE A.EFFDT = ( SELECT MAX(A1.EFFDT) FROM PS_SCHOOL_SUBJ_TBL A1 WHERE A1.EXT_ORG_ID=A.EXT_ORG_ID AND A1.SCHOOL_SUBJECT=A.SCHOOL_SUBJECT AND A1.EFFDT<=%CurrentDateIn) AND A.EFF_STATUS = 'A'

  • Related Language Record: CAT_SUBJ_VW_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CATALOG_ORG Character(11) VARCHAR2(11) NOT NULL Catalog Organization

    Prompt Table: CATALOG_ORG_VW

    2 SCHOOL_SUBJECT Character(8) VARCHAR2(8) NOT NULL School Subject

    Prompt Table: SCHOOL_SUBJ_HDR

    3 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    4 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    7 EXT_SUBJECT_AREA Character(4) VARCHAR2(4) NOT NULL External Subject Area

    Prompt Table: EXT_SUBJECT_TBL