ACAD_CAR_TBL

(SQL Table)
 Index Back

Academic Career Table

The Academic Career Table defines all Careers that an institution offers and is used to summarize statistics on the academic transcipt.

  • Related Language Record: ACAD_CAR_LANG

  • Parent Record Of ACAD_CAR_PTRS SFA_SAP_ET_AYRH SFA_SAP_ET_TRMH SFA_SAP_STP_HDR SSR_CAR_ACDFLT SSR_CAR_IDDFLT

    • # 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

    Prompt Table: INSTITUTION_TBL

    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

    Prompt Table: SSR_CAR_XLAT_VW

    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

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

    Default Value: A

    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    7 GRADING_SCHEME Character(3) VARCHAR2(3) NOT NULL Grading Scheme

    Prompt Table: GRADESCHEME_TBL

    8 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

    9 GRADE_TRANSFER Character(3) VARCHAR2(3) NOT NULL Default Grade- Transfer Credit

    Prompt Table: GRADE_TBL

    10 REPEAT_SCHEME Character(4) VARCHAR2(4) NOT NULL Repeat Scheme

    Prompt Table: REPEAT_SCHM_TBL

    11 TERM_TYPE Character(1) VARCHAR2(1) NOT NULL Term Unit Type
    C=Clock Hours
    E=Continuing Education Units
    Q=Quarter Hours
    S=Semester Hours
    T=Trimester Hours
    U=Units

    Prompt Table: TERM_TYPE_TBL

    12 HOLIDAY_SCHEDULE Character(6) VARCHAR2(6) NOT NULL Holiday Schedule

    Prompt Table: HOLIDAY_TBL

    13 FA_PRIMACY_NBR Number(3,0) SMALLINT NOT NULL Primacy Nbr
    14 ACAD_PLAN_TYPE Character(3) VARCHAR2(3) NOT NULL Academic Plan Type
    CON=Concentration
    COS=Course of Study
    HON=Honors
    MAJ=Major
    MIN=Minor
    PRP=Preparation
    RTC=ROTC
    SP=Specialization
    15 ADVISOR_EDIT Character(1) VARCHAR2(1) NOT NULL Advisor Edit
    A=Advisor Role
    I=Instructor Advisor
    P=Personal Data

    Default Value: P

    16 LST_TRM_HIST_ENRL Character(4) VARCHAR2(4) NOT NULL Last Term for Hist Enrl Data

    Default Value: 0000

    Prompt Table: TERM_TBL

    17 DYN_CLASS_DATA Character(10) VARCHAR2(10) NOT NULL Dynamic Class Data Rule

    Prompt Table: DYN_CLASS_TVW2

    18 OEE_DYN_DATE_RULE Character(10) VARCHAR2(10) NOT NULL OEE Dynamic Date Rule

    Prompt Table: DYN_CLASS_TVW1

    19 USE_DYN_CLASS_DATE Character(1) VARCHAR2(1) NOT NULL Use Dynamic Class Dates

    Y/N Table Edit

    Default Value: N

    20 SF_GRAD_DESIGNATIO Character(1) VARCHAR2(1) NOT NULL Grad Designation
    1=Undergrad
    2=Graduate
    3=Prefessional
    4=Unknown

    Default Value: 4

    21 FA_CAR_TYPE Character(1) VARCHAR2(1) NOT NULL Financial Aid Career Type
    E=Extended Ed
    G=Graduate
    P=Professional
    U=Undergraduate

    Default Value: U

    22 GRADUATE_LVL_IND Character(1) VARCHAR2(1) NOT NULL Graduate Level

    Y/N Table Edit

    Default Value: N

    23 OEE_IND Character(1) VARCHAR2(1) NOT NULL Allow OEE Enrollment

    Y/N Table Edit

    Default Value: Y

    24 REPEAT_RULE Character(10) VARCHAR2(10) NOT NULL Repeat Rule

    Prompt Table: REPEAT_RULE_VW

    25 REPEAT_ENRL_CTL Character(1) VARCHAR2(1) NOT NULL Process on Enrollment
    N=No
    Y=Yes

    Default Value: INSTITUTION_TBL.REPEAT_ENRL_CTL

    26 REPEAT_ENRL_SUSP Character(1) VARCHAR2(1) NOT NULL Temp Susp Rpt Ck on Enrl

    Y/N Table Edit

    Default Value: INSTITUTION_TBL.REPEAT_ENRL_SUSP

    27 REPEAT_GRD_CK Character(1) VARCHAR2(1) NOT NULL Repeat Grade Check
    A=All Courses
    N=Never
    O=Only Repeat Candidates

    Default Value: INSTITUTION_TBL.REPEAT_GRD_CK

    28 REPEAT_GRD_SUSP Character(1) VARCHAR2(1) NOT NULL Temp Susp Rpt Ck on Grading

    Y/N Table Edit

    Default Value: INSTITUTION_TBL.REPEAT_GRD_SUSP

    29 REPEAT_CRSE_ERROR Character(1) VARCHAR2(1) NOT NULL Course Catalog Repeat Message
    E=Error
    N=None
    W=Warning

    Default Value: W

    30 SS_ENRL_APPT_CHKPT Character(1) VARCHAR2(1) NOT NULL Self Service Enrl Appt Edit
    E=Enrollment Engine Only
    O=Online and Engine

    Default Value: O

    31 SSR_ALLOW_PROG_IN Character(1) VARCHAR2(1) NOT NULL Allow Student to select Academic Program.

    Y/N Table Edit

    Default Value: N

    32 SSR_DFLT_TRMAC_LST Character(2) VARCHAR2(2) NOT NULL Default for Term Activation
    10=Term Begin Date
    20=Term End Date

    Default Value: 10

    33 SAA_DISPLAY_OPTION Character(1) VARCHAR2(1) NOT NULL This field will control if items will print/display in Academic Advisement Reports
    N=Display Name
    O=Display Operator
    X=Do Not Display

    Default Value: O

    34 TRANSCRIPT_LEVEL Character(2) VARCHAR2(2) NOT NULL Transcript level
    00=Never Print
    20=Print on Official
    40=Print on Unofficial
    60=Print on Student Life
    80=Print on Degree Progress

    Default Value: 40

    35 SSR_TRNSFR_UNT_DEF Character(1) VARCHAR2(1) NOT NULL Manual Course Units Default
    C=From Course Catalog
    I=From Incoming Course

    Default Value: I

    36 SSR_GRAD_SETP_OVRD Character(1) VARCHAR2(1) NOT NULL Override Institution Setup
    37 SSR_GRAD_CHRG_FEE Character(1) VARCHAR2(1) NOT NULL Charge a Graduation Fee
    38 SSR_GRAD_PAY_REQ Character(1) VARCHAR2(1) NOT NULL Self Service Payment Required
    39 FEE_CODE Character(6) VARCHAR2(6) NOT NULL Fee Code

    Prompt Table: TERM_FE_CD_TBL

    40 PROG_REASON Character(4) VARCHAR2(4) NOT NULL Action Reason

    Prompt Table: SSR_PROGRSN_VW

    41 SSR_USE_GRAD_TRACK Character(1) VARCHAR2(1) NOT NULL Use Graduation Tracking
    42 SSR_GRAD_STATUS Character(4) VARCHAR2(4) NOT NULL eLearning Status which is used to derive the INTERNET field on SDR Course Register File

    Prompt Table: SSR_GRADSTATTBL

    43 SSR_SESS_ALL_IND Character(1) VARCHAR2(1) NOT NULL Appointment Control Unit Limit Session Indicator
    N=Limit Applies by Session
    Y=Limit Applies Across Sessions

    Default Value: N

    44 SSR_BLIND_GRADED Character(1) VARCHAR2(1) NOT NULL This field indicates if blind grading is active
    N=Do not Use
    Y=Override Display Values

    Y/N Table Edit

    45 SSR_ANID_ARR_DEF Character(4) VARCHAR2(4) NOT NULL Activity Result Roster default ID display
    ANON=Anonymous ID only
    BOTH=Anonymous, Student ID and Name
    STUD=Student ID and Name only
    46 SSR_ANID_WKC_DEF Character(4) VARCHAR2(4) NOT NULL Work Center default ID display
    ANON=Anonymous ID
    STID=Do not Display in Workcenter
    47 SSR_ANID_IAM_DEF Character(4) VARCHAR2(4) NOT NULL Individual Activity Manager default ID display
    ANON=Anonymous ID
    BOTH=Anonymous, Student ID and Name
    STUD=Student ID and Name only
    48 OVERRIDE Character(1) VARCHAR2(1) NOT NULL Copy Method