[Home] [Help] [Dependency Information]
Object Name: | PER_TIME_PERIOD_TYPES |
---|---|
Object Type: | TABLE |
Owner: | HR |
FND Design Data: | PER.PER_TIME_PERIOD_TYPES |
Subobject Name: | |
Status: | VALID |
PER_TIME_PERIOD_TYPES holds the predefined list of valid period types
used to define calendars for payroll processing or HR budgets. Users
can change the names of the predefined period types, but cannot add
new period types for payroll processing.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PER_TIME_PERIOD_TYPES_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX |
PERIOD_TYPE
ZD_EDITION_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PERIOD_TYPE | VARCHAR2 | (30) | Yes | Name of the period type. |
NUMBER_PER_FISCAL_YEAR | NUMBER | (15) | Yes | Number of periods in a fiscal year. |
YEAR_TYPE_IN_NAME | VARCHAR2 | (1) | Yes | Year type. Always set to F, (Fiscal). |
DESCRIPTION | VARCHAR2 | (240) | Description and remark. | |
SYSTEM_FLAG | VARCHAR2 | (30) | Indicates whether period type is predefined data (Y/N). | |
REQUEST_ID | NUMBER | (15) | Standard Who Column. | |
PROGRAM_APPLICATION_ID | NUMBER | (15) | Standard Who column. | |
PROGRAM_ID | NUMBER | (15) | Standard Who Column. | |
PROGRAM_UPDATE_DATE | DATE | Standard Who column. | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure defining column. | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield column. | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield column. | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield column. | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield column. | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield column. | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield column. | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield column. | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield column. | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield column. | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield column. | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield column. | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield column. | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield column. | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield column. | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield column. | |
ATTRIBUTE16 | VARCHAR2 | (150) | Descriptive flexfield column. | |
ATTRIBUTE17 | VARCHAR2 | (150) | Descriptive flexfield column. | |
ATTRIBUTE18 | VARCHAR2 | (150) | Descriptive flexfield column. | |
ATTRIBUTE19 | VARCHAR2 | (150) | Descriptive flexfield column. | |
ATTRIBUTE20 | VARCHAR2 | (150) | Descriptive flexfield column. | |
LAST_UPDATE_DATE | DATE | Standard Who column. | ||
LAST_UPDATED_BY | NUMBER | (15) | Standard Who column. | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column. | |
CREATED_BY | NUMBER | (15) | Standard Who column. | |
CREATION_DATE | DATE | Standard Who column. | ||
DISPLAY_PERIOD_TYPE | VARCHAR2 | (60) | Translated name of the period type | |
ZD_EDITION_NAME | VARCHAR2 | (30) | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT PERIOD_TYPE
, NUMBER_PER_FISCAL_YEAR
, YEAR_TYPE_IN_NAME
, DESCRIPTION
, SYSTEM_FLAG
, 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
, DISPLAY_PERIOD_TYPE
, ZD_EDITION_NAME
FROM HR.PER_TIME_PERIOD_TYPES;
HR.PER_TIME_PERIOD_TYPES does not reference any database object
HR.PER_TIME_PERIOD_TYPES is referenced by following:
|
|
|