[Home] [Help] [Dependency Information]
Object Name: | PAY_TIME_DEFINITIONS# |
---|---|
Object Type: | VIEW |
Owner: | HR |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TIME_DEFINITION_ID | NUMBER | (9) | Yes | |
SHORT_NAME | VARCHAR2 | (30) | Yes | |
DEFINITION_NAME | VARCHAR2 | (80) | Yes | |
PERIOD_TYPE | VARCHAR2 | (30) | ||
PERIOD_UNIT | VARCHAR2 | (30) | ||
DAY_ADJUSTMENT | VARCHAR2 | (30) | ||
DYNAMIC_CODE | VARCHAR2 | (61) | ||
BUSINESS_GROUP_ID | NUMBER | (15) | ||
LEGISLATION_CODE | VARCHAR2 | (30) | ||
DEFINITION_TYPE | VARCHAR2 | (30) | ||
NUMBER_OF_YEARS | NUMBER | (9) | ||
START_DATE | DATE | |||
PERIOD_TIME_DEFINITION_ID | NUMBER | (9) | ||
CREATOR_ID | NUMBER | (9) | ||
CREATOR_TYPE | VARCHAR2 | (30) | ||
OBJECT_VERSION_NUMBER | NUMBER | (9) | ||
ZD_EDITION_NAME | VARCHAR2 | (30) | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT TIME_DEFINITION_ID
, SHORT_NAME
, DEFINITION_NAME
, PERIOD_TYPE
, PERIOD_UNIT
, DAY_ADJUSTMENT
, DYNAMIC_CODE
, BUSINESS_GROUP_ID
, LEGISLATION_CODE
, DEFINITION_TYPE
, NUMBER_OF_YEARS
, START_DATE
, PERIOD_TIME_DEFINITION_ID
, CREATOR_ID
, CREATOR_TYPE
, OBJECT_VERSION_NUMBER
, ZD_EDITION_NAME
FROM HR.PAY_TIME_DEFINITIONS#;
|
|
|