SQL-001: Criteria
This SQL artifact supports Criteria by executing a create operation through Inline.
Classification
| Field |
Value |
| SQL ID |
SQL-001 |
| Operation type |
Create |
| Execution method |
Inline |
| Database |
Oracle |
| Schema |
[unqualified]** |
| Command type |
Text |
| Business object |
Criteria |
| Criteria property |
insertsql |
| Lifecycle method |
Criteria create |
Parameters
| Parameter |
Direction |
Type |
Max length |
Description |
:AllClaimFlag |
Input |
String |
1 |
Source value AllClaimFlag |
:ArrearageFlag |
Input |
String |
1 |
Source value ArrearageFlag |
:DelinquentMonthlyAmt |
Input |
Unknown |
N/A |
Source value DelinquentMonthlyAmt |
:EffDate |
Input |
Date |
N/A |
Source value m_EffDate |
:MaxReductionPercent |
Input |
Unknown |
N/A |
Source value MaxReductionPercent |
:MonthlyAmt |
Input |
Unknown |
N/A |
Source value MonthlyAmt |
:ReceiveDate |
Input |
Date |
N/A |
Source value m_ReceiveDate |
:SedAccountNum |
Input |
Number |
12 |
Source value SedAccountNum |
:SourceTxt |
Input |
Unknown |
20 |
Source value SourceTxt |
:SupportOrderID |
Input |
Number |
N/A |
Source value SupportOrderID |
:TermDate |
Input |
Date |
N/A |
Source value TermDate |
:WorkerID |
Input |
Number |
N/A |
Source value WorkerID |
:UpdateUser |
Input |
Date |
30 |
Source value UpdateUser |
:WorkerID |
Input |
Number |
N/A |
Source value MyCriteria.WorkerID |
Tables
Sample SQL
Insert into CL_CLAIM_SUPPORT_ORDER (
ALL_CLAIM_FLAG,
ARREARAGE_FLAG,
DELINQUENT_MONTHLY_AMT,
EFF_DATE,
MAX_REDUCTION_PERCENT,
MONTHLY_AMT,
RECEIVE_DATE,
SED_ACCOUNT_NUM,
SOURCE_TXT,
SUPPORT_ORDER_ID,
TERM_DATE,
UPDATE_DATE,
UPDATE_NUM,
UPDATE_USER,
WORKER_ID
)
Values (
:AllClaimFlag,
:ArrearageFlag,
:DelinquentMonthlyAmt,
:EffDate,
:MaxReductionPercent,
:MonthlyAmt,
:ReceiveDate,
:SedAccountNum,
:SourceTxt,
:SupportOrderID,
:TermDate,
SYSDATE,
0,
:UpdateUser,
:WorkerID
)
Sources
Business\SAIF.Business.Claim.SupportOrder\clsClaimSupportOrder.vb