1 |
CONTROLLER |
|
PRXCTRLTAB |
|
TTYP |
0 |
0 |
|
|
2 |
LOYALTY_PROGRAMME_MEMBERSHIP |
|
LOYMSH_MSHIDQRSELBY_ID |
|
STRU |
0 |
0 |
|
|
3 |
CONTROLLER |
|
PRXCTRLTAB |
|
TTYP |
0 |
0 |
|
|
4 |
ID |
|
LOY_LOYALTY_PROG_MEMBERSHIP_ID |
|
STRU |
0 |
0 |
|
|
5 |
CONTROLLER |
|
PRXCTRLTAB |
|
TTYP |
0 |
0 |
|
|
6 |
SCHEME_ID |
|
|
|
CHAR |
60 |
0 |
|
|
7 |
SCHEME_VERSION_ID |
|
|
|
CHAR |
15 |
0 |
|
|
8 |
SCHEME_AGENCY_ID |
|
|
|
CHAR |
60 |
0 |
|
|
9 |
CONTENT |
|
LOY_LOYALTY_PROGRAMME_MEMBERSH |
|
CHAR |
40 |
0 |
Proxy Data Element (generated) |
|
10 |
CHANGE_STATE_ID |
|
LOY_CHANGE_STATE_ID |
|
CHAR |
40 |
0 |
Proxy Data Element (generated) |
|
11 |
LOYALTY_PROGRAMME_ID |
|
LOY_LOYALTY_PROGRAMME_ID |
|
STRU |
0 |
0 |
|
|
12 |
CONTROLLER |
|
PRXCTRLTAB |
|
TTYP |
0 |
0 |
|
|
13 |
SCHEME_ID |
|
|
|
CHAR |
60 |
0 |
|
|
14 |
SCHEME_VERSION_ID |
|
|
|
CHAR |
15 |
0 |
|
|
15 |
SCHEME_AGENCY_ID |
|
|
|
CHAR |
60 |
0 |
|
|
16 |
CONTENT |
|
LOY_LOYALTY_PROGRAMME_ID_CONTE |
|
CHAR |
24 |
0 |
Proxy Data Element (generated) |
|
17 |
LOYALTY_PROGRAMME_DESCRIPTION |
|
LOY_MEDIUM_NAME |
|
STRU |
0 |
0 |
|
|
18 |
CONTROLLER |
|
PRXCTRLTAB |
|
TTYP |
0 |
0 |
|
|
19 |
LANGUAGE_CODE |
|
LOY_LANGUAGE_CODE |
|
CHAR |
9 |
0 |
Proxy Data Element (generated) |
|
20 |
CONTENT |
|
LOY_MEDIUM_NAME_CONTENT |
|
CHAR |
40 |
0 |
Proxy Data Element (generated) |
|
21 |
CAMPAIGN_ID |
|
LOY_CAMPAIGN_ID1 |
|
STRU |
0 |
0 |
|
|
22 |
CONTROLLER |
|
PRXCTRLTAB |
|
TTYP |
0 |
0 |
|
|
23 |
SCHEME_ID |
|
|
|
CHAR |
60 |
0 |
|
|
24 |
SCHEME_VERSION_ID |
|
|
|
CHAR |
15 |
0 |
|
|
25 |
SCHEME_AGENCY_ID |
|
|
|
CHAR |
60 |
0 |
|
|
26 |
CONTENT |
|
LOY_CAMPAIGN_ID_CONTENT |
|
CHAR |
24 |
0 |
Proxy Data Element (generated) |
|
27 |
CAMPAIGN_DESCRIPTION |
|
LOY_MEDIUM_DESCRIPTION |
|
STRU |
0 |
0 |
|
|
28 |
CONTROLLER |
|
PRXCTRLTAB |
|
TTYP |
0 |
0 |
|
|
29 |
LANGUAGE_CODE |
|
LOY_LANGUAGE_CODE |
|
CHAR |
9 |
0 |
Proxy Data Element (generated) |
|
30 |
CONTENT |
|
LOY_MEDIUM_DESCRIPTION_CONTENT |
|
CHAR |
80 |
0 |
Proxy Data Element (generated) |
|
31 |
LOYALTY_PROGRAMME_POINT_ACCOUN |
|
LOY_LOYLTY_PROG_PTACCT_GROUPID |
|
STRU |
0 |
0 |
|
|
32 |
CONTROLLER |
|
PRXCTRLTAB |
|
TTYP |
0 |
0 |
|
|
33 |
SCHEME_ID |
|
|
|
CHAR |
60 |
0 |
|
|
34 |
SCHEME_VERSION_ID |
|
|
|
CHAR |
15 |
0 |
|
|
35 |
SCHEME_AGENCY_ID |
|
|
|
CHAR |
60 |
0 |
|
|
36 |
CONTENT |
|
LOY_LOYALTY_PROGRAMME_POINT_AC |
|
CHAR |
15 |
0 |
Proxy Data Element (generated) |
|
37 |
START_DATE |
|
LOY_DATE |
XSDDATE_D |
DATS |
8 |
0 |
Proxy Data Element (generated) |
|
38 |
END_DATE |
|
LOY_DATE |
XSDDATE_D |
DATS |
8 |
0 |
Proxy Data Element (generated) |
|
39 |
USER_STATUS |
|
LOY_USER_STATUS |
|
STRU |
0 |
0 |
|
|
40 |
CONTROLLER |
|
PRXCTRLTAB |
|
TTYP |
0 |
0 |
|
|
41 |
CODE |
|
LOY_USER_STATUS_CODE |
|
STRU |
0 |
0 |
|
|
42 |
CONTROLLER |
|
PRXCTRLTAB |
|
TTYP |
0 |
0 |
|
|
43 |
LIST_ID |
|
|
|
CHAR |
60 |
0 |
|
|
44 |
LIST_VERSION_ID |
|
|
|
CHAR |
15 |
0 |
|
|
45 |
LIST_AGENCY_ID |
|
|
|
CHAR |
60 |
0 |
|
|
46 |
LIST_AGENCY_SCHEME_ID |
|
|
|
CHAR |
60 |
0 |
|
|
47 |
LIST_AGENCY_SCHEME_AGENCY_ID |
|
LOY_AGENCY_IDENTIFICATION_CODE |
|
CHAR |
3 |
0 |
A code representation of agency responsible for a code list |
|
48 |
CONTENT |
|
LOY_USER_STATUS_CODE_CONTENT |
|
CHAR |
5 |
0 |
Proxy Data Element (generated) |
|
49 |
NAME |
|
LOY_LEN30_NAME |
|
STRU |
0 |
0 |
|
|
50 |
CONTROLLER |
|
PRXCTRLTAB |
|
TTYP |
0 |
0 |
|
|
51 |
LANGUAGE_CODE |
|
LOY_LANGUAGE_CODE |
|
CHAR |
9 |
0 |
Proxy Data Element (generated) |
|
52 |
CONTENT |
|
LOY_LEN30_NAME_CONTENT |
|
CHAR |
30 |
0 |
Proxy Data Element (generated) |
|
53 |
ORDINAL_NUMBER_VALUE |
|
LOY_ORDINAL_NUMBER_VALUE |
|
INT4 |
10 |
0 |
Proxy Data Element (generated) |
|
54 |
ACTIVE_INDICATOR |
|
LOY_INDICATOR |
XSDBOOLEAN |
CHAR |
1 |
0 |
Representation of two mutually exclusive Boolean value |
|
55 |
MEMBER_PARTY |
|
LOYMSH_LOYLTY_PROG_MBRSHP_TAB9 |
|
TTYP |
0 |
0 |
|
|
56 |
AGENT_PARTY |
|
LOYMSH_MSHIDQR_LOYPROGPARTPTY |
|
STRU |
0 |
0 |
|
|
57 |
CONTROLLER |
|
PRXCTRLTAB |
|
TTYP |
0 |
0 |
|
|
58 |
ID |
|
LOY_PARTY_ID |
|
STRU |
0 |
0 |
|
|
59 |
CONTROLLER |
|
PRXCTRLTAB |
|
TTYP |
0 |
0 |
|
|
60 |
SCHEME_ID |
|
|
|
CHAR |
60 |
0 |
|
|
61 |
SCHEME_AGENCY_ID |
|
|
|
CHAR |
60 |
0 |
|
|
62 |
SCHEME_AGENCY_SCHEME_ID |
|
|
|
CHAR |
60 |
0 |
|
|
63 |
SCHEME_AGENCY_SCHEME_AGENCY_ID |
|
LOY_AGENCY_IDENTIFICATION_CODE |
|
CHAR |
3 |
0 |
A code representation of agency responsible for a code list |
|
64 |
CONTENT |
|
LOY_PARTY_ID_CONTENT |
|
CHAR |
60 |
0 |
Proxy Data Element (generated) |
|
65 |
FORMATTED_NAME |
|
LOY_LONG_NAME |
|
STRU |
0 |
0 |
|
|
66 |
CONTROLLER |
|
PRXCTRLTAB |
|
TTYP |
0 |
0 |
|
|
67 |
LANGUAGE_CODE |
|
LOY_LANGUAGE_CODE |
|
CHAR |
9 |
0 |
Proxy Data Element (generated) |
|
68 |
CONTENT |
|
LOY_LONG_NAME_CONTENT |
|
CHAR |
80 |
0 |
Proxy Data Element (generated) |
|
69 |
TIER |
|
LOYMSH_LOYLTY_PROG_MBRSH_TAB11 |
|
TTYP |
0 |
0 |
|
|
70 |
POINT_ACCOUNT |
|
LOYMSH_LOYLTY_PROG_MBRSH_TAB10 |
|
TTYP |
0 |
0 |
|
|
71 |
LOG |
|
LOY_LOG |
|
STRU |
0 |
0 |
|
|
72 |
CONTROLLER |
|
PRXCTRLTAB |
|
TTYP |
0 |
0 |
|
|
73 |
PROCESSING_RESULT_CODE |
|
LOY_PROCESSING_RESULT_CODE |
|
CHAR |
2 |
0 |
Proxy Data Element (generated) |
|
74 |
MAXIMUM_LOG_ITEM_SEVERITY_CODE |
|
LOY_LOG_ITEM_SEVERITY_CODE |
|
CHAR |
1 |
0 |
Proxy Data Element (generated) |
|
75 |
ITEM |
|
LOY_LOG_ITEM_TAB |
|
TTYP |
0 |
0 |
|
|