eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.IGFFV_STUDENT_EMPLOYMENT_JOBS

Object Details

Object Name:	IGFFV_STUDENT_EMPLOYMENT_JOBS
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IGF.IGFFV_STUDENT_EMPLOYMENT_JOBS
Subobject Name:
Status:	VALID

View Type

A Business Intelligence System view

Full View for the Entity that holds Student Employment Job listing

[View Source]

Columns

Name	Datatype	Length	Comments
ORGANIZATIONAL_UNIT_CODE	VARCHAR2	(0)	Organization Unit Code for an Active Organization, that offers the Job
JOB_DESCRIPTION	VARCHAR2	(0)	Title of the Job
WORK_LOCATION	VARCHAR2	(0)	Job location details
SUPERVISOR_CONTACT	VARCHAR2	(0)	Hiring Supervisor contact details
CLOSED_INDICATOR	VARCHAR2	(0)	Indicator identifying whether the Job is active or not. Y indicates open, N indicates closed.
TELEPHONE_NUMBER	VARCHAR2	(0)	Supervisor's Telephone Number
PAY_RANGE_FROM	VARCHAR2	(0)	Lower Pay range Limit of the job
PAY_RANGE_TO	VARCHAR2	(0)	Upper Pay range Limit
WORK_START_DATE	VARCHAR2	(0)	Date from which the Job is offered
WORK_LOCACTION_DEV	VARCHAR2	(0)	Job Location and Development Indicator. Allowable values are Y and N. This is a specific federal Program Attribute
JOB_PURPOSE	VARCHAR2	(0)	Detail description about the job
OFF_CAMPUS_EMPLOYER	VARCHAR2	(0)	Indicates that the off campus employer will process payroll for the student. Defaults to N. Allowed values are Y and N
HELP_AMERICA_READ_POSITION	VARCHAR2	(0)	Indicates that the job position qualifies as a Help America Read program and allows for the government share to be higher than the default for jobs so designated. Defaults to N. Allowed values are Y and N
COMMUNITY_SERVICE_POSITION	VARCHAR2	(0)	Indicates that the job qualifies as a Community Service position and allows for the government share to be higher than the default for jobs so designated. Defaults to N. Allowed values are Y and N
JOB_SKILLS	VARCHAR2	(0)	Details about skills required for the job
CAREER_OBJECTIVE	VARCHAR2	(0)	Career Object details that the job offers
ORGANIZATION_NAME	VARCHAR2	(0)	Name of the Organization Unit for an Active Organization, that offers the Job
JOB_CODE	VARCHAR2	(0)	Unique Identifier for the Job
CREATED_BY	VARCHAR2	(0)	Standard WHO Column
CREATION_DATE	VARCHAR2	(0)	Standard WHO Column
LAST_UPDATED_BY	VARCHAR2	(0)	Standard WHO Column
LAST_UPDATE_DATE	VARCHAR2	(0)	Standard WHO Column

Query Text

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


SELECT ORGANIZATIONAL_UNIT_CODE
,      JOB_DESCRIPTION
,      WORK_LOCATION
,      SUPERVISOR_CONTACT
,      CLOSED_INDICATOR
,      TELEPHONE_NUMBER
,      PAY_RANGE_FROM
,      PAY_RANGE_TO
,      WORK_START_DATE
,      WORK_LOCACTION_DEV
,      JOB_PURPOSE
,      OFF_CAMPUS_EMPLOYER
,      HELP_AMERICA_READ_POSITION
,      COMMUNITY_SERVICE_POSITION
,      JOB_SKILLS
,      CAREER_OBJECTIVE
,      ORGANIZATION_NAME
,      JOB_CODE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM APPS.IGFFV_STUDENT_EMPLOYMENT_JOBS;

Dependencies

[top of page]

APPS.IGFFV_STUDENT_EMPLOYMENT_JOBS references the following:

PUBLIC: DUAL

APPS.IGFFV_STUDENT_EMPLOYMENT_JOBS is not referenced by any database object