ADDRESS

⚠️ Auto-generated — do not edit this file directly. Re-run python scripts/generate_docs.py to refresh it.

Info

Property	Value
Source	CEGID
Database	RESILIANS_CEGID_DB
Schema	STG_DBO
Layer	🪙 Staging
Type	BASE TABLE
Rows	668,406
Columns	22

Columns

#	Column	Type	Nullable	Default	Description
1	_FIVETRAN_SYNCED	TIMESTAMP_TZ	✅	—	—
2	NOTE_ID	TEXT	✅	—	—
3	ADDRESS_TYPE	TEXT	✅	—	—
4	CITY	TEXT	✅	—	—
5	BACCOUNT_ID	NUMBER	✅	—	—
6	CREATED_BY_SCREEN_ID	TEXT	✅	—	—
7	ADDRESS_ID	NUMBER	✅	—	—
8	_FIVETRAN_DELETED	BOOLEAN	✅	—	—
9	DISPLAY_NAME	TEXT	✅	—	—
10	LAST_MODIFIED_BY_SCREEN_ID	TEXT	✅	—	—
11	CREATED_DATE_TIME	TIMESTAMP_TZ	✅	—	—
12	TSTAMP	TEXT	✅	—	—
13	PSEUDONYMIZATION_STATUS	NUMBER	✅	—	—
14	LAST_MODIFIED_BY_ID	TEXT	✅	—	—
15	ADDRESS_LINE_1	TEXT	✅	—	—
16	STATE	TEXT	✅	—	—
17	ADDRESS_LINE_2	TEXT	✅	—	—
18	CREATED_BY_ID	TEXT	✅	—	—
19	POSTAL_CODE	TEXT	✅	—	—
20	LAST_MODIFIED_DATE_TIME	TIMESTAMP_TZ	✅	—	—
21	COUNTRY_ID	TEXT	✅	—	—
22	REVISION_ID	NUMBER	✅	—	—