DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.IGS_PS_UNIT_VER

Object Details
Object Name: IGS_PS_UNIT_VER
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIGS.IGS_PS_UNIT_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.

[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
UNIT_CD VARCHAR2 (10) Yes
VERSION_NUMBER NUMBER (3) Yes
START_DT DATE
Yes
REVIEW_DT DATE

EXPIRY_DT DATE

END_DT DATE

UNIT_STATUS VARCHAR2 (10) Yes
TITLE VARCHAR2 (90) Yes
SHORT_TITLE VARCHAR2 (40) Yes
TITLE_OVERRIDE_IND VARCHAR2 (1) Yes
ABBREVIATION VARCHAR2 (20) Yes
UNIT_LEVEL VARCHAR2 (4) Yes
CREDIT_POINT_DESCRIPTOR VARCHAR2 (30) Yes
ENROLLED_CREDIT_POINTS NUMBER (6) Yes
POINTS_OVERRIDE_IND VARCHAR2 (1) Yes
SUPP_EXAM_PERMITTED_IND VARCHAR2 (1) Yes
COORD_PERSON_ID NUMBER (15) Yes
OWNER_ORG_UNIT_CD VARCHAR2 (30) Yes
OWNER_OU_START_DT DATE
Yes
AWARD_COURSE_ONLY_IND VARCHAR2 (1) Yes
RESEARCH_UNIT_IND VARCHAR2 (1) Yes
SUB_UNIT_ALLOWED_IND VARCHAR2 (1)
Case and Seed document: PS202_SuperiorStructure_PS_3052452_CS_DP2.doc - Obsolete
SUP_UNIT_ALLOWED_IND VARCHAR2 (1)
Case and Seed document: PS202_SuperiorStructure_PS_3052452_CS_DP2.doc - Obsolete
INDUSTRIAL_IND VARCHAR2 (1) Yes
PRACTICAL_IND VARCHAR2 (1) Yes
REPEATABLE_IND VARCHAR2 (1) Yes
ASSESSABLE_IND VARCHAR2 (1) Yes
ACHIEVABLE_CREDIT_POINTS NUMBER (6)
POINTS_INCREMENT NUMBER (6)
POINTS_MIN NUMBER (6)
POINTS_MAX NUMBER (6)
UNIT_INT_COURSE_LEVEL_CD VARCHAR2 (10)
SUBTITLE_ID NUMBER

SUBTITLE VARCHAR2 (90)
OBSOLETE
SUBTITLE_MODIFIABLE_FLAG VARCHAR2 (1)
APPROVAL_DATE DATE

LECTURE_CREDIT_POINTS NUMBER (6)
LAB_CREDIT_POINTS NUMBER (6)
OTHER_CREDIT_POINTS NUMBER (6)
CLOCK_HOURS NUMBER (6)
BILLING_CREDIT_POINTS NUMBER

Audit Credit Points
WORK_LOAD_CP_LECTURE NUMBER (6)
WORK_LOAD_CP_LAB NUMBER (6)
CONTINUING_EDUCATION_UNITS NUMBER (6)
ENROLLMENT_EXPECTED NUMBER

ENROLLMENT_MINIMUM NUMBER

ENROLLMENT_MAXIMUM NUMBER

ADVANCE_MAXIMUM NUMBER

STATE_FINANCIAL_AID VARCHAR2 (1)
FEDERAL_FINANCIAL_AID VARCHAR2 (1)
INSTITUTIONAL_FINANCIAL_AID VARCHAR2 (1)
SAME_TEACHING_PERIOD VARCHAR2 (1)
MAX_REPEATS_FOR_CREDIT NUMBER

MAX_REPEATS_FOR_FUNDING NUMBER

MAX_REPEAT_CREDIT_POINTS NUMBER (6)
SAME_TEACH_PERIOD_REPEATS NUMBER

SAME_TEACH_PERIOD_REPEATS_CP NUMBER (6)
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)
WORK_LOAD_OTHER NUMBER (5)
CONTACT_HRS_LECTURE NUMBER (5)
CONTACT_HRS_LAB NUMBER (5)
CONTACT_HRS_OTHER NUMBER (5)
BILLING_HRS NUMBER

