Student Information Analytics

This section lists the upgrade changes after 11.1.1.9.2 to 11.1.1.10.1 upgrade.

Admissions and Recruiting (AR)

Following are the upgrade changes:
  1. Tables truncated or records deleted:

    • W_SIA_TRANS_CREDIT_F

    • W_SIA_ADM_APPL_A

    • W_SIA_EXT_ACAD_SUMM_A

    • W_SIA_EXT_TESTSCORE_A

    • W_SIA_TRANS_CREDIT_A

  2. New columns included in base fact:

    W_SIA_ADM_APPL_A

    • SEQUENCE_NBR

    • SIA_SNAPSHOT_DATE

    W_SIA_TRANS_CREDIT_F

    • TRF_CRED_TYPE_ID

    • ACAD_PLAN_WID

    • ACAD_PROG_WID

    • INCL_GPA_FLG

    • MDL_STAT_WID

    • TRF_GPA

    • TRF_GRD_POINTS

    • TRF_PASS_GPA

    • TRF_PASS_NOGPA

    • TRF_TAKEN_GPA

    • TRF_TAKEN_NOGPA

    • TRNS_LVL_WID

    • UNIT_TAKEN

    • UNIT_TRNSFR

    W_SIA_TRANS_CREDIT_A

    • TRF_CRED_TYPE_ID

    • ACAD_PLAN_WID

    • ACAD_PROG_WID

    • INCL_GPA_FLG

    • MDL_STAT_WID

    • TRF_GPA

    • TRF_GRD_POINTS

    • TRF_PASS_GPA

    • TRF_PASS_NOGPA

    • TRF_TAKEN_GPA

    • TRF_TAKEN_NOGPA

    • TRNS_LVL_WID

    • UNIT_TAKEN

    • UNIT_TRNSFR

    • W_INSERT_DT

    • W_UPDATE_DT

  3. Tables with records added:

    • W_SIA_ADM_FUNNEL_F

  4. Affected tables and columns:

    Table Name

    Upgrage Mode

    Column Names

    W_SIA_ADM_APPL_A

    Truncate

    NA

    W_SIA_EXT_ACAD_SUMM_A

    Truncate

    NA

    W_SIA_EXT_TESTSCORE_A

    Truncate

    NA

    W_SIA_TRANS_CREDIT_A

    Reload

    NA

    W_SIA_RECRTR_D

    Update

    RECRUITER_NAME

    W_SIA_RECRTR_REG_D

    Update

    REGION_CS_WID

    W_SIA_ADM_APPL_F

    Update

    ENROLL_CNT

    W_SIA_ADM_APPL_STAT_F

    Update

    CREATED_ON_DT

    W_SIA_ADM_FUNNEL_F

    UpdateInsert/Update/Soft Delete

    CREATED_ON_DTAll

    W_SIA_EXT_TESTSCORE_F

    Soft DeleteUpdate

    DELETE_FLGCREATED_ON_DT

    W_SIA_STDNT_RESP_F

    Update

    REASON_CNTRESPONSE_CNTCREATED_ON_DT

    W_SIA_TRANS_CREDIT_F

    Reload

    All

  5. Metrics calculated differently:

    Subject Area

    Presentation Table

    Presentation Column

    SIA - Admissions and Recruiting - Admission Application

    Expected Graduation Term

    Source Graduation Term

    Fact - Admission Application

    Admit Count

    Enroll Count

    Sub Plan Term

    Source SubPlanTerm

    SIA - Admissions and Recruiting - Admission Application Snapshot

    Expected Graduation Term

    Source Graduation Term

    Fact - Admission Application Snapshot

    Admit Count

    Applicant Count

    Application Count

    Enroll Count

    Sub Plan Term

    Source SubPlanTerm

    SIA - Admissions and Recruiting - Admissions Funnel

    Academic Program Applicant

    Source Applicant Academic Program

    Academic Program Prospect

    Source Prospect Academic Program

    Academic Term Applicant

    Applicant Source Academic Term

    Academic Term Prospect

    Prospect Source Academic Term

    Admit Type Applicant

    Source Applicant Admit Type

    Admit Type Prospect

    Source Prospect Admit Type

    Campus Applicant

    Source Applicant Campus

    Campus Prospect

    Source Prospect Campus

    Fact - Admission Funnel

    Admit Count

    Admit to Confirm Yield

    Admit to Enrollment Yield

    Applicant Count

    Applicant to Admit Yield

    Confirm Count

    Confirm to Enrollment Yield

    Enrollment Count

    Prospect Count

    Prospect to Applicant Yield

    Prospect to Enrollment Yield

    SIA - Admissions and Recruiting - Application Evaluation

    Evaluation Code

    Source Evaluation

    Evaluation Status

    Source Evaluation Status

    Rating Component

    Source Rating Component

    SIA - Admissions and Recruiting - Application Status

    Expected Graduation Term

    Source Graduation Term

    SIA - Admissions and Recruiting - External Academic Summary

    External Term

    Source External Term

    GPA Type

    Source GPA Type

    SIA - Admissions and Recruiting - External Academic Summary Snapshot

    External Term

    Source External Term

    GPA Type

    Source GPA Type

    SIA - Admissions and Recruiting - External Test Scores

    Document Details

    Row Count

    External Test Component

    External Test Component

    Fact - External Test Scores

    % Chg Year Ago Average Score

    % Chg Year Ago Minimum Score

    Chg Year Ago Average Score

    Chg Year Ago Minimum Score

    SIA - Admissions and Recruiting - External Test Scores Snapshot

    Document Details

    Row Count

    External Test Component

    External Test Component

    SIA - Admissions and Recruiting - Student Recruiting

    Fact - Student Recruiting

    Applicant Count

  6. New attributes:

    Subject Area

    Presentation Table

    Presentation Column

    SIA - Admissions and Recruiting - Admission Application

    Fact - Admission Application

    % Chg Year Ago Confirm Count

    Chg Year Ago Confirm Count

    Confirm Count

    Year Ago Confirm Count

    SIA - Admissions and Recruiting - Admission Application Snapshot

    Fact - Admission Application Snapshot

    Confirm Count

    SIA - Admissions and Recruiting - Admissions Funnel

    Last School Attended

    External Organization State Code

    SIA - Admissions and Recruiting - External Academic Summary

    External Academic Level

    Source External Academic Level

    SIA - Admissions and Recruiting - External Academic Summary Snapshot

    External Academic Level

    Source External Academic Level

    SIA - Admissions and Recruiting - External Test Scores

    External Academic Level

    Source External Academic Level

    External Test Component

    External Test Code

    SIA - Admissions and Recruiting - External Test Scores Snapshot

    External Academic Level

    Source External Academic Level

    External Test Component

    External Test Code

    SIA - Admissions and Recruiting - Transfer Credit Snapshot

    Document Details

    Inclusion GPA Flag

    Transfer Credit Source

    Transfer Credit Type Id

    Unit Taken

    Unit Transfer

    Fact - Transfer Credit Snapshot

    Transfer GPA

    Transfer Grade Points

    Transfer Pass GPA

    Transfer Pass NOGPA

    Transfer Taken GPA

    Transfer Taken NOGPA
  7. Data model changes:

    • W_SIA_RECRTR_REG_DS

      Seq# Column Name Data Type (length, precisions) Change Type(Existing/New/Obsolete)
      4 REGION VARCHAR2(40) Existing

    • W_SIA_ADM_APPL_A

      Seq# Column Name Data Type (length, precisions) Change Type(Existing/New/Obsolete)
      75

      SEQUENCE_NBR

      NUMBER(10)

      		 New
      76

      SIA_SNAPSHOT_DATE

      DATE

      		 New

    • W_SIA_TRANS_CREDIT_F

      Seq# Column Name Data Type (length, precisions) Change Type(Existing/New/Obsolete)

      67

      TRF_CRED_TYPE_ID

      VARCHAR2(10,0)

      New

      68

      ACAD_PLAN_WID

      NUMBER(10,0)

      New

      69

      ACAD_PROG_WID

      NUMBER(10,0)

      New

      70

      INCL_GPA_FLG

      VARCHAR2(1,0)

      New

      71

      MDL_STAT_WID

      NUMBER(10,0)

      New

      72

      TRF_GPA

      NUMBER(10,3)

      New

      73

      TRF_GRD_POINTS

      NUMBER(10,3)

      New

      74

      TRF_PASS_GPA

      NUMBER(10,3)

      New

      75

      TRF_PASS_NOGPA

      NUMBER(10,3)

      New

      76

      TRF_TAKEN_GPA

      NUMBER(10,3)

      New

      77

      TRF_TAKEN_NOGPA

      NUMBER(10,3)

      New

      78

      TRNS_LVL_WID

      NUMBER(10,0)

      New

      79

      UNIT_TAKEN

      NUMBER(10,3)

      New

      80

      UNIT_TRNSFR

      NUMBER(10,3)

      New

      55

      CREATED_BY_WID

      NUMBER(10,0)

      Existing

      56

      CHANGED_BY_WID

      NUMBER(10,0)

      Existing

      6

      CRSE_ACAD_PROG_WID

      NUMBER(10,0)

      Obsolete

      7

      CRSE_ACAD_PLAN_WID

      NUMBER(10,0)

      Obsolete

      15

      CRSE_TRNS_LVL_WID

      NUMBER(10,0)

      Obsolete

      16

      CRSE_MDL_STAT_WID

      NUMBER(10,0)

      Obsolete

      17

      CRSE_UNIT_TAKEN

      NUMBER(10,3)

      Obsolete

      18

      CRSE_UNIT_TRNSFR

      NUMBER(10,3)

      Obsolete

      19

      CRSE_TRF_TAKEN_GPA

      NUMBER(10,3)

      Obsolete

      20

      CRSE_TRF_TAKEN_NOGPA

      NUMBER(10,3)

      Obsolete

      21

      CRSE_TRF_PASS_GPA

      NUMBER(10,3)

      Obsolete

      22

      CRSE_TRF_PASS_NOGPA

      NUMBER(10,3)

      Obsolete

      23

      CRSE_TRF_GRD_POINTS

      NUMBER(10,3)

      Obsolete

      24

      CRSE_TRF_GPA

      NUMBER(10,3)

      Obsolete

      25

      CRSE_INCL_GPA_FLG

      VARCHAR2(1,0)

      Obsolete

      26

      TST_MDL_STAT_WID

      NUMBER(10,0)

      Obsolete

      27

      TST_ACAD_PROG_WID

      NUMBER(10,0)

      Obsolete

      28

      TST_ACAD_PLAN_WID

      NUMBER(10,0)

      Obsolete

      29

      TST_TRNS_LVL_WID

      NUMBER(10,0)

      Obsolete

      30

      TST_UNIT_TRNSFR

      NUMBER(10,3)

      Obsolete

      31

      TST_TRF_TAKEN_GPA

      NUMBER(10,3)

      Obsolete

      32

      TST_TRF_TKN_NOGPA

      NUMBER(10,3)

      Obsolete

      33

      TST_TRF_PASS_GPA

      NUMBER(10,3)

      Obsolete

      34

      TST_TRF_PASS_NOGPA

      NUMBER(10,3)

      Obsolete

      35

      TST_TRF_GRD_POINTS

      NUMBER(10,3)

      Obsolete

      36

      TST_TRF_GPA

      NUMBER(10,3)

      Obsolete

      37

      TST_INCL_GPA_FLG

      VARCHAR2(1,0)

      Obsolete

      38

      OTHR_ACAD_PROG_WID

      NUMBER(10,0)

      Obsolete

      39

      OTHR_ACAD_PLAN_WID

      NUMBER(10,0)

      Obsolete

      40

      OTHR_MDL_STAT_WID

      NUMBER(10,0)

      Obsolete

      41

      OTHR_TRNS_LVL_WID

      NUMBER(10,0)

      Obsolete

      42

      OTHR_UNIT_TRNSFR

      NUMBER(10,0)

      Obsolete

      43

      OTHR_TRF_PASS_GPA

      NUMBER(10,0)

      Obsolete

      44

      OTHR_TRF_PASS_NOGPA

      NUMBER(10,0)

      Obsolete

      45

      OTHR_TRF_TAKEN_GPA

      NUMBER(10,0)

      Obsolete

      46

      OTHR_TRF_TAKEN_NOGPA

      NUMBER(10,0)

      Obsolete

      47

      OTHR_TRF_GRD_POINT

      NUMBER(10,0)

      Obsolete

      48

      OTHR_TRF_GPA

      NUMBER(10,0)

      Obsolete

      49

      OTHR_INCL_GPA_FLG

      VARCHAR2(1,0)

      Obsolete

    • W_SIA_TRANS_CREDIT_A

      Seq# Column Name Data Type (length, precisions) Change Type(Existing/New/Obsolete)

      66

      TRF_CRED_TYPE_ID

      VARCHAR2(10,0)

      New

      67

      ACAD_PLAN_WID

      NUMBER(10,0)

      New

      68

      ACAD_PROG_WID

      NUMBER(10,0)

      New

      69

      INCL_GPA_FLG

      VARCHAR2(1,0)

      New

      70

      MDL_STAT_WID

      NUMBER(10,0)

      New

      71

      TRF_GPA

      NUMBER(10,3)

      New

      72

      TRF_GRD_POINTS

      NUMBER(10,3)

      New

      73

      TRF_PASS_GPA

      NUMBER(10,3)

      New

      74

      TRF_PASS_NOGPA

      NUMBER(10,3)

      New

      75

      TRF_TAKEN_GPA

      NUMBER(10,3)

      New

      76

      TRF_TAKEN_NOGPA

      NUMBER(10,3)

      New

      77

      TRNS_LVL_WID

      NUMBER(10,0)

      New

      78

      UNIT_TAKEN

      NUMBER(10,3)

      New

      79

      UNIT_TRNSFR

      NUMBER(10,3)

      New

      80

      W_INSERT_DT

      DATE

      New

      81

      W_UPDATE_DT

      DATE

      New

      56

      CREATED_BY_WID

      NUMBER(10,0)

      Existing

      57

      CHANGED_BY_WID

      NUMBER(10,0)

      Existing

      7

      CRSE_ACAD_PROG_WID

      NUMBER(10,0)

      Obsolete

      8

      CRSE_ACAD_PLAN_WID

      NUMBER(10,0)

      Obsolete

      16

      CRSE_TRNS_LVL_WID

      NUMBER(10,0)

      Obsolete

      17

      CRSE_MDL_STAT_WID

      NUMBER(10,0)

      Obsolete

      18

      CRSE_UNIT_TAKEN

      NUMBER(10,3)

      Obsolete

      19

      CRSE_UNIT_TRNSFR

      NUMBER(10,3)

      Obsolete

      20

      CRSE_TRF_TAKEN_GPA

      NUMBER(10,3)

      Obsolete

      21

      CRSE_TRF_TAKEN_NOGPA

      NUMBER(10,3)

      Obsolete

      22

      CRSE_TRF_PASS_GPA

      NUMBER(10,3)

      Obsolete

      23

      CRSE_TRF_PASS_NOGPA

      NUMBER(10,3)

      Obsolete

      24

      CRSE_TRF_GRD_POINTS

      NUMBER(10,3)

      Obsolete

      25

      CRSE_TRF_GPA

      NUMBER(10,3)

      Obsolete

      26

      CRSE_INCL_GPA_FLG

      VARCHAR2(1,0)

      Obsolete

      27

      TST_MDL_STAT_WID

      NUMBER(10,0)

      Obsolete

      28

      TST_ACAD_PROG_WID

      NUMBER(10,0)

      Obsolete

      29

      TST_ACAD_PLAN_WID

      NUMBER(10,0)

      Obsolete

      30

      TST_TRNS_LVL_WID

      NUMBER(10,0)

      Obsolete

      31

      TST_UNIT_TRNSFR

      NUMBER(10,3)

      Obsolete

      32

      TST_TRF_TAKEN_GPA

      NUMBER(10,3)

      Obsolete

      33

      TST_TRF_TKN_NOGPA

      NUMBER(10,3)

      Obsolete

      34

      TST_TRF_PASS_GPA

      NUMBER(10,3)

      Obsolete

      35

      TST_TRF_PASS_NOGPA

      NUMBER(10,3)

      Obsolete

      36

      TST_TRF_GRD_POINTS

      NUMBER(10,3)

      Obsolete

      37

      TST_TRF_GPA

      NUMBER(10,3)

      Obsolete

      38

      TST_INCL_GPA_FLG

      VARCHAR2(1,0)

      Obsolete

      39

      OTHR_ACAD_PROG_WID

      NUMBER(10,0)

      Obsolete

      40

      OTHR_ACAD_PLAN_WID

      NUMBER(10,0)

      Obsolete

      41

      OTHR_MDL_STAT_WID

      NUMBER(10,0)

      Obsolete

      42

      OTHR_TRNS_LVL_WID

      NUMBER(10,0)

      Obsolete

      43

      OTHR_UNIT_TRNSFR

      NUMBER(10,0)

      Obsolete

      44

      OTHR_TRF_PASS_GPA

      NUMBER(10,0)

      Obsolete

      45

      OTHR_TRF_PASS_NOGPA

      NUMBER(10,0)

      Obsolete

      46

      OTHR_TRF_TAKEN_GPA

      NUMBER(10,0)

      Obsolete

      47

      OTHR_TRF_TAKEN_NOGPA

      NUMBER(10,0)

      Obsolete

      48

      OTHR_TRF_GRD_POINT

      NUMBER(10,0)

      Obsolete

      49

      OTHR_TRF_GPA

      NUMBER(10,0)

      Obsolete

      50

      OTHR_INCL_GPA_FLG

      VARCHAR2(1,0)

      Obsolete

