EOEC_CCI_CARD(SQL Table) |
Index Back |
|---|---|
CCI CardCredit 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
2008=2008 2009=2009 2010=2010 2011=2011 2012=2012 2013=2013 2014=2014 2015=2015 2016=2016 2017=2017 2018=2018 2019=2019 |
| 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 |