SETIDPrompt Table: SP_SETID_NONVW
Prompt Table: ACCT_TYP_TBL_SF
Prompt Table: SP_ITEMWV_NONVW
Prompt Table: SP_ITEMWV_NONVW
Prompt Table: SP_ITYPE_NONVW
Prompt Table: ITEM_GROUP_TBL
SSF_ANZ_LOAN_DF(SQL Table) |
Index Back |
|---|---|
ANZ Loan Default |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SP_SETID_NONVW |
| 2 | ACCOUNT_TYPE_SF | Character(3) | VARCHAR2(3) NOT NULL |
Account Type
Prompt Table: ACCT_TYP_TBL_SF |
| 3 | SSF_ITM_TYPE_DSCNT | Character(12) | VARCHAR2(12) NOT NULL |
Discount Item Type
Prompt Table: SP_ITEMWV_NONVW |
| 4 | SSF_ITM_TYPE_DEFER | Character(12) | VARCHAR2(12) NOT NULL |
Deferral Item Type
Prompt Table: SP_ITEMWV_NONVW |
| 5 | SSF_DISCOUNT_PCT | Number(6,2) | DECIMAL(5,2) NOT NULL | Discount Percent |
| 6 | SSF_MIN_PAY_DSCNT | Number(15,2) | DECIMAL(14,2) NOT NULL | Min Payment for Discount |
| 7 | SSF_ITM_TYPE_PELS | Character(12) | VARCHAR2(12) NOT NULL |
Deferral Item
Prompt Table: SP_ITYPE_NONVW |
| 8 | SSF_ITM_GROUP_PELS | Character(10) | VARCHAR2(10) NOT NULL |
Item Type Group
Prompt Table: ITEM_GROUP_TBL |