[Home] [Help] [Dependency Information]
Object Name: | IGS_AD_SBMINTAK_TRGT |
---|---|
Object Type: | TABLE |
Owner: | IGS |
FND Design Data: | IGS.IGS_AD_SBMINTAK_TRGT |
Subobject Name: | |
Status: | VALID |
IGS_AD_SBMINTAK_TRGT holds intake targets for submission period records.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGS_AD_SBMINTAK_TRGT_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
SUBMISSION_YR
SUBMISSION_NUMBER INTAKE_TARGET_TYPE |
IGS_AD_SBMINTAK_TRGT_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | INTAKE_TARGET_TYPE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SUBMISSION_YR | NUMBER | (4) | Yes | The Higher Education Student Data Collection |
SUBMISSION_NUMBER | NUMBER | (1) | Yes | The Higher Education Student Data Collection submission number<1,2 or 3> for target collection. |
INTAKE_TARGET_TYPE | VARCHAR2 | (10) | Yes | Describes the type of student target required |
PRIORITY_OF_TARGET | NUMBER | (2) | The priority defines the order in which targets are to be met. | |
TARGET | NUMBER | (8) | Yes | Student intake target. If maximum target exists, then this defines the minimum. The amount type of the target is defined by intake target type definition or can be overridden. |
MAX_TARGET | NUMBER | (8) | Shows the maximum target figure | |
OVERRIDE_S_AMOUNT_TYPE | VARCHAR2 | (30) | Allows an override of the amount type of the target. If the target is typically measured as, for example, in Persons, then the intake target type will define this. The override allows this to be changed to. | |
ACTUAL_ENROLMENT | NUMBER | (8) | Is included so that historical enrollment actual figures can be retained | |
ACTUAL_ENR_EFFECTIVE_DT | DATE | Contains the date and time when the actual enrollment figures were calculated | ||
CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
CREATION_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column |
Cut, paste (and edit) the following text to query this object:
SELECT SUBMISSION_YR
, SUBMISSION_NUMBER
, INTAKE_TARGET_TYPE
, PRIORITY_OF_TARGET
, TARGET
, MAX_TARGET
, OVERRIDE_S_AMOUNT_TYPE
, ACTUAL_ENROLMENT
, ACTUAL_ENR_EFFECTIVE_DT
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM IGS.IGS_AD_SBMINTAK_TRGT;
IGS.IGS_AD_SBMINTAK_TRGT does not reference any database object
IGS.IGS_AD_SBMINTAK_TRGT is referenced by following:
|
|
|