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]

TABLE: IGF.IGF_SE_EXT_JOB_ALL

Object Details

Object Name:	IGF_SE_EXT_JOB_ALL
Object Type:	TABLE
Owner:	IGF
FND Design Data:	IGF.IGF_SE_EXT_JOB_ALL
Subobject Name:
Status:	VALID

No longer used.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
ORG_UNIT_CD	VARCHAR2	(30)	Yes	Organization Unit Code for an Active Organization, that offers the Job
JOB_CODE	VARCHAR2	(15)	Yes	Unique Identifier for the Job
DESCRIPTION	VARCHAR2	(100)	Yes	Title of the Job
WORK_LOC	VARCHAR2	(200)		Job location details
CLOSED_IND	VARCHAR2	(1)	Yes	Indicator identifying whetehr the Job is active or not. Y indicates open, N indicates closed.
SUPERVISOR_ID	NUMBER	(15)		Hiring Supervisor Person Identifier. This person should have a Person Type attribute of EXTERNAL CONTACT - OBSOLETE(bug # 2272375)
TELEPHONE_NO	VARCHAR2	(20)		Supervisor's Telephone Number
PAYRANGE_FROM	NUMBER	(12)		Lower Payrange Limit of the job.
PAYRANGE_TO	NUMBER	(12)		Upper Payrange Limit
WORK_START_DATE	DATE			Date from which the Job is offered.
WORK_LOC_DEV	VARCHAR2	(1)		Job Location and Development Indicator. Allowable values are Y and N. This is a speecific fedral Program Attribute.
JOB_PURPOSE	VARCHAR2	(1000)		Detail description about the job.
PAIDBY_CAMPUS_EMP	VARCHAR2	(1)		Indicates that the off campus employer will process payroll for the student. Defaults to N. Allowed values are Y and N.
HELP_AMERICA_READ	VARCHAR2	(1)		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.
COMMON_SERVICE	VARCHAR2	(1)		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	(1000)		Details about skills required for the job.
CAREER_OBJECTIVE	VARCHAR2	(1000)		Career Object details that the job offers.
CREATED_BY	NUMBER	(15)	Yes	Standard WHO Column
CREATION_DATE	DATE		Yes	Standard WHO Column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard WHO Column
LAST_UPDATE_DATE	DATE		Yes	Standard WHO Column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard WHO Column
ORG_ID	NUMBER	(15)		Organization Identifier
SUPERVISOR_CONTACT	VARCHAR2	(80)		Hiring Supervisor contact details

Query Text

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


SELECT ORG_UNIT_CD
,      JOB_CODE
,      DESCRIPTION
,      WORK_LOC
,      CLOSED_IND
,      SUPERVISOR_ID
,      TELEPHONE_NO
,      PAYRANGE_FROM
,      PAYRANGE_TO
,      WORK_START_DATE
,      WORK_LOC_DEV
,      JOB_PURPOSE
,      PAIDBY_CAMPUS_EMP
,      HELP_AMERICA_READ
,      COMMON_SERVICE
,      JOB_SKILLS
,      CAREER_OBJECTIVE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ORG_ID
,      SUPERVISOR_CONTACT
FROM IGF.IGF_SE_EXT_JOB_ALL;

Dependencies

[top of page]

IGF.IGF_SE_EXT_JOB_ALL does not reference any database object

IGF.IGF_SE_EXT_JOB_ALL is referenced by following:

APPS: IGF_SE_EXT_JOB_ALL