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

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Institution field to store institution information in campus solution system.

    Prompt Table: INSTITUTION_TBL

    2 ACAD_CAREER Character(4) VARCHAR2(4) NOT NULL Academic career field coming from campus solution system.
    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
    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
    8 GRADING_BASIS Character(3) VARCHAR2(3) NOT NULL Grading Basis
    9 GRADE_TRANSFER Character(3) VARCHAR2(3) NOT NULL Default Grade- Transfer Credit
    10 REPEAT_SCHEME Character(4) VARCHAR2(4) NOT NULL Field used to store the Repeat Scheme value.
    11 TERM_TYPE Character(1) VARCHAR2(1) NOT NULL This field is used to store the Term Type value.
    12 HOLIDAY_SCHEDULE Character(6) VARCHAR2(6) NOT NULL This is the holiday schedule field.

    Prompt Table: HOLIDAY_TBL

    13 FA_PRIMACY_NBR Number(3,0) SMALLINT NOT NULL Primacy Number
    14 ACAD_PLAN_TYPE Character(3) VARCHAR2(3) NOT NULL Academic Plan Type
    15 ADVISOR_EDIT Character(1) VARCHAR2(1) NOT NULL Advisor Edit
    16 LST_TRM_HIST_ENRL Character(4) VARCHAR2(4) NOT NULL Last Term for History Enrolment Data

    Default Value: 0000

    17 DYN_CLASS_DATA Character(10) VARCHAR2(10) NOT NULL Dynamic Class Data Rule
    18 OEE_DYN_DATE_RULE Character(10) VARCHAR2(10) NOT NULL This field is used to store the Dynamic Data Rule value.
    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

    Default Value: 4

    21 FA_CAR_TYPE Character(1) VARCHAR2(1) NOT NULL Financial Aid Career Type.

    Default Value: U

    22 GRADUATE_LVL_IND Character(1) VARCHAR2(1) NOT NULL This field stores the Graduate Level Indicator.

    Y/N Table Edit

    Default Value: N

    23 OEE_IND Character(1) VARCHAR2(1) NOT NULL This field is used as a flag to Allow OEE Enrollment

    Y/N Table Edit

    Default Value: Y

    24 REPEAT_RULE Character(10) VARCHAR2(10) NOT NULL Field used to store the Repeat Rule.
    25 REPEAT_ENRL_CTL Character(1) VARCHAR2(1) NOT NULL This field is used to store the Process Enrollment value.

    Default Value: INSTITUTION_TBL.REPEAT_ENRL_CTL

    26 REPEAT_ENRL_SUSP Character(1) VARCHAR2(1) NOT NULL Temprory Suspension Rpeat Check on Enrolment Flag

    Y/N Table Edit

    Default Value: INSTITUTION_TBL.REPEAT_ENRL_SUSP

    27 REPEAT_GRD_CK Character(1) VARCHAR2(1) NOT NULL Repeat Grade Check

    Default Value: INSTITUTION_TBL.REPEAT_GRD_CK

    28 REPEAT_GRD_SUSP Character(1) VARCHAR2(1) NOT NULL Temprory Suspension Rpeat check 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
    30 SS_ENRL_APPT_CHKPT Character(1) VARCHAR2(1) NOT NULL Self Service Enrollment Appointment.
    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
    33 SAA_DISPLAY_OPTION Character(1) VARCHAR2(1) NOT NULL This field will control if items will print/display in Academic Advisement Reports
    34 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.
    35 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.
    36 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.
    37 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.
    38 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
    39 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time