OEB_IBY_CREDITCARD

Database

SDSNZS01_R12

Schema

CDCPADM_R12

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 INSTRID BIGINT 8
2 EXPIRYDATE TIMESTAMP 8
3 ACCTTYPEID BIGINT 8
4 ADDRESSID BIGINT 8
5 INSTRNAME CHARACTER VARYING(80) 80
6 DESCRIPTION CHARACTER VARYING(240) 240
7 CHNAME CHARACTER VARYING(80) 80
8 FINAME CHARACTER VARYING(80) 80
9 LAST_UPDATE_DATE TIMESTAMP 8
10 SUBTYPE CHARACTER VARYING(80) 80
11 LAST_UPDATED_BY BIGINT 8
12 CREATION_DATE TIMESTAMP 8
13 CREATED_BY BIGINT 8
14 LAST_UPDATE_LOGIN BIGINT 8
15 OBJECT_VERSION_NUMBER BIGINT 8
16 SECURITY_GROUP_ID BIGINT 8
17 ENCRYPTED CHARACTER VARYING(1) 1
18 CARD_OWNER_ID BIGINT 8
19 BILLING_ADDR_POSTAL_CODE CHARACTER VARYING(50) 50
20 BILL_ADDR_TERRITORY_CODE CHARACTER VARYING(2) 2
21 MASKED_CC_NUMBER CHARACTER VARYING(30) 30
22 CARD_MASK_SETTING CHARACTER VARYING(30) 30
23 CARD_UNMASK_LENGTH BIGINT 8
24 CC_NUMBER_HASH1 CHARACTER VARYING(64) 64
25 CC_NUMBER_HASH2 CHARACTER VARYING(64) 64
26 SALT_VERSION BIGINT 8
27 INSTRUMENT_TYPE CHARACTER VARYING(30) 30
28 PURCHASECARD_FLAG CHARACTER VARYING(1) 1
29 PURCHASECARD_SUBTYPE CHARACTER VARYING(30) 30
30 CARD_ISSUER_CODE CHARACTER VARYING(30) 30
31 CC_ISSUER_RANGE_ID BIGINT 8
32 CC_NUMBER_LENGTH BIGINT 8
33 ACTIVE_FLAG CHARACTER VARYING(1) 1
34 SINGLE_USE_FLAG CHARACTER VARYING(1) 1
35 INFORMATION_ONLY_FLAG CHARACTER VARYING(1) 1
36 CARD_PURPOSE CHARACTER VARYING(30) 30
37 INACTIVE_DATE TIMESTAMP 8
38 CC_NUM_SEC_SEGMENT_ID BIGINT 8
39 ATTRIBUTE_CATEGORY CHARACTER VARYING(150) 150
40 ATTRIBUTE1 CHARACTER VARYING(150) 150
41 ATTRIBUTE2 CHARACTER VARYING(150) 150
42 ATTRIBUTE3 CHARACTER VARYING(150) 150
43 ATTRIBUTE4 CHARACTER VARYING(150) 150
44 ATTRIBUTE5 CHARACTER VARYING(150) 150
45 ATTRIBUTE6 CHARACTER VARYING(150) 150
46 ATTRIBUTE7 CHARACTER VARYING(150) 150
47 ATTRIBUTE8 CHARACTER VARYING(150) 150
48 ATTRIBUTE9 CHARACTER VARYING(150) 150
49 ATTRIBUTE10 CHARACTER VARYING(150) 150
50 ATTRIBUTE11 CHARACTER VARYING(150) 150
51 ATTRIBUTE12 CHARACTER VARYING(150) 150
52 ATTRIBUTE13 CHARACTER VARYING(150) 150
53 ATTRIBUTE14 CHARACTER VARYING(150) 150
54 ATTRIBUTE15 CHARACTER VARYING(150) 150
55 ATTRIBUTE16 CHARACTER VARYING(150) 150
56 ATTRIBUTE17 CHARACTER VARYING(150) 150
57 ATTRIBUTE18 CHARACTER VARYING(150) 150
58 ATTRIBUTE19 CHARACTER VARYING(150) 150
59 ATTRIBUTE20 CHARACTER VARYING(150) 150
60 ATTRIBUTE21 CHARACTER VARYING(150) 150
61 ATTRIBUTE22 CHARACTER VARYING(150) 150
62 ATTRIBUTE23 CHARACTER VARYING(150) 150
63 ATTRIBUTE24 CHARACTER VARYING(150) 150
64 ATTRIBUTE25 CHARACTER VARYING(150) 150
65 ATTRIBUTE26 CHARACTER VARYING(150) 150
66 ATTRIBUTE27 CHARACTER VARYING(150) 150
67 ATTRIBUTE28 CHARACTER VARYING(150) 150
68 ATTRIBUTE29 CHARACTER VARYING(150) 150
69 ATTRIBUTE30 CHARACTER VARYING(150) 150
70 REQUEST_ID BIGINT 8
71 PROGRAM_APPLICATION_ID BIGINT 8
72 PROGRAM_ID BIGINT 8
73 PROGRAM_UPDATE_DATE TIMESTAMP 8
74 UPGRADE_ADDRESSID BIGINT 8
75 SEC_SUBKEY_ID BIGINT 8
76 EXPIRY_SEC_SEGMENT_ID BIGINT 8
77 CHNAME_SEC_SEGMENT_ID BIGINT 8
78 EXPIRED_FLAG CHARACTER VARYING(1) 1
79 CHNAME_MASK_SETTING CHARACTER VARYING(30) 30
80 CHNAME_UNMASK_LENGTH BIGINT 8
81 INVALID_FLAG CHARACTER VARYING(1) 1
82 INVALIDATION_REASON CHARACTER VARYING(100) 100
83 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
84 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
85 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
86 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8