GPDE_SI_PRV_BNK

(SQL Table)
 Index Back

SI Provider Bank Data

SI Provider Bank Data

  • Parent record: GPDE_SI_PROV

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 GPDE_SI_PROV Character(8) VARCHAR2(8) NOT NULL Social Insurance Provider
    2 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    3 COUNTRY_CD Character(3) VARCHAR2(3) NOT NULL Country Code

    Default Value: OPR_DEF_TBL_HR.COUNTRY

    Prompt Table: GPSC_CNT_DVW_FL

    4 BANK_CD Character(11) VARCHAR2(11) NOT NULL Bank ID

    Prompt Table: BANK_EC_TBL

    5 BRANCH_EC_CD Character(17) VARCHAR2(17) NOT NULL Bank Branch ID

    Prompt Table: %GP_EDIT_FLD1

    6 ACCOUNT_EC_ID Character(35) VARCHAR2(35) NOT NULL Account Number used in banking.
    7 CHECK_DIGIT Character(2) VARCHAR2(2) NOT NULL Check Digit
    8 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Default Value: COUNTRY_CUR_TBL.CURRENCY_CD

    Prompt Table: CURRENCY_CD_TBL

    9 ACCOUNT_NAME Character(50) VARCHAR2(50) NOT NULL Account Name
    10 INTL_BANK_ACCT_NBR Character(34) VARCHAR2(34) NOT NULL IBAN International Bank Account Number
    11 ROLL_NAME Character(50) VARCHAR2(50) NOT NULL Roll Name
    12 ROLL_NUMBER Character(20) VARCHAR2(20) NOT NULL Roll Number
    13 IAT_IND Character(1) VARCHAR2(1) NOT NULL International ACH Transaction Bank (or IAT) Indicator

    Y/N Table Edit

    Default Value: N

    14 DEP_SCHED_ID Character(10) VARCHAR2(10) NOT NULL Deposit Schedule

    Prompt Table: DEP_SCHED