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_AP_FA_BASE_H_ALL

Object Details

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

This table is obsolete now.

Storage Details

Tablespace:	APPS_TS_ARCHIVE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGF_AP_FA_BASE_H_ALL_U1	NORMAL	UNIQUE	APPS_TS_ARCHIVE	FABH_ID
IGF_AP_FA_BASE_H_ALL_N1	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	BASE_ID PRIMARY_REC

Columns

Name	Datatype	Length	Mandatory	Comments
FABH_ID	NUMBER	(15)	Yes	Sequence generated column
BASE_ID	NUMBER	(15)	Yes	Unique identifier for student financial aid record
PERSON_ID	NUMBER	(15)	Yes	Holds the person ID
PRIMARY_REC	VARCHAR2	(30)	Yes	Indicates the Latest Details from OSS for the Student, as used by Financial Aid. Only one record for a FA Base ID can have a value of Y
REC_LAST_UPDATED	DATE		Yes	Indicates the date and time on which the details were taken from OSS
ENCUMBRANCE_TYPE	VARCHAR2	(30)		Indicates encumbrance type for a student
VISA_TYPE	VARCHAR2	(30)		Indicates Visa type for a student
CITIZENSHIP_STATUS	VARCHAR2	(30)		Indicates citizenship status for a student
RESIDENCY_STATUS	VARCHAR2	(30)		Indicates residency status for a student
MIL_SERVICE_TYPE	VARCHAR2	(30)		Indicates military service type of a student if any
ADMISSION_APPL_NUMBER	NUMBER	(15)		Indicates admission application number of a student
ADM_APPL_STATUS	VARCHAR2	(30)		Indicates the user defined Admission Application status for the selected application for the student in OSS
S_ADM_APPL_STATUS	VARCHAR2	(30)		Indicates the System defined Admission Application status for the selected application for the student in OSS
APPL_DT	DATE			Admission Application Date
CLASS_STANDING	VARCHAR2	(60)		Current Class Standing of the student, for the primary program
PERSON_TYPE	VARCHAR2	(30)		Indicates person type of a student
CUR_ENROL_CREDIT_POINTS	NUMBER	(15)		Holds the Student Current Enrollment Credit Points
ADMISSION_CAT	VARCHAR2	(30)		The Admission Category for this Admission Application as set in OSS
S_ADMISSION_PROCESS_TYPE	VARCHAR2	(30)		Holds the System defined Admission Process Type for the Admission Category
PROG_ATT_COURSE_CD	VARCHAR2	(30)		Holds the program name which the student has applied during admission
PROG_ATT_VER_NUM	NUMBER	(15)		Holds the program version which the student has applied during admission
PROG_ATT_ATTEND_MODE	VARCHAR2	(30)		Holds the attendance mode for the student as in Admission Application form
PROG_ATT_ATTEND_TYPE	VARCHAR2	(30)		Holds the attendance type for the student as in Admission Application form
ADM_ORG_UNIT_CD	VARCHAR2	(30)		Responsible organizational unit for the admitted program
ADM_OUTCOME_STATUS	VARCHAR2	(30)		User-defined Admission outcome status for the admission application
S_ADM_OUTCOME_STATUS	VARCHAR2	(30)		System-defined Admission outcome status for the admission application
DECISION_DATE	DATE			Holds the admission outcome status date for the admission application
ADM_OFFER_RESP_STATUS	VARCHAR2	(30)		Holds the admission offer response status for the admission application
S_ADM_OFFER_RESP_STATUS	VARCHAR2	(30)		Holds the system defined admission offer response status for the admission application
ACTUAL_RESPONSE_DATE	DATE			Holds the Actual Admission offer responsible date
ADM_FEE_STATUS	VARCHAR2	(30)		Holds the user defined admission fee status for the admission application
S_ADM_FEE_STATUS	VARCHAR2	(30)		Holds the system defined admission fee status for the admission application
SP_PROGRAM_1	VARCHAR2	(30)		Indicates special program student has applied for
SP_PROGRAM_2	VARCHAR2	(30)		Indicates special program student has applied for
ENTRY_LEVEL	VARCHAR2	(30)		Indicates entry level of the student
ANTICIP_COMPL_DATE	DATE			Indicates the Anticipated completion of the program by the student. This is derived using the academic, admission calendar information, program attempted and attendance mode information.
ATHLETIC_SPORT_ID	NUMBER	(15)		Holds the identifier for the athletic sport as indicated by the student
ATHELETIC_SPORT	VARCHAR2	(30)		Holds the user defined athletic sport as indicated by the student
ACADEMIC_INDEX	VARCHAR2	(30)		Holds the admission index from the admission application
FINAL_UNIT_SET_COURSE_CD	VARCHAR2	(30)		Holds the Final Unit Set Course Code
FINAL_UNIT_SET_VER_NUM	NUMBER	(15)		Holds the Final Unit Set Details
PROG_ATT_START_DT	DATE			Holds the program attempt start Date
TRANSFERED	VARCHAR2	(30)		Indicates whether Student was transferred from another program
ATB	VARCHAR2	(30)		Y/N checkbox. This checkbox indicates whether the student in context has taken the "Ability to benefit" test. Below query will return a record,if the student has taken this test. No other conditions are checked here
ENRL_LOAD_CAL_TYPE	VARCHAR2	(30)		Holds the enrollment load calendar instance
ENRL_LOAD_SEQ_NUM	NUMBER	(15)		Holds the enrollment load calendar instance
SAP_EVALUATION_DATE	DATE			Indicates the last evaluation date for the academic progress.
SAP_SELECTED_FLAG	VARCHAR2	(30)		Indicates the academic progress for the student
ENRL_PRIMARY_PROG_COURSE_CD	VARCHAR2	(30)		Holds the primary program for the student
ENRL_PRIMARY_PROG_VER_NUM	NUMBER	(15)		Holds the primary program for the student
ENRL_PROGRAM_TYPE	VARCHAR2	(30)		Holds the program type
ENRL_COURSE_ATTEMPT_STATUS	VARCHAR2	(30)		Holds the program status
ENRL_USET_COURSE_CD	VARCHAR2	(30)		Holds the student Unit Set for the enrolled primary program
ENRL_USET_VER_NUM	NUMBER	(15)		Holds the student Unit Set for the enrolled primary program
DERIVED_ATTEND_TYPE	VARCHAR2	(30)		Holds the derived attendance type for the enrolled program
CURRENT_GPA	VARCHAR2	(30)		Holds the student current GPA
CUMULATIVE_GPA	VARCHAR2	(30)		Holds the student cumulative GPA
ACHEIVED_CR_PTS	VARCHAR2	(30)		Holds the student Archived credit points
PRED_CLASS_STANDING	VARCHAR2	(60)		Indicates the predictive class standing of the student for a program
ENRL_ORG_UNIT_CD	VARCHAR2	(30)		Indicates the responsible organizational unit for the primary program
ENRL_ATTEND_MODE	VARCHAR2	(30)		Holds the Enrollment Attendance mode
ENRL_LOCATION_CD	VARCHAR2	(30)		Holds the location code for the available for the program
ENRL_TOTAL_CP	NUMBER	(15)		Enrollment Total Credit Points
ENRL_CUML_CP	NUMBER	(15)		Enrollment Cumulative Credit Points
ENRL_CUML_TRANS_CP	NUMBER	(15)		Enrollment Cumulative Credit Points on transfer
ORG_ID	NUMBER	(15)		Operating Unit Identifier
CREATED_BY	NUMBER	(15)	Yes	Standard Who columns
CREATION_DATE	DATE		Yes	Standard Who columns
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who columns
LAST_UPDATE_DATE	DATE		Yes	Standard Who columns
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who columns
REQUEST_ID	NUMBER	(15)		Standard Who column for concurrent programs
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
KEY_PROGRAM	VARCHAR2	(30)		Identifies whether the enrolled program is a key program or not.

