BUSINESS_UNITSSF_LOAN_DF_VW(SQL View) |
Index Back |
|---|---|
ANZ Loan Default View |
| SELECT %Substring(C.SETCNTRLVALUE,1,5) ,A.ACCOUNT_TYPE_SF ,A.SSF_ITM_TYPE_DSCNT ,A.SSF_ITM_TYPE_DEFER ,B.SSF_MIN_PAY_DSCNT ,B.SSF_DISCOUNT_PCT FROM PS_SSF_ANZ_LOAN_DF A , PS_SSF_HECS_DEF_RT B , PS_SET_CNTRL_REC C WHERE A.SETID = B.SETID AND C.RECNAME = 'ACCT_TYP_TBL_SF' AND A.SETID = C.SETID AND B.EFFDT = ( SELECT MAX (B1.EFFDT) FROM PS_SSF_HECS_DEF_RT B1 WHERE B1.SETID = B.SETID AND B1.EFFDT <= %CurrentDateIn) AND B.EFF_STATUS = 'A' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | ACCOUNT_TYPE_SF | Character(3) | VARCHAR2(3) NOT NULL | Account Type |
| 3 | SSF_ITM_TYPE_DSCNT | Character(12) | VARCHAR2(12) NOT NULL | Discount Item Type |
| 4 | SSF_ITM_TYPE_DEFER | Character(12) | VARCHAR2(12) NOT NULL | Deferral Item Type |
| 5 | SSF_MIN_PAY_DSCNT | Number(15,2) | DECIMAL(14,2) NOT NULL | Min Payment for Discount |
| 6 | SSF_DISCOUNT_PCT | Number(6,2) | DECIMAL(5,2) NOT NULL | Discount Percent |