[Home] [Help] [Dependency Information]
Object Name: | ABM_PERIODS |
---|---|
Object Type: | TABLE |
Owner: | ABM |
Subobject Name: | |
Status: | VALID |
A contiguous period of time expressed as a range of dates (inclusive) during which financial amounts and statistical quantities will be accumulated and stored for MODES in DATA SETS. PERIODS of the same type cannot have the same begin date.
Fairly static (updated once per year), light reads.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
ABM_PERIODS_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX |
SYN_I02_PERIOD_ID
SYN_I01_PERIOD_ID BEGIN_DATE |
ABM_PERIODS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | I14_PERIOD_ID |
Table | |
Foreign Table | Foreign Key Column | ABM_PERIODS | ABM_TAGS |
ABM_PERIODS
SYN_I02_PERIOD_ID
ABM_PERIODS SYN_I01_PERIOD_ID |
ABM_PDS | ABM_PERIODS |
ABM_PDS
SYN_I02_PERIOD_ID
ABM_PDS SYN_I01_PERIOD_ID ABM_PDS BEGIN_DATE |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SYN_I02_PERIOD_ID | VARCHAR2 | (30) | Yes | Period Attribute ID |
SYN_I01_PERIOD_ID | VARCHAR2 | (30) | Yes | Period Attribute Value |
BEGIN_DATE | DATE | Yes | Period Begin Date | |
I14_PERIOD_ID | VARCHAR2 | (30) | Yes | Period Id |
I14_NAME | VARCHAR2 | (75) | Yes | Period Name |
END_DATE | DATE | Yes | Period End Date | |
DESCRIPTION_TEXT | VARCHAR2 | (750) | Period Description | |
MAINT_USER_ID | VARCHAR2 | (11) | Legacy column. No longer used in ABM 11i. | |
MAINT_EFFECT_CODE | VARCHAR2 | (1) | Legacy column. No longer used in ABM 11i. | |
MAINT_TIMESTAMP | DATE | Legacy column. No longer used in ABM 11i. | ||
CREATION_DATE | DATE | Yes | Standard who column. | |
CREATED_BY | NUMBER | (15) | Yes | Standard who column. |
LAST_UPDATE_DATE | DATE | Yes | Standard who column. | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column. |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column. |
Cut, paste (and edit) the following text to query this object:
SELECT SYN_I02_PERIOD_ID
, SYN_I01_PERIOD_ID
, BEGIN_DATE
, I14_PERIOD_ID
, I14_NAME
, END_DATE
, DESCRIPTION_TEXT
, MAINT_USER_ID
, MAINT_EFFECT_CODE
, MAINT_TIMESTAMP
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
FROM ABM.ABM_PERIODS;
ABM.ABM_PERIODS does not reference any database object
ABM.ABM_PERIODS is not referenced by any database object
|
|
|