ORG_INST_TBL

(SQL Table)
 Index Back

Org - Institution Table

  • Parent record: EXT_ORG_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID

    Prompt Table: EXT_ORG_TBL

    2 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Default Value: OPR_DEF_TBL_CS.INSTITUTION

    Prompt Table: INSTITUTN_SCRTY

    3 GPA_TYPE Character(4) VARCHAR2(4) NOT NULL GPA Type

    Prompt Table: GPA_TYPE_TBL

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

    Default Value: INSTITUTION_TBL.GRADING_SCHEME

    Prompt Table: GRADESCHEME_TBL

    5 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)

    Default Value: INSTITUTION_TBL.GRADING_BASIS_SCH

    Prompt Table: GRADE_BASIS_TBL

    6 TRNSFR_CR_INCL_GPA Character(1) VARCHAR2(1) NOT NULL Include Transfer Credit in GPA

    Y/N Table Edit

    Default Value: N

    7 TRNSFR_CR_LEVEL Character(1) VARCHAR2(1) NOT NULL Level of Detail
    D=Detail
    S=Summary

    Default Value: S

    8 TRNSFR_CR_DETAIL Character(1) VARCHAR2(1) NOT NULL Details to Print
    B=External and Internal
    E=External Courses
    I=Internal Equivalent Course