This section lists the upgrade changes after 11.1.1.9.2 to 11.1.1.10.1 upgrade.
Admissions and Recruiting (AR)
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
New columns included in base fact:
SEQUENCE_NBR
SIA_SNAPSHOT_DATE
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
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
W_SIA_ADM_FUNNEL_F
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 |
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 |
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 |
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)
W_SIA_INST_SUMM_A
W_SIA_ACAD_PROG_DTL_F
ACAD_CAR_WID
W_SIA_SCHOLAR_ATTR_D
W_SIA_SCHOLAR_RSDNCY_D
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 |
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 |
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 |
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)
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 |
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 |
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 |
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)
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 |