University of Calgary Data Warehouse
From Leo's Notes
Last edited on 24 February 2017, at 04:26.
Tables[edit | edit source]
The University of Calgary Data Warehouse schema can be made out below. The records below are values from my record.
Table F_Student_Courses_And_Credits[edit | edit source]
[Expr1] => 00500***
[Expr2] => UGRD
[Expr3] => UCALG
[Expr4] => SCBCH
[Expr5] => 20111
[Expr6] => S
[Expr7] => Student Enrol
[Expr8] => 0
[Expr9] => 0
[Expr10] =>
[Expr11] => 2111
[Expr12] => 107211
[Expr13] => 34001
[Expr14] => UGRD
[Expr15] => 1
[Expr16] => 3.000
[Expr17] => 3.00
[Expr18] => 3
[Expr19] => A-
[Expr20] => A-
[Expr21] => 2011-04-27 00:00:00
[Expr22] => 3.700
[Expr23] => Y
[Expr24] => Y
[Expr25] => Y
[Expr26] => 2011
[Expr27] =>
[Expr28] =>
[Expr29] =>
[Expr30] =>
[Expr31] =>
[Expr32] =>
[Expr33] =>
[Expr34] => E
[Expr35] => ENRL
[Expr36] => Jan 3 2011 12:00:00:000AM
[Expr37] => UGD
[Expr38] => GRD
[Expr39] => UGD-GRD
[Expr40] =>
[Expr41] =>
[Expr42] => 1
[Expr43] => 370
[Expr44] => N
[Expr45] => 11.100000
[Expr46] =>
[Expr47] =>
[Expr48] => Y
[Expr49] => NONE
[Expr50] => 3.000
[Expr51] => 0
[Expr52] => 0
[Expr53] =>
[Expr54] => 0
[Expr55] =>
[Expr56] =>
[Expr57] =>
[Expr58] =>
[Expr59] =>
[Expr60] =>
[Expr61] => 1
[Expr62] => 107211-2111
[Expr63] => 2111-34001
[Expr64] => 00500***-UGRD-UCALG-2111
[Expr65] => 00500***-UGRD-UCALG-2111-107211-34001- -0-0-0-S
[Expr66] => PS_STDNT_ENRL
[Expr67] => 390***
[Expr68] => 3
[Expr69] => 1
[Expr70] => 78
[Expr71] => 219
[Expr72] => 16
[Expr73] => 121
[Expr74] => 3
[Expr75] => 7
[Expr76] => 104
[Expr77] => 20
[Expr78] => 2
[Expr79] => 7
[Expr80] => 42
[Expr81] => 5
[Expr82] => 4281
[Expr83] => 22
[Expr84] => 7
[Expr85] => Apr 27 2011 10:20:36:000PM
[Expr86] =>
Table D_Class_Table[edit | edit source]
[Course_ID] => 107211
[Course_Offer_Nbr] => 1
[Term] => 2111
[Session_Code] => 1
[Class_Section] => 01
[Institution] => UCALG
[Institution_Desc] => University of Calgary
[Institution_Desc_Short] => UCALG
[Institution_Desc_Formal] => University of Calgary
[Institution_Code_Desc] => UCALG-University of Calgary
[Campus] => MAIN
[Location] => MAIN
[Academic_Career] => UGRD
[Acad_Career_Desc] => Undergraduate Programs
[Acad_Career_Desc_Short] => UGRD
[Acad_Career_Code_Desc] => UGRD-Undergraduate Programs
[Academic_Group] => SC
[Academic_Group_Desc] => Faculty of Science
[Academic_Group_Desc_Short] => SC
[Academic_Group_Code_Desc] => SC-Faculty of Science
[Academic_Organization] => CPSC
[Academic_Organization_Desc] => Dept of Computer Science
[Academic_Organization_Desc_Short] => CPSC
[Academic_Organization_Desc_Formal] => Department of Computer Science
[Academic_Organization_Code_Desc] => CPSC-Dept of Computer Science
[Class_Desc] => History Of Computation
[Class_Nbr] => 34001
[Subject] => CPSC
[Subject_Desc] => Computer Science
[Catalog_Nbr] => 409
[Subject_Catalog_Nbr] => CPSC409
[Component] => LEC
[Component_Desc] => Lecture
[Component_Desc_Short] => Lecture
[Component_Code_Desc] => LEC-Lecture
[Primary_Instruction_Section] => 01
[Combined_Section] =>
[Class_Status] => A
[Class_Status_Desc] => Active
[Class_Status_Desc_Short] => Active
[Class_Status_Code_Desc] => A-Active
[Class_Type] => E
[Class_Type_Desc] => Enrollment Section
[Class_Type_Desc_Short] => Enrollment
[Class_Type_Code_Desc] => E-Enrollment Section
[Consent] => N
[Consent_Desc] => No Special Consent Required
[Consent_Desc_Short] => No Consent
[Consent_Code_Desc] => N-No Special Consent Required
[Component_Full_Ind] => N
[Course_Full_Ind] => N
[Course_Topic_ID] => 0
[Instruction_Mode] => P
[Instruction_Mode_Desc] => In Person
[Instruction_Mode_Desc_Short] => In Person
[Instruction_Mode_Code_Desc] => P-In Person
[Instruction_Mode_Print_On_Catalog] => N
[Equivalent_Course_ID] =>
[Equivalent_Course_Desc] =>
[Equivalent_Course_Desc_Short] =>
[Equivalent_Course_Code_Desc] => -
[Class_Start_Date] => Jan 10 2011 12:00:00:000AM
[Class_End_Date] => Apr 15 2011 12:00:00:000AM
[Class_Cancel_Date] =>
[Crse_Strm_DKey] => 107211-2111
[Strm_Class_DKey] => 2111-34001
[DB_Source] => Stage_PS_CLASS_TBL
[Term_Key] => 219
[Institution_Key] => 1
[Academic_Career_Key] => 3
[Academic_Group_Key] => 18
[Academic_Org_Key] => 19
[Component_Key] => 7
[Class_Status_Key] => 1
[Class_Type_Key] => 1
[Consent_Key] => 3
[Instruction_Mode_Key] => 9
[Equivalent_Course_ID_Key] => 1
[Last_Update_Date] => Jan 1 2012 11:26:33:000PM
[Session_Code_Desc] => Regular Academic
[Session_Code_Desc_Short] => Regular
[Session_Code_And_Desc] => 1-Regular Academic
[Component_Minimum] => LEC
[Blackboard_PK1] => 0
[Blackboard_Course_ID] =>
[Blackboard_URL] =>
[Blackboard_Available_IND] =>
Table D_Person_PS[edit | edit source]
[0] => 390***
[Person_Key] => 390***
[1] => 00500***
[Emplid] => 00500***
[2] => 00500***
[Person_IT_Username] => 00500***
[3] => 89123****
[Person_Alberta_Student_Number] => 89123****
[4] => Leung, Leo
[Person_Reporting_Name] => Leung, Leo
[5] => Mr
[Person_Name_Prefix] => Mr
[6] => Leo Leung
[Person_Name] => Leo Leung
[7] => Leung
[Person_Last_Name] => Leung
[8] => Leo
[Person_First_Name] => Leo
[9] =>
[Person_Middle_Name] =>
[10] => *****************
[Person_Address1] => *****************
[11] =>
[Person_Address2] =>
[12] =>
[Person_Address3] =>
[13] =>
[Person_Address4] =>
[14] => Calgary
[Person_City] => Calgary
[15] => AB
[Person_State] => AB
[16] => *******
[Person_Postal] => *******
[17] => CAN
[Person_Country] => CAN
[18] => CELL
[Person_Phone_Type] => CELL
[19] => ********
[Person_Phone] => ********
[20] => lleung@ucalgary.ca
[Person_Email_Addr] => lleung@ucalgary.ca
[21] =>
[Person_Hospital_Address] =>
[22] => *****************
[Person_Permanent_Address] => *****************
[23] => Calgary
[Person_Permanent_City] => Calgary
[24] => AB
[Person_Permanent_Province] => AB
[25] => CAN
[Person_Permanent_Country] => CAN
[26] => M
[Person_Gender] => M
[27] => Male
[Person_Gender_Desc] => Male
[28] => S
[Person_Mar_Status] => S
[29] => Single
[Person_Mar_Status_Desc] => Single
[30] => Dec 26 **** 12:00:00:000AM
[Person_Birth_Date] => Dec 26 **** 12:00:00:000AM
[31] =>
[Person_Date_Of_Death] =>
[32] => N
[Person_Aboriginal_Ind] => N
[33] =>
[Person_Disability_Ind] =>
[34] => CAN
[Person_Citizenship] => CAN
[35] => A
[Person_Highest_Educ_Lvl] => A
[36] => A-Not Indicated
[Person_Highest_Educ_Lvl_Desc] => A-Not Indicated
[37] => N
[Person_FT_Student] => N
[38] => 12150
[Person_Main_Dept_ID] => 12150
[39] => Computer Science
[Person_Main_Dept_Desc] => Computer Science
[40] => 000517
[Person_Main_Jobcode] => 000517
[41] => CompScience Technician II
[Person_Main_Jobcode_Desc] => CompScience Technician II
[42] => MS145
[Person_Campus_Location] => MS145
[43] => +1 (403) 220-2289
[Person_Campus_Phone] => +1 (403) 220-2289
[44] => lleung@ucalgary.ca
[Person_Campus_eMail] => lleung@ucalgary.ca
[45] => leo.leung
[Person_eID] => leo.leung
[46] => lleung
[Expr1] => lleung
[47] => Jan 1 1900 12:00:00:000AM
[Effective_Start_Date] => Jan 1 1900 12:00:00:000AM
[48] => Dec 31 9999 11:59:59:000PM
[Effective_End_Date] => Dec 31 9999 11:59:59:000PM
[49] => Nov 16 2006 12:16:47:000AM
[Create_Date] => Nov 16 2006 12:16:47:000AM
[50] => Apr 25 2013 10:07:27:000PM
[Last_Update_Date] => Apr 25 2013 10:07:27:000PM
[51] => Y
[Current_Indicator] => Y
[52] => Stage_Person
[DB_Source] => Stage_Person
[53] => A
[Person_Finance_Status] => A
[54] => Canada
[Person_Country_Desc] => Canada
[55] => *******
[Person_Permanent_Postal] => *******
[56] => Canada
[Person_Permanent_Country_Desc] => Canada
[57] => Not Applicable
[Person_Visible_Minority_Desc] => Not Applicable
[58] => Canada
[Person_Citizenship_Desc] => Canada
[59] => 12150 - Computer Science
[Person_Main_Dept_ID_Desc] => 12150 - Computer Science
[60] => 00500*** - Leo Leung
[Person_ID_Name] => 00500*** - Leo Leung
?[edit | edit source]
[0] => 390***
[Person_Key] => 390***
[1] => 00500***
[Emplid] => 00500***
[2] => 00500***
[Person_IT_Username] => 00500***
[3] => 89123****
[Person_Alberta_Student_Number] => 89123****
[4] => Leung, Leo
[Person_Reporting_Name] => Leung, Leo
[5] => Mr
[Person_Name_Prefix] => Mr
[6] => Leo Leung
[Person_Name] => Leo Leung
[7] => Leung
[Person_Last_Name] => Leung
[8] => Leo
[Person_First_Name] => Leo
[9] =>
[Person_Middle_Name] =>
[10] => *********************
[Person_Address1] => *********************
[11] =>
[Person_Address2] =>
[12] =>
[Person_Address3] =>
[13] =>
[Person_Address4] =>
[14] => Calgary
[Person_City] => Calgary
[15] => AB
[Person_State] => AB
[16] => *******
[Person_Postal] => *******
[17] => CAN
[Person_Country] => CAN
[18] => CELL
[Person_Phone_Type] => CELL
[19] => ***********
[Person_Phone] => ***********
[20] => lleung@ucalgary.ca
[Person_Email_Addr] => lleung@ucalgary.ca
[21] =>
[Person_Hospital_Address] =>
[22] => *********************
[Person_Permanent_Address] => *********************
[23] => Calgary
[Person_Permanent_City] => Calgary
[24] => AB
[Person_Permanent_Province] => AB
[25] => CAN
[Person_Permanent_Country] => CAN
[26] => M
[Person_Gender] => M
[27] => Male
[Person_Gender_Desc] => Male
[28] => S
[Person_Mar_Status] => S
[29] => Single
[Person_Mar_Status_Desc] => Single
[30] => Dec 26 **** 12:00:00:000AM
[Person_Birth_Date] => Dec 26 **** 12:00:00:000AM
[31] =>
[Person_Date_Of_Death] =>
[32] => N
[Person_Aboriginal_Ind] => N
[33] =>
[Person_Disability_Ind] =>
[34] => CAN
[Person_Citizenship] => CAN
[35] => A
[Person_Highest_Educ_Lvl] => A
[36] => A-Not Indicated
[Person_Highest_Educ_Lvl_Desc] => A-Not Indicated
[37] => N
[Person_FT_Student] => N
[38] => 12150
[Person_Main_Dept_ID] => 12150
[39] => Computer Science
[Person_Main_Dept_Desc] => Computer Science
[40] => 000517
[Person_Main_Jobcode] => 000517
[41] => CompScience Technician II
[Person_Main_Jobcode_Desc] => CompScience Technician II
[42] => MS145
[Person_Campus_Location] => MS145
[43] => +1 (403) 220-2289
[Person_Campus_Phone] => +1 (403) 220-2289
[44] => lleung@ucalgary.ca
[Person_Campus_eMail] => lleung@ucalgary.ca
[45] => leo.leung
[Person_eID] => leo.leung
[46] => lleung
[Expr1] => lleung
[47] => Jan 1 1900 12:00:00:000AM
[Effective_Start_Date] => Jan 1 1900 12:00:00:000AM
[48] => Dec 31 9999 11:59:59:000PM
[Effective_End_Date] => Dec 31 9999 11:59:59:000PM
[49] => Nov 16 2006 12:16:47:000AM
[Create_Date] => Nov 16 2006 12:16:47:000AM
[50] => Apr 25 2013 10:07:27:000PM
[Last_Update_Date] => May 22 2011 10:16:59:000PM
[51] => Y
[Current_Indicator] => Y
[52] => Stage_Person
[DB_Source] => PS_STDNT_CAR_TERM
[53] => A
[Person_Finance_Status] => A
[54] => Canada
[Person_Country_Desc] => Canada
[55] => *******
[Person_Permanent_Postal] => *******
[56] => Canada
[Person_Permanent_Country_Desc] => Canada
[57] => Not Applicable
[Person_Visible_Minority_Desc] => Not Applicable
[58] => Canada
[Person_Citizenship_Desc] => Canada
[59] => 12150 - Computer Science
[Person_Main_Dept_ID_Desc] => 12150 - Computer Science
[60] => 00500*** - Leo Leung
[Person_ID_Name] => 00500*** - Leo Leung
[61] => 00500***
[62] => UGRD
[Academic_Career] => UGRD
[63] => UCALG
[Institution] => UCALG
[64] => 2115
[Term] => 2115
[65] => 2
[Student_Career_Nbr] => 2
[66] => SCBCH
[Academic_Program] => SCBCH
[67] => SC
[Acad_Group] => SC
[68] => Faculty of Science
[Acad_Group_Desc] => Faculty of Science
[69] => SC-Faculty of Science
[Acad_Group_Code_Desc] => SC-Faculty of Science
[70] => Science Bachelor
[Acad_Prog_Desc] => Science Bachelor
[71] => SCBCH
[Acad_Prog_Desc_Short] => SCBCH
[72] => SCBCH-Science Bachelor
[Acad_Prog_Code_Desc] => SCBCH-Science Bachelor
[73] => STND
[Acad_Prog_Calendar_ID] => STND
[74] => MAIN
[Acad_Prog_Campus] => MAIN
[75] => BSC-DEG
[Degree_Plan] => BSC-DEG
[76] => Bachelor of Science
[Degree_Plan_Desc] => Bachelor of Science
[77] => Bachelor of Science
[Degree_Plan_Desc_60] => Bachelor of Science
[78] => BSC
[Degree_Plan_Short] => BSC
[79] => BSC-DEG-Bachelor of Science
[Degree_Plan_Code_Desc] => BSC-DEG-Bachelor of Science
[80] => DEG
[Degree_Plan_Type] => DEG
[81] => (Degree Stream)
[Degree_Plan_Type_Desc] => (Degree Stream)
[82] => CPSC-MAJ
[Primary_Acad_Plan] => CPSC-MAJ
[83] => Computer Science
[Primary_Acad_Plan_Desc] => Computer Science
[84] => Computer Science
[Primary_Acad_Plan_Desc_60] => Computer Science
[85] => CPSC-MAJ
[Primary_Acad_Plan_Short] => CPSC-MAJ
[86] => CPSC-MAJ-Computer Science
[Primary_Acad_Plan_Code_Desc] => CPSC-MAJ-Computer Science
[87] => MAJ
[Primary_Acad_Plan_Type] => MAJ
[88] => (Major)
[Primary_Acad_Plan_Type_Desc] => (Major)
[89] =>
[Acad_Plan_1_Sub_Plan_1] =>
[90] =>
[Acad_Plan_1_Sub_Plan_1_Desc] =>
[91] =>
[Acad_Plan_1_Sub_Plan_1_Desc_Short] =>
[92] =>
[Acad_Plan_1_Sub_Plan_1_Code_Desc] =>
[93] =>
[Acad_Plan_1_Sub_Plan_1_Type] =>
[94] =>
[Acad_Plan_1_Sub_Plan_1_Type_Desc] =>
[95] =>
[Acad_Plan_1_Sub_Plan_2] =>
[96] =>
[Acad_Plan_1_Sub_Plan_2_Desc] =>
[97] =>
[Acad_Plan_1_Sub_Plan_2_Desc_Short] =>
[98] =>
[Acad_Plan_1_Sub_Plan_2_Code_Desc] =>
[99] =>
[Acad_Plan_1_Sub_Plan_2_Type] =>
[100] =>
[Acad_Plan_1_Sub_Plan_2_Type_Desc] =>
[101] =>
[Primary_Acad_Plan_2] =>
[102] =>
[Primary_Acad_Plan_2_Desc] =>
[103] =>
[Primary_Acad_Plan_2_Desc_60] =>
[104] =>
[Primary_Acad_Plan_2_Short] =>
[105] =>
[Primary_Acad_Plan_2_Code_Desc] =>
[106] =>
[Primary_Acad_Plan_2_Type] =>
[107] =>
[Primary_Acad_Plan_2_Type_Desc] =>
[108] =>
[Acad_Plan_2_Sub_Plan_1] =>
[109] =>
[Acad_Plan_2_Sub_Plan_1_Desc] =>
[110] =>
[Acad_Plan_2_Sub_Plan_1_Desc_Short] =>
[111] =>
[Acad_Plan_2_Sub_Plan_1_Code_Desc] =>
[112] =>
[Acad_Plan_2_Sub_Plan_1_Type] =>
[113] =>
[Acad_Plan_2_Sub_Plan_1_Type_Desc] =>
[114] =>
[Acad_Plan_2_Sub_Plan_2] =>
[115] =>
[Acad_Plan_2_Sub_Plan_2_Desc] =>
[116] =>
[Acad_Plan_2_Sub_Plan_2_Desc_Short] =>
[117] =>
[Acad_Plan_2_Sub_Plan_2_Code_Desc] =>
[118] =>
[Acad_Plan_2_Sub_Plan_2_Type] =>
[119] =>
[Acad_Plan_2_Sub_Plan_2_Type_Desc] =>
[120] =>
[Other_Plan_1] =>
[121] =>
[Other_Plan_1_Desc] =>
[122] =>
[Other_Plan_1_Desc_60] =>
[123] =>
[Other_Plan_1_Short] =>
[124] =>
[Other_Plan_1_Code_Desc] =>
[125] =>
[Other_Plan_1_Type] =>
[126] =>
[Other_Plan_1_Type_Desc] =>
[127] =>
[Other_Plan_2] =>
[128] =>
[Other_Plan_2_Desc] =>
[129] =>
[Other_Plan_2_Desc_60] =>
[130] =>
[Other_Plan_2_Short] =>
[131] =>
[Other_Plan_2_Code_Desc] =>
[132] =>
[Other_Plan_2_Type] =>
[133] =>
[Other_Plan_2_Type_Desc] =>
[134] =>
[Other_Plan_3] =>
[135] =>
[Other_Plan_3_Desc] =>
[136] =>
[Other_Plan_3_Desc_60] =>
[137] =>
[Other_Plan_3_Short] =>
[138] =>
[Other_Plan_3_Code_Desc] =>
[139] =>
[Other_Plan_3_Type] =>
[140] =>
[Other_Plan_3_Type_Desc] =>
[141] =>
[Other_Plan_4] =>
[142] =>
[Other_Plan_4_Desc] =>
[143] =>
[Other_Plan_4_Desc_60] =>
[144] =>
[Other_Plan_4_Short] =>
[145] =>
[Other_Plan_4_Code_Desc] =>
[146] =>
[Other_Plan_4_Type] =>
[147] =>
[Other_Plan_4_Type_Desc] =>
[148] =>
[Other_Plan_5] =>
[149] =>
[Other_Plan_5_Desc] =>
[150] =>
[Other_Plan_5_Desc_60] =>
[151] =>
[Other_Plan_5_Short] =>
[152] =>
[Other_Plan_5_Code_Desc] =>
[153] =>
[Other_Plan_5_Type] =>
[154] =>
[Other_Plan_5_Type_Desc] =>
[155] => AW
[Degree_Checkout_Status] => AW
[156] => Degree Awarded (Not for Staff)
[Degree_Checkout_Status_Desc] => Degree Awarded (Not for Staff)
[157] => AW - Degree Awarded (Not for Staff)
[Degree_Checkout_Status_Code_Desc] => AW - Degree Awarded (Not for Staff)
[158] => 2111
[Expected_Grad_Term] => 2111
[159] => 2010
[Expected_Grad_Term_Academic_Year] => 2010
[160] => Winter 2011
[Expected_Grad_Term_Desc] => Winter 2011
[161] => 2111 - Winter 2011
[Expected_Grad_Term_Code_Desc] => 2111 - Winter 2011
[162] => W11
[Expected_Grad_Term_Desc_Short] => W11
[163] => 2111
[Completion_Term] => 2111
[164] => 2010
[Completion_Term_Academic_Year] => 2010
[165] => Winter 2011
[Completion_Term_Desc] => Winter 2011
[166] => 2111 - Winter 2011
[Completion_Term_Code_Desc] => 2111 - Winter 2011
[167] => W11
[Completion_Term_Desc_Short] => W11
[168] =>
[Degree_After_Ind] =>
[169] =>
[Honors_Applied_Ind] =>
[170] =>
[Honors_Official_Ind] =>
[171] =>
[Cohort_Ind] =>
[172] =>
[Coop_Internship_Ind] =>
[173] => UGRD- -
[Academic_Standing_ID] => UGRD- -
[174] => ZZZZ
[Acad_Standing_Sort_ID] => ZZZZ
[175] =>
[Acad_Standing_Action] =>
[176] =>
[Acad_Standing_Desc] =>
[177] => UGRD- - - Orphan
[Acad_Standing_Code_Desc] => UGRD- - - Orphan
[178] =>
[Acad_Standing_Desc_Short] =>
[179] =>
[Acad_Standing_Desc_Formal] =>
[180] =>
[Acad_Standing_Desc_Internal] =>
[181] =>
[Acad_Standing_Desc254] =>
[182] =>
[Acad_Standing_Status] =>
[183] =>
[Acad_Standing_Status_Desc] =>
[184] =>
[Acad_Standing_Acad_Career] =>
[185] =>
[Acad_Standing_Transcript_Level] =>
[186] =>
[Acad_Standing_Transcript_Level_Desc] =>
[187] => - Orphan
[Acad_Standing_Transcript_Level_Code_Desc] => - Orphan
[188] =>
[Action_Date] =>
[189] =>
[Oprid] =>
[190] =>
[Reg_Card_Date] =>
[191] => NWD
[Withdraw_Code] => NWD
[192] =>
[Withdraw_Code_Desc] =>
[193] =>
[Withdraw_Code_Short_Desc] =>
[194] =>
[Withdraw_Reason] =>
[195] =>
[Withdraw_Reason_Desc] =>
[196] => - Orphan
[Withdraw_Reason_Code_Desc] => - Orphan
[197] =>
[Withdraw_Reason_Desc_Short] =>
[198] =>
[Withdraw_Date] =>
[199] =>
[Last_Date_Attended] =>
[200] => F
[Academic_Load_Approved] => F
[201] => Full-Time
[Academic_Load_Approved_Desc] => Full-Time
[202] => F - Full-Time
[Academic_Load_Approved_Code_Desc] => F - Full-Time
[203] => Full-Time
[Academic_Load_Approved_Desc_Short] => Full-Time
[204] => N
[Academic_Load] => N
[205] => No Unit Load
[Academic_Load_Desc] => No Unit Load
[206] => N - No Unit Load
[Academic_Load_Code_Desc] => N - No Unit Load
[207] => No Units
[Academic_Load_Desc_Short] => No Units
[208] => 5
[Academic_Level_Projected] => 5
[209] => Year 5
[Academic_Level_Projected_Desc] => Year 5
[210] => 5 - Year 5
[Academic_Level_Projected_Code_Desc] => 5 - Year 5
[211] => Year 5
[Academic_Level_Projected_Desc_Short] => Year 5
[212] => 5
[Academic_Level_Begin_Term] => 5
[213] => 5
[Academic_Level_End_Term] => 5
[214] => N
[NSLDS_Loan_Year] => N
[215] => N
[Override_Acad_Level_Projected] => N
[216] => N
[Override_Acad_Level_All] => N
[217] => N
[Eligible_To_Enrol] => N
[218] => N
[Registered_Ind] => N
[219] => N
[Registration_Initialization_Ind] => N
[220] =>
[Coordinator_ID] =>
[221] => N
[Override_Maximum_Unit] => N
[222] => N
[Override_Billing_Units] => N
[223] => 0
[Projected_Billing_Unit] => 0
[224] => N
[Reset_Cum_Stats] => N
[225] => ENRL
[Form_Of_Study] => ENRL
[226] => Class Enrollment
[Form_Of_Study_Desc] => Class Enrollment
[227] => ENRL - Class Enrollment
[Form_Of_Study_Code_Desc] => ENRL - Class Enrollment
[228] => Enrollment
[Form_Of_Study_Desc_Short] => Enrollment
[229] => U
[Term_Type] => U
[230] => UGRD
[Sel_Group] => UGRD
[231] => N
[Tuition_Calc_Req] => N
[232] => Mar 17 2011 07:19:47:000PM
[Tuition_Calc_Datetime] => Mar 17 2011 07:19:47:000PM
[233] => UGRD
[Billing_Career] => UGRD
[234] => 2011
[Academic_Year] => 2011
[235] => SC
[Academic_Group_Advis] => SC
[236] => N
[Pro_Rata_Eligible] => N
[237] => Aug 20 2011 12:00:00:000AM
[Fully_Enrolled_Date] => Aug 20 2011 12:00:00:000AM
[238] => Jun 2 2011 12:00:00:000AM
[Enrol_On_Trans_Date] => Jun 2 2011 12:00:00:000AM
[239] => Aug 20 2011 12:00:00:000AM
[Stats_On_Trans_Date] => Aug 20 2011 12:00:00:000AM
[240] => Sep 15 2010 12:00:00:000AM
[Fully_Graded_Date] => Sep 15 2010 12:00:00:000AM
[241] =>
[External_Organization_ID] =>
[242] =>
[External_Org_Desc] =>
[243] =>
[Country] =>
[244] =>
[Study_Agreement] =>
[245] =>
[Study_Agreement_Desc] =>
[246] => - Orphan
[Study_Agreement_Code_Desc] => - Orphan
[247] =>
[Study_Agreement_Desc_Short] =>
[248] =>
[Study_Agreement_Desc60] =>
[249] =>
[Start_Date] =>
[250] =>
[End_Date] =>
[251] => N
[Override_Initial_Add_Fee] => N
[252] => N
[Override_Initial_Enr_Fee] => N
[253] => Y
[Academic_Career_First] => Y
[254] =>
[Academic_Load_Date] =>
[255] =>
[Unit_Prg_Chg_NSLC_Date] =>
[256] => Jul 4 2011 12:00:00:000AM
[Activation_Date] => Jul 4 2011 12:00:00:000AM
[257] => N
[Joint_Program_Ind] => N
[258] => SCBCH
[Academic_Program_Primary] => SCBCH
[259] => Y
[Primary_Program_Ind] => Y
[260] => 00500***-UGRD-UCALG-2115
[Std_Car_Term_DKey] => 00500***-UGRD-UCALG-2115
[261] => 00500***-UGRD-UCALG-2115-2
[Table_DKey] => 00500***-UGRD-UCALG-2115-2
[262] => PS_STDNT_CAR_TERM
[263] => 390***
[264] => 3
[Academic_Career_Key] => 3
[265] => 1
[Institution_Key] => 1
[266] => 191
[Term_Key] => 191
[267] => May 22 2011 10:16:59:000PM
[268] => 2107
[Admit_Term] => 2107
[269] => Fall 2010
[Admit_Term_Desc] => Fall 2010
[270] => 2010
[Admit_Term_Academic_Year] => 2010
[271] => 2107 - Fall 2010
[Admit_Term_Code_Desc] => 2107 - Fall 2010
[272] => F10
[Admit_Term_Desc_Short] => F10
[273] => SS
[Maxi_Term] => SS
[274] => Spring/Summer
[Maxi_Term_Desc] => Spring/Summer
[275] => 0000
[Latest_Maxi_Term] => 0000
[276] => Y
[Primary_Career_Ind] => Y
[277] => CM
[Program_Status] => CM
[278] => Completed Program
[Program_Status_Desc] => Completed Program
[279] => CM - Completed Program
[Program_Status_Code_Desc] => CM - Completed Program
[280] => Completed
[Program_Status_Desc_Short] => Completed
[281] => CF3
[Admit_Type] => CF3
[282] => Other Change of Program
[Admit_Type_Desc] => Other Change of Program
[283] => CF3-Other Change of Program
[Admit_Type_Code_Desc] => CF3-Other Change of Program
[284] => Othr COP
[Admit_Type_Desc_Short] => Othr COP
[285] => N
[Primary_Term_Ind] => N
[286] => 2012
[Next_Academic_Year] => 2012
[287] => 4209****
[Admission_Application_Nbr] => 4209****
[288] => 2
[Application_Program_Nbr] => 2
[289] => CPSC-MAJ-2115
[Acad_Plan_Term] => CPSC-MAJ-2115
[290] => CPSC
[Acad_Org_Owner] => CPSC
[291] => Dept of Computer Science
[Acad_Org_Owner_Desc] => Dept of Computer Science
[292] => CPSC - Dept of Computer Science
[Acad_Org_Owner_Code_Desc] => CPSC - Dept of Computer Science
[293] => 12150
[Dept_ID_Owner] => 12150
[294] => Computer Science
[Dept_ID_Owner_Desc] => Computer Science
[295] => 12150 - Computer Science
[Dept_ID_Owner_Code_Desc] => 12150 - Computer Science
[296] => SCIENCE
[Dept_L5_Code] => SCIENCE
[297] => Faculty of Science
[Dept_L5_Desc] => Faculty of Science
[298] => SCIENCE - Faculty of Science
[Dept_L5_Code_Desc] => SCIENCE - Faculty of Science
[299] => No_Primary_Plan_2
[Acad_Plan_Term_2] => No_Primary_Plan_2
[300] => No_Primary_Plan_2
[Acad_Org_Owner_2] => No_Primary_Plan_2
[301] => 0
[Acad_Org_Owner_2_Desc] => 0
[302] => No_Primary_Plan_2 - 0
[Acad_Org_Owner_2_Code_Desc] => No_Primary_Plan_2 - 0
[303] => No_Primary_Plan_2
[Dept_ID_Owner_2] => No_Primary_Plan_2
[304] => 0
[Dept_ID_Owner_2_Desc] => 0
[305] => No_Primary_Plan_2 - 0
[Dept_ID_Owner_2_Code_Desc] => No_Primary_Plan_2 - 0
[306] => No_Primary_Plan_2
[Dept_L5_2_Code] => No_Primary_Plan_2
[307] => 0
[Dept_L5_2_Desc] => 0
[308] => No_Primary_Plan_2 - 0
[Dept_L5_2_Code_Desc] => No_Primary_Plan_2 - 0
F_Class_Meeting_Pattern[edit | edit source]
[0] => 100013
[Course_ID] => 100013
[1] => 1
[Course_Offer_Nbr] => 1
[2] => 2061
[Term] => 2061
[3] => 1
[Session_Code] => 1
[4] => T02
[Class_Section] => T02
[5] => 10004
[Class_Nbr] => 10004
[6] => 1
[Class_Meeting_Nbr] => 1
[7] => PF 114
[Facility_ID] => PF 114
[8] => Jan 9 2006 12:00:00:000AM
[Class_Start_Date] => Jan 9 2006 12:00:00:000AM
[9] => Apr 28 2006 12:00:00:000AM
[Class_End_Date] => Apr 28 2006 12:00:00:000AM
[10] => 09:00:00
[Class_Start_Time] => 09:00:00
[11] => 09:50:00
[Class_End_Time] => 09:50:00
[12] => 50
[Class_Duration] => 50
[13] => OTH
[Days] => OTH
[14] => N
[Monday] => N
[15] => N
[Tuesday] => N
[16] => N
[Wednesday] => N
[17] => N
[Thursday] => N
[18] => Y
[Friday] => Y
[19] => N
[Saturday] => N
[20] => N
[Sunday] => N
[21] =>
[Standard_Meeting_Pattern] =>
[22] => N
[Print_Topic_On_XCR] => N
[23] => 1
[Count] => 1
[24] => 100013-2061
[Crse_Strm_DKey] => 100013-2061
[25] => 2061-10004
[Strm_Class_DKey] => 2061-10004
[26] => 100013-1-2061-1-T02-1
[Table_DKey] => 100013-1-2061-1-T02-1
[27] => PS_CLASS_MTG_PAT
[DB_Source] => PS_CLASS_MTG_PAT
[28] => 171
[Term_Key] => 171
[29] => 1019
[Facility_ID_Key] => 1019
[30] => Jul 5 2012 11:35:44:000PM
[Last_Update_Date] => Jul 5 2012 11:35:44:000PM