CFD_MCFD_AGENT_DETAIL

Database

SDSNZS01_CFDM

Schema

CDCPADM_CFDM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 AGNT_DETL_ID BIGINT 8
2 PRDT_SYS_CODE CHARACTER VARYING(10) 10
3 AGNT_ID BIGINT 8
4 AGNT_CODE CHARACTER VARYING(20) 20
5 AGNT_CHNL_ID BIGINT 8
6 AGNT_CHNL_CODE CHARACTER VARYING(20) 20
7 AGNT_NAM CHARACTER VARYING(100) 100
8 AGNT_TITLE CHARACTER VARYING(20) 20
9 AGNT_FRST_NAM CHARACTER VARYING(100) 100
10 AGNT_MIDDLE_NAM CHARACTER VARYING(100) 100
11 AGNT_LST_NAM CHARACTER VARYING(100) 100
12 AGNT_PREF_CNTCT_NAM CHARACTER VARYING(100) 100
13 AGNT_GNDR_IND CHARACTER VARYING(3) 3
14 AGNT_BRTH_DATE TIMESTAMP 8
15 AGNT_ABN CHARACTER VARYING(20) 20
16 AGNT_STRT_DATE TIMESTAMP 8
17 AGNT_END_DATE TIMESTAMP 8
18 AGNT_STAT_ID BIGINT 8
19 AGNT_STAT_CODE CHARACTER VARYING(20) 20
20 ASIS_CODE CHARACTER VARYING(20) 20
21 AGNT_EMP_NUM CHARACTER VARYING(20) 20
22 AGNT_ROLE_ID BIGINT 8
23 AGNT_ROLE_CODE CHARACTER VARYING(20) 20
24 AGNT_CAT_ID BIGINT 8
25 AGNT_CAT_CODE CHARACTER VARYING(20) 20
26 AGNT_TYP_CODE CHARACTER VARYING(20) 20
27 AGNT_REGION_ID BIGINT 8
28 AGNT_REGION_CODE CHARACTER VARYING(20) 20
29 AGNT_DISTRICT_ID BIGINT 8
30 AGNT_DISTRICT_CODE CHARACTER VARYING(20) 20
31 AGNT_BUS_DIV_ID BIGINT 8
32 AGNT_BUS_DIV_CODE CHARACTER VARYING(20) 20
33 AGNT_STATE_ID BIGINT 8
34 AGNT_STATE_CODE CHARACTER VARYING(20) 20
35 AGNT_CLASS_ID BIGINT 8
36 AGNT_CLASS_CODE CHARACTER VARYING(20) 20
37 AGNT_LIC_NUM CHARACTER VARYING(20) 20
38 AGNT_DSTRBTN_CHNL_ID BIGINT 8
39 AGNT_DSTRBTN_CHNL_CODE CHARACTER VARYING(20) 20
40 AGNT_PRDT_SYS_CUST_NUM CHARACTER VARYING(20) 20
41 AGNT_FAX_PREF_IND CHARACTER VARYING(3) 3
42 AGNT_EMAIL_PREF_IND CHARACTER VARYING(3) 3
43 AGNT_MAIL_PREF_IND CHARACTER VARYING(3) 3
44 AGNT_DLR_ID BIGINT 8
45 AGNT_DLR_CODE CHARACTER VARYING(20) 20
46 AGNT_RPTG_AGNT_CODE CHARACTER VARYING(20) 20
47 AGNT_RPTG_AGNT_NAM CHARACTER VARYING(100) 100
48 AGNT_RPTG_AGNT_ABN CHARACTER VARYING(20) 20
49 EFF_STRT_DATE TIMESTAMP 8
50 EFF_END_DATE TIMESTAMP 8
51 DATA_LOAD_DATE TIMESTAMP 8
52 AGNT_TYP CHARACTER VARYING(5) 5
53 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
54 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
55 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
56 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8