[Home] [Help]
[Dependency Information]
VIEW: APPS.IGS_PS_VER
Object Details
Object Name: | IGS_PS_VER |
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGS.IGS_PS_VER
|
---|
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.
This view would be used in form
[View Source]
Columns
Name |
Datatype |
Length |
Mandatory |
Comments |
ROW_ID |
ROWID |
(10) |
|
|
COURSE_CD |
VARCHAR2 |
(6) |
Yes |
|
VERSION_NUMBER |
NUMBER |
(3) |
Yes |
|
START_DT |
DATE |
|
Yes |
|
REVIEW_DT |
DATE |
|
|
|
EXPIRY_DT |
DATE |
|
|
|
END_DT |
DATE |
|
|
|
COURSE_STATUS |
VARCHAR2 |
(10) |
Yes |
|
TITLE |
VARCHAR2 |
(90) |
Yes |
|
SHORT_TITLE |
VARCHAR2 |
(40) |
Yes |
|
ABBREVIATION |
VARCHAR2 |
(20) |
Yes |
|
SUPP_EXAM_PERMITTED_IND |
VARCHAR2 |
(1) |
Yes |
|
GENERIC_COURSE_IND |
VARCHAR2 |
(1) |
Yes |
|
GRADUATE_STUDENTS_IND |
VARCHAR2 |
(1) |
Yes |
|
COUNT_INTRMSN_IN_TIME_IND |
VARCHAR2 |
(1) |
Yes |
|
INTRMSN_ALLOWED_IND |
VARCHAR2 |
(1) |
Yes |
|
COURSE_TYPE |
VARCHAR2 |
(10) |
Yes |
|
RESPONSIBLE_ORG_UNIT_CD |
VARCHAR2 |
(30) |
Yes |
|
RESPONSIBLE_OU_START_DT |
DATE |
|
Yes |
|
GOVT_SPECIAL_COURSE_TYPE |
VARCHAR2 |
(2) |
Yes |
|
QUALIFICATION_RECENCY |
NUMBER |
(2) |
|
|
EXTERNAL_ADV_STND_LIMIT |
NUMBER |
(7) |
|
|
INTERNAL_ADV_STND_LIMIT |
NUMBER |
(7) |
|
|
CONTACT_HOURS |
NUMBER |
(7) |
|
|
CREDIT_POINTS_REQUIRED |
NUMBER |
(6) |
|
|
GOVT_COURSE_LOAD |
NUMBER |
(2) |
|
|
STD_ANNUAL_LOAD |
NUMBER |
(7) |
|
|
ANNUAL_INSTRUCTION_TIME |
NUMBER |
|
|
Annul Instruction Time of the program measured in weeks. |
COURSE_TOTAL_EFTSU |
NUMBER |
(5) |
|
|
STD_FT_COMPLETION_TIME |
NUMBER |
(3) |
|
OBSOLETE |
STD_PT_COMPLETION_TIME |
NUMBER |
(3) |
|
OBSOLETE |
MAX_INTRMSN_DURATION |
NUMBER |
(3) |
|
|
NUM_OF_UNITS_BEFORE_INTRMSN |
NUMBER |
(3) |
|
|
MIN_SBMSN_PERCENTAGE |
NUMBER |
(5) |
|
|
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) |
|
|
MAX_CP_PER_TEACHING_PERIOD |
NUMBER |
(6) |
|
|
APPROVAL_DATE |
DATE |
|
|
|
EXTERNAL_APPROVAL_DATE |
DATE |
|
|
|
RESIDENCY_CP_REQUIRED |
NUMBER |
(6) |
|
|
STATE_FINANCIAL_AID |
VARCHAR2 |
(1) |
|
|
FEDERAL_FINANCIAL_AID |
VARCHAR2 |
(1) |
|
|
INSTITUTIONAL_FINANCIAL_AID |
VARCHAR2 |
(1) |
|
|
MIN_CP_PER_CALENDAR |
NUMBER |
(5) |
|
|
REV_ACCOUNT_CD |
VARCHAR2 |
(40) |
|
|
PRIMARY_PROGRAM_RANK |
NUMBER |
(5) |
|
Primary Program Rank Higher the Value , Lower the Rank |
ATTRIBUTE_CATEGORY |
VARCHAR2 |
(30) |
|
|
ATTRIBUTE1 |
VARCHAR2 |
(150) |
|
|
ATTRIBUTE2 |
VARCHAR2 |
(150) |
|
|
ATTRIBUTE3 |
VARCHAR2 |
(150) |
|
|
ATTRIBUTE4 |
VARCHAR2 |
(150) |
|
|
ATTRIBUTE5 |
VARCHAR2 |
(150) |
|
|
ATTRIBUTE6 |
VARCHAR2 |
(150) |
|
|
ATTRIBUTE7 |
VARCHAR2 |
(150) |
|
|
ATTRIBUTE8 |
VARCHAR2 |
(150) |
|
|
ATTRIBUTE9 |
VARCHAR2 |
(150) |
|
|
ATTRIBUTE10 |
VARCHAR2 |
(150) |
|
|
ATTRIBUTE11 |
VARCHAR2 |
(150) |
|
|
ATTRIBUTE12 |
VARCHAR2 |
(150) |
|
|
ATTRIBUTE13 |
VARCHAR2 |
(150) |
|
|
ATTRIBUTE14 |
VARCHAR2 |
(150) |
|
|
ATTRIBUTE15 |
VARCHAR2 |
(150) |
|
|
ATTRIBUTE16 |
VARCHAR2 |
(150) |
|
|
ATTRIBUTE17 |
VARCHAR2 |
(150) |
|
|
ATTRIBUTE18 |
VARCHAR2 |
(150) |
|
|
ATTRIBUTE19 |
VARCHAR2 |
(150) |
|
|
ATTRIBUTE20 |
VARCHAR2 |
(150) |
|
|
ORG_ID |
NUMBER |
(15) |
|
|
MAX_WLST_PER_STUD |
NUMBER |
|
|
Maximum waitlists allowed per student |
Query Text
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, COURSE_CD
, VERSION_NUMBER
, START_DT
, REVIEW_DT
, EXPIRY_DT
, END_DT
, COURSE_STATUS
, TITLE
, SHORT_TITLE
, ABBREVIATION
, SUPP_EXAM_PERMITTED_IND
, GENERIC_COURSE_IND
, GRADUATE_STUDENTS_IND
, COUNT_INTRMSN_IN_TIME_IND
, INTRMSN_ALLOWED_IND
, COURSE_TYPE
, RESPONSIBLE_ORG_UNIT_CD
, RESPONSIBLE_OU_START_DT
, GOVT_SPECIAL_COURSE_TYPE
, QUALIFICATION_RECENCY
, EXTERNAL_ADV_STND_LIMIT
, INTERNAL_ADV_STND_LIMIT
, CONTACT_HOURS
, CREDIT_POINTS_REQUIRED
, GOVT_COURSE_LOAD
, STD_ANNUAL_LOAD
, ANNUAL_INSTRUCTION_TIME
, COURSE_TOTAL_EFTSU
, STD_FT_COMPLETION_TIME
, STD_PT_COMPLETION_TIME
, MAX_INTRMSN_DURATION
, NUM_OF_UNITS_BEFORE_INTRMSN
, MIN_SBMSN_PERCENTAGE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, MAX_CP_PER_TEACHING_PERIOD
, APPROVAL_DATE
, EXTERNAL_APPROVAL_DATE
, RESIDENCY_CP_REQUIRED
, STATE_FINANCIAL_AID
, FEDERAL_FINANCIAL_AID
, INSTITUTIONAL_FINANCIAL_AID
, MIN_CP_PER_CALENDAR
, REV_ACCOUNT_CD
, PRIMARY_PROGRAM_RANK
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE16
, ATTRIBUTE17
, ATTRIBUTE18
, ATTRIBUTE19
, ATTRIBUTE20
, ORG_ID
, MAX_WLST_PER_STUD
FROM APPS.IGS_PS_VER;
Dependencies
[top of page]
APPS.IGS_PS_VER references the following:
-
APPS
-
IGS_PS_VER_ALL
APPS.IGS_PS_VER is referenced by following:
-
APPS
-
IGF_AP_GEN_001
- show dependent code
-
IGF_AP_IA_LOOKUP_V
-
IGF_AP_OSS_INTEGR
- show dependent code
-
IGF_AP_OSS_INTR_DTLS
- show dependent code
-
IGF_AW_ANTICIPATED_DATA
- show dependent code
-
IGF_AW_COA_GEN
- show dependent code
-
IGF_AW_COA_GEN
- show dependent code
-
IGF_AW_FISAP_PKG
- show dependent code
-
IGF_AW_FUND_PRG_V
-
IGF_AW_PACKAGING
- show dependent code
-
IGF_GR_PELL_CALC
- show dependent code
-
IGF_GR_PELL_SETUP_V
-
IGF_SL_DL_VALIDATION
- show dependent code
-
IGF_SP_GEN_001
- show dependent code
-
IGF_SP_GEN_001
- show dependent code
-
IGF_SP_PRG_V
-
IGF_SP_STD_PRG_V
-
IGS_AD_ACAD_HISTORY_V
-
IGS_AD_DEPLVL_PRG_V
-
IGS_AD_GEN_002
- show dependent code
-
IGS_AD_GEN_004
- show dependent code
-
IGS_AD_GEN_010
- show dependent code
-
IGS_AD_GEN_011
- show dependent code
-
IGS_AD_GEN_013
- show dependent code
-
IGS_AD_GEN_014
- show dependent code
-
IGS_AD_KEY_ACAD_IND_V
-
IGS_AD_MKADM_DES_INT_V
-
IGS_AD_PANEL_DTLS_V
-
IGS_AD_PRC_TAC_OFFER
- show dependent code
-
IGS_AD_PS_APL_INST_CNTX_V
-
IGS_AD_PS_APPL_APLCNTX_V
-
IGS_AD_PS_APPL_INST_APLINST_V
-
IGS_AD_PS_APPL_INST_APLSUMR_V
-
IGS_AD_PS_APPL_INST_CONTEXT_V
-
IGS_AD_PS_APPL_INST_PKG
- show dependent code
-
IGS_AD_PS_APPL_PKG
- show dependent code
-
IGS_AD_RVGR_PROG_CD_V
-
IGS_AD_VAL_ACA
- show dependent code
-
IGS_AD_VAL_ACAI
- show dependent code
-
IGS_AD_VAL_ACAI_STATUS
- show dependent code
-
IGS_AD_VAL_CEPI
- show dependent code
-
IGS_AD_VAL_COOAC
- show dependent code
-
IGS_AD_VAL_CRS_ADMPERD
- show dependent code
-
IGS_AS_ADI_UPLD_PR_PKG
- show dependent code
-
IGS_AS_CALC_AWARD_MARK
- show dependent code
-
IGS_AS_GEN_001
- show dependent code
-
IGS_AS_GEN_003
- show dependent code
-
IGS_AS_GEN_004
- show dependent code
-
IGS_AS_GEN_005
- show dependent code
-
IGS_AS_GEN_006
- show dependent code
-
IGS_AS_GPC_PROGRAMS_V
-
IGS_AS_PRC_TRANSCRPT
- show dependent code
-
IGS_AS_SS_DOC_REQUEST
- show dependent code
-
IGS_AS_SS_DOC_REQUEST
- show dependent code
-
IGS_AS_SU_STMPTOUT_MID
-
IGS_AS_SU_STMPTOUT_V
-
IGS_AS_UAI_ETISTD_EXAM_V
-
IGS_AS_VAL_UAI
- show dependent code
-
IGS_AV_ADV_STANDING_PKG
- show dependent code
-
IGS_AV_GEN_001
- show dependent code
-
IGS_AV_LVL_LGCY_PUB
- show dependent code
-
IGS_AV_UNT_LGCY_PUB
- show dependent code
-
IGS_AV_VAL_ASU
- show dependent code
-
IGS_AV_VAL_ASULEB
- show dependent code
-
IGS_DA_CNFG_REQ_TYP_V
-
IGS_DA_REQ_STDNTS_V
-
IGS_DA_REQ_WIF_V
-
IGS_DA_TRNS_IMP
- show dependent code
-
IGS_DA_XML_ACADEMICPROGRAM_V
-
IGS_DA_XML_PKG
- show dependent code
-
IGS_EN_CAREER_MODEL
- show dependent code
-
IGS_EN_ELGBL_OVERRIDE
- show dependent code
-
IGS_EN_ELGBL_PROGRAM
- show dependent code
-
IGS_EN_ELGBL_UNIT
- show dependent code
-
IGS_EN_FUTURE_DT_TRANS
- show dependent code
-
IGS_EN_GEN_002
- show dependent code
-
IGS_EN_GEN_003
- show dependent code
-
IGS_EN_GEN_005
- show dependent code
-
IGS_EN_GEN_006
- show dependent code
-
IGS_EN_GEN_008
- show dependent code
-
IGS_EN_GEN_010
- show dependent code
-
IGS_EN_GEN_011
- show dependent code
-
IGS_EN_GEN_012
- show dependent code
-
IGS_EN_GEN_015
- show dependent code
-
IGS_EN_GEN_016
- show dependent code
-
IGS_EN_GEN_017
- show dependent code
-
IGS_EN_GEN_LEGACY
- show dependent code
-
IGS_EN_GEN_LEGACY
- show dependent code
-
IGS_EN_IVR_PUB
- show dependent code
-
IGS_EN_NSC_PKG
- show dependent code
-
IGS_EN_OR_UNIT_WLST_PRF_V
-
IGS_EN_PE_PRG_CTXT_V
-
IGS_EN_PRC_LOAD
- show dependent code
-
IGS_EN_PS_ATT_CH_OPT_V
-
IGS_EN_SCA_V
-
IGS_EN_SPAT_LGCY_PUB
- show dependent code
-
IGS_EN_SPA_LGCY_PUB
- show dependent code
-
IGS_EN_SPA_TERMS_API
- show dependent code
-
IGS_EN_SPA_TERMS_V
-
IGS_EN_SS_SCHEDULE_DISP_V
-
IGS_EN_SS_STUD_CONTEXT_V
-
IGS_EN_STDNT_COURSE_ATTEMPT_V
-
IGS_EN_STDNT_PS_ATT_CRV_V
-
IGS_EN_STDNT_PS_ATT_PKG
- show dependent code
-
IGS_EN_ST_SNAPSHOT_WARNING_V
-
IGS_EN_SUA_API
- show dependent code
-
IGS_EN_SUA_LGCY_PUB
- show dependent code
-
IGS_EN_SUA_WLST_V
-
IGS_EN_SU_ATTEMPT_PKG
- show dependent code
-
IGS_EN_TIMESLOTS
- show dependent code
-
IGS_EN_TIMESLOT_PREF_V
-
IGS_EN_TRANSFER_APIS
- show dependent code
-
IGS_EN_VAL_SCA
- show dependent code
-
IGS_EN_VAL_SCHO
- show dependent code
-
IGS_EN_VAL_SCI
- show dependent code
-
IGS_EN_VAL_SCT
- show dependent code
-
IGS_EN_WLST_GEN_PROC
- show dependent code
-
IGS_EN_WORKFLOW
- show dependent code
-
IGS_FI_1098T_EXTRACT_DATA
- show dependent code
-
IGS_FI_ACCT_STP_CNV
- show dependent code
-
IGS_FI_CHARGES_API_PVT
- show dependent code
-
IGS_FI_COM_REC_INTERFACE
- show dependent code
-
IGS_FI_FD_SRC_RSTN_H_V
-
IGS_FI_FEE_AS_RATE_V
-
IGS_FI_FEE_TRG_GRP_V
-
IGS_FI_GEN_001
- show dependent code
-
IGS_FI_GEN_004
- show dependent code
-
IGS_FI_GEN_004
- show dependent code
-
IGS_FI_GEN_005
- show dependent code
-
IGS_FI_GEN_008
- show dependent code
-
IGS_FI_GEN_008
- show dependent code
-
IGS_FI_PRC_FEE_ASS
- show dependent code
-
IGS_FI_PRC_SP_FEES
- show dependent code
-
IGS_FI_PRC_STDNT_DPSTS
- show dependent code
-
IGS_FI_VAL_CFT
- show dependent code
-
IGS_GE_VAL_PARAM
- show dependent code
-
IGS_GR_GEN_002
- show dependent code
-
IGS_GR_VAL_GR
- show dependent code
-
IGS_HE_EXTRACT2_PKG
- show dependent code
-
IGS_HE_EXTRACT_FIELDS_PKG
- show dependent code
-
IGS_HE_EXTRACT_FIELDS_PKG
- show dependent code
-
IGS_HE_EXTRACT_PKG
- show dependent code
-
IGS_HE_FTE_CALC_PKG
- show dependent code
-
IGS_HE_IDENTIFY_TARGET_POP
- show dependent code
-
IGS_HE_IMPORT_DATA
- show dependent code
-
IGS_HE_POOUS_DTLS_V
-
IGS_HE_POO_DTLS_V
-
IGS_HE_ST_PRG_DTLS_V
-
IGS_IN_GEN_001
- show dependent code
-
IGS_PE_PRG_ATP_V
-
IGS_PR_ACAD_LOAD_V
-
IGS_PR_ACAD_UNIT_V
-
IGS_PR_COHORT_INST_RANK_V
-
IGS_PR_CP_GPA
- show dependent code
-
IGS_PR_GEN_001
- show dependent code
-
IGS_PR_GEN_004
- show dependent code
-
IGS_PR_GEN_005
- show dependent code
-
IGS_PR_GEN_006
- show dependent code
-
IGS_PR_GET_CLASS_STD
- show dependent code
-
IGS_PR_PROG_OUT_WF_PKG
- show dependent code
-
IGS_PR_SCA_PRG_RULE_APPL_V
-
IGS_PR_STDNT_PR_OU_V
-
IGS_PR_STD_PRG_AWD_AIM_V
-
IGS_PR_STU_ACAD_V
-
IGS_PR_UPLOAD_EXT_RESULTS
- show dependent code
-
IGS_PR_VAL_POC
- show dependent code
-
IGS_PR_VAL_PRA
- show dependent code
-
IGS_PS_ENT_PT_REF_CD_PKG
- show dependent code
-
IGS_PS_FLD_STUDY_HIST_V
-
IGS_PS_GEN_001
- show dependent code
-
IGS_PS_GEN_002
- show dependent code
-
IGS_PS_GEN_003
- show dependent code
-
IGS_PS_GEN_004
- show dependent code
-
IGS_PS_GEN_007
- show dependent code
-
IGS_PS_OCCUP_TITLES_V
-
IGS_PS_OFR_INST_PKG
- show dependent code
-
IGS_PS_OFR_OPT_PKG
- show dependent code
-
IGS_PS_OFR_PAT_APCOOD_PAT_V
-
IGS_PS_OFR_PAT_OFERPAT_V
-
IGS_PS_OFR_PAT_PKG
- show dependent code
-
IGS_PS_OFR_PAT_V
-
IGS_PS_OFR_PKG
- show dependent code
-
IGS_PS_OFR_VERSION_V
-
IGS_PS_OWN_HIST_V
-
IGS_PS_REF_CD_HIST_V
-
IGS_PS_RSV_ORGUN_PRF_V
-
IGS_PS_RSV_UOP_PRF_V
-
IGS_PS_RSV_USEC_PRF_V
-
IGS_PS_UOFR_WLST_PRF_V
-
IGS_PS_USEC_WLST_PRF_V
-
IGS_PS_VALIDATE_GENERIC_PKG
- show dependent code
-
IGS_PS_VAL_CAO
- show dependent code
-
IGS_PS_VAL_CAW
- show dependent code
-
IGS_PS_VAL_CFOS
- show dependent code
-
IGS_PS_VAL_COUS
- show dependent code
-
IGS_PS_VAL_COW
- show dependent code
-
IGS_PS_VAL_CRS
- show dependent code
-
IGS_PS_VAL_CRV
- show dependent code
-
IGS_PS_VAL_CTY
- show dependent code
-
IGS_PS_VER_HIST_V
-
IGS_PS_VER_PKG
- show dependent code
-
IGS_PS_VER_RU_V
-
IGS_PS_VER_TITLE_V
-
IGS_PS_VER_V
-
IGS_PT_GEN_PKG
- show dependent code
-
IGS_RE_GEN_001
- show dependent code
-
IGS_RE_GEN_002
- show dependent code
-
IGS_RE_VAL_CA
- show dependent code
-
IGS_RE_WORKFLOW
- show dependent code
-
IGS_RU_GEN_001
- show dependent code
-
IGS_RU_GEN_002
- show dependent code
-
IGS_SS_ENROLL_PKG
- show dependent code
-
IGS_SS_ENR_DETAILS
- show dependent code
-
IGS_ST_GEN_001
- show dependent code
-
IGS_ST_GEN_002
- show dependent code
-
IGS_ST_GEN_003
- show dependent code
-
IGS_ST_GEN_004
- show dependent code
-
IGS_UC_EXPORT_TO_OSS
- show dependent code
-
IGS_UC_UCAPCH_OSSAPPL_V