Student Records (SR)

Following are the upgrade changes:
  1. Tables truncated or records deleted:

    • W_SIA_INST_SUMM_A

  2. New columns included in base fact:

    • W_SIA_ACAD_PROG_DTL_F

      ACAD_CAR_WID

  3. Tables with records added:

    • W_SIA_SCHOLAR_ATTR_D

    • W_SIA_SCHOLAR_RSDNCY_D

  4. Affected tables and columns:

    Table Name

    Upgrage Mode

    Column Names

    W_SIA_INST_SUMM_A

    Reload

    All

    W_SIA_SCHOLAR_ATTR_D

    Soft Delete and Insert

    All

    W_SIA_SCHOLAR_RSDNCY_D

    Insert/Update

    All

    W_SIA_STDNT_DEG_PLN_D

    Update

    HONORS_PREFIXHONORS_SUFFIX

    W_SIA_STDNT_DEG_SPLN_D

    Update

    HONORS_PREFIXHONORS_SUFFIX

    W_SIA_TERM_D

    Update

    ACAD_YEAR

    W_SIA_ACAD_PROG_DTL_F

    Update

    ACAD_CAR_WID

    W_SIA_CLASS_ENRLMT_F

    Update

    TERM_ACTVN_DT_WID

    W_SIA_ENRL_REQ_F

    Update

    CREATED_ON_DT

    W_SIA_TERM_ENRLMT_F

    Update

    ACAD_ORG_WIDRETURNING_FLG

  5. Metrics calculated differently:

    Subject Area

    Presentation Table

    Presentation Column

    SIA - Student Records - Academic Plan Summary

    Fact - Academic Plan Summary

    Degree GPA Points

    Academic Subplan

    Source Academic Subplan Code

    Source Academic Subplan

    Term Expected Graduation Term

    Source Expected Graduation Term

    SIA - Student Records - Academic Program Details

    Term Expected Graduation Term

    Source Expected Graduation Term

    SIA - Student Records - Class Enrollment

    Fact - Class Enrollment

    Average GPA

    Scholar

    Sport

    SIA - Student Records - Class Instructor

    Instructor

    Country

    Gender

    Marital Status

    Military Status

    SIA - Student Records - Class Meeting Pattern

    Instructor

    Country

    Gender

    Marital Status

    Military Status

    SIA - Student Records - Enrollment Requests

    Instructor

    Country

    Gender

    Marital Status

    Military Status

    SIA - Student Records - Term Enrollments

    Fact - Term Enrollment

    Cumulative Grade Point Average

    Current Grade Point Average

    Grade Points

    Scholar

    Sport

    Scholar Residency

    Source Residency

  6. New attributes:

    Subject Area

    Presentation Table

    Presentation Column

    SIA - Student Records - Academic Class

    Course Administrator

    Active Flag

    Course Admin First Name

    Course Admin ID

    Course Admin Last Name

    Course Admin Name

    Primary Instructor

    Country Code

    Ethnic Group

    Marital Status Code

    Military Status Code

    SIA - Student Records - Academic Program Details

    Academic Career

    Academic Career

    Academic Career Code

    Academic Career Term Type Code

    Active Flag

    Source Academic Career

    Source Academic Career Code

    SIA - Student Records - Class Enrollment

    Academic Level Start Term

    Active Flag

    Primary Instructor

    Country Code

    Ethnic Group

    Marital Status Code

    Military Status Code

    SIA - Student Records - Class Instructor

    Instructor

    Country Code

    Ethnic Group

    Marital Status Code

    Military Status Code

    SIA - Student Records - Class Meeting Pattern

    Instructor

    Country Code

    Ethnic Group

    Marital Status Code

    Military Status Code

    SIA - Student Records - Enrollment Requests

    Instructor

    Country Code

    Ethnic Group

    Marital Status Code

    Military Status Code

    SIA - Student Records - Term Enrollments

    Academic Career

    Academic Career Term Type Code

    Billing Career

    Billing Career Term Type Code

    Fact - Term Enrollment

    FA Unit Taken Grade Point Average

    Withdraw Reason

    Withdraw Reason Code

    Withdraw Reason Description
  7. Data model changes:

    • W_SIA_TERM_D

      Seq# Column Name Data Type (length, precisions) Change Type(Existing/New/Obsolete)

      7

      ACAD_YR

      VARCHAR2(15)

      Existing

    • W_SIA_RECRTR_EXT_DS

      Seq# Column Name Data Type (length, precisions) Change Type(Existing/New/Obsolete)

      6

      REGION

      VARCHAR2(40)

      Existing

    • W_SIA_RECRTR_REG_DS

      Seq# Column Name Data Type (length, precisions) Change Type(Existing/New/Obsolete)

      4

      REGION

      VARCHAR2(40)

      Existing

    • W_SIA_STDNT_DEG_PLN_DS

      Seq# Column Name Data Type (length, precisions) Change Type(Existing/New/Obsolete)

      8

      HONORS_PREFIX

      VARCHAR2(20)

      Existing

      9

      HONORS_SUFFIX

      VARCHAR2(20)

      Existing

    • W_SIA_STDNT_DEG_SPLN_DS

      Seq# Column Name Data Type (length, precisions) Change Type(Existing/New/Obsolete)

      5

      HONORS_PREFIX

      VARCHAR2(20)

      Existing

      6

      HONORS_SUFFIX

      VARCHAR2(20)

      Existing

    • W_SIA_STDNT_DEG_PLN_D

      Seq# Column Name Data Type (length, precisions) Change Type(Existing/New/Obsolete)

      9

      HONORS_PREFIX

      VARCHAR2(20)

      Existing

      10

      HONORS_SUFFIX

      VARCHAR2(20)

      Existing

    • W_SIA_STDNT_DEG_SPLN_D

      Seq# Column Name Data Type (length, precisions) Change Type(Existing/New/Obsolete)

      6

      HONORS_PREFIX

      VARCHAR2(20)

      Existing

      7

      HONORS_SUFFIX

      VARCHAR2(20)

      Existing

    • W_SIA_ACAD_PROG_DTL_FS

      Seq# Column Name Data Type (length, precisions) Change Type(Existing/New/Obsolete)

      38

      ACAD_CAR_ID

      VARCHAR2(80)

      New

    • W_SIA_ACAD_PROG_DTL_F

      Seq# Column Name Data Type (length, precisions) Change Type(Existing/New/Obsolete)

      39

      ACAD_CAR_WID

      NUMBER(10)

      New

