ISET_BU_DTL(SQL Table) |
Index Back |
|---|---|
ISet Business Unit Detail |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Character(5) | VARCHAR2(5) NOT NULL | Institution Set | |
| 2 | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: BUS_UNIT_TBL_SF |
|
| 3 | PRIORITY | Number(3,0) | SMALLINT NOT NULL | Priority |
| 4 | PRIMARY_BU | Character(1) | VARCHAR2(1) NOT NULL |
Primary Business Unit
Y/N Table Edit Default Value: N |
| 5 | BU_LIMIT_AMT | Number(19,4) | DECIMAL(18,4) NOT NULL | Limit Amount |
| 6 | BU_PCT | Number(12,8) | DECIMAL(11,8) NOT NULL | Percent |
| 7 | BU_PRIORITY_AMT | Number(19,4) | DECIMAL(18,4) NOT NULL | Priority Amount |
| 8 | SERVICE_IMPACT | Character(5) | VARCHAR2(5) NOT NULL |
Service Impact
Prompt Table: SSF_SVCIMP_D_VW |
| 9 | SERVICE_IMPACT_SF | Character(5) | VARCHAR2(5) NOT NULL |
Service Impact SF
Prompt Table: SSF_SVCIMP_D_VW |
| 10 | ITEM_TYPE_GROUP | Character(10) | VARCHAR2(10) NOT NULL |
Item Type Group
Prompt Table: ITEM_GROUP_TBL |
| 11 | ITEM_TYPE | Character(12) | VARCHAR2(12) NOT NULL |
Item Type
Prompt Table: ITEM_TYPE_CR_VW |
| 12 | ITEM_TYPE_ECHK | Character(12) | VARCHAR2(12) NOT NULL |
eCheck Item Type
Prompt Table: ITEM_TYPE_EC_VW |
| 13 | CONTACT_ID | Character(15) | VARCHAR2(15) NOT NULL |
Contact Identifier for Treasury Contacts
Prompt Table: PEOPLE_SRCH |
| 14 | EMAILID | Character(70) | VARCHAR2(70) NOT NULL | A user's E-mail address |
| 15 | COUNTRY_CODE | Character(3) | VARCHAR2(3) NOT NULL | Country Code |
| 16 | PHONE | Character(24) | VARCHAR2(24) NOT NULL | Telephone |
| 17 | EXTENSION | Character(6) | VARCHAR2(6) NOT NULL | Phone number extension |
| 18 | SF_ALLOW_EXCESS | Character(1) | VARCHAR2(1) NOT NULL |
Allow Excess Payment
Y/N Table Edit Default Value: Y |
| 19 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 20 | ACCOUNT_TYPE_SF | Character(3) | VARCHAR2(3) NOT NULL |
Account Type
Prompt Table: ACCT_TYP_TBL_SF |
| 21 | ACCOUNT_TYPE_SF_CR | Character(3) | VARCHAR2(3) NOT NULL |
Convenience Fee Account Type
Prompt Table: ACCT_TYP_TBL_SF |
| 22 | ITEM_TYPE_DEPOSIT | Character(12) | VARCHAR2(12) NOT NULL |
Deposit Item Type
Prompt Table: ITEM_TYPE_DP_VW |
| 23 | SRVC_IND_REV_CD | Character(3) | VARCHAR2(3) NOT NULL |
Service Indicator Cd
Prompt Table: SRV_IND_CD_SCTY |
| 24 | LOCATION | Character(10) | VARCHAR2(10) NOT NULL |
Location Code
Prompt Table: LOCATION_TBL |
| 25 | SSF_ITEM_TYPE_CC | Character(12) | VARCHAR2(12) NOT NULL |
Misc Fee Credit Card Item Type
Prompt Table: ITEM_TYPE_CR_VW |
| 26 | SSF_ITEM_TYPE_EC | Character(12) | VARCHAR2(12) NOT NULL |
Misc Fee Echeck Item Type
Prompt Table: ITEM_TYPE_EC_VW |
| 27 | SSF_ITEM_TYPE_FEE | Character(12) | VARCHAR2(12) NOT NULL |
Convenience Fee Item Type
Prompt Table: ITEM_TYPE_CH_VW |
| 28 | SSF_ACCT_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Account Type
Prompt Table: ACCT_TYP_TBL_SF |
| 29 | SSF_BANK_SRVC_IMP | Character(5) | VARCHAR2(5) NOT NULL |
Service Impact for disabling Self-Service access to Manage Banks.
Prompt Table: SSF_SVCIMP_D_VW |
| 30 | SSF_DD_SRVC_IMP_FL | Character(5) | VARCHAR2(5) NOT NULL |
Service Impact for disabling Self-Service access to Manage Banks.
Prompt Table: SSF_SVCIMP_D_VW |