EX_VISA_MNT_ERR

(SQL Table)
Index Back

Stage Maintenance Errors

Holds errors encountered in the Visa maintenance load.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 CRDMEM_ACCT_NBR Character(44) VARCHAR2(44) NOT NULL Cardmember Number
2 VS_PROCESS_DATE Date(10) DATE Visa Processing Date
3 VS_ACCT_NBR Character(19) VARCHAR2(19) NOT NULL Account Number
4 VS_CRDHLDR_NAME Character(125) VARCHAR2(125) NOT NULL Cardholder's Name
5 VS_EXPIRE_DT Date(10) DATE Visa Expiry Date
6 VS_ACCT_OPEN_DT Date(10) DATE Account Open Date
7 VS_SPEND_LMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Maximum Credit Limit
8 VS_TRANS_LIMIT Signed Number(28,3) DECIMAL(26,3) NOT NULL Limit per Transaction
9 VS_COST_CENTER Character(50) VARCHAR2(50) NOT NULL Cost Center
10 VS_EFF_DT Date(10) DATE Visa Effective Date
11 VS_STATUS_CODE Character(2) VARCHAR2(2) NOT NULL Status Code
12 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
13 PROFILE_EXISTS Character(1) VARCHAR2(1) NOT NULL Profile Exists
14 INV_EXP_DT Character(1) VARCHAR2(1) NOT NULL Invalid Expiry Date
15 INV_BUS_UNIT Character(1) VARCHAR2(1) NOT NULL Invalid Business Unit
16 INV_CUR_CD Character(1) VARCHAR2(1) NOT NULL Invalid Currency Code
17 EX_COMP_FLAG Character(3) VARCHAR2(3) NOT NULL Complete
CMP=Complete
NCP=Not Complete

Default Value: NCP

18 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
19 VS_CARDHOLDER_ID Character(20) VARCHAR2(20) NOT NULL Visa Cardholder ID
20 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
21 SETID Character(5) VARCHAR2(5) NOT NULL SetID
22 CREDIT_CARD_VENDOR Character(5) VARCHAR2(5) NOT NULL Corporate Card Vendor