CC_CARD_DATA_EX (SQL Table)	Index Back
ProCard Data Use CC_CARD_DATA_EX to identify a company credit card issued to an employee.

CC_CARD_DATA_EX

(SQL Table)

ProCard Data

Use CC_CARD_DATA_EX to identify a company credit card issued to an employee.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

2 CREDIT_CARD_VENDOR Character(5) VARCHAR2(5) NOT NULL Credit Card Vendor
Prompt Table: CC_CARD_TBL_EX
Set Control Field: BUSINESS_UNIT

3 CRDMEM_ACCT_NBR Character(44) VARCHAR2(44) NOT NULL Cardmember Number

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

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

6 EXPIRATION_DT Date(10) DATE NOT NULL Expiration Date

7 LIMIT_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Accumulation Limit Amount

8 LIMIT_TRANS_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount Limit per Transaction

9 DT_ISSUED_TO_EMPL Date(10) DATE Date Issued to Employee

10 BILL_TO Character(1) VARCHAR2(1) NOT NULL Bill To
C=Company
E=Employee

11 CC_CARD_TYPE Character(4) VARCHAR2(4) NOT NULL Credit Card Type (e.g Corporate Card, debit Card, Procurement Card, etc.)
AMEX=American Express
CORP=Corporate Card
DEBT=Debit Card
MC=MasterCard
PHON=Phone Card
PRCR=Procurement Card
VISA=Visa

12 CC_CARD_FUNCTION Character(4) VARCHAR2(4) NOT NULL Card's Charging Function
CORP=Corporate Card
DEBT=Debit Card
PHON=Phone Card
PRCR=Procurement Card

13 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Default Value: OPR_DEF_TBL_HR.BUSINESS_UNIT
Prompt Table: BUS_UNIT_TBL_HR

14 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.

15 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time

16 CC_VENDOR_CARD Character(1) VARCHAR2(1) NOT NULL Vendor Card
N=No Vendor Card
Y=Vendor Card
Default Value: N

17 CC_SECURITY_ID Number(10,0) DECIMAL(10) NOT NULL Credit Card security ID

18 CC_STATUS_DT Date(10) DATE credit card status date

19 CC_ACCT_STATUS Character(1) VARCHAR2(1) NOT NULL Credit Card account status
A=Active
I=Inactive

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	CREDIT_CARD_VENDOR	Character(5)	VARCHAR2(5) NOT NULL	Credit Card Vendor Prompt Table: CC_CARD_TBL_EX Set Control Field: BUSINESS_UNIT
3	CRDMEM_ACCT_NBR	Character(44)	VARCHAR2(44) NOT NULL	Cardmember Number
4	CR_CARD_DIGITS	Character(4)	VARCHAR2(4) NOT NULL	Card Number's Last Four Digits
5	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Prompt Table: CURRENCY_CD_TBL
6	EXPIRATION_DT	Date(10)	DATE NOT NULL	Expiration Date
7	LIMIT_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Accumulation Limit Amount
8	LIMIT_TRANS_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Amount Limit per Transaction
9	DT_ISSUED_TO_EMPL	Date(10)	DATE	Date Issued to Employee
10	BILL_TO	Character(1)	VARCHAR2(1) NOT NULL	Bill To C=Company E=Employee
11	CC_CARD_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Credit Card Type (e.g Corporate Card, debit Card, Procurement Card, etc.) AMEX=American Express CORP=Corporate Card DEBT=Debit Card MC=MasterCard PHON=Phone Card PRCR=Procurement Card VISA=Visa
12	CC_CARD_FUNCTION	Character(4)	VARCHAR2(4) NOT NULL	Card's Charging Function CORP=Corporate Card DEBT=Debit Card PHON=Phone Card PRCR=Procurement Card
13	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: OPR_DEF_TBL_HR.BUSINESS_UNIT Prompt Table: BUS_UNIT_TBL_HR
14	SYNCID	Number(10,0)	DECIMAL(10) NOT NULL	The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
15	SYNCDTTM	DateTime(26)	TIMESTAMP	Synchronization Last Update Date Time
16	CC_VENDOR_CARD	Character(1)	VARCHAR2(1) NOT NULL	Vendor Card N=No Vendor Card Y=Vendor Card Default Value: N
17	CC_SECURITY_ID	Number(10,0)	DECIMAL(10) NOT NULL	Credit Card security ID
18	CC_STATUS_DT	Date(10)	DATE	credit card status date
19	CC_ACCT_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Credit Card account status A=Active I=Inactive