[Home] [Help] [Dependency Information]
Object Name: | PER_ABSENCE_ATTENDANCES# |
---|---|
Object Type: | VIEW |
Owner: | HR |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ABSENCE_ATTENDANCE_ID | NUMBER | (10) | Yes | |
BUSINESS_GROUP_ID | NUMBER | (15) | Yes | |
ABSENCE_ATTENDANCE_TYPE_ID | NUMBER | (9) | Yes | |
ABS_ATTENDANCE_REASON_ID | NUMBER | (9) | ||
PERSON_ID | NUMBER | (10) | Yes | |
AUTHORISING_PERSON_ID | NUMBER | (10) | ||
REPLACEMENT_PERSON_ID | NUMBER | (10) | ||
PERIOD_OF_INCAPACITY_ID | NUMBER | (9) | ||
ABSENCE_DAYS | NUMBER | (9) | ||
ABSENCE_HOURS | NUMBER | (9) | ||
DATE_END | DATE | |||
DATE_NOTIFICATION | DATE | |||
DATE_PROJECTED_END | DATE | |||
DATE_PROJECTED_START | DATE | |||
DATE_START | DATE | |||
OCCURRENCE | NUMBER | (15) | ||
SSP1_ISSUED | VARCHAR2 | (30) | ||
TIME_END | VARCHAR2 | (5) | ||
TIME_PROJECTED_END | VARCHAR2 | (5) | ||
TIME_PROJECTED_START | VARCHAR2 | (5) | ||
TIME_START | VARCHAR2 | (5) | ||
REQUEST_ID | NUMBER | (15) | ||
PROGRAM_APPLICATION_ID | NUMBER | (15) | ||
PROGRAM_ID | NUMBER | (15) | ||
PROGRAM_UPDATE_DATE | DATE | |||
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
ATTRIBUTE1 | VARCHAR2 | (150) | ||
ATTRIBUTE2 | VARCHAR2 | (150) | ||
ATTRIBUTE3 | VARCHAR2 | (150) | ||
ATTRIBUTE4 | VARCHAR2 | (150) | ||
ATTRIBUTE5 | VARCHAR2 | (150) | ||
ATTRIBUTE6 | VARCHAR2 | (150) | ||
ATTRIBUTE7 | VARCHAR2 | (150) | ||
ATTRIBUTE8 | VARCHAR2 | (150) | ||
ATTRIBUTE9 | VARCHAR2 | (150) | ||
ATTRIBUTE10 | VARCHAR2 | (150) | ||
ATTRIBUTE11 | VARCHAR2 | (150) | ||
ATTRIBUTE12 | VARCHAR2 | (150) | ||
ATTRIBUTE13 | VARCHAR2 | (150) | ||
ATTRIBUTE14 | VARCHAR2 | (150) | ||
ATTRIBUTE15 | VARCHAR2 | (150) | ||
ATTRIBUTE16 | VARCHAR2 | (150) | ||
ATTRIBUTE17 | VARCHAR2 | (150) | ||
ATTRIBUTE18 | VARCHAR2 | (150) | ||
ATTRIBUTE19 | VARCHAR2 | (150) | ||
ATTRIBUTE20 | VARCHAR2 | (150) | ||
LAST_UPDATE_DATE | DATE | |||
LAST_UPDATED_BY | NUMBER | (15) | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
CREATED_BY | NUMBER | (15) | ||
CREATION_DATE | DATE | |||
MATERNITY_ID | NUMBER | |||
SICKNESS_START_DATE | DATE | |||
SICKNESS_END_DATE | DATE | |||
PREGNANCY_RELATED_ILLNESS | VARCHAR2 | (30) | ||
REASON_FOR_NOTIFICATION_DELAY | VARCHAR2 | (2000) | ||
ACCEPT_LATE_NOTIFICATION_FLAG | VARCHAR2 | (30) | ||
LINKED_ABSENCE_ID | NUMBER | |||
BATCH_ID | NUMBER | (9) | ||
ABS_INFORMATION_CATEGORY | VARCHAR2 | (30) | ||
ABS_INFORMATION1 | VARCHAR2 | (150) | ||
ABS_INFORMATION2 | VARCHAR2 | (150) | ||
ABS_INFORMATION3 | VARCHAR2 | (150) | ||
ABS_INFORMATION4 | VARCHAR2 | (150) | ||
ABS_INFORMATION5 | VARCHAR2 | (150) | ||
ABS_INFORMATION6 | VARCHAR2 | (150) | ||
ABS_INFORMATION7 | VARCHAR2 | (150) | ||
ABS_INFORMATION8 | VARCHAR2 | (150) | ||
ABS_INFORMATION9 | VARCHAR2 | (150) | ||
ABS_INFORMATION10 | VARCHAR2 | (150) | ||
ABS_INFORMATION11 | VARCHAR2 | (150) | ||
ABS_INFORMATION12 | VARCHAR2 | (150) | ||
ABS_INFORMATION13 | VARCHAR2 | (150) | ||
ABS_INFORMATION14 | VARCHAR2 | (150) | ||
ABS_INFORMATION15 | VARCHAR2 | (150) | ||
ABS_INFORMATION16 | VARCHAR2 | (150) | ||
ABS_INFORMATION17 | VARCHAR2 | (150) | ||
ABS_INFORMATION18 | VARCHAR2 | (150) | ||
ABS_INFORMATION19 | VARCHAR2 | (150) | ||
ABS_INFORMATION20 | VARCHAR2 | (150) | ||
ABS_INFORMATION21 | VARCHAR2 | (150) | ||
ABS_INFORMATION22 | VARCHAR2 | (150) | ||
ABS_INFORMATION23 | VARCHAR2 | (150) | ||
ABS_INFORMATION24 | VARCHAR2 | (150) | ||
ABS_INFORMATION25 | VARCHAR2 | (150) | ||
ABS_INFORMATION26 | VARCHAR2 | (150) | ||
ABS_INFORMATION27 | VARCHAR2 | (150) | ||
ABS_INFORMATION28 | VARCHAR2 | (150) | ||
ABS_INFORMATION29 | VARCHAR2 | (150) | ||
ABS_INFORMATION30 | VARCHAR2 | (150) | ||
OBJECT_VERSION_NUMBER | NUMBER | (9) | ||
COMMENTS | CLOB | (4000) | ||
ABSENCE_CASE_ID | NUMBER | (10) | ||
APPROVAL_STATUS | VARCHAR2 | (30) | ||
CONFIRMED_UNTIL | DATE | |||
SOURCE | VARCHAR2 | (30) | ||
ADVANCE_PAY | VARCHAR2 | (30) |
Cut, paste (and edit) the following text to query this object:
SELECT ABSENCE_ATTENDANCE_ID
, BUSINESS_GROUP_ID
, ABSENCE_ATTENDANCE_TYPE_ID
, ABS_ATTENDANCE_REASON_ID
, PERSON_ID
, AUTHORISING_PERSON_ID
, REPLACEMENT_PERSON_ID
, PERIOD_OF_INCAPACITY_ID
, ABSENCE_DAYS
, ABSENCE_HOURS
, DATE_END
, DATE_NOTIFICATION
, DATE_PROJECTED_END
, DATE_PROJECTED_START
, DATE_START
, OCCURRENCE
, SSP1_ISSUED
, TIME_END
, TIME_PROJECTED_END
, TIME_PROJECTED_START
, TIME_START
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE16
, ATTRIBUTE17
, ATTRIBUTE18
, ATTRIBUTE19
, ATTRIBUTE20
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, MATERNITY_ID
, SICKNESS_START_DATE
, SICKNESS_END_DATE
, PREGNANCY_RELATED_ILLNESS
, REASON_FOR_NOTIFICATION_DELAY
, ACCEPT_LATE_NOTIFICATION_FLAG
, LINKED_ABSENCE_ID
, BATCH_ID
, ABS_INFORMATION_CATEGORY
, ABS_INFORMATION1
, ABS_INFORMATION2
, ABS_INFORMATION3
, ABS_INFORMATION4
, ABS_INFORMATION5
, ABS_INFORMATION6
, ABS_INFORMATION7
, ABS_INFORMATION8
, ABS_INFORMATION9
, ABS_INFORMATION10
, ABS_INFORMATION11
, ABS_INFORMATION12
, ABS_INFORMATION13
, ABS_INFORMATION14
, ABS_INFORMATION15
, ABS_INFORMATION16
, ABS_INFORMATION17
, ABS_INFORMATION18
, ABS_INFORMATION19
, ABS_INFORMATION20
, ABS_INFORMATION21
, ABS_INFORMATION22
, ABS_INFORMATION23
, ABS_INFORMATION24
, ABS_INFORMATION25
, ABS_INFORMATION26
, ABS_INFORMATION27
, ABS_INFORMATION28
, ABS_INFORMATION29
, ABS_INFORMATION30
, OBJECT_VERSION_NUMBER
, COMMENTS
, ABSENCE_CASE_ID
, APPROVAL_STATUS
, CONFIRMED_UNTIL
, SOURCE
, ADVANCE_PAY
FROM HR.PER_ABSENCE_ATTENDANCES#;
|
|
|