RB_PERSON_CARD

(SQL Table)
Index Back

Contact Card Information

CRm Common Object: Contact Card Information..

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID

Prompt Table: RD_PERSON

2 EFFDT Date(10) DATE NOT NULL Effective Date

Default Value: %date

3 CR_CARD_NBR Character(44) VARCHAR2(44) NOT NULL "See OM
4 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
5 PRIMARY_CARD Character(1) VARCHAR2(1) NOT NULL Primary Card

Y/N Table Edit

Default Value: N

6 CR_CARD_FNAME Character(40) VARCHAR2(40) NOT NULL Credit Card First Name
7 CR_CARD_LNAME Character(40) VARCHAR2(40) NOT NULL Credit Card Last Name
8 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
9 CR_CARD_EXPYR Character(4) VARCHAR2(4) NOT NULL Card Expiration Year
10 CR_CARD_DIGITS Character(4) VARCHAR2(4) NOT NULL Card Number's Last Four Digits
11 ADDR_SEQ_NUM Number(5,0) INTEGER NOT NULL Address Sequence Number
12 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.
13 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.
14 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.
15 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.
16 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.
17 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time
18 CC_PROF_TOKEN Character(44) VARCHAR2(44) NOT NULL Profile Token ID
19 CR_CARD_VENDOR Character(16) VARCHAR2(16) NOT NULL Vendor name for credit card processing