[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | IGS_AS_ENTRY_CONF |
|---|---|
| Object Type: | TABLE |
| Owner: | IGS |
| FND Design Data: |  IGS.IGS_AS_ENTRY_CONF
|
| Subobject Name: | |
| Status: | VALID |
IGS_AS_ENTRY_CONF stores seed data for entry configuration of marks and grades.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| IGS_AS_ENTRY_CONF_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 S_CONTROL_NUM
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| S_CONTROL_NUM | NUMBER | (1) | Yes | System control number |
| KEY_ALLOW_INVALID_IND | VARCHAR2 | (1) | Yes | Indicates and specifies if or not invalid mark or grade combinations can be entered. An invalid combination exists when the keyed mark is outside the range of marks associated with the entered grade in the grading schema. If selected, the system allows invalid mark or grade combinations to be entered. If necessary invalid results can be manually resolved using the invalid grades report. |
| KEY_COLLECT_MARK_IND | VARCHAR2 | (1) | Yes | Indicates and specifies if or not marks can be entered when keying results. If selected, the 'Mark' column is displayed in ASSF5330 and marks can be entered. This indicator must be set if the 'Mark Entry Mandatory' is set and should normally be set if the 'derive Grade' and 'Invalid Mark or Grade Allowed' indicators are set. |
| KEY_GRADE_DERIVE_IND | VARCHAR2 | (1) | Yes | Indicates and specifies if or not the grade should be derived from the entered marks. If set selected, the system derives the grade from the mark using the grading schema mark range. If not set, a grade must be entered. If set, the 'Collect Mark' option must also be set. |
| KEY_MARK_MNDTRY_IND | VARCHAR2 | (1) | Yes | Indicates and specifies if or not a mark must be entered when keying results. If set selected, a mark must be selected if the grade has a mark range in the grading schema. This validation also operates for the electronic result upload process that is, the validation file must contain a mark in cases where the entered grade has a mark range. When this indicator is set the 'Collect Marks' option must also be set. |
| KEY_CHECK_DIGIT_IND | VARCHAR2 | (1) | Obsolete | |
| KEY_OVERWRITE_ALLOWED_IND | VARCHAR2 | (1) | Obsolete | |
| KEY_SS_GRADE_MNDTRY_IND | VARCHAR2 | (1) | Obsolete | |
| KEY_ADM_GRADE_MNDTRY_IND | VARCHAR2 | (1) | Obsolete | |
| UPLD_PERSON_NO_EXIST | VARCHAR2 | (1) | Yes | Describes an electronic upload configuration setting which defines the action to be taken by the system if a person entered in the upload file doesnot exist in the system that is person ID does not exist. The available options are 'Abort File' upload file will not be loaded into system and 'Don't Load' student unit attempt outcome will not be uploaded. |
| KEY_MARK_ENTRY_DEC_POINTS | NUMBER | (1) | Mark entry decimal points 0,1,2 or 3. | |
| UPLD_CRS_NOT_ENROLLED | VARCHAR2 | (1) | Yes | Describes an electronic upload configuration setting which defines the action to be taken by the system if the person specified in the validation file does not have any entered program attempts. The available options are 'Abort File' upload file will not be loaded into system, and 'Don't Load' Student unit attempt outcome will not be uploaded-. |
| UPLD_UNIT_NOT_ENROLLED | VARCHAR2 | (1) | Yes | Describes an electronic upload configuration setting which defines the action to be taken by the system when a student is not enrolled in the unit entered in the upload file. The available options are 'Abort File upload file will not be loaded into system, 'Don't Load' student unit attempt outcome will not be uploaded and 'Holding' the outcome details will be loaded into the 'Non-Enrolled Outcomes' structure. |
| UPLD_UNIT_DISCONT | VARCHAR2 | (1) | Yes | Describes an electronic upload configuration setting which defines the action to be taken by the system when a unit attempt entered in the upload file is discontinued. The available options are 'Abort File' upload file will not be loaded into system, 'Don't Load' student unit attempt outcome will not be uploaded and 'Holding' the outcome details will be loaded into the 'Non-Enrolled Outcomes' structure. |
| UPLD_GRADE_EXISTS | VARCHAR2 | (1) | Obsolete | |
| UPLD_GRADE_INVALID | VARCHAR2 | (1) | Yes | Describes an electronic upload configuration setting which defines the action to be taken by the system when the grade specified for a student unit attempt in the upload file does not exist in the grading schema being used. The available options are 'Abort File' upload file will not be loaded into system and 'Don't Load' student unit attempt outcomes will not be uploaded. |
| UPLD_MARK_GRADE_INVALID | VARCHAR2 | (1) | Yes | Describes an electronic upload configuration setting which defines the action to be taken by the system when the mark or grade combination entered for astudent unit attempt in the upload file is invalid. The available options are 'Abort File' upload file will not be loaded into system,'Don't Load' student unit attempt outcome will not be uploaded ,'Holding' the outcome details will be loaded into the 'Non-EnrolledOutcomes' structure and 'Warning Only' displayed as a warning on the validate upload File and upload outcomes exception reports. |
| 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 | |
| KEY_PRTL_SBMN_ALLOWED_IND | VARCHAR2 | (1) | Partial Submission for grade entry allowed indicator | |
| UPLD_UG_SBMTD_GRADE_EXIST | VARCHAR2 | (1) | Action to take if submitted grade exists | |
| UPLD_UG_SAVED_GRADE_EXIST | VARCHAR2 | (1) | Action to take if saved grade exists | |
| UPLD_ASMNT_ITEM_NOT_EXIST | VARCHAR2 | (1) | Action to take if assessment item does not exists | |
| UPLD_ASMNT_ITEM_GRD_EXIST | VARCHAR2 | (1) | Action to take if assessment item grade exists. | |
| KEY_DERIVE_UNIT_GRADE_FLAG | VARCHAR2 | (1) | Yes | If enabled, it allows the users to calculate the student unit attempt outcome marks based on student assessment item outcomes' marks. By default, this checkbox is selected. Note: For 'Derive Unit Marks from Assessment item Marks' checkbox to be enabled 'Collect Marks', 'Mark Entry Mandatory', and 'Derive Grade from Mark' checkboxes should be checked. |
| KEY_ALLOW_INST_FINALIZE_FLAG | VARCHAR2 | (1) | Yes | If not selected the "Faculty" responsibility users, will be restricted from Finalizing and Releasing the grades. |
| KEY_AI_COLLECT_MARK_FLAG | VARCHAR2 | (1) | Yes | If selected, allows the user to insert a mark for each student assessment item outcome record; by default, this check box is selectedNote: This check box must be selected if the assessment item 'Mark Entry Mandatory' check box is selected. |
| KEY_AI_MARK_MNDTRY_FLAG | VARCHAR2 | (1) | Yes | If selected, a mark is required for each student assessment item outcome record where the grade has an equivalent mark range; by default, this check box is selected. |
| KEY_AI_GRADE_DERIVE_FLAG | VARCHAR2 | (1) | Yes | If selected, the system automatically derives and inserts the grades for the respective mark range, from the corresponding assessment item grading schema; by default, this check box is selectedNote: This check box can be selected only if assessment item 'Collect Mark' check box is selected. |
| KEY_AI_ALLOW_INVALID_FLAG | VARCHAR2 | (1) | Yes | If selected, allows a grade other than that normally corresponding to the assessment item mark to be entered. The entered grade has to be within the relevant assessment item grading schema; by default, this check box is not selected. |
| KEY_AI_MARK_ENTRY_DEC_POINTS | NUMBER | (1) | Number of decimals for the assessment item mark to be entered and displayed; values are 0,1,2, and 3. By Default the value is set to 2. |
Cut, paste (and edit) the following text to query this object:
SELECT S_CONTROL_NUM
, KEY_ALLOW_INVALID_IND
, KEY_COLLECT_MARK_IND
, KEY_GRADE_DERIVE_IND
, KEY_MARK_MNDTRY_IND
, KEY_CHECK_DIGIT_IND
, KEY_OVERWRITE_ALLOWED_IND
, KEY_SS_GRADE_MNDTRY_IND
, KEY_ADM_GRADE_MNDTRY_IND
, UPLD_PERSON_NO_EXIST
, KEY_MARK_ENTRY_DEC_POINTS
, UPLD_CRS_NOT_ENROLLED
, UPLD_UNIT_NOT_ENROLLED
, UPLD_UNIT_DISCONT
, UPLD_GRADE_EXISTS
, UPLD_GRADE_INVALID
, UPLD_MARK_GRADE_INVALID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, KEY_PRTL_SBMN_ALLOWED_IND
, UPLD_UG_SBMTD_GRADE_EXIST
, UPLD_UG_SAVED_GRADE_EXIST
, UPLD_ASMNT_ITEM_NOT_EXIST
, UPLD_ASMNT_ITEM_GRD_EXIST
, KEY_DERIVE_UNIT_GRADE_FLAG
, KEY_ALLOW_INST_FINALIZE_FLAG
, KEY_AI_COLLECT_MARK_FLAG
, KEY_AI_MARK_MNDTRY_FLAG
, KEY_AI_GRADE_DERIVE_FLAG
, KEY_AI_ALLOW_INVALID_FLAG
, KEY_AI_MARK_ENTRY_DEC_POINTS
FROM IGS.IGS_AS_ENTRY_CONF;
IGS.IGS_AS_ENTRY_CONF does not reference any database object
IGS.IGS_AS_ENTRY_CONF is referenced by following:
APPS
IGS_AS_ENTRY_CONF
|
|
|
|