[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | IGSBV_ADVISING_GROUPS |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  IGS.IGSBV_ADVISING_GROUPS
|
| Subobject Name: | |
| Status: | VALID |
A Business Intelligence System view
Stores advising group definition
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ADVISING_GROUP_NAME | VARCHAR2 | (90) | Yes | Primary Key Name of the Advising Group |
| GROUP_DESCRIPTION | VARCHAR2 | (240) | Yes | A short description of the Advising Group |
| ADVISING_CATEGORY | VARCHAR2 | (30) | User defined advising category that is used as a means to cluster advising groups e.g. Academic Advising Groups, Administrative Advising Groups, Athletic Advising groups, etc. | |
| _LA:ADVISING_CATEGORY_DESC | CHAR | (64) | Advising Category description | |
| RESP_ORG_UNIT_CODE | VARCHAR2 | (30) | Yes | Responsible organization code |
| RESP_PERSON_IDENTIFIER | NUMBER | (15) | Person id of the person responsible for this group | |
| DELIVERY_METHOD_CODE | VARCHAR2 | (30) | Yes | The type of the advising group such as 1-on-1 etc |
| _LA:DELIVERY_METHOD_CD_DESC | CHAR | (70) | The description of the delivery method for this group | |
| ADVISOR_GROUP_ID | NUMBER | Advisor's Person ID Group (PIG) associated with the Advising group. The PIG could be static or dynamic. | ||
| STUDENT_GROUP_ID | NUMBER | Student's Person ID Group (PIG) associated with the Advising group. The PIG could be static or dynamic | ||
| DEFAULT_ADVISOR_LOAD | NUMBER | The default number of Students an Advisor is expected to counsel in an advising group. This number can be overwritten for each advisor assigned to the group. | ||
| MANDATORY_FLAG | VARCHAR2 | (1) | Yes | If selected, the system will track to ensure that students meet their respective advisor(s) at least as many times as stated in the "Advising Sessions" field |
| ADVISING_SESSIONS | NUMBER | Expected number of times a student is expected to meet an Advisor | ||
| ADVISING_HOLD_TYPE | VARCHAR2 | (10) | If selected, all students associated with the advising group will be required to be put on a "hold" with the selected Advising Hold Type | |
| CLOSED_FLAG | VARCHAR2 | (1) | Yes | If selected the checkbox signifies that the group is "inactive" |
| COMMENTS | VARCHAR2 | (2000) | Free form text field to allow user enter more specific information about the group definition e.g. the types of students, advisors expected to be part of the advising group, etc. | |
| AUTO_REFRESH_FLAG | VARCHAR2 | (1) | Yes | Indicates whether the advising group will be selected for periodic run of the maintenance job. If selected, the advising group will be included in the periodic run of the "Maintain Advising Group" concurrent manager job. |
| LAST_AUTO_REFRESH_DATE | DATE | Indicates whether the advising group will be selected for periodic run of the maintenance job. If selected, the advising group will be included in the periodic run of the "Maintain Advising Group" concurrent manager job. | ||
| AUTO_STDNT_ADD_FLAG | VARCHAR2 | (1) | Yes | If selected, the suggested Student Additions will be automatically confirmed by the "Maintain Advising Group" concurrent manager job |
| AUTO_STDNT_REMOVE_FLAG | VARCHAR2 | (1) | Yes | If selected, the suggested Student Removals will be automatically confirmed by the "Maintain Advising Group" concurrent manager job |
| AUTO_ADVISOR_ADD_FLAG | VARCHAR2 | (1) | Yes | If selected, the suggested Advisor Additions will be automatically confirmed by the "Maintain Advising Group" concurrent manager job |
| AUTO_ADVISOR_REMOVE_FLAG | VARCHAR2 | (1) | Yes | If selected, the suggested Advisor Removals will be automatically confirmed by the "Maintain Advising Group" concurrent manager job |
| AUTO_MATCH_FLAG | VARCHAR2 | (1) | Yes | If selected, the suggested Advisor and Student matches will be automatically confirmed by the "Maintain Advising Group" concurrent manager job |
| AUTO_APPLY_HOLD_FLAG | VARCHAR2 | (1) | Yes | If selected the "Apply Advising Hold" concurrent manager job, during its periodic run, will put all eligible students on an "advising hold" |
| LOCATION_CODE | VARCHAR2 | (10) | Location of the Advising Center of an advising group | |
| 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 |
Cut, paste (and edit) the following text to query this object:
SELECT ADVISING_GROUP_NAME
, GROUP_DESCRIPTION
, ADVISING_CATEGORY
, _LA:ADVISING_CATEGORY_DESC
, RESP_ORG_UNIT_CODE
, RESP_PERSON_IDENTIFIER
, DELIVERY_METHOD_CODE
, _LA:DELIVERY_METHOD_CD_DESC
, ADVISOR_GROUP_ID
, STUDENT_GROUP_ID
, DEFAULT_ADVISOR_LOAD
, MANDATORY_FLAG
, ADVISING_SESSIONS
, ADVISING_HOLD_TYPE
, CLOSED_FLAG
, COMMENTS
, AUTO_REFRESH_FLAG
, LAST_AUTO_REFRESH_DATE
, AUTO_STDNT_ADD_FLAG
, AUTO_STDNT_REMOVE_FLAG
, AUTO_ADVISOR_ADD_FLAG
, AUTO_ADVISOR_REMOVE_FLAG
, AUTO_MATCH_FLAG
, AUTO_APPLY_HOLD_FLAG
, LOCATION_CODE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
FROM APPS.IGSBV_ADVISING_GROUPS;
APPS
IGS_AZ_GROUPS
APPS.IGSBV_ADVISING_GROUPS is not referenced by any database object
|
|
|
|