RBF_ATM_CARD

(SQL Table)
 Index Back

ATM Card

FSI ATM Card header information

  • Parent Record Of RBF_ATM_USAGE

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 ATM_CARD_NO Number(16,0) DECIMAL(16) NOT NULL ATM Card Number
    2 ATM_CARD_TYPE Character(4) VARCHAR2(4) NOT NULL ATM card types such as Standard and Debit
    PRDB=Premium Debit
    PRND=Premium
    STDB=Standard Debit
    STND=Standard
    3 DEBIT_CARD_TYPE Character(4) VARCHAR2(4) NOT NULL Debit Card Type
    MAST=MasterCard
    VISA=VISA
    4 SETID_PRODUCT Character(5) VARCHAR2(5) NOT NULL Product SetID

    Prompt Table: SP_SETID_NONVW

    5 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID

    Prompt Table: RBF_ATM_PROD_VW

    6 ATM_CARD_STATUS Character(3) VARCHAR2(3) NOT NULL Status of an ATM Card, stored as a translate value
    ACT=Active
    CNC=Cancelled
    ERR=Error
    INA=Inactive
    PRC=Processing
    SSP=Suspended

    Default Value: INA

    7 BO_ID_CUST Number(31,0) DECIMAL(31) NOT NULL This field stores the Business Object ID for the customer.

    Prompt Table: BO

    8 ROLE_TYPE_ID_CUST Number(12,0) DECIMAL(12) NOT NULL Stores ROLE_TYPE_ID for the customer
    9 BO_ID_CONTACT Number(31,0) DECIMAL(31) NOT NULL This field indicates the Business Object ID for the contact.

    Prompt Table: BO_CNCT_PRSN_VW

    10 ROLE_TYPE_ID_CNTCT Number(12,0) DECIMAL(12) NOT NULL Stores ROLE_TYPE_ID for the contact
    11 CM_ID Number(31,0) DECIMAL(31) NOT NULL Contact Method ID

    Prompt Table: CM

    12 CASH_WD_FLG Character(1) VARCHAR2(1) NOT NULL Cash withdrawal flag

    Y/N Table Edit

    Default Value: Y

    13 POS_FLG Character(1) VARCHAR2(1) NOT NULL position flag

    Y/N Table Edit

    Default Value: Y

    14 BILL_PAY_FLG Character(1) VARCHAR2(1) NOT NULL Bill Pay Flag

    Y/N Table Edit

    Default Value: Y

    15 LIMIT_CURR_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Prompt Table: CURRENCY_CD_TBL

    16 CASH_WD_LIMIT Number(29,4) DECIMAL(28,4) NOT NULL Cash Withdrawal Limit
    17 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.
    18 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.
    19 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.
    20 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.
    21 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
    22 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time