[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | IGS_PS_UNIT_VER_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  IGS.IGS_PS_UNIT_VER_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) | ||
| 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 | |
| CPD_DESCRIPTION | VARCHAR2 | (80) | 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 | |
| PERSON_NUMBER | VARCHAR2 | (30) | 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 | VARCHAR2 | (90) | ||
| SUBTITLE_ID | NUMBER | |||
| 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_CP | NUMBER | (6) | ||
| SAME_TEACH_PERIOD_REPEATS | NUMBER | |||
| WORK_LOAD_OTHER | NUMBER | (5) | ||
| CONTACT_HRS_LECTURE | NUMBER | (5) | ||
| CONTACT_HRS_LAB | NUMBER | (5) | ||
| CONTACT_HRS_OTHER | NUMBER | (5) | ||
| DSP_CONTACT_HRS_TOTAL | NUMBER | |||
| 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) | ||
| DSP_LAST_CALENDAR_ENROLLED | VARCHAR2 | (21) | ||
| DSP_LAST_CALENDAR_OFFERED | VARCHAR2 | (21) | ||
| CURRICULUM_ID | VARCHAR2 | (10) | ||
| OVERRIDE_ENROLLMENT_MAX | NUMBER | (6) | ||
| RPT_FMLY_ID | NUMBER | |||
| UNIT_TYPE_ID | NUMBER | |||
| DSP_LEVEL_CODE | VARCHAR2 | (10) | Yes | |
| SPECIAL_PERMISSION_IND | VARCHAR2 | (1) | ||
| SS_ENROL_IND | VARCHAR2 | (1) | Self Service Enrollment Indicator | |
| IVR_ENROL_IND | VARCHAR2 | (1) | IVR Enrollment Indicator | |
| 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 | |
| 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) | ||
| 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 |
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
, CPD_DESCRIPTION
, ENROLLED_CREDIT_POINTS
, POINTS_OVERRIDE_IND
, SUPP_EXAM_PERMITTED_IND
, COORD_PERSON_ID
, PERSON_NUMBER
, 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
, SUBTITLE_ID
, 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_CP
, SAME_TEACH_PERIOD_REPEATS
, WORK_LOAD_OTHER
, CONTACT_HRS_LECTURE
, CONTACT_HRS_LAB
, CONTACT_HRS_OTHER
, DSP_CONTACT_HRS_TOTAL
, 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
, DSP_LAST_CALENDAR_ENROLLED
, DSP_LAST_CALENDAR_OFFERED
, CURRICULUM_ID
, OVERRIDE_ENROLLMENT_MAX
, RPT_FMLY_ID
, UNIT_TYPE_ID
, DSP_LEVEL_CODE
, SPECIAL_PERMISSION_IND
, SS_ENROL_IND
, IVR_ENROL_IND
, REV_ACCOUNT_CD
, CLAIMABLE_HOURS
, ANON_UNIT_GRADING_IND
, ANON_ASSESS_GRADING_IND
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE16
, ATTRIBUTE17
, ATTRIBUTE18
, ATTRIBUTE19
, ATTRIBUTE20
, 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_V;
APPS
HZ_PARTIES
IGS_EN_GEN_014
- show dependent code
IGS_LOOKUP_VALUES
IGS_PS_UNIT_SUBTITLE
IGS_PS_UNIT_TYPE_LVL
IGS_PS_UNIT_VER
APPS
IGS_EN_GEN_008
- show dependent code
IGS_EN_PLAN_UTILS
- 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_PS_UNIT_VER_PKG
- show dependent code
IGS_SS_ENR_DETAILS
- show dependent code
|
|
|
|