[Home] [Help] [Dependency Information]
Object Name: | IGF_AP_FA_BASE_H_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGF.IGF_AP_FA_BASE_H_V |
Subobject Name: | |
Status: | VALID |
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | ||
FABH_ID | NUMBER | (15) | Yes | |
BASE_ID | NUMBER | (15) | Yes | |
PERSON_ID | NUMBER | (15) | Yes | |
PRIMARY_REC | VARCHAR2 | (30) | Yes | |
REC_LAST_UPDATED | DATE | Yes | ||
ENCUMBRANCE_TYPE | VARCHAR2 | (30) | ||
ENCUMBRANCE_DESC | VARCHAR2 | (60) | ||
VISA_TYPE | VARCHAR2 | (30) | ||
CITIZENSHIP_STATUS | VARCHAR2 | (30) | ||
RESIDENCY_STATUS | VARCHAR2 | (30) | ||
MIL_SERVICE_TYPE | VARCHAR2 | (30) | ||
ADMISSION_APPL_NUMBER | NUMBER | (15) | ||
ADM_APPL_STATUS | VARCHAR2 | (30) | ||
S_ADM_APPL_STATUS | VARCHAR2 | (30) | ||
APPL_DT | DATE | |||
CLASS_STANDING | VARCHAR2 | (60) | ||
PERSON_TYPE | VARCHAR2 | (30) | ||
CUR_ENROL_CREDIT_POINTS | NUMBER | (15) | ||
ADMISSION_CAT | VARCHAR2 | (30) | ||
S_ADMISSION_PROCESS_TYPE | VARCHAR2 | (30) | ||
PROGRAM_ATTEMPT | VARCHAR2 | (71) | ||
PROG_ATT_COURSE_CD | VARCHAR2 | (30) | ||
PROG_ATT_VER_NUM | NUMBER | (15) | ||
PROG_ATT_ATTEND_MODE | VARCHAR2 | (30) | ||
PROG_ATT_ATTEND_TYPE | VARCHAR2 | (30) | ||
ADM_ORG_UNIT_CD | VARCHAR2 | (30) | ||
ADM_OUTCOME_STATUS | VARCHAR2 | (30) | ||
S_ADM_OUTCOME_STATUS | VARCHAR2 | (30) | ||
DECISION_DATE | DATE | |||
ADM_OFFER_RESP_STATUS | VARCHAR2 | (30) | ||
S_ADM_OFFER_RESP_STATUS | VARCHAR2 | (30) | ||
ACTUAL_RESPONSE_DATE | DATE | |||
ADM_FEE_STATUS | VARCHAR2 | (30) | ||
S_ADM_FEE_STATUS | VARCHAR2 | (30) | ||
SP_PROGRAM_1 | VARCHAR2 | (30) | ||
SP_PROGRAM_2 | VARCHAR2 | (30) | ||
ENTRY_LEVEL | VARCHAR2 | (30) | ||
ANTICIP_COMPL_DATE | DATE | |||
ATHLETIC_SPORT_ID | NUMBER | (15) | ||
ATHELETIC_SPORT | VARCHAR2 | (30) | ||
ACADEMIC_INDEX | VARCHAR2 | (30) | ||
FINAL_UNIT_SET | VARCHAR2 | (71) | ||
FINAL_UNIT_SET_COURSE_CD | VARCHAR2 | (30) | ||
FINAL_UNIT_SET_VER_NUM | NUMBER | (15) | ||
PROG_ATT_START_DT | DATE | |||
TRANSFERED | VARCHAR2 | (30) | ||
ATB | VARCHAR2 | (30) | ||
ENROLLED_TERM | VARCHAR2 | (10) | ||
ENRL_LOAD_CAL_TYPE | VARCHAR2 | (30) | ||
ENRL_LOAD_SEQ_NUM | NUMBER | (15) | ||
SAP_EVALUATION_DATE | DATE | |||
SAP_SELECTED_FLAG | VARCHAR2 | (30) | ||
ENRL_PRIMARY_PROGRAM | VARCHAR2 | (71) | ||
ENRL_PRIMARY_PROG_COURSE_CD | VARCHAR2 | (30) | ||
ENRL_PRIMARY_PROG_VER_NUM | NUMBER | (15) | ||
ENRL_PROGRAM_TYPE | VARCHAR2 | (30) | ||
ENRL_UNIT_SET | VARCHAR2 | (71) | ||
ENRL_USET_COURSE_CD | VARCHAR2 | (30) | ||
ENRL_USET_VER_NUM | NUMBER | (15) | ||
ENRL_COURSE_ATTEMPT_STATUS | VARCHAR2 | (30) | ||
DERIVED_ATTEND_TYPE | VARCHAR2 | (30) | ||
CURRENT_GPA | VARCHAR2 | (30) | ||
CUMULATIVE_GPA | VARCHAR2 | (30) | ||
ACHEIVED_CR_PTS | VARCHAR2 | (30) | ||
PRED_CLASS_STANDING | VARCHAR2 | (60) | ||
ENRL_ORG_UNIT_CD | VARCHAR2 | (30) | ||
ENRL_ATTEND_MODE | VARCHAR2 | (30) | ||
ENRL_LOCATION_CD | VARCHAR2 | (30) | ||
ENRL_TOTAL_CP | NUMBER | (15) | ||
ENRL_CUML_CP | NUMBER | (15) | ||
ENRL_CUML_TRANS_CP | NUMBER | (15) | ||
ORG_ID | NUMBER | (15) | ||
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 | |||
KEY_PROGRAM | VARCHAR2 | (30) |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, FABH_ID
, BASE_ID
, PERSON_ID
, PRIMARY_REC
, REC_LAST_UPDATED
, ENCUMBRANCE_TYPE
, ENCUMBRANCE_DESC
, 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
, PROGRAM_ATTEMPT
, 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
, FINAL_UNIT_SET_COURSE_CD
, FINAL_UNIT_SET_VER_NUM
, PROG_ATT_START_DT
, TRANSFERED
, ATB
, ENROLLED_TERM
, ENRL_LOAD_CAL_TYPE
, ENRL_LOAD_SEQ_NUM
, SAP_EVALUATION_DATE
, SAP_SELECTED_FLAG
, ENRL_PRIMARY_PROGRAM
, ENRL_PRIMARY_PROG_COURSE_CD
, ENRL_PRIMARY_PROG_VER_NUM
, ENRL_PROGRAM_TYPE
, ENRL_UNIT_SET
, ENRL_USET_COURSE_CD
, ENRL_USET_VER_NUM
, ENRL_COURSE_ATTEMPT_STATUS
, 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 APPS.IGF_AP_FA_BASE_H_V;
APPS.IGF_AP_FA_BASE_H_V is not referenced by any database object
|
|
|