SSR_ACDPRGT_AUS

(SQL Table)
 Index Back

Academic Program TAC Data

This is a child record of ACAD_PROG_TBL. It is used to isolate the Australian specific data of an Academic Program. LTD54R6 added TAC_STREAM_CODE to the key to enable mapping of tac course and stream to PS program and plan.

  • Parent record: SSR_ACD_PRG_AUS

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

    Prompt Table: INSTITUTION_TBL

    2 ACAD_PROG Character(5) VARCHAR2(5) NOT NULL Academic Program
    3 EFFDT Date(10) DATE NOT NULL Effective Date
    4 SSR_PROGRAM_CD Character(10) VARCHAR2(10) NOT NULL Program Code

    Prompt Table: SSR_PRG_CD_TBL

    5 SAD_TAC_STREAM_CD Character(10) VARCHAR2(10) NOT NULL TAC Stream Code for SATAC
    6 CAMPUS Character(5) VARCHAR2(5) NOT NULL Campus

    Prompt Table: HOME_CAMPUS_VW

    7 SAD_ATTEND_MODE Character(1) VARCHAR2(1) NOT NULL Mode of Attendance
    1=Internal Mode of Attendance
    2=External Mode of Attendance
    3=Multi-modal Mode of Attendance
    4=Completed Course through OUA
    5=Submission of Original Work
    6=Employer based
    7=Completed Course except in OUA
    8 ACAD_PLAN Character(10) VARCHAR2(10) NOT NULL Academic Plan

    Prompt Table: ACAD_PLAN_TBLVW

    9 ACAD_LOAD_APPR Character(1) VARCHAR2(1) NOT NULL Approved Academic Load
    B=Vocational Coaching (NLD)
    D=Dual (NLD)
    E=Part-time Vocational Tr (NLD)
    F=Full-Time
    O=Vocational Training (NLD)
    P=Part-Time