eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: HR.PER_KR_ASSIGNMENT_YEA_INFO

Object Details

Object Name:	PER_KR_ASSIGNMENT_YEA_INFO
Object Type:	TABLE
Owner:	HR
Subobject Name:
Status:	VALID

This table stores the information entered from Korean Self-Service YEA Entry page.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PER_KR_ASSIGNMENT_YEA_INFO_UK	NORMAL	UNIQUE	APPS_TS_TX_IDX	ASSIGNMENT_YEA_INFO_ID
PER_KR_ASSIGNMENT_YEA_INFO_N50	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ASSIGNMENT_ID INFORMATION_TYPE TARGET_YEAR

Columns

Name	Datatype	Length	Mandatory	Comments
ASSIGNMENT_YEA_INFO_ID	NUMBER	(15)	Yes	This is the key column
ASSIGNMENT_ID	NUMBER	(10)	Yes	Assignment Id
INFORMATION_TYPE	VARCHAR2	(40)	Yes	Information Type should be one of the information types defined for Assignment Extra Information for Korea legislation
TARGET_YEAR	NUMBER	(4)		Target Year for YEA
AYI_INFORMATION_CATEGORY	VARCHAR2	(30)		Same as Information Type
AYI_INFORMATION1	VARCHAR2	(150)		AYI_INFORMATION1
AYI_INFORMATION2	VARCHAR2	(150)		AYI_INFORMATION2
AYI_INFORMATION3	VARCHAR2	(150)		AYI_INFORMATION3
AYI_INFORMATION4	VARCHAR2	(150)		AYI_INFORMATION4
AYI_INFORMATION5	VARCHAR2	(150)		AYI_INFORMATION5
AYI_INFORMATION6	VARCHAR2	(150)		AYI_INFORMATION6
AYI_INFORMATION7	VARCHAR2	(150)		AYI_INFORMATION7
AYI_INFORMATION8	VARCHAR2	(150)		AYI_INFORMATION8
AYI_INFORMATION9	VARCHAR2	(150)		AYI_INFORMATION9
AYI_INFORMATION10	VARCHAR2	(150)		AYI_INFORMATION10
AYI_INFORMATION11	VARCHAR2	(150)		AYI_INFORMATION11
AYI_INFORMATION12	VARCHAR2	(150)		AYI_INFORMATION12
AYI_INFORMATION13	VARCHAR2	(150)		AYI_INFORMATION13
AYI_INFORMATION14	VARCHAR2	(150)		AYI_INFORMATION14
AYI_INFORMATION15	VARCHAR2	(150)		AYI_INFORMATION15
AYI_INFORMATION16	VARCHAR2	(150)		AYI_INFORMATION16
AYI_INFORMATION17	VARCHAR2	(150)		AYI_INFORMATION17
AYI_INFORMATION18	VARCHAR2	(150)		AYI_INFORMATION18
AYI_INFORMATION19	VARCHAR2	(150)		AYI_INFORMATION19
AYI_INFORMATION20	VARCHAR2	(150)		AYI_INFORMATION20
AYI_INFORMATION21	VARCHAR2	(150)		AYI_INFORMATION21
AYI_INFORMATION22	VARCHAR2	(150)		AYI_INFORMATION22
AYI_INFORMATION23	VARCHAR2	(150)		AYI_INFORMATION23
AYI_INFORMATION24	VARCHAR2	(150)		AYI_INFORMATION24
AYI_INFORMATION25	VARCHAR2	(150)		AYI_INFORMATION25
AYI_INFORMATION26	VARCHAR2	(150)		AYI_INFORMATION26
AYI_INFORMATION27	VARCHAR2	(150)		AYI_INFORMATION27
AYI_INFORMATION28	VARCHAR2	(150)		AYI_INFORMATION28
AYI_INFORMATION29	VARCHAR2	(150)		AYI_INFORMATION29
AYI_INFORMATION30	VARCHAR2	(150)		AYI_INFORMATION30
AYI_INFORMATION31	VARCHAR2	(150)		AYI_INFORMATION31
AYI_INFORMATION32	VARCHAR2	(150)		AYI_INFORMATION32
AYI_INFORMATION33	VARCHAR2	(150)		AYI_INFORMATION33
AYI_INFORMATION34	VARCHAR2	(150)		AYI_INFORMATION34
AYI_INFORMATION35	VARCHAR2	(150)		AYI_INFORMATION35
LAST_UPDATE_DATE	DATE			Last Update Date
OBJECT_VERSION_NUMBER	NUMBER	(9)		Object Version Number
LAST_UPDATED_BY	NUMBER	(15)		Last Updated By
LAST_UPDATE_LOGIN	NUMBER	(15)		Last Update Login
CREATED_BY	NUMBER	(15)		Created By
CREATION_DATE	DATE			Creation Date

Query Text

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


SELECT ASSIGNMENT_YEA_INFO_ID
,      ASSIGNMENT_ID
,      INFORMATION_TYPE
,      TARGET_YEAR
,      AYI_INFORMATION_CATEGORY
,      AYI_INFORMATION1
,      AYI_INFORMATION2
,      AYI_INFORMATION3
,      AYI_INFORMATION4
,      AYI_INFORMATION5
,      AYI_INFORMATION6
,      AYI_INFORMATION7
,      AYI_INFORMATION8
,      AYI_INFORMATION9
,      AYI_INFORMATION10
,      AYI_INFORMATION11
,      AYI_INFORMATION12
,      AYI_INFORMATION13
,      AYI_INFORMATION14
,      AYI_INFORMATION15
,      AYI_INFORMATION16
,      AYI_INFORMATION17
,      AYI_INFORMATION18
,      AYI_INFORMATION19
,      AYI_INFORMATION20
,      AYI_INFORMATION21
,      AYI_INFORMATION22
,      AYI_INFORMATION23
,      AYI_INFORMATION24
,      AYI_INFORMATION25
,      AYI_INFORMATION26
,      AYI_INFORMATION27
,      AYI_INFORMATION28
,      AYI_INFORMATION29
,      AYI_INFORMATION30
,      AYI_INFORMATION31
,      AYI_INFORMATION32
,      AYI_INFORMATION33
,      AYI_INFORMATION34
,      AYI_INFORMATION35
,      LAST_UPDATE_DATE
,      OBJECT_VERSION_NUMBER
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
FROM HR.PER_KR_ASSIGNMENT_YEA_INFO;

Dependencies

[top of page]

HR.PER_KR_ASSIGNMENT_YEA_INFO does not reference any database object

HR.PER_KR_ASSIGNMENT_YEA_INFO is referenced by following:

APPS: PER_KR_ASSIGNMENT_YEA_INFO; PER_KR_ASSIGNMENT_YEA_INFO_WHO
PUBLIC: PER_KR_ASSIGNMENT_YEA_INFO