[Home] [Help]
[Dependency Information]
[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
IGS_CA_INST
IGS_FI_ENCMB_TYPE
APPS.IGF_AP_FA_BASE_H_V is not referenced by any database object
|
|
|
|