CFD_TCFDD_PRACTICE_DETAIL

Database

SDSNZS01_CFDM

Schema

CDCPADM_CFDM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 PRACTICE_ID BIGINT 8
2 PRACTICE_CODE CHARACTER VARYING(20) 20
3 PRACTICE_NAM CHARACTER VARYING(300) 300
4 PRACTICE_TYP_DESC CHARACTER VARYING(100) 100
5 PRACTICE_POSTAL_STREET_ADDR CHARACTER VARYING(300) 300
6 PRACTICE_POSTAL_SBRB_CODE CHARACTER VARYING(50) 50
7 PRACTICE_POSTAL_STATE_DESC CHARACTER VARYING(100) 100
8 PRACTICE_POSTAL_PCODE CHARACTER VARYING(20) 20
9 PRACTICE_POSTAL_CNTRY_DESC CHARACTER VARYING(100) 100
10 PRACTICE_BUS_STREET_ADDR CHARACTER VARYING(300) 300
11 PRACTICE_BUS_SBRB_CODE CHARACTER VARYING(50) 50
12 PRACTICE_BUS_STATE_DESC CHARACTER VARYING(100) 100
13 PRACTICE_BUS_PCODE CHARACTER VARYING(20) 20
14 PRACTICE_BUS_CNTRY_DESC CHARACTER VARYING(100) 100
15 PRACTICE_PH_NUM CHARACTER VARYING(50) 50
16 PRACTICE_FAX_NUM CHARACTER VARYING(50) 50
17 PRACTICE_SRVCNG_LOCN_DESC CHARACTER VARYING(300) 300
18 PRACTICE_STAT_DESC CHARACTER VARYING(300) 300
19 PRACTICE_PRIM_MGR_CODE CHARACTER VARYING(20) 20
20 PRACTICE_PRIM_MGR_NAM CHARACTER VARYING(200) 200
21 PRACTICE_PRIM_MGR_JOB_TITLE CHARACTER VARYING(100) 100
22 PRACTICE_PRIM_MGR_STAT_FLG CHARACTER VARYING(1) 1
23 EFF_STRT_DATE TIMESTAMP 8
24 EFF_END_DATE TIMESTAMP 8
25 DATA_LOAD_DATE TIMESTAMP 8
26 SNPSHT_DATE TIMESTAMP 8
27 SRC_SYS_ID CHARACTER VARYING(5) 5
28 LOAD_ID BIGINT 8
29 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
30 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
31 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
32 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8