SQL-028 Retrieve PPD unscheduled degree-award bands¶

Retrieves the effective-dated, banded unscheduled degree-award table used by clsPPDUnscheduledDegreeAwards.GetAwardAmount to walk degree ranges.

Classification¶

Field	Value
SQL ID	SQL-028
Operation type	Read
Execution method	Inline SQL (SqlHelper.ResultSetQuery)
Database	Oracle
Schema	`[unqualified]**`
Command type	Text
Business object	`clsPPDUnscheduledDegreeAwards`
Criteria property	`(none)`
Lifecycle method	`GetUnscheduledDegreeAwards`

Tables¶

Table	Access	Columns used
CL_PPD_UNSCHED_DEGREE_AWARD	SELECT	DEGREE_UPPER_RANGE_NUM, AWARD_PER_DEGREE_AMT, EFFECTIVE_DATE

Sample SQL¶

-- Retrieve PPD unscheduled degree-award bands
select degree_upper_range_num  degree,
       award_per_degree_amt    award,
       effective_date          eff_dt
  from cl_ppd_unsched_degree_award
 order by eff_dt, degree

Operations and processes¶

PPD award calculation

Sources¶

SAIF.Business.Claim/clsPPDUnscheduledDegreeAwards.vb