Appendix B - Data Dictionary

LOCALITY_POSTCODE

Name	Data Type	Description	Prim Key	Man	F K TABLE	F K Col	10 Char Alias
LOCALITY_POSTCODE_PID	varchar2(15)	The Persistent Identifier is unique to the real world feature this record represents.	Y	Y	-	-	LOC_PO_PID
DATE_CREATED	date	Date this record was created.	N	Y	-	-	DT_CREATE
DATE_RETIRED	date	Date this record was retired.	N	N	-	-	DT_RETIRE
LOCALITY_PID	varchar2(15)	The locality or suburb persistent identifier from the Localities product.	N	Y	localities	locality_pid	LOC_PID
POSTCODE_PID	varchar2(15)	The postcode persistent identifier.	N	Y	POSTCODE	POSTCODE_PID	PC_PID

POSTCODE

Name	Data Type	Description	Prim Key	Man	F K TABLE	F K Col	10 Char Alias
POSTCODE_PID	varchar2(15)	The Persistent Identifier is unique to the real world feature this record represents.	Y	Y	-	-	PC_PID
DATE_CREATED	date	Date this record was created.	N	Y	-	-	DT_CREATE
DATE_RETIRED	date	Date this record was retired.	N	N	-	-	DT_RETIRE
POSTCODE_CLASS_CODE	char(1)	Defines the postcode class code. Currently there is only one class code - 1 (DELIVERY AREA).	N	Y	POSTCODE_CLASS_AUT	CODE	PC_CS_CODE
POSTCODE	varchar2(4)	Postcode.	N	Y	-	-	POSTCODE
STATE_PID	varchar2(15)	State or Territory persistent identifier.	N	Y	-	-	STATE_PID

POSTCODE_POINT

Name	Data Type	Description	Prim Key	Man	F K TABLE	F K Col	10 Char Alias
POSTCODE_POINT_PID	varchar2(15)	The Persistent Identifier is unique to the real world feature this record represents.	Y	Y	-	-	PC_PNT_PID
DATE_CREATED	date	Date this record was created.	N	Y	-	-	DT_CREATE
DATE_RETIRED	date	Date this record was retired.	N	N	-	-	DT_RETIRE
POSTCODE_PID	varchar2(15)	The postcode persistent identifier.	N	Y	POSTCODE	POSTCODE_PID	PC_PID
GEOMETRY	point	Point geometry.	N	Y	-	-	GEOMETRY

POSTCODE_POLYGON

Name	Data Type	Description	Prim Key	Man	F K TABLE	F K Col	10 Char Alias
POSTCODE_POLYGON_PID	varchar2(15)	The Persistent Identifier is unique to the real world feature this record represents.	Y	Y	-	-	PC_PLY_PID
DATE_CREATED	date	Date this record was created.	N	Y	-	-	DT_CREATE
DATE_RETIRED	date	Date this record was retired.	N	N	-	-	DT_RETIRE
POSTCODE_PID	varchar2(15)	The postcode persistent identifier.	N	Y	POSTCODE	POSTCODE_PID	PC_PID
GEOMETRY	polygon	Polygon geometry.	N	Y	-	-	GEOMETRY

POSTCODE_CLASS_AUT

Name	Data Type	Description	Prim Key	Man	F K TABLE	F K Col	10 Char Alias
CODE	char(1)	Postcode class code. This is the persistent identifier of the record.	Y	Y	-	-	CODE_AUT
NAME	varchar2(50)	Name of the postcode class code (e.g. DELIVERY AREA).	N	Y	-	-	NAME_AUT
DESCRIPTION	varchar2(200)	Description of what the postcode class code represents (e.g. DELIVERY AREA FOR MAIL).	N	N	-	-	DSCPN_AUT

POSTCODE_CLASS_AUT_codes

CODE	Description	NAME
1	DELIVERY AREA FOR MAIL	DELIVERY AREA