CFD_MCFD_AGENT_HIERARCHY

Database

SDSNZS01_CFDM

Schema

CDCPADM_CFDM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 PRDT_SYS_CODE CHARACTER VARYING(10) 10
2 AGNT_CODE CHARACTER VARYING(20) 20
3 AGNT_NAM CHARACTER VARYING(100) 100
4 AGNT_TITLE CHARACTER VARYING(20) 20
5 AGNT_FRST_NAM CHARACTER VARYING(100) 100
6 AGNT_MIDDLE_NAM CHARACTER VARYING(100) 100
7 AGNT_LST_NAM CHARACTER VARYING(100) 100
8 AGNT_GNDR_IND CHARACTER VARYING(3) 3
9 AGNT_BRTH_DATE TIMESTAMP 8
10 AGNT_AGE_YRS NUMERIC(38,10) 19
11 AGNT_EMP_NUM CHARACTER VARYING(20) 20
12 ASIS_CODE CHARACTER VARYING(20) 20
13 AGNT_ABN CHARACTER VARYING(20) 20
14 AGNT_STRT_DATE TIMESTAMP 8
15 AGNT_END_DATE TIMESTAMP 8
16 AGNT_STAT_CODE CHARACTER VARYING(20) 20
17 AGNT_STAT_DESC CHARACTER VARYING(100) 100
18 ADDR_TYP_CODE CHARACTER VARYING(20) 20
19 ADDR_LNE_1 CHARACTER VARYING(100) 100
20 ADDR_LNE_2 CHARACTER VARYING(100) 100
21 ADDR_LNE_3 CHARACTER VARYING(100) 100
22 ADDR_LNE_4 CHARACTER VARYING(100) 100
23 SBRB_CODE CHARACTER VARYING(50) 50
24 PCODE CHARACTER VARYING(10) 10
25 STATE_CODE CHARACTER VARYING(50) 50
26 CNTRY_DESC CHARACTER VARYING(50) 50
27 AGNT_DISTRICT_CODE CHARACTER VARYING(20) 20
28 AGNT_HME_PH_NUM CHARACTER VARYING(20) 20
29 AGNT_WRK_PH_NUM CHARACTER VARYING(20) 20
30 AGNT_MOB_PH_NUM CHARACTER VARYING(20) 20
31 AGNT_FAX_NUM CHARACTER VARYING(20) 20
32 AGNT_EMAIL_ADDR CHARACTER VARYING(150) 150
33 AGNT_FAX_PREF_IND CHARACTER VARYING(3) 3
34 AGNT_EMAIL_PREF_IND CHARACTER VARYING(3) 3
35 AGNT_MAIL_PREF_IND CHARACTER VARYING(3) 3
36 SF_AGNT_CODE CHARACTER VARYING(20) 20
37 SF_AGNT_STAT_DESC CHARACTER VARYING(300) 300
38 SF_AGNT_NAM CHARACTER VARYING(300) 300
39 SF_AGNT_TITLE CHARACTER VARYING(50) 50
40 SF_AGNT_FRST_NAM CHARACTER VARYING(100) 100
41 SF_AGNT_LST_NAM CHARACTER VARYING(100) 100
42 SF_AGNT_GNDR_DESC CHARACTER VARYING(300) 300
43 SF_AGNT_STREET_ADDR CHARACTER VARYING(300) 300
44 SF_AGNT_SBRB_CODE CHARACTER VARYING(50) 50
45 SF_AGNT_PCODE CHARACTER VARYING(20) 20
46 SF_AGNT_STATE_DESC CHARACTER VARYING(100) 100
47 SF_AGNT_CNTRY_DESC CHARACTER VARYING(100) 100
48 SF_AGNT_REGION_DESC CHARACTER VARYING(300) 300
49 SF_AGNT_HME_PH_NUM CHARACTER VARYING(50) 50
50 SF_AGNT_WRK_PH_NUM CHARACTER VARYING(50) 50
51 SF_AGNT_MOB_PH_NUM CHARACTER VARYING(50) 50
52 SF_AGNT_FAX_NUM CHARACTER VARYING(50) 50
53 SF_AGNT_EMAIL_ADDR CHARACTER VARYING(100) 100
54 SF_AGNT_EMAIL_OPT_OUT_FLG CHARACTER VARYING(1) 1
55 SF_AGNT_FAX_OPT_OUT_FLG CHARACTER VARYING(1) 1
56 SF_AGNT_PH_OPT_OUT_FLG CHARACTER VARYING(1) 1
57 SF_AGNT_MAIL_OPT_OUT_FLG CHARACTER VARYING(1) 1
58 SF_AGNT_CLIENT_OPT_OUT_FLG CHARACTER VARYING(1) 1
59 SF_AGNT_SGMNTN_DESC CHARACTER VARYING(300) 300
60 SF_AGNT_SRVCNG_LOCN_DESC CHARACTER VARYING(300) 300
61 SF_AGNT_ADVISORY_BRD_DESC CHARACTER VARYING(100) 100
62 SF_AGNT_PRIM_MGR_CODE CHARACTER VARYING(200) 200
63 SF_AGNT_PRIM_MGR_NAM CHARACTER VARYING(200) 200
64 SF_AGNT_PRIM_MGR_JOB_TITLE CHARACTER VARYING(100) 100
65 SF_AGNT_PRIM_MGR_STAT_FLG CHARACTER VARYING(1) 1
66 PRACTICE_CODE CHARACTER VARYING(20) 20
67 PRACTICE_NAM CHARACTER VARYING(300) 300
68 PRACTICE_TYP_DESC CHARACTER VARYING(100) 100
69 PRACTICE_STREET_ADDR CHARACTER VARYING(300) 300
70 PRACTICE_SBRB_CODE CHARACTER VARYING(50) 50
71 PRACTICE_STATE_DESC CHARACTER VARYING(100) 100
72 PRACTICE_PCODE CHARACTER VARYING(20) 20
73 PRACTICE_CNTRY_DESC CHARACTER VARYING(100) 100
74 PRACTICE_PH_NUM CHARACTER VARYING(50) 50
75 PRACTICE_FAX_NUM CHARACTER VARYING(50) 50
76 PRACTICE_SRVCNG_LOCN_DESC CHARACTER VARYING(300) 300
77 PRACTICE_STAT_DESC CHARACTER VARYING(300) 300
78 PRACTICE_PRIM_MGR_CODE CHARACTER VARYING(20) 20
79 PRACTICE_PRIM_MGR_NAM CHARACTER VARYING(200) 200
80 PRACTICE_PRIM_MGR_JOB_TITLE CHARACTER VARYING(100) 100
81 PRACTICE_PRIM_MGR_STAT_FLG CHARACTER VARYING(1) 1
82 AGNT_RPTG_AGNT_CODE CHARACTER VARYING(20) 20
83 AGNT_RPTG_AGNT_NAM CHARACTER VARYING(100) 100
84 AGNT_RPTG_AGNT_ABN CHARACTER VARYING(20) 20
85 DLR_CODE CHARACTER VARYING(20) 20
86 DLR_NAM CHARACTER VARYING(100) 100
87 DLR_CHNL_CODE CHARACTER VARYING(20) 20
88 DLR_LIC_NUM CHARACTER VARYING(20) 20
89 DLR_ABN CHARACTER VARYING(20) 20
90 NMNTD_AFSL_DLR_CODE CHARACTER VARYING(20) 20
91 NMNTD_AFSL_DLR_NAM CHARACTER VARYING(100) 100
92 SNPSHT_DATE TIMESTAMP 8
93 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
94 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
95 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
96 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8