ISET_BU_DTL

(SQL Table)
Index Back

ISet Business Unit Detail

  • Related Language Record: ISET_BU_DTL_LNG
  • # 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