[Home] [Help] [Dependency Information]
Object Name: | IGFFV_STUDENT_EMPLOYMENT_JOBS |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGF.IGFFV_STUDENT_EMPLOYMENT_JOBS |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
Full View for the Entity that holds Student Employment Job listing
Name | Datatype | Length | Mandatory | 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 |
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;
APPS.IGFFV_STUDENT_EMPLOYMENT_JOBS is not referenced by any database object
|
|
|