EOEC_CCI_CARD

(SQL Table)
Index Back

CCI Card

Credit Card Interface Card

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EOEC_CCI_TYPE Character(3) VARCHAR2(3) NOT NULL Credit Card Name
2 EOEC_CCI_NUMBER Character(200) VARCHAR2(200) NOT NULL Use in the Credit Card Number Capture Process
3 EOEC_CCI_EXPYR Character(4) VARCHAR2(4) NOT NULL Use in the Credit Card Number Capture Process
2001=2001
2002=2002
2003=2003
2004=2004
2005=2005
2006=2006
2007=2007
2008=2008
2009=2009
2010=2010
4 EOEC_CCI_EXPMO Character(2) VARCHAR2(2) NOT NULL Credit Card Expiry Month
01=January
02=February
03=March
04=April
05=May
06=June
07=July
08=August
09=September
10=October
11=November
12=December
5 EOEC_CCI_CVNUM Character(4) VARCHAR2(4) NOT NULL Card Verification Number
6 EOEC_CCI_MAGDATA Character(80) VARCHAR2(80) NOT NULL Magnetic Strip Data
7 EOEC_CCI_FULLNAME Character(70) VARCHAR2(70) NOT NULL Full Name
8 EOEC_CCI_FNAME Character(60) VARCHAR2(60) NOT NULL Use in the Credit Card Number Capture Process
9 EOEC_CCI_LNAME Character(60) VARCHAR2(60) NOT NULL Use in the Credit Card Number Capture Process