Query Text

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


SELECT FABH_ID
,      BASE_ID
,      PERSON_ID
,      PRIMARY_REC
,      REC_LAST_UPDATED
,      ENCUMBRANCE_TYPE
,      VISA_TYPE
,      CITIZENSHIP_STATUS
,      RESIDENCY_STATUS
,      MIL_SERVICE_TYPE
,      ADMISSION_APPL_NUMBER
,      ADM_APPL_STATUS
,      S_ADM_APPL_STATUS
,      APPL_DT
,      CLASS_STANDING
,      PERSON_TYPE
,      CUR_ENROL_CREDIT_POINTS
,      ADMISSION_CAT
,      S_ADMISSION_PROCESS_TYPE
,      PROG_ATT_COURSE_CD
,      PROG_ATT_VER_NUM
,      PROG_ATT_ATTEND_MODE
,      PROG_ATT_ATTEND_TYPE
,      ADM_ORG_UNIT_CD
,      ADM_OUTCOME_STATUS
,      S_ADM_OUTCOME_STATUS
,      DECISION_DATE
,      ADM_OFFER_RESP_STATUS
,      S_ADM_OFFER_RESP_STATUS
,      ACTUAL_RESPONSE_DATE
,      ADM_FEE_STATUS
,      S_ADM_FEE_STATUS
,      SP_PROGRAM_1
,      SP_PROGRAM_2
,      ENTRY_LEVEL
,      ANTICIP_COMPL_DATE
,      ATHLETIC_SPORT_ID
,      ATHELETIC_SPORT
,      ACADEMIC_INDEX
,      FINAL_UNIT_SET_COURSE_CD
,      FINAL_UNIT_SET_VER_NUM
,      PROG_ATT_START_DT
,      TRANSFERED
,      ATB
,      ENRL_LOAD_CAL_TYPE
,      ENRL_LOAD_SEQ_NUM
,      SAP_EVALUATION_DATE
,      SAP_SELECTED_FLAG
,      ENRL_PRIMARY_PROG_COURSE_CD
,      ENRL_PRIMARY_PROG_VER_NUM
,      ENRL_PROGRAM_TYPE
,      ENRL_COURSE_ATTEMPT_STATUS
,      ENRL_USET_COURSE_CD
,      ENRL_USET_VER_NUM
,      DERIVED_ATTEND_TYPE
,      CURRENT_GPA
,      CUMULATIVE_GPA
,      ACHEIVED_CR_PTS
,      PRED_CLASS_STANDING
,      ENRL_ORG_UNIT_CD
,      ENRL_ATTEND_MODE
,      ENRL_LOCATION_CD
,      ENRL_TOTAL_CP
,      ENRL_CUML_CP
,      ENRL_CUML_TRANS_CP
,      ORG_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      KEY_PROGRAM
FROM IGF.IGF_AP_FA_BASE_H_ALL;

Dependencies

[top of page]

IGF.IGF_AP_FA_BASE_H_ALL does not reference any database object

IGF.IGF_AP_FA_BASE_H_ALL is referenced by following:

APPS: IGF_AP_FA_BASE_H_ALL