[Home] [Help] [Dependency Information]
Object Name: | HRBV_ABSENCE_ATTENDANCES_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
Absence attendance (from PER_ABSENCE_ATTENDANCES table).
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ABSENCE_DAYS | NUMBER | (9) | Duration days. | |
ABSENCE_HOURS | NUMBER | (9) | Duration hours. | |
COMMENTS | CLOB | (4000) | Comments. | |
DATE_END | DATE | Actual end date. | ||
DATE_NOTIFICATION | DATE | Notified date. | ||
DATE_PROJECTED_END | DATE | Projected end date. | ||
DATE_PROJECTED_START | DATE | Projected start date. | ||
DATE_START | DATE | Actual start date. | ||
OCCURRENCE | NUMBER | (15) | Occurrence. | |
SSP1_ISSUED | VARCHAR2 | (30) | Ssp1 issued. | |
TIME_END | VARCHAR2 | (5) | Actual end time. | |
TIME_PROJECTED_END | VARCHAR2 | (5) | Projected end time. | |
TIME_PROJECTED_START | VARCHAR2 | (5) | Projected start time. | |
TIME_START | VARCHAR2 | (5) | Actual start time. | |
PROGRAM_UPDATE_DATE | DATE | Program update date. | ||
SICKNESS_START_DATE | DATE | Sickness start date. | ||
SICKNESS_END_DATE | DATE | Sickness end date. | ||
PREGNANCY_RELATED_ILLNESS | VARCHAR2 | (30) | Pregnancy related illness. | |
REASON_FOR_NOTIFICATION_DELAY | VARCHAR2 | (2000) | Reason for notification delay. | |
ABS_INFORMATION_CATEGORY | VARCHAR2 | (30) | Abs information category. | |
ABS_INFORMATION1 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
ABS_INFORMATION2 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
ABS_INFORMATION3 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
ABS_INFORMATION4 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
ABS_INFORMATION5 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
ABS_INFORMATION6 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
ABS_INFORMATION7 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
ABS_INFORMATION8 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
ABS_INFORMATION9 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
ABS_INFORMATION10 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
ABS_INFORMATION11 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
ABS_INFORMATION12 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
ABS_INFORMATION13 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
ABS_INFORMATION14 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
ABS_INFORMATION15 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
ABS_INFORMATION16 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
ABS_INFORMATION17 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
ABS_INFORMATION18 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
ABS_INFORMATION19 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
ABS_INFORMATION20 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
ABS_INFORMATION21 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
ABS_INFORMATION22 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
ABS_INFORMATION23 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
ABS_INFORMATION24 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
ABS_INFORMATION25 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
ABS_INFORMATION26 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
ABS_INFORMATION27 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
ABS_INFORMATION28 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
ABS_INFORMATION29 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
ABS_INFORMATION30 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
_DF:ABS | CHAR | (35) | Descriptive Flexfield Column | |
ACCEPT_LATE_NOTIFICATION_FLAG | VARCHAR2 | (30) | (Lookup code based on lookup type YES_NO). | |
ACCEPT_LATE_NOTIFICATION_FLA_M | VARCHAR2 | (4000) | (Lookup meaning based on lookup type YES_NO). | |
LEGISLATION_CODE | VARCHAR2 | (4000) | Legislation code. | |
ABSENCE_ATTENDANCE_ID | NUMBER | (10) | Yes | Primary key for PER_ABSENCE_ATTENDANCES. |
BUSINESS_GROUP_ID | NUMBER | (15) | Yes | Foreign key to HR_ALL_ORGANIZATION_UNITS. |
ABSENCE_ATTENDANCE_TYPE_ID | NUMBER | (9) | Yes | Foreign key to PER_ABSENCE_ATTENDANCE_TYPES. |
ABS_ATTENDANCE_REASON_ID | NUMBER | (9) | Foreign key to PER_ABS_ATTENDANCE_REASONS. | |
PERSON_ID | NUMBER | (10) | Yes | Foreign key to PER_ALL_PEOPLE_F. |
AUTHORISING_PERSON_ID | NUMBER | (10) | Foreign key to PER_ALL_PEOPLE_F. | |
REPLACEMENT_PERSON_ID | NUMBER | (10) | Foreign key to PER_ALL_PEOPLE_F. | |
PERIOD_OF_INCAPACITY_ID | NUMBER | (9) | Period Of Incapacity Id. | |
MATERNITY_ID | NUMBER | Foreign key to SSP_MATERNITIES. | ||
LINKED_ABSENCE_ID | NUMBER | Foreign key to PER_ABSENCE_ATTENDANCES. | ||
BATCH_ID | NUMBER | (9) | Batch Id. | |
LAST_UPDATE_DATE | DATE | Standard who column | ||
LAST_UPDATED_BY | NUMBER | (15) | Standard who column | |
CREATED_BY | NUMBER | (15) | Standard who column | |
CREATION_DATE | DATE | Standard who column | ||
BG_SECURITY_FLAG_CODE | CHAR | (1) | Business group security flag code. |
Cut, paste (and edit) the following text to query this object:
SELECT ABSENCE_DAYS
, ABSENCE_HOURS
, COMMENTS
, 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
, PROGRAM_UPDATE_DATE
, SICKNESS_START_DATE
, SICKNESS_END_DATE
, PREGNANCY_RELATED_ILLNESS
, REASON_FOR_NOTIFICATION_DELAY
, 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
, _DF:ABS
, ACCEPT_LATE_NOTIFICATION_FLAG
, ACCEPT_LATE_NOTIFICATION_FLA_M
, LEGISLATION_CODE
, 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
, MATERNITY_ID
, LINKED_ABSENCE_ID
, BATCH_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATED_BY
, CREATION_DATE
, BG_SECURITY_FLAG_CODE
FROM APPS.HRBV_ABSENCE_ATTENDANCES_V;
APPS.HRBV_ABSENCE_ATTENDANCES_V is not referenced by any database object
|
|
|