SSR_ACD_PRG_AUS

(SQL Table)
 Index Back

Academic Program Table AUS

The Academic Program Table defines all academic programs that an institution offers. Students are admitted to Academic Programs. SCS SA LTRA8N2 Added FIELD_OF_EDUCATION and FIELD_OF_EDUC_SUPP.

  • Parent Record Of SSR_ACDPRGT_AUS

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

    Default Value: ACAD_PROG_TBL.INSTITUTION

    Prompt Table: INSTITUTION_TBL

    2 ACAD_PROG Character(5) VARCHAR2(5) NOT NULL Academic Program

    Default Value: ACAD_PROG_TBL.ACAD_PROG

    Prompt Table: ACAD_PROG_TBL

    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: ACAD_PROG_TBL.EFFDT

    4 SSR_FLD_OF_STUDY Character(8) VARCHAR2(8) NOT NULL Field of Study Code

    Prompt Table: SSR_FOS_TBL

    5 SSR_FLD_OF_STD_SUP Character(6) VARCHAR2(6) NOT NULL Supplementary FOS

    Default Value: 000000

    Prompt Table: SSR_FOS_TBL

    6 SSR_PROGRAM_CD Character(10) VARCHAR2(10) NOT NULL Program Code

    Prompt Table: SSR_PRG_CD_TBL

    7 SSR_PROG_TYPE_CD Character(2) VARCHAR2(2) NOT NULL Program Type Code

    Prompt Table: SSR_PRG_TYP_TBL

    8 SSR_SPCL_PROG_TYPE Character(2) VARCHAR2(2) NOT NULL Special Program Type - AUS
    00=Not Course of Special Interest
    15=AUS Maritime College Special
    15=AUS Maritime College Special
    21=General Nursing Course Req
    22=Initial Teacher Training
    23=Provisional Reg Medical
    25=Veterinary Science
    26=Dentistry
    27=Clinical Psychology
    9 SSR_EFTSU_AGGRGATD Number(2,0) SMALLINT NOT NULL Aggregated EFTSU

    Prompt Table: SSR_EFTSU_TBL

    10 SSR_COMBINED_CRSE Character(1) VARCHAR2(1) NOT NULL Combined Course Indicator

    Y/N Table Edit

    Default Value: N

    11 UNITS_MINIMUM Number(6,2) DECIMAL(5,2) NOT NULL Minimum Units
    12 SSR_CRICOS_CD Character(10) VARCHAR2(10) NOT NULL CRICOS Code - AUS
    13 SSR_FLD_OF_EDUCATN Character(8) VARCHAR2(8) NOT NULL SCS SA LTRA8N2 Created.

    Prompt Table: SSR_FOE_TBL

    14 SSR_FLD_OF_EDU_SUP Character(8) VARCHAR2(8) NOT NULL SCS SA LTRA8N2 Created.

    Prompt Table: SSR_FOE_TBL

    15 SSR_PROG_ELIG_FLG Character(1) VARCHAR2(1) NOT NULL Program Eligibility
    I=Ineligible for PELS
    P=PELS Eligible Program
    16 SSR_CRS_STDY_NM Character(210) VARCHAR2(210) NOT NULL Course of Study Name (HEIMS)
    17 SSR_STD_CRSE_DUR Number(5,3) DECIMAL(4,3) NOT NULL Standard Course Duration (HEIMS)
    18 SSR_HM_AGGR_AWRD Character(1) VARCHAR2(1) NOT NULL Flag to check whether Program should be used as Aggregated Award

    Y/N Table Edit

    Default Value: N