[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | PA_PROJ_PERIOD_PROFILES |
|---|---|
| Object Type: | TABLE |
| Owner: | PA |
| FND Design Data: |  PA.PA_PROJ_PERIOD_PROFILES
|
| Subobject Name: | |
| Status: | VALID |
This table stores the period profile information that is used for reporting purposes. The purpose of this table is to hold 52 period buckets that indicate the periods and their corresponding start and end dates for which values can be displayed in a matrix format. Users can set up period profiles for each project
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| PA_PROJ_PERIOD_PROFILES_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 PERIOD_PROFILE_ID
|
| PA_PROJ_PERIOD_PROFILES_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
PROJECT_ID
PERIOD_PROFILE_TYPE
PLAN_PERIOD_TYPE
GL_PERIOD_TYPE
PERIOD_SET_NAME
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| PERIOD_PROFILE_ID | NUMBER | (15) | Yes | The system generated number that uniquely identifies the period profile |
| PERIOD_PROFILE_TYPE | VARCHAR2 | (30) | Yes | Stores the type of the Period Profile. Currently, the profile type is used only for Financial Planning purposes |
| PROJECT_ID | NUMBER | (15) | Yes | Identifier of the project for which the period profile has been set up |
| PERIOD_SET_NAME | VARCHAR2 | (15) | Yes | Stores the Period Set Name for the Operating Unit |
| GL_PERIOD_TYPE | VARCHAR2 | (15) | Yes | Stores the GL Period Type |
| PLAN_PERIOD_TYPE | VARCHAR2 | (30) | Yes | Indicates the Period type. Period_name1 to Period_name52 will hold the PA or GL period names based on the value in this column. |
| NUMBER_OF_PERIODS | NUMBER | (15) | Indicates the number of periods in the profile. | |
| PERIOD_NAME1 | VARCHAR2 | (30) | Stores the Period Name | |
| PERIOD_NAME2 | VARCHAR2 | (30) | Stores the Period Name | |
| PERIOD_NAME3 | VARCHAR2 | (30) | Stores the Period Name | |
| PERIOD_NAME4 | VARCHAR2 | (30) | Stores the Period Name | |
| PERIOD_NAME5 | VARCHAR2 | (30) | Stores the Period Name | |
| PERIOD_NAME6 | VARCHAR2 | (30) | Stores the Period Name | |
| PERIOD_NAME7 | VARCHAR2 | (30) | Stores the Period Name | |
| PERIOD_NAME8 | VARCHAR2 | (30) | Stores the Period Name | |
| PERIOD_NAME9 | VARCHAR2 | (30) | Stores the Period Name | |
| PERIOD_NAME10 | VARCHAR2 | (30) | Stores the Period Name | |
| PERIOD_NAME11 | VARCHAR2 | (30) | Stores the Period Name | |
| PERIOD_NAME12 | VARCHAR2 | (30) | Stores the Period Name | |
| PERIOD_NAME13 | VARCHAR2 | (30) | Stores the Period Name | |
| PERIOD_NAME14 | VARCHAR2 | (30) | Stores the Period Name | |
| PERIOD_NAME15 | VARCHAR2 | (30) | Stores the Period Name | |
| PERIOD_NAME16 | VARCHAR2 | (30) | Stores the Period Name | |
| PERIOD_NAME17 | VARCHAR2 | (30) | Stores the Period Name | |
| PERIOD_NAME18 | VARCHAR2 | (30) | Stores the Period Name | |
| PERIOD_NAME19 | VARCHAR2 | (30) | Stores the Period Name | |
| PERIOD_NAME20 | VARCHAR2 | (30) | Stores the Period Name | |
| PERIOD_NAME21 | VARCHAR2 | (30) | Stores the Period Name | |
| PERIOD_NAME22 | VARCHAR2 | (30) | Stores the Period Name | |
| PERIOD_NAME23 | VARCHAR2 | (30) | Stores the Period Name | |
| PERIOD_NAME24 | VARCHAR2 | (30) | Stores the Period Name | |
| PERIOD_NAME25 | VARCHAR2 | (30) | Stores the Period Name | |
| PERIOD_NAME26 | VARCHAR2 | (30) | Stores the Period Name | |
| PERIOD_NAME27 | VARCHAR2 | (30) | Stores the Period Name | |
| PERIOD_NAME28 | VARCHAR2 | (30) | Stores the Period Name | |
| PERIOD_NAME29 | VARCHAR2 | (30) | Stores the Period Name | |
| PERIOD_NAME30 | VARCHAR2 | (30) | Stores the Period Name | |
| PERIOD_NAME31 | VARCHAR2 | (30) | Stores the Period Name | |
| PERIOD_NAME32 | VARCHAR2 | (30) | Stores the Period Name | |
| PERIOD_NAME33 | VARCHAR2 | (30) | Stores the Period Name | |
| PERIOD_NAME34 | VARCHAR2 | (30) | Stores the Period Name | |
| PERIOD_NAME35 | VARCHAR2 | (30) | Stores the Period Name | |
| PERIOD_NAME36 | VARCHAR2 | (30) | Stores the Period Name | |
| PERIOD_NAME37 | VARCHAR2 | (30) | Stores the Period Name | |
| PERIOD_NAME38 | VARCHAR2 | (30) | Stores the Period Name | |
| PERIOD_NAME39 | VARCHAR2 | (30) | Stores the Period Name | |
| PERIOD_NAME40 | VARCHAR2 | (30) | Stores the Period Name | |
| PERIOD_NAME41 | VARCHAR2 | (30) | Stores the Period Name | |
| PERIOD_NAME42 | VARCHAR2 | (30) | Stores the Period Name | |
| PERIOD_NAME43 | VARCHAR2 | (30) | Stores the Period Name | |
| PERIOD_NAME44 | VARCHAR2 | (30) | Stores the Period Name | |
| PERIOD_NAME45 | VARCHAR2 | (30) | Stores the Period Name | |
| PERIOD_NAME46 | VARCHAR2 | (30) | Stores the Period Name | |
| PERIOD_NAME47 | VARCHAR2 | (30) | Stores the Period Name | |
| PERIOD_NAME48 | VARCHAR2 | (30) | Stores the Period Name | |
| PERIOD_NAME49 | VARCHAR2 | (30) | Stores the Period Name | |
| PERIOD_NAME50 | VARCHAR2 | (30) | Stores the Period Name | |
| PERIOD_NAME51 | VARCHAR2 | (30) | Stores the Period Name | |
| PERIOD_NAME52 | VARCHAR2 | (30) | Stores the Period Name | |
| PERIOD1_START_DATE | DATE | Stores the Start Date of the Period | ||
| PERIOD2_START_DATE | DATE | Stores the Start Date of the Period | ||
| PERIOD3_START_DATE | DATE | Stores the Start Date of the Period | ||
| PERIOD4_START_DATE | DATE | Stores the Start Date of the Period | ||
| PERIOD5_START_DATE | DATE | Stores the Start Date of the Period | ||
| PERIOD6_START_DATE | DATE | Stores the Start Date of the Period | ||
| PERIOD7_START_DATE | DATE | Stores the Start Date of the Period | ||
| PERIOD8_START_DATE | DATE | Stores the Start Date of the Period | ||
| PERIOD9_START_DATE | DATE | Stores the Start Date of the Period | ||
| PERIOD10_START_DATE | DATE | Stores the Start Date of the Period | ||
| PERIOD11_START_DATE | DATE | Stores the Start Date of the Period | ||
| PERIOD12_START_DATE | DATE | Stores the Start Date of the Period | ||
| PERIOD13_START_DATE | DATE | Stores the Start Date of the Period | ||
| PERIOD14_START_DATE | DATE | Stores the Start Date of the Period | ||
| PERIOD15_START_DATE | DATE | Stores the Start Date of the Period | ||
| PERIOD16_START_DATE | DATE | Stores the Start Date of the Period | ||
| PERIOD17_START_DATE | DATE | Stores the Start Date of the Period | ||
| PERIOD18_START_DATE | DATE | Stores the Start Date of the Period | ||
| PERIOD19_START_DATE | DATE | Stores the Start Date of the Period | ||
| PERIOD20_START_DATE | DATE | Stores the Start Date of the Period | ||
| PERIOD21_START_DATE | DATE | Stores the Start Date of the Period | ||
| PERIOD22_START_DATE | DATE | Stores the Start Date of the Period | ||
| PERIOD23_START_DATE | DATE | Stores the Start Date of the Period | ||
| PERIOD24_START_DATE | DATE | Stores the Start Date of the Period | ||
| PERIOD25_START_DATE | DATE | Stores the Start Date of the Period | ||
| PERIOD26_START_DATE | DATE | Stores the Start Date of the Period | ||
| PERIOD27_START_DATE | DATE | Stores the Start Date of the Period | ||
| PERIOD28_START_DATE | DATE | Stores the Start Date of the Period | ||
| PERIOD29_START_DATE | DATE | Stores the Start Date of the Period | ||
| PERIOD30_START_DATE | DATE | Stores the Start Date of the Period | ||
| PERIOD31_START_DATE | DATE | Stores the Start Date of the Period | ||
| PERIOD32_START_DATE | DATE | Stores the Start Date of the Period | ||
| PERIOD33_START_DATE | DATE | Stores the Start Date of the Period | ||
| PERIOD34_START_DATE | DATE | Stores the Start Date of the Period | ||
| PERIOD35_START_DATE | DATE | Stores the Start Date of the Period | ||
| PERIOD36_START_DATE | DATE | Stores the Start Date of the Period | ||
| PERIOD37_START_DATE | DATE | Stores the Start Date of the Period | ||
| PERIOD38_START_DATE | DATE | Stores the Start Date of the Period | ||
| PERIOD39_START_DATE | DATE | Stores the Start Date of the Period | ||
| PERIOD40_START_DATE | DATE | Stores the Start Date of the Period | ||
| PERIOD41_START_DATE | DATE | Stores the Start Date of the Period | ||
| PERIOD42_START_DATE | DATE | Stores the Start Date of the Period | ||
| PERIOD43_START_DATE | DATE | Stores the Start Date of the Period | ||
| PERIOD44_START_DATE | DATE | Stores the Start Date of the Period | ||
| PERIOD45_START_DATE | DATE | Stores the Start Date of the Period | ||
| PERIOD46_START_DATE | DATE | Stores the Start Date of the Period | ||
| PERIOD47_START_DATE | DATE | Stores the Start Date of the Period | ||
| PERIOD48_START_DATE | DATE | Stores the Start Date of the Period | ||
| PERIOD49_START_DATE | DATE | Stores the Start Date of the Period | ||
| PERIOD50_START_DATE | DATE | Stores the Start Date of the Period | ||
| PERIOD51_START_DATE | DATE | Stores the Start Date of the Period | ||
| PERIOD52_START_DATE | DATE | Stores the Start Date of the Period | ||
| PERIOD1_END_DATE | DATE | Stores the End Date of the Period | ||
| PERIOD2_END_DATE | DATE | Stores the End Date of the Period | ||
| PERIOD3_END_DATE | DATE | Stores the End Date of the Period | ||
| PERIOD4_END_DATE | DATE | Stores the End Date of the Period | ||
| PERIOD5_END_DATE | DATE | Stores the End Date of the Period | ||
| PERIOD6_END_DATE | DATE | Stores the End Date of the Period | ||
| PERIOD7_END_DATE | DATE | Stores the End Date of the Period | ||
| PERIOD8_END_DATE | DATE | Stores the End Date of the Period | ||
| PERIOD9_END_DATE | DATE | Stores the End Date of the Period | ||
| PERIOD10_END_DATE | DATE | Stores the End Date of the Period | ||
| PERIOD11_END_DATE | DATE | Stores the End Date of the Period | ||
| PERIOD12_END_DATE | DATE | Stores the End Date of the Period | ||
| PERIOD13_END_DATE | DATE | Stores the End Date of the Period | ||
| PERIOD14_END_DATE | DATE | Stores the End Date of the Period | ||
| PERIOD15_END_DATE | DATE | Stores the End Date of the Period | ||
| PERIOD16_END_DATE | DATE | Stores the End Date of the Period | ||
| PERIOD17_END_DATE | DATE | Stores the End Date of the Period | ||
| PERIOD18_END_DATE | DATE | Stores the End Date of the Period | ||
| PERIOD19_END_DATE | DATE | Stores the End Date of the Period | ||
| PERIOD20_END_DATE | DATE | Stores the End Date of the Period | ||
| PERIOD21_END_DATE | DATE | Stores the End Date of the Period | ||
| PERIOD22_END_DATE | DATE | Stores the End Date of the Period | ||
| PERIOD23_END_DATE | DATE | Stores the End Date of the Period | ||
| PERIOD24_END_DATE | DATE | Stores the End Date of the Period | ||
| PERIOD25_END_DATE | DATE | Stores the End Date of the Period | ||
| PERIOD26_END_DATE | DATE | Stores the End Date of the Period | ||
| PERIOD27_END_DATE | DATE | Stores the End Date of the Period | ||
| PERIOD28_END_DATE | DATE | Stores the End Date of the Period | ||
| PERIOD29_END_DATE | DATE | Stores the End Date of the Period | ||
| PERIOD30_END_DATE | DATE | Stores the End Date of the Period | ||
| PERIOD31_END_DATE | DATE | Stores the End Date of the Period | ||
| PERIOD32_END_DATE | DATE | Stores the End Date of the Period | ||
| PERIOD33_END_DATE | DATE | Stores the End Date of the Period | ||
| PERIOD34_END_DATE | DATE | Stores the End Date of the Period | ||
| PERIOD35_END_DATE | DATE | Stores the End Date of the Period | ||
| PERIOD36_END_DATE | DATE | Stores the End Date of the Period | ||
| PERIOD37_END_DATE | DATE | Stores the End Date of the Period | ||
| PERIOD38_END_DATE | DATE | Stores the End Date of the Period | ||
| PERIOD39_END_DATE | DATE | Stores the End Date of the Period | ||
| PERIOD40_END_DATE | DATE | Stores the End Date of the Period | ||
| PERIOD41_END_DATE | DATE | Stores the End Date of the Period | ||
| PERIOD42_END_DATE | DATE | Stores the End Date of the Period | ||
| PERIOD43_END_DATE | DATE | Stores the End Date of the Period | ||
| PERIOD44_END_DATE | DATE | Stores the End Date of the Period | ||
| PERIOD45_END_DATE | DATE | Stores the End Date of the Period | ||
| PERIOD46_END_DATE | DATE | Stores the End Date of the Period | ||
| PERIOD47_END_DATE | DATE | Stores the End Date of the Period | ||
| PERIOD48_END_DATE | DATE | Stores the End Date of the Period | ||
| PERIOD49_END_DATE | DATE | Stores the End Date of the Period | ||
| PERIOD50_END_DATE | DATE | Stores the End Date of the Period | ||
| PERIOD51_END_DATE | DATE | Stores the End Date of the Period | ||
| PERIOD52_END_DATE | DATE | Stores the End Date of the Period | ||
| LAST_UPDATE_DATE | DATE | Yes | Standard Who Column | |
| LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who Column |
| CREATION_DATE | DATE | Yes | Standard Who Column | |
| CREATED_BY | NUMBER | (15) | Yes | Standard Who Column |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Yes | Standard Who Column |
| CURRENT_FLAG | VARCHAR2 | (1) | Flag that indicates whether this is the current period profile for the period type | |
| PROFILE_END_PERIOD_NAME | VARCHAR2 | (30) | Stores the end period in the period profile. |
Cut, paste (and edit) the following text to query this object:
SELECT PERIOD_PROFILE_ID
, PERIOD_PROFILE_TYPE
, PROJECT_ID
, PERIOD_SET_NAME
, GL_PERIOD_TYPE
, PLAN_PERIOD_TYPE
, NUMBER_OF_PERIODS
, PERIOD_NAME1
, PERIOD_NAME2
, PERIOD_NAME3
, PERIOD_NAME4
, PERIOD_NAME5
, PERIOD_NAME6
, PERIOD_NAME7
, PERIOD_NAME8
, PERIOD_NAME9
, PERIOD_NAME10
, PERIOD_NAME11
, PERIOD_NAME12
, PERIOD_NAME13
, PERIOD_NAME14
, PERIOD_NAME15
, PERIOD_NAME16
, PERIOD_NAME17
, PERIOD_NAME18
, PERIOD_NAME19
, PERIOD_NAME20
, PERIOD_NAME21
, PERIOD_NAME22
, PERIOD_NAME23
, PERIOD_NAME24
, PERIOD_NAME25
, PERIOD_NAME26
, PERIOD_NAME27
, PERIOD_NAME28
, PERIOD_NAME29
, PERIOD_NAME30
, PERIOD_NAME31
, PERIOD_NAME32
, PERIOD_NAME33
, PERIOD_NAME34
, PERIOD_NAME35
, PERIOD_NAME36
, PERIOD_NAME37
, PERIOD_NAME38
, PERIOD_NAME39
, PERIOD_NAME40
, PERIOD_NAME41
, PERIOD_NAME42
, PERIOD_NAME43
, PERIOD_NAME44
, PERIOD_NAME45
, PERIOD_NAME46
, PERIOD_NAME47
, PERIOD_NAME48
, PERIOD_NAME49
, PERIOD_NAME50
, PERIOD_NAME51
, PERIOD_NAME52
, PERIOD1_START_DATE
, PERIOD2_START_DATE
, PERIOD3_START_DATE
, PERIOD4_START_DATE
, PERIOD5_START_DATE
, PERIOD6_START_DATE
, PERIOD7_START_DATE
, PERIOD8_START_DATE
, PERIOD9_START_DATE
, PERIOD10_START_DATE
, PERIOD11_START_DATE
, PERIOD12_START_DATE
, PERIOD13_START_DATE
, PERIOD14_START_DATE
, PERIOD15_START_DATE
, PERIOD16_START_DATE
, PERIOD17_START_DATE
, PERIOD18_START_DATE
, PERIOD19_START_DATE
, PERIOD20_START_DATE
, PERIOD21_START_DATE
, PERIOD22_START_DATE
, PERIOD23_START_DATE
, PERIOD24_START_DATE
, PERIOD25_START_DATE
, PERIOD26_START_DATE
, PERIOD27_START_DATE
, PERIOD28_START_DATE
, PERIOD29_START_DATE
, PERIOD30_START_DATE
, PERIOD31_START_DATE
, PERIOD32_START_DATE
, PERIOD33_START_DATE
, PERIOD34_START_DATE
, PERIOD35_START_DATE
, PERIOD36_START_DATE
, PERIOD37_START_DATE
, PERIOD38_START_DATE
, PERIOD39_START_DATE
, PERIOD40_START_DATE
, PERIOD41_START_DATE
, PERIOD42_START_DATE
, PERIOD43_START_DATE
, PERIOD44_START_DATE
, PERIOD45_START_DATE
, PERIOD46_START_DATE
, PERIOD47_START_DATE
, PERIOD48_START_DATE
, PERIOD49_START_DATE
, PERIOD50_START_DATE
, PERIOD51_START_DATE
, PERIOD52_START_DATE
, PERIOD1_END_DATE
, PERIOD2_END_DATE
, PERIOD3_END_DATE
, PERIOD4_END_DATE
, PERIOD5_END_DATE
, PERIOD6_END_DATE
, PERIOD7_END_DATE
, PERIOD8_END_DATE
, PERIOD9_END_DATE
, PERIOD10_END_DATE
, PERIOD11_END_DATE
, PERIOD12_END_DATE
, PERIOD13_END_DATE
, PERIOD14_END_DATE
, PERIOD15_END_DATE
, PERIOD16_END_DATE
, PERIOD17_END_DATE
, PERIOD18_END_DATE
, PERIOD19_END_DATE
, PERIOD20_END_DATE
, PERIOD21_END_DATE
, PERIOD22_END_DATE
, PERIOD23_END_DATE
, PERIOD24_END_DATE
, PERIOD25_END_DATE
, PERIOD26_END_DATE
, PERIOD27_END_DATE
, PERIOD28_END_DATE
, PERIOD29_END_DATE
, PERIOD30_END_DATE
, PERIOD31_END_DATE
, PERIOD32_END_DATE
, PERIOD33_END_DATE
, PERIOD34_END_DATE
, PERIOD35_END_DATE
, PERIOD36_END_DATE
, PERIOD37_END_DATE
, PERIOD38_END_DATE
, PERIOD39_END_DATE
, PERIOD40_END_DATE
, PERIOD41_END_DATE
, PERIOD42_END_DATE
, PERIOD43_END_DATE
, PERIOD44_END_DATE
, PERIOD45_END_DATE
, PERIOD46_END_DATE
, PERIOD47_END_DATE
, PERIOD48_END_DATE
, PERIOD49_END_DATE
, PERIOD50_END_DATE
, PERIOD51_END_DATE
, PERIOD52_END_DATE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, CURRENT_FLAG
, PROFILE_END_PERIOD_NAME
FROM PA.PA_PROJ_PERIOD_PROFILES;
PA.PA_PROJ_PERIOD_PROFILES does not reference any database object
PA.PA_PROJ_PERIOD_PROFILES is referenced by following:
PA
PA_PROJ_PERIOD_PROFILES#
|
|
|
|