EOEC_CCI_TEST (SQL Table)	Index Back
Test CCI Record to contain test records for the Credit Card Interface. This record is merely used to verify the working of the credit card subrecord.

EOEC_CCI_TEST

(SQL Table)

Test CCI

Record to contain test records for the Credit Card Interface. This record is merely used to verify the working of the credit card subrecord.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SEQNO Number(5,0) INTEGER NOT NULL Sequence Number

2 DESCR Character(30) VARCHAR2(30) NOT NULL Description

3 EOEC_CCI_AMOUNT Number(27,3) DECIMAL(26,3) NOT NULL Amount for credit card transactions. Always positive, the service type (bill or credit) will determine the difference between debit and credit.

4 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
Prompt Table: CURRENCY_CD_TBL

5 EOEC_CCI_RQSTID Character(30) VARCHAR2(30) NOT NULL Request ID

6 EOEC_CCI_NUMBER Character(200) VARCHAR2(200) NOT NULL Use in the Credit Card Number Capture Process

7 EOEC_CCI_TYPE Character(3) VARCHAR2(3) NOT NULL Credit Card Name
Prompt Table: EOEC_CCI_TP_VW

8 EOEC_CCI_STATUS Character(1) VARCHAR2(1) NOT NULL Hold Credit Card Status. Valid Values 1. Active 2. Inactive
A=Active
I=Inactive
Default Value: A

9 EOEC_CCI_FNAME Character(60) VARCHAR2(60) NOT NULL Use in the Credit Card Number Capture Process

10 EOEC_CCI_LNAME Character(60) VARCHAR2(60) NOT NULL Use in the Credit Card Number Capture Process

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

12 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

13 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

14 EOEC_CCI_4DIGITS Character(4) VARCHAR2(4) NOT NULL Use in the Credit Card Number Capture Process

15 EOEC_CCI_AUTH Number(5,0) INTEGER NOT NULL Holds Credit Card Authorization Number. Few credit cards have some extra numbers, which is required for authoization.

16 EOEC_CCI_CVNUM Character(4) VARCHAR2(4) NOT NULL Card Verification Number

17 CREATEDTTM DateTime(26) TIMESTAMP DateTime of Query Creation

18 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

19 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

20 EOEC_CCI_RQSTTOKEN Long Character(256) VARCHAR2(256) Request Token

21 EOEC_SUBSCRIPTION Number(26,0) DECIMAL(26) NOT NULL Subscription ID

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SEQNO	Number(5,0)	INTEGER NOT NULL	Sequence Number
2	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
3	EOEC_CCI_AMOUNT	Number(27,3)	DECIMAL(26,3) NOT NULL	Amount for credit card transactions. Always positive, the service type (bill or credit) will determine the difference between debit and credit.
4	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Prompt Table: CURRENCY_CD_TBL
5	EOEC_CCI_RQSTID	Character(30)	VARCHAR2(30) NOT NULL	Request ID
6	EOEC_CCI_NUMBER	Character(200)	VARCHAR2(200) NOT NULL	Use in the Credit Card Number Capture Process
7	EOEC_CCI_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Credit Card Name Prompt Table: EOEC_CCI_TP_VW
8	EOEC_CCI_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Hold Credit Card Status. Valid Values 1. Active 2. Inactive A=Active I=Inactive Default Value: A
9	EOEC_CCI_FNAME	Character(60)	VARCHAR2(60) NOT NULL	Use in the Credit Card Number Capture Process
10	EOEC_CCI_LNAME	Character(60)	VARCHAR2(60) NOT NULL	Use in the Credit Card Number Capture Process
11	EOEC_CCI_APPEARS	Character(80)	VARCHAR2(80) NOT NULL	Hold Credit Card Name as it appears in the Card
12	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
13	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
14	EOEC_CCI_4DIGITS	Character(4)	VARCHAR2(4) NOT NULL	Use in the Credit Card Number Capture Process
15	EOEC_CCI_AUTH	Number(5,0)	INTEGER NOT NULL	Holds Credit Card Authorization Number. Few credit cards have some extra numbers, which is required for authoization.
16	EOEC_CCI_CVNUM	Character(4)	VARCHAR2(4) NOT NULL	Card Verification Number
17	CREATEDTTM	DateTime(26)	TIMESTAMP	DateTime of Query Creation
18	LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
19	LASTUPDOPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
20	EOEC_CCI_RQSTTOKEN	Long Character(256)	VARCHAR2(256)	Request Token
21	EOEC_SUBSCRIPTION	Number(26,0)	DECIMAL(26) NOT NULL	Subscription ID