ISET_BU_DTL(SQL Table) |
Index Back |
---|---|
ISet Business Unit Detail |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | INSTITUTION_SET | Character(5) | VARCHAR2(5) NOT NULL | Institution Set |
2 | BUSINESS_UNIT | 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 |