[Home] [Help]
[Dependency Information]
VIEW: APPS.IGS_PS_TYPE
Object Details
Object Name: | IGS_PS_TYPE |
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGS.IGS_PS_TYPE
|
---|
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.
Multi Org view for IGS_PS_TYPE_ALL table, which stores the information about the program types.
[View Source]
Columns
Name |
Datatype |
Length |
Mandatory |
Comments |
ROW_ID |
ROWID |
(10) |
|
|
COURSE_TYPE |
VARCHAR2 |
(10) |
Yes |
|
DESCRIPTION |
VARCHAR2 |
(60) |
Yes |
|
GOVT_COURSE_TYPE |
NUMBER |
(2) |
Yes |
|
AWARD_COURSE_IND |
VARCHAR2 |
(1) |
Yes |
|
COURSE_TYPE_GROUP_CD |
VARCHAR2 |
(10) |
|
|
TAC_COURSE_LEVEL |
VARCHAR2 |
(4) |
|
|
RESEARCH_TYPE_IND |
VARCHAR2 |
(1) |
Yes |
|
CLOSED_IND |
VARCHAR2 |
(1) |
Yes |
|
PRIMARY_AUTO_SELECT |
VARCHAR2 |
(1) |
|
Y/N Field, Default 'Y' |
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) |
|
|
ORG_ID |
NUMBER |
(15) |
|
|
ENROLMENT_CAT |
VARCHAR2 |
(10) |
|
|
FIN_AID_PROGRAM_TYPE |
VARCHAR2 |
(30) |
|
A system defined program type that is used by Financial Aid. |
Query Text
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, COURSE_TYPE
, DESCRIPTION
, GOVT_COURSE_TYPE
, AWARD_COURSE_IND
, COURSE_TYPE_GROUP_CD
, TAC_COURSE_LEVEL
, RESEARCH_TYPE_IND
, CLOSED_IND
, PRIMARY_AUTO_SELECT
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, ORG_ID
, ENROLMENT_CAT
, FIN_AID_PROGRAM_TYPE
FROM APPS.IGS_PS_TYPE;
Dependencies
[top of page]
APPS.IGS_PS_TYPE references the following:
-
APPS
-
IGS_PS_TYPE_ALL
APPS.IGS_PS_TYPE is referenced by following:
-
APPS
-
IGF_AP_PR_PRG_TYPE_V
-
IGS_AD_DEPLVL_PRGTY_V
-
IGS_AD_GEN_002
- show dependent code
-
IGS_AD_VAL_ACAI
- show dependent code
-
IGS_AD_VAL_ACAI_STATUS
- show dependent code
-
IGS_AD_VAL_CRS_ADMPERD
- show dependent code
-
IGS_AS_GEN_001
- show dependent code
-
IGS_AS_SS_DOC_REQUEST
- show dependent code
-
IGS_AS_VAL_ACOT
- show dependent code
-
IGS_EN_ADD_UNITS_API
- show dependent code
-
IGS_EN_CAREER_MODEL
- show dependent code
-
IGS_EN_DROP_UNITS_API
- show dependent code
-
IGS_EN_ELGBL_UNIT
- show dependent code
-
IGS_EN_GEN_003
- show dependent code
-
IGS_EN_GEN_005
- 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_016
- show dependent code
-
IGS_EN_GEN_LEGACY
- show dependent code
-
IGS_EN_GEN_LEGACY
- show dependent code
-
IGS_EN_NSC_PKG
- show dependent code
-
IGS_EN_PLAN_UTILS
- show dependent code
-
IGS_EN_SPA_LGCY_PUB
- show dependent code
-
IGS_EN_STDNT_PS_ATT_PKG
- show dependent code
-
IGS_EN_TIMESLOTS
- show dependent code
-
IGS_EN_TIMESLOT_PREF_V
-
IGS_EN_TRANSFER_APIS
- show dependent code
-
IGS_EN_UNIT_SET_COURSE_TYPE_V
-
IGS_EN_VAL_SCA
- show dependent code
-
IGS_EN_VAL_SCHO
- show dependent code
-
IGS_EN_VAL_SUA
- show dependent code
-
IGS_GE_VAL_PARAM
- show dependent code
-
IGS_HE_IDENTIFY_TARGET_POP
- show dependent code
-
IGS_PR_ACAD_PROGRAM_V
-
IGS_PR_CS_SCHDL_V
-
IGS_PR_GET_CLASS_STD
- show dependent code
-
IGS_PS_GEN_002
- show dependent code
-
IGS_PS_TYPE_HIST_V
-
IGS_PS_TYPE_V
-
IGS_PS_VAL_CAW
- show dependent code
-
IGS_PS_VAL_CRV
- show dependent code
-
IGS_PS_VAL_CTY
- show dependent code
-
IGS_PS_VAL_CUL
- show dependent code
-
IGS_PS_VAL_GCT
- show dependent code
-
IGS_PS_VER_HIST_V
-
IGS_RE_GEN_002
- show dependent code
-
IGS_RE_VAL_CA
- 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