[Home] [Help] [Dependency Information]
Object Name: | IGW_BUDGET_PERSONS |
---|---|
Object Type: | TABLE |
Owner: | IGW |
FND Design Data: | IGW.IGW_BUDGET_PERSONS |
Subobject Name: | |
Status: | VALID |
IGW_BUDGET_PERSONS stores budgeting information about personnel, along with information such as appointment type, base salary, and effective date. The same person can be stored multiple times with different appointment types.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGW_BUDGET_PERSONS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
PROPOSAL_ID
VERSION_ID PARTY_ID APPOINTMENT_TYPE_CODE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PROPOSAL_ID | NUMBER | (15) | Yes | Proposal identifier |
VERSION_ID | NUMBER | (4) | Yes | Budget version identifier |
PERSON_ID | NUMBER | (15) | Person identifier | |
APPOINTMENT_TYPE_CODE | VARCHAR2 | (30) | Yes | Code that uniquely identifies appointment type |
EFFECTIVE_DATE | DATE | Yes | Effective start date from which the base salary associated with a person is valid | |
CALCULATION_BASE | NUMBER | (15) | Yes | Base salary of a person |
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 |
RECORD_VERSION_NUMBER | NUMBER | Yes | Field for storing locking sequence number | |
PARTY_ID | NUMBER | (15) | Yes | Party identifier for person |
Cut, paste (and edit) the following text to query this object:
SELECT PROPOSAL_ID
, VERSION_ID
, PERSON_ID
, APPOINTMENT_TYPE_CODE
, EFFECTIVE_DATE
, CALCULATION_BASE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, RECORD_VERSION_NUMBER
, PARTY_ID
FROM IGW.IGW_BUDGET_PERSONS;
IGW.IGW_BUDGET_PERSONS does not reference any database object
IGW.IGW_BUDGET_PERSONS is referenced by following:
|
|
|