MCFD_LIFE_POLICY_AGENT_DAILY

Database

SDSNZS01_CFDM

Schema

CDCPADM_CFDM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 AGNT_CODE CHARACTER VARYING(20) 20
2 AGNT_CHNL_CODE CHARACTER VARYING(20) 20
3 AGNT_CHNL_DESC CHARACTER VARYING(100) 100
4 AGNT_NAM CHARACTER VARYING(100) 100
5 AGNT_TITLE CHARACTER VARYING(20) 20
6 AGNT_FRST_NAM CHARACTER VARYING(100) 100
7 AGNT_MIDDLE_NAM CHARACTER VARYING(100) 100
8 AGNT_LST_NAM CHARACTER VARYING(100) 100
9 AGNT_PREF_CNTCT_NAM CHARACTER VARYING(100) 100
10 AGNT_GNDR_IND CHARACTER VARYING(3) 3
11 AGNT_BRTH_DATE DATE 4
12 AGNT_ABN CHARACTER VARYING(20) 20
13 AGNT_STRT_DATE DATE 4
14 AGNT_END_DATE DATE 4
15 AGNT_STAT_CODE CHARACTER VARYING(20) 20
16 AGNT_STAT_DESC CHARACTER VARYING(100) 100
17 ASIS_CODE CHARACTER VARYING(20) 20
18 AGNT_EMP_NUM CHARACTER VARYING(20) 20
19 AGNT_ROLE_CODE CHARACTER VARYING(20) 20
20 AGNT_ROLE_DESC CHARACTER VARYING(100) 100
21 AGNT_TYP_CODE CHARACTER VARYING(20) 20
22 AGNT_CAT_CODE CHARACTER VARYING(20) 20
23 AGNT_CAT_DESC CHARACTER VARYING(100) 100
24 AGNT_REGION_CODE CHARACTER VARYING(20) 20
25 AGNT_REGION_DESC CHARACTER VARYING(100) 100
26 AGNT_DISTRICT_CODE CHARACTER VARYING(20) 20
27 AGNT_DISTRICT_DESC CHARACTER VARYING(100) 100
28 AGNT_BUS_DIV_CODE CHARACTER VARYING(20) 20
29 AGNT_BUS_DIV_DESC CHARACTER VARYING(100) 100
30 AGNT_CLASS_CODE CHARACTER VARYING(20) 20
31 AGNT_CLASS_DESC CHARACTER VARYING(100) 100
32 AGNT_LIC_NUM CHARACTER VARYING(20) 20
33 AGNT_DSTRBTN_CHNL_CODE CHARACTER VARYING(20) 20
34 AGNT_DSTRBTN_CHNL_DESC CHARACTER VARYING(100) 100
35 AGNT_PRDT_SYS_CUST_NUM CHARACTER VARYING(20) 20
36 AGNT_FAX_PREF_IND CHARACTER VARYING(3) 3
37 AGNT_EMAIL_PREF_IND CHARACTER VARYING(3) 3
38 AGNT_MAIL_PREF_IND CHARACTER VARYING(3) 3
39 AGNT_DLR_CODE CHARACTER VARYING(20) 20
40 AGNT_DLR_NAM CHARACTER VARYING(100) 100
41 NMNTD_AFSL_DLR_CODE CHARACTER VARYING(20) 20
42 NMNTD_AFSL_DLR_NAM CHARACTER VARYING(100) 100
43 AGNT_RPTG_AGNT_CODE CHARACTER VARYING(20) 20
44 AGNT_RPTG_AGNT_NAM CHARACTER VARYING(100) 100
45 AGNT_RPTG_AGNT_ABN CHARACTER VARYING(20) 20
46 AGNT_ADDR_TYP_CODE CHARACTER VARYING(4) 4
47 AGNT_ADDR_LNE_1 CHARACTER VARYING(100) 100
48 AGNT_ADDR_LNE_2 CHARACTER VARYING(100) 100
49 AGNT_ADDR_LNE_3 CHARACTER VARYING(100) 100
50 AGNT_ADDR_LNE_4 CHARACTER VARYING(100) 100
51 AGNT_SBRB_CODE CHARACTER VARYING(50) 50
52 AGNT_PCODE CHARACTER VARYING(10) 10
53 AGNT_STATE_CODE CHARACTER VARYING(50) 50
54 AGNT_STATE_DESC CHARACTER VARYING(50) 50
55 AGNT_CNTRY_DESC CHARACTER VARYING(50) 50
56 AGNT_ASIS_ADDR_CODE CHARACTER VARYING(20) 20
57 AGNT_CRNT_ADDR_FLG CHARACTER VARYING(3) 3
58 SF_AGNT_CODE CHARACTER VARYING(20) 20
59 SF_AGNT_REGION_DESC CHARACTER VARYING(300) 300
60 SF_AGNT_STAT_DESC CHARACTER VARYING(300) 300
61 SF_AGNT_NAM CHARACTER VARYING(300) 300
62 SF_AGNT_TITLE CHARACTER VARYING(50) 50
63 SF_AGNT_FRST_NAM CHARACTER VARYING(100) 100
64 SF_AGNT_LST_NAM CHARACTER VARYING(100) 100
65 SF_AGNT_GNDR_DESC CHARACTER VARYING(300) 300
66 SF_AGNT_HME_PH_NUM CHARACTER VARYING(50) 50
67 SF_AGNT_WRK_PH_NUM CHARACTER VARYING(50) 50
68 SF_AGNT_MOB_PH_NUM CHARACTER VARYING(50) 50
69 SF_AGNT_FAX_NUM CHARACTER VARYING(50) 50
70 SF_AGNT_EMAIL_ADDR CHARACTER VARYING(100) 100
71 SF_AGNT_POSTAL_STREET_ADDR CHARACTER VARYING(300) 300
72 SF_AGNT_POSTAL_SBRB_CODE CHARACTER VARYING(50) 50
73 SF_AGNT_POSTAL_PCODE CHARACTER VARYING(20) 20
74 SF_AGNT_POSTAL_STATE_DESC CHARACTER VARYING(100) 100
75 SF_AGNT_POSTAL_CNTRY_DESC CHARACTER VARYING(100) 100
76 SF_AGNT_OTH_STREET_ADDR CHARACTER VARYING(300) 300
77 SF_AGNT_OTH_SBRB_CODE CHARACTER VARYING(50) 50
78 SF_AGNT_OTH_PCODE CHARACTER VARYING(20) 20
79 SF_AGNT_OTH_STATE_DESC CHARACTER VARYING(100) 100
80 SF_AGNT_OTH_CNTRY_DESC CHARACTER VARYING(100) 100
81 SF_AGNT_EMAIL_OPT_OUT_FLG CHARACTER VARYING(3) 3
82 SF_AGNT_FAX_OPT_OUT_FLG CHARACTER VARYING(3) 3
83 SF_AGNT_PH_OPT_OUT_FLG CHARACTER VARYING(3) 3
84 SF_AGNT_MAIL_OPT_OUT_FLG CHARACTER VARYING(3) 3
85 SF_AGNT_CLIENT_OPT_OUT_FLG CHARACTER VARYING(3) 3
86 SF_AGNT_LOYALTY_PRGRM_FLG CHARACTER VARYING(3) 3
87 SF_AGNT_SGMNTN_DESC CHARACTER VARYING(300) 300
88 SF_AGNT_SRVCNG_LOCN_DESC CHARACTER VARYING(300) 300
89 SF_AGNT_ADVISORY_BRD_DESC CHARACTER VARYING(100) 100
90 SF_AGNT_PRIM_MGR_CODE CHARACTER VARYING(20) 20
91 SF_AGNT_PRIM_MGR_NAM CHARACTER VARYING(200) 200
92 SF_AGNT_PRIM_MGR_JOB_TITLE CHARACTER VARYING(100) 100
93 SF_AGNT_PRIM_MGR_STAT_FLG CHARACTER VARYING(3) 3
94 SF_AGNT_BUS_LDR_OF_YR_DESC CHARACTER VARYING(100) 100
95 PRACTICE_CODE CHARACTER VARYING(20) 20
96 PRACTICE_NAM CHARACTER VARYING(300) 300
97 PRACTICE_TYP_DESC CHARACTER VARYING(100) 100
98 PRACTICE_POSTAL_STREET_ADDR CHARACTER VARYING(300) 300
99 PRACTICE_POSTAL_SBRB_CODE CHARACTER VARYING(50) 50
100 PRACTICE_POSTAL_STATE_DESC CHARACTER VARYING(100) 100
101 PRACTICE_POSTAL_PCODE CHARACTER VARYING(20) 20
102 PRACTICE_POSTAL_CNTRY_DESC CHARACTER VARYING(100) 100
103 PRACTICE_PH_NUM CHARACTER VARYING(50) 50
104 PRACTICE_FAX_NUM CHARACTER VARYING(50) 50
105 PRACTICE_SRVCNG_LOCN_DESC CHARACTER VARYING(300) 300
106 PRACTICE_STAT_DESC CHARACTER VARYING(300) 300
107 PRACTICE_PRIM_MGR_CODE CHARACTER VARYING(20) 20
108 PRACTICE_PRIM_MGR_NAM CHARACTER VARYING(200) 200
109 PRACTICE_PRIM_MGR_JOB_TITLE CHARACTER VARYING(100) 100
110 PRACTICE_PRIM_MGR_STAT_FLG CHARACTER VARYING(3) 3