[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;
|
|
|