Billable Credit Points
NON_SCHD_REQUIRED_HRS NUMBER (5)
FIN_AID_CP NUMBER (5)
Financial Aid Credit Points - Obsolete
FIN_AID_HRS NUMBER (5)
Financial Aid Hours - Obsolete
EXCLUDE_FROM_MAX_CP_LIMIT VARCHAR2 (1)
RECORD_EXCLUSION_FLAG VARCHAR2 (1)
SS_DISPLAY_IND VARCHAR2 (1)
CAL_TYPE_ENROL_LOAD_CAL VARCHAR2 (10)
SEQUENCE_NUM_ENROL_LOAD_CAL NUMBER (6)
CAL_TYPE_OFFER_LOAD_CAL VARCHAR2 (10)
SEQUENCE_NUM_OFFER_LOAD_CAL NUMBER (6)
CURRICULUM_ID VARCHAR2 (10)
OVERRIDE_ENROLLMENT_MAX NUMBER (6)
RPT_FMLY_ID NUMBER

UNIT_TYPE_ID NUMBER

SPECIAL_PERMISSION_IND VARCHAR2 (1)
SS_ENROL_IND VARCHAR2 (1)
IVR_ENROL_IND VARCHAR2 (1)
REV_ACCOUNT_CD VARCHAR2 (40)
CLAIMABLE_HOURS NUMBER (7)
The maximum hours that a student in a class can claim
ANON_UNIT_GRADING_IND VARCHAR2 (1)
Anonymous Unit Grading Y / N
ANON_ASSESS_GRADING_IND VARCHAR2 (1)
Anonymous Assessment Item Grading Y / N
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)
AUDITABLE_IND VARCHAR2 (1)
Indicates if a unit can be audited
AUDIT_PERMISSION_IND VARCHAR2 (1)
Indicates if permission is required to audit
MAX_AUDITORS_ALLOWED NUMBER (6)
Indicates maximum number of auditors allowed
OVRD_WKLD_VAL_FLAG VARCHAR2 (1)
Override workload validation flag
WORKLOAD_VAL_CODE VARCHAR2 (30)
Workload validation type
Query Text

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


