RI_ATM_STAT_VW

(SQL View)
 Index Back

ATM Status View

ATM Status views returns the ATM Card number and ATM Card status

SELECT ATM.BO_ID_CUST , ATM.ROLE_TYPE_ID_CUST , ATM.BO_ID_CONTACT , ATM.ROLE_TYPE_ID_CNTCT , 0 ,ATM.ATM_CARD_STATUS , ATM.ATM_CARD_NO , XL.XLATLONGNAME , 0 , 0 , 0 , 0 , %subrec(RB_AUDIT_SBR,ATM) FROM PS_RBF_ATM_CARD ATM , PSXLATITEM XL WHERE ATM.ATM_CARD_STATUS = XL.FIELDVALUE AND XL.FIELDNAME = 'ATM_CARD_STATUS' AND XL.EFF_STATUS = 'A' AND XL.EFFDT <= %CurrentDateIn

  • Related Language Record: RI_ATM_STATLVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BO_ID_CUST Number(31,0) DECIMAL(31) NOT NULL This field stores the Business Object ID for the customer.
    2 ROLE_TYPE_ID_CUST Number(12,0) DECIMAL(12) NOT NULL Stores ROLE_TYPE_ID for the customer
    3 BO_ID_CONTACT Number(31,0) DECIMAL(31) NOT NULL This field indicates the Business Object ID for the contact.
    4 ROLE_TYPE_ID_CNTCT Number(12,0) DECIMAL(12) NOT NULL Stores ROLE_TYPE_ID for the contact
    5 BO_ID_SITE Number(31,0) DECIMAL(31) NOT NULL Business Object ID
    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
    7 ATM_CARD_NO Number(16,0) DECIMAL(16) NOT NULL ATM Card Number
    8 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name
    9 BO_ID_PARTNER Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID of Partner Company.
    10 ROLE_TYPE_ID_PART Number(12,0) DECIMAL(12) NOT NULL Stores ROLE_TYPE_ID for the partner
    11 BO_ID_PART_CONT Signed Number(32,0) DECIMAL(31) NOT NULL This is the business object identifier for the partner contact.
    12 ROLE_TYPE_ID_PARTC Number(12,0) DECIMAL(12) NOT NULL Stores ROLE_TYPE_ID for the partner contact
    13 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.
    14 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.
    15 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.
    16 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.
    17 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.
    18 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time