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

TABLE: IGF.IGF_GR_YTD_DISB_ALL

Object Details
Object Name: IGF_GR_YTD_DISB_ALL
Object Type: TABLE
Owner: IGF
FND Design Data: TableIGF.IGF_GR_YTD_DISB_ALL
Subobject Name:
Status: VALID


IGF_GR_YTD_DISB_ALL stores the year to date disbursement data.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IGF_GR_YTD_DISB_ALL_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnYTDDS_ID
Columns
Name Datatype Length Mandatory Comments
YTDDS_ID NUMBER
Yes Identifier for each year to date origination record
ORIGINATION_ID VARCHAR2 (30)
Unique code for each origination
INST_CROSS_REF_CODE VARCHAR2 (30)
Contains cross reference information useful to institution for internally identifying student records
ACTION_CODE VARCHAR2 (1)
Code indicating action to be taken
DISB_REF_NUM VARCHAR2 (30) Yes Number of disbursement
DISB_ACCPT_AMT NUMBER (12) Yes Amount of disbursement for student
DB_CR_FLAG VARCHAR2 (1)
Indicates if disbursement amount is positive or negative
DISB_DT DATE

Date disbursement is made to student
PYMT_PRD_START_DT DATE
Yes Begin date of payment period
DISB_BATCH_ID VARCHAR2 (30)
Number generated by institution to identify batch of disbursement records
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
PROGRAM_APPLICATION_ID NUMBER (15)
Standard Who column for concurrent programs
PROGRAM_ID NUMBER (15)
Standard Who column for concurrent programs
PROGRAM_UPDATE_DATE DATE

Standard Who column for concurrent programs
REQUEST_ID NUMBER (15)
Standard Who column for concurrent programs
ORG_ID NUMBER (15)
Operating unit identifier
CI_CAL_TYPE VARCHAR2 (10)
Calendar Type
CI_SEQUENCE_NUMBER NUMBER

Calendar Instance Identifier
STUDENT_NAME VARCHAR2 (30)
Student's Name
CURRENT_SSN_TXT VARCHAR2 (9)
Student's Current Social Security Number
STUDENT_BIRTH_DATE DATE

Student Date of Birth
DISB_PROCESS_DATE DATE

Date disbursement information was processed by the COD System
ROUTING_ID_TXT VARCHAR2 (8)
Unique entity identifier assigned to each record
FIN_AWARD_YEAR_NUM NUMBER

The last year in the two-year cycle of the Program's Award Year
ATTEND_ENTITY_ID_TXT VARCHAR2 (8)
Pell-ID of attended campus
DISB_SEQ_NUM NUMBER

The two-digit integer assigned to count the progression of disbursement adjustments for a given Disbursement Number
DISB_REL_IND VARCHAR2 (1)
Value that is reported by the Full Participant school to indicate whether the disbursement is anticipated or actual
PREV_DISB_SEQ_NUM NUMBER

The prior sequence number is given to substantiate the order in which Disbursement records were processed
Query Text

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


SELECT YTDDS_ID
,      ORIGINATION_ID
,      INST_CROSS_REF_CODE
,      ACTION_CODE
,      DISB_REF_NUM
,      DISB_ACCPT_AMT
,      DB_CR_FLAG
,      DISB_DT
,      PYMT_PRD_START_DT
,      DISB_BATCH_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
,      ORG_ID
,      CI_CAL_TYPE
,      CI_SEQUENCE_NUMBER
,      STUDENT_NAME
,      CURRENT_SSN_TXT
,      STUDENT_BIRTH_DATE
,      DISB_PROCESS_DATE
,      ROUTING_ID_TXT
,      FIN_AWARD_YEAR_NUM
,      ATTEND_ENTITY_ID_TXT
,      DISB_SEQ_NUM
,      DISB_REL_IND
,      PREV_DISB_SEQ_NUM
FROM IGF.IGF_GR_YTD_DISB_ALL;

Dependencies

[top of page]

IGF.IGF_GR_YTD_DISB_ALL does not reference any database object

IGF.IGF_GR_YTD_DISB_ALL is referenced by following:

SchemaAPPS
SynonymIGF_GR_YTD_DISB_ALL