SELECT ROW_ID
,      UNIT_CD
,      VERSION_NUMBER
,      START_DT
,      REVIEW_DT
,      EXPIRY_DT
,      END_DT
,      UNIT_STATUS
,      TITLE
,      SHORT_TITLE
,      TITLE_OVERRIDE_IND
,      ABBREVIATION
,      UNIT_LEVEL
,      CREDIT_POINT_DESCRIPTOR
,      ENROLLED_CREDIT_POINTS
,      POINTS_OVERRIDE_IND
,      SUPP_EXAM_PERMITTED_IND
,      COORD_PERSON_ID
,      OWNER_ORG_UNIT_CD
,      OWNER_OU_START_DT
,      AWARD_COURSE_ONLY_IND
,      RESEARCH_UNIT_IND
,      SUB_UNIT_ALLOWED_IND
,      SUP_UNIT_ALLOWED_IND
,      INDUSTRIAL_IND
,      PRACTICAL_IND
,      REPEATABLE_IND
,      ASSESSABLE_IND
,      ACHIEVABLE_CREDIT_POINTS
,      POINTS_INCREMENT
,      POINTS_MIN
,      POINTS_MAX
,      UNIT_INT_COURSE_LEVEL_CD
,      SUBTITLE_ID
,      SUBTITLE
,      SUBTITLE_MODIFIABLE_FLAG
,      APPROVAL_DATE
,      LECTURE_CREDIT_POINTS
,      LAB_CREDIT_POINTS
,      OTHER_CREDIT_POINTS
,      CLOCK_HOURS
,      BILLING_CREDIT_POINTS
,      WORK_LOAD_CP_LECTURE
,      WORK_LOAD_CP_LAB
,      CONTINUING_EDUCATION_UNITS
,      ENROLLMENT_EXPECTED
,      ENROLLMENT_MINIMUM
,      ENROLLMENT_MAXIMUM
,      ADVANCE_MAXIMUM
,      STATE_FINANCIAL_AID
,      FEDERAL_FINANCIAL_AID
,      INSTITUTIONAL_FINANCIAL_AID
,      SAME_TEACHING_PERIOD
,      MAX_REPEATS_FOR_CREDIT
,      MAX_REPEATS_FOR_FUNDING
,      MAX_REPEAT_CREDIT_POINTS
,      SAME_TEACH_PERIOD_REPEATS
,      SAME_TEACH_PERIOD_REPEATS_CP
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      ORG_ID
,      WORK_LOAD_OTHER
,      CONTACT_HRS_LECTURE
,      CONTACT_HRS_LAB
,      CONTACT_HRS_OTHER
,      BILLING_HRS
,      NON_SCHD_REQUIRED_HRS
,      FIN_AID_CP
,      FIN_AID_HRS
,      EXCLUDE_FROM_MAX_CP_LIMIT
,      RECORD_EXCLUSION_FLAG
,      SS_DISPLAY_IND
,      CAL_TYPE_ENROL_LOAD_CAL
,      SEQUENCE_NUM_ENROL_LOAD_CAL
,      CAL_TYPE_OFFER_LOAD_CAL
,      SEQUENCE_NUM_OFFER_LOAD_CAL
,      CURRICULUM_ID
,      OVERRIDE_ENROLLMENT_MAX
,      RPT_FMLY_ID
,      UNIT_TYPE_ID
,      SPECIAL_PERMISSION_IND
,      SS_ENROL_IND
,      IVR_ENROL_IND
,      REV_ACCOUNT_CD
,      CLAIMABLE_HOURS
,      ANON_UNIT_GRADING_IND
,      ANON_ASSESS_GRADING_IND
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      AUDITABLE_IND
,      AUDIT_PERMISSION_IND
,      MAX_AUDITORS_ALLOWED
,      OVRD_WKLD_VAL_FLAG
,      WORKLOAD_VAL_CODE
FROM APPS.IGS_PS_UNIT_VER;

Dependencies

[top of page]

APPS.IGS_PS_UNIT_VER references the following:

SchemaAPPS
SynonymIGS_PS_UNIT_VER_ALL
APPS.IGS_PS_UNIT_VER is referenced by following:

