SQL-027 Retrieve PPD scheduled degree-award table

Retrieves the effective-dated scheduled degree-award amounts used by clsPPDScheduledDegreeAwards.GetAwardAmount.

Classification

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

Tables

Table	Access	Columns used
CL_PPD_SCHED_DEGREE_AWARD	SELECT	EFFECTIVE_DATE, AWARD_PER_DEGREE_AMT

Sample SQL

-- Retrieve PPD scheduled degree-award table
select effective_date        Eff_dt,
       award_per_degree_amt  award
  from cl_ppd_sched_degree_award

Operations and processes

• PPD award calculation

Sources

• SAIF.Business.Claim/clsPPDScheduledDegreeAwards.vb