EX_AMEX_MNT_ERR

(SQL Table)
Index Back

Stage Maintenance Errors

Holds errors encountered in the Amex 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 AMEX_PROCESS_DT Date(10) DATE Load Date
3 AMEX_CM_ACCT_NBR Character(15) VARCHAR2(15) NOT NULL Amex Cardmember Number
4 AMX_CRDHLDR_NAME Character(50) VARCHAR2(50) NOT NULL Cardholder's Name
5 AMEX_EXPIRE_DATE Date(10) DATE Expiry Date
6 AMEX_ANNIV_DT Date(10) DATE Date Issued
7 AMEX_COST_CENTER Character(13) VARCHAR2(13) NOT NULL AMEX Cost Center
8 AMEX_STATUS_CD Character(2) VARCHAR2(2) NOT NULL Status Code
9 AMX_STATUS_DATE Date(10) DATE Amex Status Date
10 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
11 PROFILE_EXISTS Character(1) VARCHAR2(1) NOT NULL Profile Exists
12 INV_EXP_DT Character(1) VARCHAR2(1) NOT NULL Invalid Expiry Date
13 INV_BUS_UNIT Character(1) VARCHAR2(1) NOT NULL Invalid Business Unit
14 INV_CUR_CD Character(1) VARCHAR2(1) NOT NULL Invalid Currency Code
15 EX_COMP_FLAG Character(3) VARCHAR2(3) NOT NULL Complete
CMP=Complete
NCP=Not Complete

Default Value: NCP

16 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
17 AMEX_EMPID Character(11) VARCHAR2(11) NOT NULL AMEX Employee ID
18 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
19 SETID Character(5) VARCHAR2(5) NOT NULL SetID
20 CREDIT_CARD_VENDOR Character(5) VARCHAR2(5) NOT NULL Corporate Card Vendor