[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | IGS_PS_UNIT_VER_HIST |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  IGS.IGS_PS_UNIT_VER_HIST
|
| Subobject Name: | |
| Status: | VALID |
A multi-org view which will retrive data for your current operating unit and ignore data in other operating units.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ROW_ID | ROWID | (10) | ||
| UNIT_CD | VARCHAR2 | (10) | Yes | |
| VERSION_NUMBER | NUMBER | (3) | Yes | |
| HIST_START_DT | DATE | Yes | ||
| HIST_END_DT | DATE | Yes | ||
| HIST_WHO | NUMBER | (15) | Yes | |
| START_DT | DATE | |||
| REVIEW_DT | DATE | |||
| EXPIRY_DT | DATE | |||
| END_DT | DATE | |||
| UNIT_STATUS | VARCHAR2 | (10) | ||
| TITLE | VARCHAR2 | (90) | ||
| SHORT_TITLE | VARCHAR2 | (40) | ||
| TITLE_OVERRIDE_IND | VARCHAR2 | (1) | ||
| ABBREVIATION | VARCHAR2 | (20) | ||
| UNIT_LEVEL | VARCHAR2 | (4) | ||
| UL_DESCRIPTION | VARCHAR2 | (60) | ||
| CREDIT_POINT_DESCRIPTOR | VARCHAR2 | (30) | ||
| ENROLLED_CREDIT_POINTS | NUMBER | (6) | ||
| POINTS_OVERRIDE_IND | VARCHAR2 | (1) | ||
| SUPP_EXAM_PERMITTED_IND | VARCHAR2 | (1) | ||
| COORD_PERSON_ID | NUMBER | (15) | ||
| OWNER_ORG_UNIT_CD | VARCHAR2 | (30) | ||
| OWNER_OU_START_DT | DATE | |||
| OU_DESCRIPTION | VARCHAR2 | (60) | ||
| AWARD_COURSE_ONLY_IND | VARCHAR2 | (1) | ||
| RESEARCH_UNIT_IND | VARCHAR2 | (1) | ||
| 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) | ||
| PRACTICAL_IND | VARCHAR2 | (1) | ||
| REPEATABLE_IND | VARCHAR2 | (1) | ||
| ASSESSABLE_IND | VARCHAR2 | (1) | ||
| ACHIEVABLE_CREDIT_POINTS | NUMBER | (6) | ||
| POINTS_INCREMENT | NUMBER | (6) | ||
| POINTS_MIN | NUMBER | (6) | ||
| POINTS_MAX | NUMBER | (6) | ||
| UNIT_INT_COURSE_LEVEL_CD | VARCHAR2 | (10) | ||
| UICL_DESCRIPTION | VARCHAR2 | (60) | ||
| SS_ENROL_IND | VARCHAR2 | (1) | Self Service Enrollment Indicator | |
| IVR_ENROL_IND | VARCHAR2 | (1) | IVR Enrollment Indicator | |
| 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 | |||
| REPEAT_CODE | VARCHAR2 | (10) | ||
| UNIT_TYPE_ID | NUMBER | |||
| LEVEL_CODE | VARCHAR2 | (10) | ||
| ADVANCE_MAXIMUM | NUMBER | |||
| APPROVAL_DATE | DATE | |||
| BILLING_CREDIT_POINTS | NUMBER | Audit Credit Points | ||
| CONTINUING_EDUCATION_UNITS | NUMBER | (6) | ||
| ENROLLMENT_EXPECTED | NUMBER | |||
| ENROLLMENT_MAXIMUM | NUMBER | |||
| ENROLLMENT_MINIMUM | NUMBER | |||
| FEDERAL_FINANCIAL_AID | VARCHAR2 | (1) | ||
| INSTITUTIONAL_FINANCIAL_AID | VARCHAR2 | (1) | ||
| LAB_CREDIT_POINTS | NUMBER | (6) | ||
| LECTURE_CREDIT_POINTS | NUMBER | (6) | ||
| MAX_REPEATS_FOR_CREDIT | NUMBER | |||
| MAX_REPEATS_FOR_FUNDING | NUMBER | |||
| MAX_REPEAT_CREDIT_POINTS | NUMBER | (6) | ||
| CLOCK_HOURS | NUMBER | (6) | ||
| OTHER_CREDIT_POINTS | NUMBER | (6) | ||
| SAME_TEACHING_PERIOD | VARCHAR2 | (1) | ||
| SAME_TEACH_PERIOD_REPEATS | NUMBER | |||
| SAME_TEACH_PERIOD_REPEATS_CP | NUMBER | (6) | ||
| STATE_FINANCIAL_AID | VARCHAR2 | (1) | ||
| WORK_LOAD_CP_LAB | NUMBER | (6) | ||
| WORK_LOAD_CP_LECTURE | NUMBER | (6) | ||
| SUBTITLE_ID | NUMBER | |||
| SUBTITLE | VARCHAR2 | (90) | ||
| SUBTITLE_MODIFIABLE_FLAG | VARCHAR2 | (1) | ||
| SPECIAL_PERMISSION_IND | VARCHAR2 | (1) | ||
| 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) | ||
| CLAIMABLE_HOURS | NUMBER | (7) | The maximum hours that a student in a class can claim | |
| 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
, HIST_START_DT
, HIST_END_DT
, HIST_WHO
, START_DT
, REVIEW_DT
, EXPIRY_DT
, END_DT
, UNIT_STATUS
, TITLE
, SHORT_TITLE
, TITLE_OVERRIDE_IND
, ABBREVIATION
, UNIT_LEVEL
, UL_DESCRIPTION
, CREDIT_POINT_DESCRIPTOR
, ENROLLED_CREDIT_POINTS
, POINTS_OVERRIDE_IND
, SUPP_EXAM_PERMITTED_IND
, COORD_PERSON_ID
, OWNER_ORG_UNIT_CD
, OWNER_OU_START_DT
, OU_DESCRIPTION
, 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
, UICL_DESCRIPTION
, SS_ENROL_IND
, IVR_ENROL_IND
, 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
, REPEAT_CODE
, UNIT_TYPE_ID
, LEVEL_CODE
, ADVANCE_MAXIMUM
, APPROVAL_DATE
, BILLING_CREDIT_POINTS
, CONTINUING_EDUCATION_UNITS
, ENROLLMENT_EXPECTED
, ENROLLMENT_MAXIMUM
, ENROLLMENT_MINIMUM
, FEDERAL_FINANCIAL_AID
, INSTITUTIONAL_FINANCIAL_AID
, LAB_CREDIT_POINTS
, LECTURE_CREDIT_POINTS
, MAX_REPEATS_FOR_CREDIT
, MAX_REPEATS_FOR_FUNDING
, MAX_REPEAT_CREDIT_POINTS
, CLOCK_HOURS
, OTHER_CREDIT_POINTS
, SAME_TEACHING_PERIOD
, SAME_TEACH_PERIOD_REPEATS
, SAME_TEACH_PERIOD_REPEATS_CP
, STATE_FINANCIAL_AID
, WORK_LOAD_CP_LAB
, WORK_LOAD_CP_LECTURE
, SUBTITLE_ID
, SUBTITLE
, SUBTITLE_MODIFIABLE_FLAG
, SPECIAL_PERMISSION_IND
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, ORG_ID
, CLAIMABLE_HOURS
, AUDITABLE_IND
, AUDIT_PERMISSION_IND
, MAX_AUDITORS_ALLOWED
, OVRD_WKLD_VAL_FLAG
, WORKLOAD_VAL_CODE
FROM APPS.IGS_PS_UNIT_VER_HIST;
APPS
IGS_PS_UNIT_VER_HIST_ALL
APPS
IGS_AU_GEN_004
- show dependent code
IGS_PS_UNIT_VER_HIST_PKG
- show dependent code
IGS_PS_UNIT_VER_HIST_V
IGS_PS_UNIT_VER_PKG
- show dependent code
|
|
|
|