CFD_TCFDD_SALES_FORCE_AGENT_DETAIL

Database

SDSNZS01_CFDM

Schema

CDCPADM_CFDM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 SF_AGNT_ID BIGINT 8
2 SF_AGNT_CODE CHARACTER VARYING(20) 20
3 SF_AGNT_REGION_DESC CHARACTER VARYING(300) 300
4 SF_AGNT_STAT_DESC CHARACTER VARYING(300) 300
5 SF_AGNT_NAM CHARACTER VARYING(300) 300
6 SF_AGNT_TITLE CHARACTER VARYING(50) 50
7 SF_AGNT_FRST_NAM CHARACTER VARYING(100) 100
8 SF_AGNT_LST_NAM CHARACTER VARYING(100) 100
9 SF_AGNT_GNDR_DESC CHARACTER VARYING(300) 300
10 SF_AGNT_HME_PH_NUM CHARACTER VARYING(50) 50
11 SF_AGNT_WRK_PH_NUM CHARACTER VARYING(50) 50
12 SF_AGNT_MOB_PH_NUM CHARACTER VARYING(50) 50
13 SF_AGNT_FAX_NUM CHARACTER VARYING(50) 50
14 SF_AGNT_EMAIL_ADDR CHARACTER VARYING(100) 100
15 SF_AGNT_POSTAL_STREET_ADDR CHARACTER VARYING(300) 300
16 SF_AGNT_POSTAL_SBRB_CODE CHARACTER VARYING(50) 50
17 SF_AGNT_POSTAL_PCODE CHARACTER VARYING(20) 20
18 SF_AGNT_POSTAL_STATE_DESC CHARACTER VARYING(100) 100
19 SF_AGNT_POSTAL_CNTRY_DESC CHARACTER VARYING(100) 100
20 SF_AGNT_OTH_STREET_ADDR CHARACTER VARYING(300) 300
21 SF_AGNT_OTH_SBRB_CODE CHARACTER VARYING(50) 50
22 SF_AGNT_OTH_PCODE CHARACTER VARYING(20) 20
23 SF_AGNT_OTH_STATE_DESC CHARACTER VARYING(100) 100
24 SF_AGNT_OTH_CNTRY_DESC CHARACTER VARYING(100) 100
25 SF_AGNT_EMAIL_OPT_OUT_FLG CHARACTER VARYING(1) 1
26 SF_AGNT_FAX_OPT_OUT_FLG CHARACTER VARYING(1) 1
27 SF_AGNT_PH_OPT_OUT_FLG CHARACTER VARYING(1) 1
28 SF_AGNT_MAIL_OPT_OUT_FLG CHARACTER VARYING(1) 1
29 SF_AGNT_CLIENT_OPT_OUT_FLG CHARACTER VARYING(1) 1
30 SF_AGNT_LOYALTY_PRGRM_FLG CHARACTER VARYING(1) 1
31 SF_AGNT_SGMNTN_DESC CHARACTER VARYING(300) 300
32 SF_AGNT_SRVCNG_LOCN_DESC CHARACTER VARYING(300) 300
33 SF_AGNT_ADVISORY_BRD_DESC CHARACTER VARYING(100) 100
34 PRACTICE_ID BIGINT 8
35 PRACTICE_CODE CHARACTER VARYING(20) 20
36 SF_AGNT_PRIM_MGR_CODE CHARACTER VARYING(20) 20
37 SF_AGNT_PRIM_MGR_NAM CHARACTER VARYING(200) 200
38 SF_AGNT_PRIM_MGR_JOB_TITLE CHARACTER VARYING(100) 100
39 SF_AGNT_PRIM_MGR_STAT_FLG CHARACTER VARYING(1) 1
40 SF_AGNT_BUS_LDR_OF_YR_DESC CHARACTER VARYING(100) 100
41 EFF_STRT_DATE TIMESTAMP 8
42 EFF_END_DATE TIMESTAMP 8
43 DATA_LOAD_DATE TIMESTAMP 8
44 SNPSHT_DATE TIMESTAMP 8
45 SRC_SYS_ID CHARACTER VARYING(5) 5
46 LOAD_ID BIGINT 8
47 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
48 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
49 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
50 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8