SSR_ACD_PLN_NZL

(SQL Table)
Index Back

Academic Plan - New Zealand

This is a sibling table of ACAD_PLAN_TBL used to isolate the New Zealand specific academic plan data.

  • Parent record: ACAD_PLAN_TBL
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
    2 ACAD_PLAN Character(10) VARCHAR2(10) NOT NULL Academic Plan
    3 EFFDT Date(10) DATE Effective Date
    4 SSR_SUBJECT_NZ_CD Character(4) VARCHAR2(4) NOT NULL This is the subject code defined by the New Zealand Ministry of Education.

    Prompt Table: SSR_MOE_SUBJECT

    5 SSR_NZVCC_SUBJECT Character(4) VARCHAR2(4) NOT NULL NZVCC Subject Code

    Prompt Table: SSR_NZVCC_SUBJ