Student Financials (SF)

Following are the upgrade changes:

  1. Affected tables and columns:

    Table Name

    Upgrage Mode

    Column Names

    W_SIA_CREDIT_HIST_F

    Update

    BILL_CAR_WID

    W_SIA_SF_PAYMENT_F

    Update

    ACAD_CAR_WIDACAD_PROG_WIDSESSION_CODE_WIDSELF_SRVC_FLGTENDER_CTGRY

    W_SIA_SF_TRAN_DTL_F

    Update

    CONTRACT_WIDGLOBAL1_EXCHANGE_RATEGLOBAL2_EXCHANGE_RATEGLOBAL3_EXCHANGE_RATE

    W_SIA_SF_TRAN_F

     Update

    GLOBAL1_EXCHANGE_RATEGLOBAL2_EXCHANGE_RATEGLOBAL3_EXCHANGE_RATE

  2. Metrics calculated differently:

    Subject Area

    Presentation Table

    Presentation Column

    SIA - Student Financials - Billing Summary

    Time - Due Date

    Month

    SIA - Student Financials - Credit History

    Aging Category

    Summary Category Description

    SIA - Student Financials - Payment Details

    Time - Encumbered Date

    Month

    Time - Posted Date

    Month

    SIA - Student Financials - Transaction Details

    Fact - SIA Transaction Detail

    Line Amount

    Time - Actual Billing Date

    Month

    Time - Billing Date

    Month

    Time - Class Price Date

    Month

    Time - Dispute Date

    Month

    Time - Encumbered Date

    Month

    Time - GL Posting Date

    Month

    Time - Posted Date

    Month

    Time - Transaction Due Date

    Month

    SIA - Student Financials - Transactions

    Time - Actual Billing Date

    Month

    Time - Billing Date

    Month

    Time - Transaction Due Date

    Month

    Time - Transaction Paid Date

    Day Name

    Month

  3. New attributes:

    Subject Area

    Presentation Table

    Presentation Column

    SIA - Student Financials - Transaction Details

    Fee Code

    Source Fee Code

    Item Term

    Active Flag

    Item Term Source Code

    Item Term Source Description

    Time - Aging Date

    Date

    Day Name

    Month

    Quarter

    Year

    SIA - Student Financials - Transactions

    Fee Code

    Source Fee Code
  4. Data model changes:

    • W_SIA_SF_PAYMENT_FS

      Seq# Column Name Data Type (length, precisions) Change Type(Existing/New/Obsolete)

      17

      SESSION_CODE

      VARCHAR2(25)

      Existing

    • W_SIA_SF_TRAN_DTL_FS

      Seq# Column Name Data Type (length, precisions) Change Type(Existing/New/Obsolete)

      47

      CONTRACT_NUM

      VARCHAR2(50)

      Existing

    • W_SIA_SF_TRAN_DTL_F

      Seq# Column Name Data Type (length, precisions) Change Type(Existing/New/Obsolete)

      80

      GLOBAL1_EXCHANGE_RATE

      NUMBER(38,10)

      Existing

      81

      GLOBAL2_EXCHANGE_RATE

      NUMBER(38,10)

      Existing

      82

      GLOBAL3_EXCHANGE_RATE

      NUMBER(38,10)

      Existing

Financial Aid (FA)

Following are the upgrade changes:

  1. Metrics calculated differently:

    Subject Area

    Presentation Table

    Presentation Column

    SIA - Financial Aid - Award Disbursement

    Fact - Award Disbursement

    Accepted Amount as a % of Offered Amount

    Authorized Amount as a % of Accepted Amount

    Disbursed Amount as a % of Authorized Amount

    Student Aid Attribute

    Source Packaging Plan

    Time - Term Begin Date

    Month

    SIA - Financial Aid - Award Summary Snapshot

    Student Aid Attribute

    Source Packaging Plan