RB_CARD_VW (SQL View)	Index Back
Person's Credit Card View Fetches the Credit Card Information along with Person ID Used in Consumer Component.

RB_CARD_VW

(SQL View)

Person's Credit Card View

Fetches the Credit Card Information along with Person ID Used in Consumer Component.

SELECT A.BO_ID , A.SEQNUM , B.PERSON_ID , A.PRIMARY_IND , A.CR_CARD_NBR , A.CR_CARD_TYPE , A.CR_CARD_STATUS , A.CR_CARD_FNAME , A.CR_CARD_LNAME , A.CR_NAME_APPEARS , A.CR_CARD_EXPMO , A.CR_CARD_EXPYR , A.CR_CARD_DIGITS , A.CR_CARD_AUTH , A.CC_PROF_TOKEN , A.CR_CARD_VENDOR , A.PROFILE_CM_SEQ FROM PS_RB_CREDIT_CARD A , PS_RD_PERSON B WHERE A.BO_ID = B.BO_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BO_ID Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID

2 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number

3 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID

4 PRIMARY_IND Character(1) VARCHAR2(1) NOT NULL Flag that indicates whether or not it is Primary
N=No
Y=Yes

5 CR_CARD_NBR Character(44) VARCHAR2(44) NOT NULL "See OM

6 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

7 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

8 CR_CARD_FNAME Character(40) VARCHAR2(40) NOT NULL Credit Card First Name

9 CR_CARD_LNAME Character(40) VARCHAR2(40) NOT NULL Credit Card Last Name

10 CR_NAME_APPEARS Character(80) VARCHAR2(80) NOT NULL Hold Credit Card Name as it appears in the Card

11 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

12 CR_CARD_EXPYR Character(4) VARCHAR2(4) NOT NULL Card Expiration Year

13 CR_CARD_DIGITS Character(4) VARCHAR2(4) NOT NULL Card Number's Last Four Digits

14 CR_CARD_AUTH Character(44) VARCHAR2(44) NOT NULL Holds Credit Card Authorization Number. Few credit cards have some extra numbers, which is required for authoization.

15 CC_PROF_TOKEN Character(44) VARCHAR2(44) NOT NULL Profile Token ID

16 CR_CARD_VENDOR Character(16) VARCHAR2(16) NOT NULL Vendor name for credit card processing
Prompt Table: EOEC_CCI_INSTAL

17 PROFILE_CM_SEQ Number(31,0) DECIMAL(31) NOT NULL The Contact Method Profile ID is a key field that is used to reference the details of a Contact Method in various CM tables.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BO_ID	Signed Number(32,0)	DECIMAL(31) NOT NULL	Business Object ID
2	SEQNUM	Number(3,0)	SMALLINT NOT NULL	Sequence Number
3	PERSON_ID	Character(15)	VARCHAR2(15) NOT NULL	Person ID
4	PRIMARY_IND	Character(1)	VARCHAR2(1) NOT NULL	Flag that indicates whether or not it is Primary N=No Y=Yes
5	CR_CARD_NBR	Character(44)	VARCHAR2(44) NOT NULL	"See OM
6	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
7	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
8	CR_CARD_FNAME	Character(40)	VARCHAR2(40) NOT NULL	Credit Card First Name
9	CR_CARD_LNAME	Character(40)	VARCHAR2(40) NOT NULL	Credit Card Last Name
10	CR_NAME_APPEARS	Character(80)	VARCHAR2(80) NOT NULL	Hold Credit Card Name as it appears in the Card
11	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
12	CR_CARD_EXPYR	Character(4)	VARCHAR2(4) NOT NULL	Card Expiration Year
13	CR_CARD_DIGITS	Character(4)	VARCHAR2(4) NOT NULL	Card Number's Last Four Digits
14	CR_CARD_AUTH	Character(44)	VARCHAR2(44) NOT NULL	Holds Credit Card Authorization Number. Few credit cards have some extra numbers, which is required for authoization.
15	CC_PROF_TOKEN	Character(44)	VARCHAR2(44) NOT NULL	Profile Token ID
16	CR_CARD_VENDOR	Character(16)	VARCHAR2(16) NOT NULL	Vendor name for credit card processing Prompt Table: EOEC_CCI_INSTAL
17	PROFILE_CM_SEQ	Number(31,0)	DECIMAL(31) NOT NULL	The Contact Method Profile ID is a key field that is used to reference the details of a Contact Method in various CM tables.