EOEC_CCI_TYPE (SQL Table)	Index Back
Credit Card Types This record contains the valid prefixes of credit cards for error checking before sending to CyberSource or other vendors.

EOEC_CCI_TYPE

(SQL Table)

Credit Card Types

This record contains the valid prefixes of credit cards for error checking before sending to CyberSource or other vendors.

Related Language Record: EOEC_CCI_TP_LNG

# 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_NAME Character(32) VARCHAR2(32) NOT NULL Use in the Credit Card Number Capture Process

3 EOEC_CCI_LENGTH Number(3,0) SMALLINT NOT NULL Use in the Credit Card Number Capture Process

4 EOEC_CCI_TYPESTAT Character(1) VARCHAR2(1) NOT NULL Use in the Credit Card Number Capture Process
A=Active Credit Card
I=Inactive Credit Card
Default Value: I

5 EOEC_CCI_PREFIX Character(60) VARCHAR2(60) NOT NULL Use in the Credit Card Number Capture Process

6 EOEC_CCI_CHKDIGIT Character(1) VARCHAR2(1) NOT NULL Use Check Digit Algorithm
N=No
Y=Yes
Default Value: N

7 EOEC_CCI_EXPDAYS Signed Number(4,0) DECIMAL(3) NOT NULL Use in the Credit Card Number Capture Process

8 CREATEDTTM DateTime(26) TIMESTAMP DateTime of Query Creation

9 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.

10 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.

#	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_NAME	Character(32)	VARCHAR2(32) NOT NULL	Use in the Credit Card Number Capture Process
3	EOEC_CCI_LENGTH	Number(3,0)	SMALLINT NOT NULL	Use in the Credit Card Number Capture Process
4	EOEC_CCI_TYPESTAT	Character(1)	VARCHAR2(1) NOT NULL	Use in the Credit Card Number Capture Process A=Active Credit Card I=Inactive Credit Card Default Value: I
5	EOEC_CCI_PREFIX	Character(60)	VARCHAR2(60) NOT NULL	Use in the Credit Card Number Capture Process
6	EOEC_CCI_CHKDIGIT	Character(1)	VARCHAR2(1) NOT NULL	Use Check Digit Algorithm N=No Y=Yes Default Value: N
7	EOEC_CCI_EXPDAYS	Signed Number(4,0)	DECIMAL(3) NOT NULL	Use in the Credit Card Number Capture Process
8	CREATEDTTM	DateTime(26)	TIMESTAMP	DateTime of Query Creation
9	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.
10	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.