[Home] [Help] [Dependency Information]
Object Name: | HRBV_ABSENCE_ATTENDANCE_TYPE_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
Absence attendance types (from PER_ABSENCE_ATTENDANCE_TYPE table).
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DATE_EFFECTIVE | DATE | Yes | Effective date from. | |
NAME | VARCHAR2 | (30) | Yes | Absence attendance type name. |
ABSENCE_CATEGORY | VARCHAR2 | (30) | (Lookup code based on lookup type ABSENCE_CATEGORY). | |
ABSENCE_CATEGORY_M | VARCHAR2 | (4000) | (Lookup meaning based on lookup type ABSENCE_CATEGORY). | |
COMMENTS | CLOB | (4000) | Comments. | |
DATE_END | DATE | Effective date to. | ||
HOURS_OR_DAYS | VARCHAR2 | (1) | (Lookup code based on lookup type HOURS_OR_DAYS). | |
HOURS_OR_DAYS_M | VARCHAR2 | (4000) | (Lookup meaning based on lookup type HOURS_OR_DAYS). | |
_DF:ABB | CHAR | (40) | Descriptive Flexfield Column | |
INCREASING_OR_DECREASING_FLAG | VARCHAR2 | (1) | (Lookup code based on lookup type INCREASING_OR_DECREASING). | |
INCREASING_OR_DECREASING_FLA_M | VARCHAR2 | (4000) | (Lookup meaning based on lookup type INCREASING_OR_DECREASING). | |
ABSENCE_ATTENDANCE_TYPE_ID | NUMBER | (9) | Yes | Primary key for PER_ABSENCE_ATTENDANCE_TYPE. |
BUSINESS_GROUP_ID | NUMBER | (15) | Foreign key to HR_ALL_ORGANIZATION_UNITS. | |
INPUT_VALUE_ID | NUMBER | (9) | Foreign key to PAY_INPUT_VALUES_F | |
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 DATE_EFFECTIVE
, NAME
, ABSENCE_CATEGORY
, ABSENCE_CATEGORY_M
, COMMENTS
, DATE_END
, HOURS_OR_DAYS
, HOURS_OR_DAYS_M
, _DF:ABB
, INCREASING_OR_DECREASING_FLAG
, INCREASING_OR_DECREASING_FLA_M
, ABSENCE_ATTENDANCE_TYPE_ID
, BUSINESS_GROUP_ID
, INPUT_VALUE_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATED_BY
, CREATION_DATE
, BG_SECURITY_FLAG_CODE
FROM APPS.HRBV_ABSENCE_ATTENDANCE_TYPE_V;
APPS.HRBV_ABSENCE_ATTENDANCE_TYPE_V is not referenced by any database object
|
|
|