CAN_GOV_SCH_VW1

(SQL View)
 Index Back

CAN Gov School View 1

Sac-r75-19990831

SELECT A.CAN_GOV_SCHOOL_CD , A.EFF_STATUS , A.DESCR100 , A.DESCRSHORT FROM PS_CAN_GOV_SCHOOL A WHERE A.CAN_GOV_TYPE = 'CISS' AND A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_CAN_GOV_SCHOOL B WHERE B.CAN_GOV_SCHOOL_CD = A.CAN_GOV_SCHOOL_CD AND B.CAN_GOV_TYPE = A.CAN_GOV_TYPE AND B.EFFDT <= %CurrentDateIn)

  • Related Language Record: CAN_GOVSCHV1_LN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CAN_GOV_SCHOOL_CD Character(15) VARCHAR2(15) NOT NULL Institution Code Sac-r75-19990831
    2 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive
    3 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description
    4 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

    Default Value: CAN_GOV_SCHOOL.DESCR100