[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 |
Table | |
Foreign Table | Foreign Key Column | PAY_ALL_PAYROLLS_F | PER_TIME_PERIOD_TYPES | PAY_ALL_PAYROLLS_F PERIOD_TYPE | PAY_CALENDARS | PER_TIME_PERIOD_TYPES | PAY_CALENDARS ACTUAL_PERIOD_TYPE | PAY_ELE_PAYROLL_FREQ_RULES | PER_TIME_PERIOD_TYPES | PAY_ELE_PAYROLL_FREQ_RULES RESET_PERIOD_TYPE | PER_COBRA_COV_ENROLLMENTS | PER_TIME_PERIOD_TYPES | PER_COBRA_COV_ENROLLMENTS PERIOD_TYPE | PER_TIME_PERIOD_SETS | PER_TIME_PERIOD_TYPES | PER_TIME_PERIOD_SETS PERIOD_TYPE | PQH_BDGT_CMMTMNT_ELMNTS | PER_TIME_PERIOD_TYPES | PQH_BDGT_CMMTMNT_ELMNTS DFLT_ELMNT_FREQUENCY |
---|
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 |
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
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:
|
|
|