[Home] [Help] [Dependency Information]
Object Name: | PER_NL_ASG_SCL_UPGRADE |
---|---|
Object Type: | TABLE |
Owner: | HR |
FND Design Data: | PER.PER_NL_ASG_SCL_UPGRADE |
Subobject Name: | |
Status: | VALID |
Records the Dutch Assignment SCL Context Information Migrated
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PER_NL_ASG_SCL_UPGRADE_UK1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
BUSINESS_GROUP_ID
PERSON_ID ASSIGNMENT_ID EFFECTIVE_START_DATE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BUSINESS_GROUP_ID | NUMBER | (15) | Yes | Business Group Id |
PERSON_ID | NUMBER | (10) | Yes | Person Id |
ASSIGNMENT_ID | NUMBER | (10) | Yes | Assignment ID |
EFFECTIVE_START_DATE | DATE | Yes | Effective Start Date | |
EFFECTIVE_END_DATE | DATE | Effective End Date | ||
RECORD_TYPE | NUMBER | (1) | Yes | Record Type |
REPORT_TEXT | VARCHAR2 | (150) | Record text |
Cut, paste (and edit) the following text to query this object:
SELECT BUSINESS_GROUP_ID
, PERSON_ID
, ASSIGNMENT_ID
, EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE
, RECORD_TYPE
, REPORT_TEXT
FROM HR.PER_NL_ASG_SCL_UPGRADE;
HR.PER_NL_ASG_SCL_UPGRADE does not reference any database object
HR.PER_NL_ASG_SCL_UPGRADE is referenced by following:
|
|
|