[Home] [Help] [Dependency Information]
Object Name: | HR_EDWBV_WRK_CMPSTN_FCV |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | HRI.HR_EDWBV_WRK_CMPSTN_FCV |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
COMPOSITION_PK | VARCHAR2 | (81) | ||
AGE_BAND_FK | VARCHAR2 | (4000) | ||
SERVICE_BAND_FK | VARCHAR2 | (4000) | ||
ASSIGNMENT_FK | VARCHAR2 | (71) | ||
CURRENCY_FK | VARCHAR2 | (15) | ||
GEOGRAPHY_FK | VARCHAR2 | (78) | ||
GRADE_FK | VARCHAR2 | (71) | ||
INSTANCE_FK | VARCHAR2 | (30) | ||
JOB_FK | VARCHAR2 | (71) | ||
ORGANIZATION_FK | VARCHAR2 | (71) | ||
PERSON_FK | VARCHAR2 | (85) | ||
PERSON_TYPE_FK | VARCHAR2 | (4000) | ||
POSITION_FK | VARCHAR2 | (71) | ||
TIME_FK | VARCHAR2 | (14) | ||
ASG_ASSIGNMENT_ID | NUMBER | (10) | Yes | |
ASG_BUSINESS_GROUP_ID | NUMBER | (15) | Yes | |
ASG_GRADE_ID | NUMBER | (15) | ||
ASG_JOB_ID | NUMBER | (15) | ||
ASG_LOCATION_ID | NUMBER | (15) | ||
ASG_ORGANIZATION_ID | NUMBER | (15) | Yes | |
ASG_PERSON_ID | NUMBER | (10) | Yes | |
ASG_POSITION_ID | NUMBER | (15) | ||
SNAPSHOT_DATE | DATE | |||
ASSIGNMENT_START_DATE | DATE | Yes | ||
DATE_OF_BIRTH | DATE | |||
LAST_UPDATE_DATE | DATE | |||
CREATION_DATE | DATE | |||
COMPOSITION_HEADCOUNT | NUMBER | |||
COMPOSITION_FTE | NUMBER | |||
LWST_GRD_SLRY | VARCHAR2 | (0) | ||
HGHST_GRD_SLRY | VARCHAR2 | (0) | ||
CRRNCY_CNVRSN_RATE | NUMBER | |||
CRNT_ANNLZED_SLRY | VARCHAR2 | (40) | ||
CRNT_ANNLZED_SLRY_BC | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT COMPOSITION_PK
, AGE_BAND_FK
, SERVICE_BAND_FK
, ASSIGNMENT_FK
, CURRENCY_FK
, GEOGRAPHY_FK
, GRADE_FK
, INSTANCE_FK
, JOB_FK
, ORGANIZATION_FK
, PERSON_FK
, PERSON_TYPE_FK
, POSITION_FK
, TIME_FK
, ASG_ASSIGNMENT_ID
, ASG_BUSINESS_GROUP_ID
, ASG_GRADE_ID
, ASG_JOB_ID
, ASG_LOCATION_ID
, ASG_ORGANIZATION_ID
, ASG_PERSON_ID
, ASG_POSITION_ID
, SNAPSHOT_DATE
, ASSIGNMENT_START_DATE
, DATE_OF_BIRTH
, LAST_UPDATE_DATE
, CREATION_DATE
, COMPOSITION_HEADCOUNT
, COMPOSITION_FTE
, LWST_GRD_SLRY
, HGHST_GRD_SLRY
, CRRNCY_CNVRSN_RATE
, CRNT_ANNLZED_SLRY
, CRNT_ANNLZED_SLRY_BC
FROM APPS.HR_EDWBV_WRK_CMPSTN_FCV;
|
|
|