SAE_INST_VW

(SQL View)
 Index Back

SELECT INST.INSTITUTION ,INST.EFFDT , INST.DESCR , INST.DESCRSHORT ,'I' SAE_UNITIND , INST.EFF_STATUS , INST.DESCRFORMAL , INST.GRADING_SCHEME , INST.GRADING_BASIS , INST.GRADING_BASIS_SCH , INST.CAMPUS , INST.STDNT_SPEC_PERM , INST.AUTO_ENRL_WAITLIST , INST.RESIDENCY_REQ , INST.FACILITY_CONFLICT , INST.UNITS_ACAD_PRG_PCT , INST.LOAD_CALC_APPLY , INST.LMS_FILE_TYPE , INST.PHONE_TYPE , INST.ADDR_USAGE , INST.EXT_USERID_OPT , INST.LMS_PROVIDER , INSTSCOPE.SAE_MODE , INSTSCOPE.SAE_EVENT_DT FROM %Table(INSTITUTION_TBL) INST , %Table(SAE_INST_SCOPE) INSTSCOPE WHERE INST.EFF_STATUS = 'A' AND %EffdtCheck(INSTITUTION_TBL INST1, INST, %CurrentDateIn) AND INST.INSTITUTION = INSTSCOPE.INSTITUTION AND INSTSCOPE.SAE_MODE <> 'D' UNION ALL SELECT INSTSCOPE.INSTITUTION ,%DateNull , '' , '' , 'I' SAE_UNITIND , '' , '' , '' , '' , '' , '' , '' , '' , '' , '' , 0 , '' , '' , '' , '' , '' , '' , INSTSCOPE.SAE_MODE , INSTSCOPE.SAE_EVENT_DT FROM %Table(SAE_INST_SCOPE) INSTSCOPE WHERE INSTSCOPE.SAE_MODE = 'D' AND NOT EXISTS ( SELECT INST.INSTITUTION FROM %Table(INSTITUTION_TBL) INST WHERE INST.EFF_STATUS = 'A' AND %EffdtCheck(INSTITUTION_TBL INST1, INST, %CurrentDateIn) AND INST.INSTITUTION = INSTSCOPE.INSTITUTION )

  • Related Language Record: INSTITUTION_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Default Value: OPR_DEF_TBL_CS.INSTITUTION

    2 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

    Default Value: INSTITUTION_TBL.DESCR

    5 SAE_UNITIND Character(1) VARCHAR2(1) NOT NULL Unit Indicator
    6 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    7 DESCRFORMAL Character(50) VARCHAR2(50) NOT NULL Formal Description field

    Default Value: INSTITUTION_TBL.DESCR

    8 GRADING_SCHEME Character(3) VARCHAR2(3) NOT NULL Grading Scheme

    Prompt Table: GRADESCHEME_TBL

    9 GRADING_BASIS Character(3) VARCHAR2(3) NOT NULL Grading Basis
    ANC=ABC/NC Grading
    AUD=Audit
    BMT=Multi-Term Course: Not Graded
    CNC=Credit / No Credit
    EQV=Equivalent
    GRD=Graded
    HSC=Hundred Point Scale (NLD)
    LAW=Law
    MED=Medical School Grades
    NOG=No Grade Associated
    NON=Non-Graded Component
    NQF=NQF Scale
    OPT=Student Option
    PNP=Pass/Not Pass
    SUS=Satisfactory/Unsatisfactory
    TRN=Transfer Grading Basis
    TSC=Ten Point Scale (NLD)

    Prompt Table: GRADE_BASIS_TBL

    10 GRADING_BASIS_SCH Character(3) VARCHAR2(3) NOT NULL School Grading Basis

    Prompt Table: GRADE_BASIS_TBL

    11 CAMPUS Character(5) VARCHAR2(5) NOT NULL Campus

    Prompt Table: CAMPUS_TBL

    12 STDNT_SPEC_PERM Character(1) VARCHAR2(1) NOT NULL Student Specific Permissions

    Y/N Table Edit

    Default Value: N

    13 AUTO_ENRL_WAITLIST Character(1) VARCHAR2(1) NOT NULL Auto Enroll from Wait List

    Y/N Table Edit

    Default Value: Y

    14 RESIDENCY_REQ Character(1) VARCHAR2(1) NOT NULL Requires Residency Coding
    N=Not Required
    Y=Required

    Default Value: Y

    15 FACILITY_CONFLICT Character(1) VARCHAR2(1) NOT NULL Status of Facility

    Y/N Table Edit

    Default Value: INSTALLATION_SA.FACILITY_CONFLICT

    16 UNITS_ACAD_PRG_PCT Number(3,0) SMALLINT NOT NULL Academic Progress Units %
    17 LOAD_CALC_APPLY Character(1) VARCHAR2(1) NOT NULL Calculate Workload

    Y/N Table Edit

    Default Value: N

    18 LMS_FILE_TYPE Character(3) VARCHAR2(3) NOT NULL LMS extract file type: XML compliant, Blackboard specific, and WebCT specific
    BKB=Blackboard CourseInfo 4
    WCT=API Input (old WebCT format)
    XML=XML V1.1 (req to authenticate)
    19 PHONE_TYPE Character(4) VARCHAR2(4) NOT NULL Phone Type
    BUSN=Business
    CAMP=Campus
    CELL=Mobile
    DORM=Dormitory
    FAX=FAX
    HOME=Home
    MAIN=Main
    OTR=Other
    PGR1=Pager 1
    PGR2=Pager 2
    TELX=Telex
    WORK=Work
    20 ADDR_USAGE Character(10) VARCHAR2(10) NOT NULL Address Usage

    Prompt Table: ADDR_USAGE_TBL

    21 EXT_USERID_OPT Character(1) VARCHAR2(1) NOT NULL UserID Extract Option
    E=ID
    U=User ID
    22 LMS_PROVIDER Character(30) VARCHAR2(30) NOT NULL Provider for Authentication

    Prompt Table: LMS_INT_SETUP
    Set Control Field: LMS_PROVIDER

    23 SAE_MODE Character(1) VARCHAR2(1) NOT NULL Operation Mode
    A=Add
    C=Change
    D=Delete
    24 SAE_EVENT_DT DateTime(26) TIMESTAMP Event Driven Timestamp