STDNT_AGRMNT

(SQL Table)
 Index Back

Student Agreements

This table describes each student specific agreement. If an advisor allows a student to take classes from another school and earn credit for it, the details of the agreement should be recorded in this table. During Transfer Credit modeling, all agreement records for the student will be displayed for reference.

  • Related Language Record: STDNT_AGRMNT_LN

  • Parent Record Of STDNT_AGRMNT_CR

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PEOPLE_SRCH

    2 ACAD_CAREER Character(4) VARCHAR2(4) NOT NULL Academic Career
    BAC=Bachelor (NLD)
    BBL=Vocational Coaching (NLD)
    BOL=Vocational Training (NLD)
    BUSN=Graduate Business
    CNED=Continuing Education
    CRED=Semester Credit
    EDU=Education (NLD)
    EXED=Extended Education
    GRAD=Graduate
    LAW=Law
    MEDS=Medical School
    NONA=Non Award
    PGRD=Postgraduate
    RSCH=Research
    TECH=Technical
    UENG=Undergraduate Engineering
    UGRD=Undergraduate
    VAVO=Advanced General Educ. (NLD)
    VETM=Veterinary Medicine

    Default Value: OPR_DEF_TBL_CS.ACAD_CAREER

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

    Default Value: OPR_DEF_TBL_CS.INSTITUTION

    Prompt Table: INSTITUTION_TBL

    4 TRNSFR_SRC_ID Character(11) VARCHAR2(11) NOT NULL Source ID
    5 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

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

    Default Value: A

    7 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    8 TC_CATLG_ORG_TYPE Character(1) VARCHAR2(1) NOT NULL Catalog Org Type
    E=External
    I=Internal
    9 CATALOG_ORG Character(11) VARCHAR2(11) NOT NULL Catalog Organization

    Prompt Table: %EDITTABLE5

    10 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    11 COMMENTS Long Character CLOB Comment