AUDIT_RBT_ACCT

(SQL Table)
 Index Back

Billing Account audit

Audit trail for Billing Account. Uses PeopleTools database-level auditing feature.

  • Audit Record Of RBT_ACCOUNT

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 AUDIT_OPRID Character(30) VARCHAR2(30) NOT NULL The OPRID of the user who made the changes audited on an audit record.
    2 AUDIT_STAMP DateTime(26) TIMESTAMP NOT NULL Timestamp
    3 AUDIT_ACTN Character(1) VARCHAR2(1) NOT NULL Audit Action Code for Application Messages. This tells the subscriber whether the row has been added, changed, or deleted.
    A=Add
    C=Change Old (PPR Only)
    D=Delete
    K=Change - Old Values
    N=Change - New Values
    O=Change - Original Values
    4 AUDIT_RECNAME Character(15) VARCHAR2(15) NOT NULL Name of the record definition audited. AUDIT_RECNAME is used in User-Defined Audit Record Definitions.
    5 RBTACCTID Character(15) VARCHAR2(15) NOT NULL Unique service account indentifier
    6 RBTPARENTACCTID Character(15) VARCHAR2(15) NOT NULL Parent Account Id
    7 RBTSPONSOREDACCTID Character(15) VARCHAR2(15) NOT NULL Sponsored Account Id
    8 RBTCONT_BO_ID Number(31,0) DECIMAL(31) NOT NULL Contact BO ID
    9 RBTACCTNAME Character(30) VARCHAR2(30) NOT NULL Account Name
    10 RBTACCTSTATUS Character(4) VARCHAR2(4) NOT NULL Account Status
    ACT=Active
    CLOS=Closed
    HOLD=On Hold
    PEND=Pending Activation
    11 RBTBILLCYCLE Character(4) VARCHAR2(4) NOT NULL Bill Cycle
    MON=Monthly
    QUAT=Quarterly
    12 RBTBILLDAY Character(4) VARCHAR2(4) NOT NULL Bill Day
    1=01
    10=10
    11=11
    12=12
    13=13
    14=14
    15=15
    16=16
    17=17
    18=18
    19=19
    2=02
    20=20
    21=21
    22=23
    23=23
    24=24
    25=25
    26=26
    27=27
    28=28
    3=03
    4=04
    5=05
    6=06
    7=07
    8=08
    9=09
    13 RBTACCESSQUESTION Character(4) VARCHAR2(4) NOT NULL Access Question
    MOTH=Mother's Maiden Name
    PET=Pet's Name
    SPRT=Favorite Sport
    TVSH=Favorite TV Show
    14 RBTANSWER Character(40) VARCHAR2(40) NOT NULL Answer
    15 RBTPAYMETHOD Character(4) VARCHAR2(4) NOT NULL Different types of payment methods for billing accounts.
    AUTO=Automatic Payment
    BANK=Bank Draft
    CC=Credit Card
    INV=Invoice
    VOUC=Voucher
    16 RBTBANKNAME Character(40) VARCHAR2(40) NOT NULL Bank Name
    17 RBTBANKACCNO Character(15) VARCHAR2(15) NOT NULL Bank Account No
    18 RBTROUTINGNO Character(20) VARCHAR2(20) NOT NULL Routing Number
    19 RBTSERIALNO Character(40) VARCHAR2(40) NOT NULL Serial Number
    20 CR_CARD_NBR Character(44) VARCHAR2(44) NOT NULL "See OM
    21 CR_CARD_TYPE Character(2) VARCHAR2(2) NOT NULL "See OM
    01=Visa
    02=MasterCard
    03=Diners Club/Carte Blanche
    04=AMEX
    05=Discover
    06=EnRoute

    Prompt Table: EOEC_CCI_TP_VW
    Set Control Field: EOEC_CCI_TYPE

    22 CR_CARD_STATUS Character(1) VARCHAR2(1) NOT NULL Hold Credit Card Status. Valid Values 1. Active 2. Inactive
    A=Active
    I=Inactive

    Default Value: A

    23 CR_CARD_FNAME Character(40) VARCHAR2(40) NOT NULL Credit Card First Name
    24 CR_CARD_LNAME Character(40) VARCHAR2(40) NOT NULL Credit Card Last Name
    25 CR_NAME_APPEARS Character(80) VARCHAR2(80) NOT NULL Hold Credit Card Name as it appears in the Card
    26 CR_CARD_EXPMO Character(2) VARCHAR2(2) NOT NULL Card Expiration Month
    01=01 - January
    02=02 - February
    03=03 - March
    04=04 - April
    05=05 - May
    06=06 - June
    07=07 - July
    08=08 - August
    09=09 - September
    10=10 - October
    11=11 - November
    12=12 - December
    27 CR_CARD_EXPYR Character(4) VARCHAR2(4) NOT NULL Card Expiration Year
    28 CR_CARD_DIGITS Character(4) VARCHAR2(4) NOT NULL Card Number's Last Four Digits
    29 RBT_PAYMENT_TYPE Character(4) VARCHAR2(4) NOT NULL Payment Type for Pre-Paid Account. Can be recurring or one time.
    MONT=Recurring Monthly Top-Up
    ONE=One Time Payment
    THRE=Recurring Threshold Top-Up
    VOUC=Voucher
    30 RBT_RELATED_ACCT Character(15) VARCHAR2(15) NOT NULL Field to hold the related account - this could be the pre-paid account or post paid account. Depending on reference.
    31 RBT_THRESHOLD Number(3,0) SMALLINT NOT NULL Field to hold top-up threshold for prepaid phones for the business unit.
    32 RBT_SECURITY Character(50) VARCHAR2(50) NOT NULL Field to hold the default security question for the business unit.
    33 RBTSTDATE Date(10) DATE Start Date
    34 RBTENDDATE Date(10) DATE End Date
    35 RBTCUST_BO_ID Number(31,0) DECIMAL(31) NOT NULL Customer BO ID
    36 CM_ID Number(31,0) DECIMAL(31) NOT NULL Contact Method ID