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.IGF_GR_YTD_ORIG

Object Details

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

View Type

A multi-org view which will retrive data for your current operating unit and ignore data in other operating units.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)
YTDOR_ID	NUMBER	(15)	Yes
ORIGINATION_ID	VARCHAR2	(30)
ORIGINAL_SSN	VARCHAR2	(9)
ORIGINAL_NAME_CD	VARCHAR2	(2)
ATTEND_PELL_ID	VARCHAR2	(30)
ED_USE	VARCHAR2	(30)
INST_CROSS_REF_CODE	VARCHAR2	(30)
ACTION_CODE	VARCHAR2	(1)
ACCPT_AWD_AMT	NUMBER	(12)
ACCPT_DISB_DT1	DATE
ACCPT_DISB_DT2	DATE
ACCPT_DISB_DT3	DATE
ACCPT_DISB_DT4	DATE
ACCPT_DISB_DT5	DATE
ACCPT_DISB_DT6	DATE
ACCPT_DISB_DT7	DATE
ACCPT_DISB_DT8	DATE
ACCPT_DISB_DT9	DATE
ACCPT_DISB_DT10	DATE
ACCPT_DISB_DT11	DATE
ACCPT_DISB_DT12	DATE
ACCPT_DISB_DT13	DATE
ACCPT_DISB_DT14	DATE
ACCPT_DISB_DT15	DATE
ACCPT_ENRL_DT	DATE
ACCPT_LOW_TUT_FLG	VARCHAR2	(1)
ACCPT_VER_STAT_FLG	VARCHAR2	(1)
ACCPT_INCR_PELL_CD	VARCHAR2	(1)
ACCPT_TRAN_NUM	VARCHAR2	(2)
ACCPT_EFC	NUMBER	(12)
ACCPT_SEC_EFC	VARCHAR2	(1)
ACCPT_ACAD_CAL	VARCHAR2	(1)
ACCPT_PYMT_METHOD	VARCHAR2	(1)
ACCPT_COA	NUMBER	(12)
ACCPT_ENRL_STAT	VARCHAR2	(1)
ACCPT_WKS_INST_PYMT	VARCHAR2	(30)
WK_INST_TIME_CALC_PYMT	NUMBER	(5)
ACCPT_WKS_ACAD	VARCHAR2	(30)
ACCPT_CR_ACAD_YR	VARCHAR2	(30)
INST_SEQ_NUM	VARCHAR2	(30)
SCH_FULL_TIME_PELL	NUMBER	(12)
STUD_NAME	VARCHAR2	(30)
SSN	VARCHAR2	(9)
STUD_DOB	DATE
CPS_VER_SEL_CD	VARCHAR2	(1)
YTD_DISB_AMT	NUMBER	(12)
BATCH_ID	VARCHAR2	(30)
PROCESS_DATE	DATE
CREATED_BY	NUMBER	(15)	Yes
CREATION_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER	(15)	Yes
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATE_LOGIN	NUMBER	(15)
REQUEST_ID	NUMBER	(15)
PROGRAM_APPLICATION_ID	NUMBER	(15)
PROGRAM_ID	NUMBER	(15)
PROGRAM_UPDATE_DATE	DATE
ORG_ID	NUMBER	(15)
CI_CAL_TYPE	VARCHAR2	(10)		Calendar Type
CI_SEQUENCE_NUMBER	NUMBER			Calendar Instance Identifier

Query Text

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


SELECT ROW_ID
,      YTDOR_ID
,      ORIGINATION_ID
,      ORIGINAL_SSN
,      ORIGINAL_NAME_CD
,      ATTEND_PELL_ID
,      ED_USE
,      INST_CROSS_REF_CODE
,      ACTION_CODE
,      ACCPT_AWD_AMT
,      ACCPT_DISB_DT1
,      ACCPT_DISB_DT2
,      ACCPT_DISB_DT3
,      ACCPT_DISB_DT4
,      ACCPT_DISB_DT5
,      ACCPT_DISB_DT6
,      ACCPT_DISB_DT7
,      ACCPT_DISB_DT8
,      ACCPT_DISB_DT9
,      ACCPT_DISB_DT10
,      ACCPT_DISB_DT11
,      ACCPT_DISB_DT12
,      ACCPT_DISB_DT13
,      ACCPT_DISB_DT14
,      ACCPT_DISB_DT15
,      ACCPT_ENRL_DT
,      ACCPT_LOW_TUT_FLG
,      ACCPT_VER_STAT_FLG
,      ACCPT_INCR_PELL_CD
,      ACCPT_TRAN_NUM
,      ACCPT_EFC
,      ACCPT_SEC_EFC
,      ACCPT_ACAD_CAL
,      ACCPT_PYMT_METHOD
,      ACCPT_COA
,      ACCPT_ENRL_STAT
,      ACCPT_WKS_INST_PYMT
,      WK_INST_TIME_CALC_PYMT
,      ACCPT_WKS_ACAD
,      ACCPT_CR_ACAD_YR
,      INST_SEQ_NUM
,      SCH_FULL_TIME_PELL
,      STUD_NAME
,      SSN
,      STUD_DOB
,      CPS_VER_SEL_CD
,      YTD_DISB_AMT
,      BATCH_ID
,      PROCESS_DATE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ORG_ID
,      CI_CAL_TYPE
,      CI_SEQUENCE_NUMBER
FROM APPS.IGF_GR_YTD_ORIG;

Dependencies

[top of page]

APPS.IGF_GR_YTD_ORIG references the following:

APPS: IGF_GR_YTD_ORIG_ALL

APPS.IGF_GR_YTD_ORIG is referenced by following:

APPS: IGF_GR_YTD_LOAD_DATA - show dependent code