SchemaAPPS
ViewIGF_AW_FUND_UNIT_V
PL/SQL PackageIGF_SP_GEN_001 - show dependent code
Package BodyIGF_SP_GEN_001 - show dependent code
ViewIGF_SP_STD_UNIT_V
ViewIGF_SP_UNIT_V
Package BodyIGS_AD_GEN_002 - show dependent code
Package BodyIGS_AD_GEN_010 - show dependent code
ViewIGS_AD_PS_APLINSTUNT_APLUNIT_V
ViewIGS_AD_UNIT_PLACEMENTS_V
ViewIGS_AD_UP_DETAIL_V
Package BodyIGS_AD_VAL_ACAIU - show dependent code
PL/SQL PackageIGS_AS_CALC_AWARD_MARK - show dependent code
Package BodyIGS_AS_CALC_AWARD_MARK - show dependent code
Package BodyIGS_AS_GEN_001 - show dependent code
Package BodyIGS_AS_GEN_003 - show dependent code
Package BodyIGS_AS_GEN_004 - show dependent code
Package BodyIGS_AS_GEN_005 - show dependent code
Package BodyIGS_AS_GEN_006 - show dependent code
Package BodyIGS_AS_GEN_007 - show dependent code
Package BodyIGS_AS_INCOMP_GRADE - show dependent code
Package BodyIGS_AS_NOTIFY_PKG - show dependent code
Package BodyIGS_AS_PRC_TRANSCRPT - show dependent code
ViewIGS_AS_SU_ATTEMPT_LKUP_V
ViewIGS_AS_SU_STMPTOUT_MID
ViewIGS_AS_SU_STMPTOUT_V
ViewIGS_AS_UAI_ETISTD_EXAM_V
ViewIGS_AS_UAI_EXAMINATION_V
Package BodyIGS_AS_VAL_EI - show dependent code
Package BodyIGS_AS_VAL_NESO - show dependent code
Package BodyIGS_AU_GEN_003 - show dependent code
Package BodyIGS_AV_GEN_001 - show dependent code
ViewIGS_AV_STND_UNIT_CREDIT_V
ViewIGS_AV_STND_UNIT_V
Package BodyIGS_AV_UNT_LGCY_PUB - show dependent code
Package BodyIGS_AV_VAL_ASU - show dependent code
Package BodyIGS_CA_VAL_QLITY - show dependent code
Package BodyIGS_DA_TRNS_IMP - show dependent code
ViewIGS_DA_XML_COURSEINSTITUTION_V
ViewIGS_DA_XML_COURSE_V
PL/SQL PackageIGS_DA_XML_PKG - show dependent code
Package BodyIGS_DA_XML_PKG - show dependent code
Package BodyIGS_EN_ELGBL_OVERRIDE - show dependent code
Package BodyIGS_EN_ELGBL_PROGRAM - show dependent code
Package BodyIGS_EN_ELGBL_UNIT - show dependent code
Package BodyIGS_EN_ELGB_OVR_UOO_PKG - show dependent code
ViewIGS_EN_ELGB_OVR_UOO_V
Package BodyIGS_EN_ENROLL_WLST - show dependent code
Package BodyIGS_EN_GEN_001 - show dependent code
Package BodyIGS_EN_GEN_005 - show dependent code
Package BodyIGS_EN_GEN_009 - show dependent code
Package BodyIGS_EN_GEN_011 - show dependent code
Package BodyIGS_EN_GEN_015 - show dependent code
Package BodyIGS_EN_GEN_018 - show dependent code
Package BodyIGS_EN_NSC_PKG - show dependent code
Package BodyIGS_EN_PRC_LOAD - show dependent code
ViewIGS_EN_SPL_PERM_V
ViewIGS_EN_ST_SNAPSHOT_WARNING_V
Package BodyIGS_EN_SUA_API - show dependent code
Package BodyIGS_EN_SUA_LGCY_PUB - show dependent code
ViewIGS_EN_SUA_YEAR_V
Package BodyIGS_EN_SU_ATTEMPT_PKG - show dependent code
Package BodyIGS_EN_TIMESLOTS - show dependent code
Package BodyIGS_EN_TRANSFER_APIS - show dependent code
ViewIGS_EN_USEC_STAT_V
Package BodyIGS_EN_VAL_SCA - show dependent code
Package BodyIGS_EN_VAL_SUA - show dependent code
Package BodyIGS_EN_WLST_GEN_PROC - show dependent code
PL/SQL PackageIGS_EN_WLST_GEN_PROC - show dependent code
Package BodyIGS_FI_ACCT_STP_CNV - show dependent code
ViewIGS_FI_FEE_TRG_GRP_V
Package BodyIGS_FI_GEN_001 - show dependent code
Package BodyIGS_FI_GEN_005 - show dependent code
Package BodyIGS_FI_PRC_FEE_ROLLV - show dependent code
Package BodyIGS_FI_PRC_SP_FEES - show dependent code
Package BodyIGS_GE_VAL_PARAM - show dependent code
Package BodyIGS_HE_EXTRACT_FIELDS_PKG - show dependent code
Package BodyIGS_HE_FTE_CALC_PKG - show dependent code
ViewIGS_HE_ST_UNV_DTLS_V
Package BodyIGS_IN_GEN_001 - show dependent code
Package BodyIGS_PR_ACAD_DETAILS - show dependent code
PL/SQL PackageIGS_PR_ACAD_DETAILS - show dependent code
ViewIGS_PR_ACAD_LOAD_V
Package BodyIGS_PR_CP_GPA - show dependent code
PL/SQL PackageIGS_PR_CP_GPA - show dependent code
Package BodyIGS_PR_GEN_004 - show dependent code
Package BodyIGS_PR_VAL_POPU - show dependent code
Package BodyIGS_PS_CAL_RSR_VAL - show dependent code
PL/SQL PackageIGS_PS_CAL_RSR_VAL - show dependent code
ViewIGS_PS_FACLTY_UNIT_V
Package BodyIGS_PS_FAC_CREDT_WRKLOAD - show dependent code
ViewIGS_PS_FAC_USEC_TCH_HIST_V
Package BodyIGS_PS_GEN_002 - show dependent code
Package BodyIGS_PS_GEN_005 - show dependent code
Package BodyIGS_PS_GEN_006 - show dependent code
Package BodyIGS_PS_GEN_007 - show dependent code
Package BodyIGS_PS_GEN_008 - show dependent code
ViewIGS_PS_TCH_RESP_HIST_V
ViewIGS_PS_UNIT_LVL_HIST_V
ViewIGS_PS_UNIT_OFFER_PAT_V
ViewIGS_PS_UNIT_OFR_OPT_GRD_SCHM_V
ViewIGS_PS_UNIT_OFR_OPT_OFROPT_V
Package BodyIGS_PS_UNIT_OFR_OPT_PKG - show dependent code
ViewIGS_PS_UNIT_OFR_OPT_V
ViewIGS_PS_UNIT_REF_HIST_V
ViewIGS_PS_UNIT_UNIT_VERSION_V
ViewIGS_PS_UNIT_VER_HIST_V
Package BodyIGS_PS_UNIT_VER_PKG - show dependent code
ViewIGS_PS_UNIT_VER_RU_V
ViewIGS_PS_UNIT_VER_V
ViewIGS_PS_UNIT_X_GRPMEM_V
ViewIGS_PS_UNT_DSCP_HIST_V
ViewIGS_PS_UNT_REPT_FMLY_V
ViewIGS_PS_USEC_CPS_V
ViewIGS_PS_USEC_RPT_FMLY_V
Package BodyIGS_PS_USEC_SCHEDULE - show dependent code
ViewIGS_PS_USEC_X_GRPMEM_V
ViewIGS_PS_USEC_X_USEC_V
ViewIGS_PS_USO_CLAS_MEET_V
ViewIGS_PS_US_EXAM_MEET_V
Package BodyIGS_PS_VALIDATE_LGCY_PKG - show dependent code
Package BodyIGS_PS_VAL_CALUL - show dependent code
Package BodyIGS_PS_VAL_POSU - show dependent code
Package BodyIGS_PS_VAL_TR - show dependent code
Package BodyIGS_PS_VAL_UD - show dependent code
Package BodyIGS_PS_VAL_UNIT - show dependent code
Package BodyIGS_PS_VAL_UV - show dependent code
Package BodyIGS_RE_GEN_001 - show dependent code
Package BodyIGS_RE_GEN_002 - show dependent code
Package BodyIGS_RE_VAL_CAH - show dependent code
Package BodyIGS_RU_GEN_001 - show dependent code
Package BodyIGS_RU_GEN_002 - show dependent code
Package BodyIGS_SS_ENR_DETAILS - show dependent code
ViewIGS_SS_EN_RULE_CART_MAX_V
ViewIGS_SS_EN_SUA_DTLS_V
Package BodyIGS_SS_EN_WRAPPERS - show dependent code
ViewIGS_SS_USEC_V
Package BodyIGS_ST_GEN_003 - show dependent code
Package BodyIGS_ST_GEN_004 - show dependent code
Package BodyIGS_ST_VAL_ULA - show dependent code