DBA Data[Home] [Help] [Dependency Information]


TABLE: HR.PER_KR_ADDRESSES

Object Details
Object Name: PER_KR_ADDRESSES
Object Type: TABLE
Owner: HR
FND Design Data: TablePER.PER_KR_ADDRESSES
Subobject Name:
Status: VALID


PER_KR_ADDRESSES holds information provided by the Korean Ministry of Information and Communication.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Primary Key: PER_KR_ADDRESSES_PK
  1. ColumnPOSTAL_CODE_ID
Unique Key: PER_KR_ADDRESSES_UK1
  1. ColumnCITY_PROVINCE
  2. ColumnDISTRICT
  3. ColumnTOWN_VILLAGE
  4. ColumnHOUSE_NUMBER
Indexes
Index Type Uniqueness Tablespace Column
PER_KR_ADDRESSES_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnPOSTAL_CODE_ID
PER_KR_ADDRESSES_UK1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnCITY_PROVINCE
ColumnDISTRICT
ColumnTOWN_VILLAGE
ColumnHOUSE_NUMBER
Columns
Name Datatype Length Mandatory Comments
POSTAL_CODE_ID NUMBER (10) Yes Postal Code ID
POSTAL_CODE VARCHAR2 (10) Yes Postal Code
CITY_PROVINCE VARCHAR2 (20) Yes City or Province(Si/Do in Korea)
DISTRICT VARCHAR2 (30) Yes District(Gu/Gun in Korea)
TOWN_VILLAGE VARCHAR2 (100) Yes Town or Village(Dong/Eup/Myeon/Ri in Korea)
HOUSE_NUMBER VARCHAR2 (30)
Range of House Number or Specific Area(Bunji in Korea)
ENABLED_FLAG VARCHAR2 (1) Yes Enabled Flag
CREATED_BY NUMBER (15)
Standard Who Column
CREATION_DATE DATE

Standard Who Column
LAST_UPDATE_DATE DATE

Standard Who Column
LAST_UPDATED_BY NUMBER (15)
Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column
POSTAL_CODE_SEQUENCE VARCHAR2 (3)
Postal Code Sequence
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT POSTAL_CODE_ID
,      POSTAL_CODE
,      CITY_PROVINCE
,      DISTRICT
,      TOWN_VILLAGE
,      HOUSE_NUMBER
,      ENABLED_FLAG
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      POSTAL_CODE_SEQUENCE
FROM HR.PER_KR_ADDRESSES;

Dependencies

[top of page]

HR.PER_KR_ADDRESSES does not reference any database object

HR.PER_KR_ADDRESSES is referenced by following:

SchemaAPPS
SynonymPER_KR_ADDRESSES
TriggerPER_KR_ADDRESSES_WHO
SchemaPUBLIC
SynonymPER_KR_ADDRESSES