DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.PER_JOBS1_DFV

Object Details
Object Name: PER_JOBS1_DFV
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
CONTEXT_VALUE VARCHAR2 (30)
CAREER_PATH VARCHAR2 (150)
FLSA VARCHAR2 (150)
EEOG VARCHAR2 (150)
NOC VARCHAR2 (150)
SURVEY_BENCHMARK VARCHAR2 (150)
JOB_GROUP VARCHAR2 (150)
LINE_OF_PROGRESSION VARCHAR2 (150)
SALARY_CODE VARCHAR2 (150)
NIGHT_SHIFT_SUPPLEMENT VARCHAR2 (150)
SHIFT_WORK_SUPPLEMENT VARCHAR2 (150)
INSEE_PCS_CODE VARCHAR2 (150)
ACTIVITY_TYPE VARCHAR2 (150)
JOB_CLASSIFICATION VARCHAR2 (150)
FEOR_NUMBER VARCHAR2 (150)
ADDITIONAL_HEALTH_HOLIDAY VARCHAR2 (150)
ADDITIONAL_WORKPLACE_HOLIDAY VARCHAR2 (150)
SSB_POSITION_CODE VARCHAR2 (150)
WORK_TITLE VARCHAR2 (150)
COLLECTIVE_AGREEMENT VARCHAR2 (150)
FLSA_CODE VARCHAR2 (150)
EEO_CATEGORY VARCHAR2 (150)
EEO_FUNCTION VARCHAR2 (150)
IPEDS_CATEGORY VARCHAR2 (150)
CONCATENATED_SEGMENTS VARCHAR2 (1389)
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ROW_ID
,      CONTEXT_VALUE
,      CAREER_PATH
,      FLSA
,      EEOG
,      NOC
,      SURVEY_BENCHMARK
,      JOB_GROUP
,      LINE_OF_PROGRESSION
,      SALARY_CODE
,      NIGHT_SHIFT_SUPPLEMENT
,      SHIFT_WORK_SUPPLEMENT
,      INSEE_PCS_CODE
,      ACTIVITY_TYPE
,      JOB_CLASSIFICATION
,      FEOR_NUMBER
,      ADDITIONAL_HEALTH_HOLIDAY
,      ADDITIONAL_WORKPLACE_HOLIDAY
,      SSB_POSITION_CODE
,      WORK_TITLE
,      COLLECTIVE_AGREEMENT
,      FLSA_CODE
,      EEO_CATEGORY
,      EEO_FUNCTION
,      IPEDS_CATEGORY
,      CONCATENATED_SEGMENTS
FROM APPS.PER_JOBS1_DFV;

Dependencies

[top of page]

APPS.PER_JOBS1_DFV references the following:

SchemaAPPS
SynonymPER_JOBS

APPS.PER_JOBS1_DFV is not referenced by any database object