[Home] [Help] [Dependency Information]
Object Name: | PER_KR_ASSIGNMENT_YEA_INFO# |
---|---|
Object Type: | VIEW |
Owner: | HR |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ASSIGNMENT_YEA_INFO_ID | NUMBER | (15) | Yes | |
ASSIGNMENT_ID | NUMBER | (10) | Yes | |
INFORMATION_TYPE | VARCHAR2 | (40) | Yes | |
TARGET_YEAR | NUMBER | (4) | ||
AYI_INFORMATION_CATEGORY | VARCHAR2 | (30) | ||
AYI_INFORMATION1 | VARCHAR2 | (150) | ||
AYI_INFORMATION2 | VARCHAR2 | (150) | ||
AYI_INFORMATION3 | VARCHAR2 | (150) | ||
AYI_INFORMATION4 | VARCHAR2 | (150) | ||
AYI_INFORMATION5 | VARCHAR2 | (150) | ||
AYI_INFORMATION6 | VARCHAR2 | (150) | ||
AYI_INFORMATION7 | VARCHAR2 | (150) | ||
AYI_INFORMATION8 | VARCHAR2 | (150) | ||
AYI_INFORMATION9 | VARCHAR2 | (150) | ||
AYI_INFORMATION10 | VARCHAR2 | (150) | ||
AYI_INFORMATION11 | VARCHAR2 | (150) | ||
AYI_INFORMATION12 | VARCHAR2 | (150) | ||
AYI_INFORMATION13 | VARCHAR2 | (150) | ||
AYI_INFORMATION14 | VARCHAR2 | (150) | ||
AYI_INFORMATION15 | VARCHAR2 | (150) | ||
AYI_INFORMATION16 | VARCHAR2 | (150) | ||
AYI_INFORMATION17 | VARCHAR2 | (150) | ||
AYI_INFORMATION18 | VARCHAR2 | (150) | ||
AYI_INFORMATION19 | VARCHAR2 | (150) | ||
AYI_INFORMATION20 | VARCHAR2 | (150) | ||
AYI_INFORMATION21 | VARCHAR2 | (150) | ||
AYI_INFORMATION22 | VARCHAR2 | (150) | ||
AYI_INFORMATION23 | VARCHAR2 | (150) | ||
AYI_INFORMATION24 | VARCHAR2 | (150) | ||
AYI_INFORMATION25 | VARCHAR2 | (150) | ||
AYI_INFORMATION26 | VARCHAR2 | (150) | ||
AYI_INFORMATION27 | VARCHAR2 | (150) | ||
AYI_INFORMATION28 | VARCHAR2 | (150) | ||
AYI_INFORMATION29 | VARCHAR2 | (150) | ||
AYI_INFORMATION30 | VARCHAR2 | (150) | ||
AYI_INFORMATION31 | VARCHAR2 | (150) | ||
AYI_INFORMATION32 | VARCHAR2 | (150) | ||
AYI_INFORMATION33 | VARCHAR2 | (150) | ||
AYI_INFORMATION34 | VARCHAR2 | (150) | ||
AYI_INFORMATION35 | VARCHAR2 | (150) | ||
LAST_UPDATE_DATE | DATE | |||
OBJECT_VERSION_NUMBER | NUMBER | (9) | ||
LAST_UPDATED_BY | NUMBER | (15) | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
CREATED_BY | NUMBER | (15) | ||
CREATION_DATE | DATE |
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#;
|
|
|