GPSC_SSB_BANK

(SQL Table)
Index Back

Banking Setup Table

Setup Record - Banking Main Setup Options

  • Parent record: GPSC_SSB_CN_SRC
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

    Prompt Table: GPSC_SSB_CNT_VW

    2 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    3 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    4 GPSC_SSB_AC_ALLOW Character(2) VARCHAR2(2) NOT NULL Allow others countries different to Pay Entity country the employee belongs.
    AC=Any Country
    HM=Home Country Only
    SC=Specified Countries

    Default Value: HM

    5 GPSC_SSB_ATACH_ENB Character(1) VARCHAR2(1) NOT NULL Enable Attachments

    Y/N Table Edit

    Default Value: N

    6 GPSC_SSB_ATACH_REQ Character(1) VARCHAR2(1) NOT NULL Attachment Required

    Y/N Table Edit

    Default Value: N

    7 GPSC_SSB_NTF_ENB Character(1) VARCHAR2(1) NOT NULL Enable Notification Option.

    Y/N Table Edit

    Default Value: N

    8 GPSC_SSB_NOTFY_EMP Character(1) VARCHAR2(1) NOT NULL Notify Employee

    Y/N Table Edit

    Default Value: N

    9 GPSC_SSB_NOTFY_ADM Character(1) VARCHAR2(1) NOT NULL Notify Admin

    Y/N Table Edit

    Default Value: N

    10 GPSC_SSB_RETYPE_AC Character(1) VARCHAR2(1) NOT NULL Retype Account Option.

    Y/N Table Edit

    Default Value: N

    11 GPSC_SSB_MASK_ENB Character(1) VARCHAR2(1) NOT NULL Enable Mask Option.

    Y/N Table Edit

    Default Value: N

    12 GPSC_SSB_ONE_ACC Character(1) VARCHAR2(1) NOT NULL Single Bank Account.

    Y/N Table Edit